MIS 183: Business Intelligence Applications - Spring 2016 COURSE OUTLINE


Spiros Velianitis, MS/MIS



Office Hours

Monday and Wednesday 4:20 – 5:50 pm and by appointment

Office Phone




Web Page


[Course Description] [Course Objectives] [Text] [Tools] [Exams] [Homework Assignments] [Grading]

Course Description [Top]

MIS 183. Business Intelligence Applications.  Advanced information technologies that extract non-trivial, actionable, and novel knowledge from data to achieve strategic goals of organizations.  Emphasis on multidimensional data modeling, online analytic processing, data warehouse, and data mining.  Prerequisite: MIS 150 or MIS 151. 3 units.

Course Objectives 

  • Understand the concepts and principles of developing a multidimensional data models.

  • Understand ROLAP, MOLAP, and HOLAP data environments and their pros and cons.

  • Understand and apply the data warehouse development life cycle.

  • Understand and apply different phases of data mining process.

  • Apply data mining software to generate business intelligence. 


Multidimensional Data Models

  • Understand the difference between a relational data model and multidimensional data model.

  • Learn the basic techniques to develop a multidimensional data model including how to identify dimensions, characteristics, and hierarchies.

  • Differentiate among star schema, snowflake schema, and multi-star schema.

  • Learn how to select the best schema to satisfy business users’ needs. 

Data Warehouse

  • Understand the purposes of a data warehouse.

  • Plan for and justify a data warehouse.

  • Identify data requirements, architecture, and infrastructure of a data warehouse.

  • Develop a logical data model for a data warehouse.

  • Develop a physical data model for a data warehouse.

Data Mining

  • Understand the purposes of data mining.

  • Understand the data mining process including objective identification, model selection, hypothesis formulation, target data collection, data preprocess, model fitting, testing/verification, interpretation/evaluation, and application.

  • Learn about values of data mining from real-life data mining applications.

  • Learn about decision trees and neural networks as two major data mining algorithms.

  • Understand the importance of text mining.


  •  Use SAP to illustrate relevant concepts in section 1, 2, and 3.

[Top]Course Methodology The goal of this course is to develop analytical and critical thinking skills for the development of integrative plans for enterprise-wide systems that optimize enterprise performance.

To pass this course you should:

  1. Prepare - Spend as much time needed to study the assigned topics before coming to class
  2. Practice - Review and practice the class exercises at your own pace
  3. Present - Complete the homework assignments, come to class, and deliver your work to your instructor

Text [Top]

Ramesh Sharda, et al. Business Intelligence: A Managerial Perspective on Analytics, 3/E , 2014, Prentice Hall, ISBN-10: 0-13-305105-6

Tools [Top]

In this class we will use the SAP GUI 7.3 or later. Connect to http://worker.cob.csuchico.edu/ to download and install this software to your computer.

Exams [Top] I will give two in-class term examinations and one final exam. Each exam consists of thirty five multiple-choice questions and two essay questions. You will need a scantron form 882 to answer the multiple-choice questions; I will provide you with paper for the identification and essay questions. Examination material will be drawn from the textbook reading, any other assigned readings, and class lectures and discussion. Emphasis will be placed on the conceptual understanding of the material and NOT on memory alone. Understanding the application of the concepts will greatly enhance your grade. 

No make-up examination will be given without the prior approval of the instructor. If you fail to take the exam, without valid documentation, I will prepare a different exam which you will take at 75% of its grade value.

Homework Assignments The purpose of the homework assignment is to encourage further practice for the topics covered in our book but not covered in class (due to time constraints) and to give you the opportunity to work on more comprehensive exercises than those covered in the book. I will provide with each team, a comprehensive set of assignment exercises. More information about the homework can be found in my assignments.htm web page

Final grades will be assigned according to the total points you have obtained through exams and homework assignments relative to the total possible number of points. 



3 Term Exams


4 Assignments @ 25 points each


Total Points


Your grade is also affected by the number of unexcused absences. You are allowed to have 5 unexcused absences. For each absence after your allowance, 5 points will be deducted. Note that absences are only excused for a valid reasons (health problems, jury duty etc) and MUST be accompanied with documentation (i.e., health center note with a phone number to call for questions) provided within a week of returning to class.

Pluses and minuses will be awarded along the extremities (i.e., greater than 3% below the upper limit and less than 3% of the lower limit, respectively). 

Based on the total points, your grades will be assigned as follows:













Any queries or appeals for a graded component (such as an assignment or an exam) must be directed to the instructor in person within 2 weeks after the graded component is returned. No adjustment will be made for the scores of graded components after the two-week period. Students are responsible for keeping track of their graded components. Uncollected graded components will be kept in the instructor’s office until the end of the current semester.

Grading system may change for compelling reasons. 

Academic Dishonesty

Unfortunately, the subject of academic dishonestly must be discussed for those who are inclined toward such activities. The university's policy is discussed in the following paragraphs. Please, there is no need to engage in any unethical behavior in this class! If you need help, my door is always open.

Academic dishonesty involves acts which may subvert or compromise the integrity of the educational process of the university. Included is any act by which a student gains or attempts to gain an academic advantage for him/herself, or another, by misrepresenting his/her, or another's work or by interfering with the completion, submission, or evaluation of work. These include, but are not limited to, accomplishing or attempting any of the following acts:

  • Using any materials that are not authorized by the instructor for use during an examination.
  • Copying from another student's paper during an examination.
  • Collaborating (i.e., talking, passing notes and/or signals, etc.) during an examination with any other person by giving or receiving information without specific permission of the instructor.
  • Stealing, buying or otherwise obtaining information about an unadministered examination.
  • Substituting for another person or permitting any other person to substitute for oneself to take an examination.
  • Submitting another person's work as yours either in its original or altered form.
  • Giving someone else your work to fulfill his/her assignment.
  • Using the assignment of another class to fulfill an assignment for this class without authorized consent of the instructor.
  • Plagiarizing

Violations of proper ethical conduct will NOT be tolerated. A failing semester grade will be assigned to all involved parties (NO exceptions). Severe cases of academic dishonesty will be handled at the university level.

If you are aware of any academic dishonesty, please notify me either personally (your identity will remain confidential) or anonymously. Cheating devalues everyone's grade and degree, including your own.

Student Tutorial on how not to plagiarize: http://library.csus.edu/content2.asp?pageID=353

Incomplete (I) and Unauthorized Withdrawal (WU) Grades

An incomplete grade (I) will only be issued in accordance to College of Business Administration policy. Among the conditions imposed by the instructor that must be met are: (1) a current passing grade (70 percent or better), (2) the successful completion of all prior assignments and exams, and (3) an unforeseen and unusual event beyond your control which prevents you from completing the semester, and can be documented and verified (employment-related events do not qualify). (4) An incomplete will only be considered after it has been determined that a withdrawal (W) cannot be issued. If you do not meet (1) through (4), you do not qualify for an incomplete. As stipulated by the University, an incomplete cannot be assigned when it is necessary for the student to attend additional class meetings to complete the course requirements.

Unauthorized Withdrawal (WU) indicates that a student did not officially withdraw from the course but failed to complete it. Among the conditions imposed by the instructor that must be met are: (1) a passing grade (70 percent or better) at the time that the student stopped attending classes, (2) attendance stopped before the 11th week of the semester. If you do not meet (1) and (2), you do not qualify for an unauthorized withdrawal (WU) grade and as a result you will be assigned a failing (F) grade.


Laptop and cell phone regulation: No photographing, recording or text messaging is allowed without permission of the instructor.

If you have a disability and require accommodations, you need to provide disability documentation to SSWD, Lassen Hall 1008, (916) 278-6955. Please discuss your accommodation needs with me ASAP, so I can prepare your exams.

A disruptive student is a student who engages in classroom behavior that interferes with the process of teaching and learning. If a student is disruptive to my class, I will follow the Procedures for dealing with incidents of disruptive behavior described in the DEALING WITH INCIDENTS OF DISRUPTIVE STUDENT BEHAVIOR IN THE CLASSROOM document (http://www.csus.edu/umanual/student/UMD03250.htm).

Schedule Please look at our current semester's schedule.htm web page.

The above items of this syllabus are subject to change, update, or more specific interpretation: (i) material to be covered in the lectures, (ii) material to be covered in the exams and exam format, (iii) the exact way of group collaboration for each project part, and (iv) the exact cutoff point (specific second or third decimal) for every letter grade. Changes and updates will be posted on the WWW and announced in class ahead of time.