|
Instructor: |
Ashraf Shirani |
|
Office Location: |
BT 263 |
|
Telephone: |
(408) 924-3521 |
|
Email: |
shirani_a @ cob.sjsu.edu |
|
Office Hours: |
TuTh 3:15-5:45 PM |
|
Class Days/Time/Room: |
Class meets on Tuesdays, 6:00-8:45 pm in BBC 003 |
Course
Description:
Overall objective of the course is to introduce
students to concepts, methods, technologies, and application of business
intelligence in enterprise performance management and decision support. Hands-on
introduction to some of the BI and related technologies is also provided.
Course Goals and
Learning Objectives:
Understand the applications of BI in enterprise performance management and decision support.
Understand the foundations and applications of BI, data mining, and other intelligent systems in managerial work.
Learn essential BI enabling technologies: relational database concepts and methods including database design and entity-relationship (E-R) modeling, data normalization, and Structured Query Language (SQL).
Understand data warehousing and online analytical processing (OLAP) concepts, including dimensional modeling, star and snowflake schemas, attribute hierarchies, metrics, and cubes.
Learn about analyzing and reporting on OLAP data.
Textbooks:
Business Intelligence: A Managerial Approach, 2nd
Edition, Prentice Hall (2011)
Authors: Turban, Sharda, Delen, and King
ISBN-10: 0-13-610066-X
ISBN-13: 978-0-13-610066-9
Database Systems: Design,
Implementation, & Management, either 8th or 9th Edition, Course Technology.
Authors: Peter Rob and Carlos Coronel
ISBN-10: 1-4239-0201-7
ISBN-13: 978-1-4239-0201-0
Other Reading Materials: Online technical documentation, tutorials, handouts, and reports will be made available by the instructor.
Classroom Protocol:
Students are responsible for the material discussed in class. If a student has to miss a class, she/he should obtain lecture notes from another student and meet the deadlines/dates announced in class.
Students are expected to have read the assigned textbook chapters and other reading materials before coming to class (please see the schedule below).
Students are responsible for understanding the policies and procedures about add/drop, grade forgiveness, etc. Refer to the current semester’s Catalog Policies section at http://info.sjsu.edu/static/catalog/policies.html. Add/drop deadlines can be found on the current academic calendar web page located at http://www.sjsu.edu/academic_programs/calendars/academic_calendar/. The Late Drop Policy is available at http://www.sjsu.edu/aars/policies/latedrops/policy/. Students should be aware of the current deadlines and penalties for dropping classes.
Information about the latest changes and news is available at the Advising Hub at http://www.sjsu.edu/advising/.
The following course components (with their relative weights as shown) will be used to determine a student's grade in this course.
| Homework assignments: | 40% |
| Term paper/project: | 10% |
| Midterm exam: | 25% |
| Final exam: | 25% |
Homework assignments/projects: A number of homework assignments and a term paper/project will be given during the semester. Requirements and due dates will be announced in class and may also be posted in the learning management system, D2L.
Please be sure to check and follow due dates listed with each homework assignment/project and upload your work to D2L by the due date. Late work may be accepted if submitted after its due date but before the end date posted in D2L, though points are deducted for late submission. Homework is not accepted after the end date.
Homework assignments (excluding any group projects) are a student's individual responsibility.
Please be sure to verify that grades posted in D2L for your homework, projects, and exams are correct. Report any discrepancies to the instructor.
Exams: Exams will contain questions based on material in the textbooks as well as other material such as exercises, handouts, and class discussions. Examples and types of questions will be discussed in class.
Your commitment as a student to learning is evidenced by your enrollment at San Jose State University. The University’s Academic Integrity policy requires you to be honest in all your academic course work. Faculty members are required to report all infractions to the office of Student Conduct and Ethical Development. Cheating on exams or plagiarism (presenting the work of another as your own, or the use of another person’s ideas without giving proper credit) will result in a failing grade and sanctions by the University. For this class, all assignments are to be completed by the individual student unless otherwise specified. If you would like to include your assignment or any material you have submitted, or plan to submit for another class, please note that SJSU’s Academic Policy S07-2 requires approval of instructors.
If you need course adaptations or accommodations because of a disability, or if you need to make special arrangements in case the building must be evacuated, please make an appointment with me as soon as possible, or see me during office hours. Presidential Directive 97-03 requires that students with disabilities requesting accommodations must register with the Disability Resource Center (DRC) at http://www.drc.sjsu.edu/ to establish a record of their disability.
Please check this website for policy details: http://www.cob.sjsu.edu/cob/5_STUDENT%20SERVICES/cobpolicy.htm
Course Schedule
R/C= chapters in the Rob/Coronel (or Coronel/Rob) book.
Please Note: Readings, documentation, and links are available in D2L
|
Week |
Dates |
T o p i c s |
Readings |
| 1 | Aug 31 |
Course introduction; class procedures and
policies Introduction to business intelligence |
Turban Ch 1; reading 1; other readings |
| 2 | Sep 7 |
Database design: entity-relationship (ER)
modeling ER diagrams with MS Visio and MySQL Workbench |
R/C Ch 4; handouts/online documentation |
| 3 | Sep 14 |
Introduction to the relational database
model; Data integrity and normalization; Introduction to Oracle and MS Access RDBMS; Oracle SQL Developer |
R/C Chs 3, 5; handouts/online documentation |
| 4 | Sep 21 | Introduction to Structured Query Language (SQL) |
R/C Chapters 7, 8; handouts/online documentation |
| 5 | Sep 28 | More Structured Query Language (SQL) |
R/C Chapters 7, 8 handouts/online documentation |
| 6 | Oct 5 | Introduction to data warehousing; data modeling for BI: multidimensional data modeling; star and snowflake schemas | Turban Ch 2; R/C Ch. 13 |
| 7 | Oct 12 | Introduction to Oracle Business Intelligence, enterprise Edition (OBIEE) |
Online access to OBIEE software; handouts/online documentation |
| 8 | Oct 19 |
Oracle Business Intelligence - OBIEE Midterm Exam |
online work with OBIEE |
| 9 | Oct 26 | OBIEE; Online analytical processing (OLAP): cubes, attribute hierarchies, and measures/metrics. Using Oracle Analytic Workspace Manager (AWM) to build cubes. | Handouts and online documentation |
| 10 | Nov 2 | Business performance management | Turban Ch 3 |
| 11 | Nov 9 |
Exploring and visualizing multidimensional
data: reports and performance dashboards; OBIEE - Oracle Answers; Simba MDX Provider for Oracle OLAP |
Handouts and online documentation |
| 12 | Nov 16 | Data mining for business intelligence |
Turban Ch 4; handouts and online documentation |
| 13 | Nov 23 | Text and Web mining | Turban Ch 5 |
| 14 | Nov 30 | BI implementation and emerging trends | Turban Ch 6 |
| 15 | Dec 7 | Course review; students may work on their term papers/projects | |
| Final Examination: Tuesday, Dec. 14 @ 5:15 PM |