San José State University
College of Business
MIS Department

297D Section 9: Business Intelligence
 Fall 2011

Course Description:
Overall objective of the course is to introduce students to concepts, technologies, and application of business intelligence in enterprise performance management and decision support. Hands-on introduction to some of the BI and related technologies such as databases is also provided.

Course Goals and Learning Objectives:

1. Understand the role of BI in enterprise performance management and decision support.

2. Understand the applications of data mining and intelligent systems in managerial work.

3. Learn essential BI enabling technologies: relational database concepts, database design and entity-relationship (E-R) modeling, data normalization, and Structured Query Language (SQL).

4. Understand data warehousing and online analytical processing (OLAP) concepts, including dimensional modeling, star and snowflake schemas, attribute hierarchies, metrics, and cubes.

5. Learn data analysis and reporting using an available BI software.

Textbooks:

1. 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
    

2. 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
   
   Please Note: You may use either the 8th or the current (9th) edition of Rob & Coronel book; for our purpose, though, both editions are quite similar.

Other Reading Materials: Online reading material and links to articles, technical documentation, tutorials, and handouts will be made available in D2L.
 

Classroom Protocol:

Students are responsible for the material discussed in class. If you miss a class, please obtain lecture notes and any important announcements from another student and meet the deadlines/dates announced in class.

Dropping and Adding Classes:

Students are responsible for understanding the policies and procedures about adding and dropping classes.  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/.

Assignments and Grading Policies:

The following course components (with their relative weights as shown) will be used to determine a student's grade in this course.

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 for homework assignments and the project and upload your work to D2L by the due date. Late assignments are either not accepted or may receive a lower grade. Homework assignments are a student's individual responsibility.

• Please be sure to verify that grades posted in D2L for your homework, projects, and exams are correct and report any discrepancies to the instructor.

Final Exam: The final exam will be a take-home exam and will contain questions based on material in the textbooks as well as other material such as exercises, handouts, and class discussions.

Project: Students may form 2-4 person groups to work on a research paper or a technical project.

University Policies:

Academic integrity

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. 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.

Campus Policy in Compliance of the Americans with Disabilities Act

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.

College of Business Policies and Procedures

Please check this website for policy details: http://www.cob.sjsu.edu/cob/5_STUDENT SERVICES/cobpolicy.htm

Course Schedule

The schedule is subject to change with fair notice. Any changes to the schedule will be announced in class during the semester.

Please Note: You may use either the 8th or the current (9th) edition of Rob & Coronel (R/C) book; for our purpose, though, both editions are quite similar.

Additional readings and links will be made available in D2L