Joomla Free Templates by BlueHost Coupon

 Syllabus Fall 2015

MIS420 - Business Intelligence (3 Credit Hours)

I. Professor and TA Information





Dr. K. D. Joshi  (call me K.D or Dr. Joshi)

Mina Jafarijoo

Office Location

Todd 437J

Check with the TA

Office Hours

MW 2:00PM-3:30PM (Or by Appointments)

TA's Lab Hours - Tue/Th 4:15PM-5:45PM in Todd203

Email Policy

We will be using the "questions for the instructor" and "announcements from the instructor" link in the course space to communicate with you. Please ask all the course content related questions by posting your questions under the "questions for the instructor" discussion space.Please subscribe to these items so you can receive alerts when a post is made in this space - do you know how to "subscribe?"

If you have a personal question, then use my WSU email ( This email address is being protected from spambots. You need JavaScript enabled to view it. ) to correspond with me. According to WSU's new Email Policy ( I will be corresponding with you only via your WSU email.

Mina - This email address is being protected from spambots. You need JavaScript enabled to view it.


II. Course Information

Class Location

Todd 203

Class Time(s)

Section I: MWF 1:10PM - 2:00PM

MIS 420 Web Page – look for MIS420 Pullman Section 1

Pre Requisites



Required Book:Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition, By : Brian Larson McGraw-Hill/Osborne © 2012 ISBN: 978007175938


This course is an elective course within the Bachelor of Arts in Business Administration degree program. The learning goals for the program are as follows:

Goal 1: Graduates will be able to solve business problems, supported by appropriate analytical techniques.

Goal 2: Graduates will demonstrate cultural awareness and will be able to identify and evaluate the global implications of business decisions.

Goal 3: Graduates will demonstrate professional, socially responsible and ethical awareness.

Goal 4: Graduates will be effective business communicators.


III. Course Description and Objectives

The use of information systems to improve decision making, enhance a firm’s strategic position and ultimately sustain competitive advantage. This course introduces the subject of business intelligence (BI) by focusing on system design and development which can help support organizational decision making processes.Business Intelligence is an umbrella term that comprise of concepts, analytical tools, architecture, databases, data warehouses, and methodologies.These collectively help an organization in gathering and accessing data from its various business processes which can be further analyzed to make better business decisions. The objective of this course is to provide hands-on experience in designing and building BI systems using Microsoft’s BI stack. Broadly speaking the learning outcomes for this course are as follows:


Learning Outcomes

  1. Understand how BI helps organizations in decision making
  2. Understanding the concept of data warehousing
  3. Learn to design and build a Datamart
  4. Learn to populate a Datamart using an ETL process
  5. Learn to create an  OLAP system (Cube) for data access 
  6. Learn to deliver BI to the users through reports and dashboards


IV. Course Work

This is a VERY technical course. You will learn to design and build Business Intelligence Systems using the following four SQL Server 2012 application features: SQL Server DB Engine, SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS). The course work comprises of Four Modules.  The week-to-week course outline is located below under the Schedule Table.  The students will be evaluated on their individual and group performances.The course work items are briefly discussed below.


1.  Syllabus Quiz:This is a pop quiz that will be administered during the second week of classes. Refer to the class agenda and the schedule for more details.


2.  In Class Assignments (ICAs):In Class Assignments have to be completed based on class lecture and class activities – these have to be mostly completely in class. These assignments test your ability to: pay attention to the class lecture and hands-on instructions (listening), take notes in class (writing), and simultaneously engage and participate in active learning in class (comprehending).There will be FIVE ICAs covered in class. ALL five will be counted towards your grade. If you are unable to finish them in class, then I will give you one Lab period to finish the assignment. Lab hours are to finish the assignment which you started in class, NOT for doing the entire assignment in one lab period!Lab period is not a substitute for the class period. THERE IS NO MAKEUP FOR THE ICAs – NO EXCEPTIONS. Please do not ask for exceptions.


3.    Homework (HW):There will be a total of four homework assignments corresponding to each of the five modules.Best three will be counted towards your grade. Homework instructions will be posted under each module. LATE HW will not be accepted - NO EXCEPTIONS - I usually discuss the HW solutions in class, so I can/will not accept late HWs.Please do not ask for exceptions.Refer to the homework instructions for details. My TA or I will NOT answer any questions related to the homework on the day HW is due. HW is due at the start of the class.


4.      Exams: There will be two exams.DO NOT MISS THE EXAMS! The exams are required. If you miss an exam for ANY REASON (illness, athletic event, funerals, car problems, personal problems, alarm problems, interviews, etc.), then you have to take a make-up exam.The make-up exam will be COMPREHENSIVE ,i.e., inclusive of all the material covered over the entire course. The make-up exam will be on Wednesday of the dead-week.The exam will be administered between 2:15 -3:15P.M on Wednesday of the dead-week.You will get 50 min to finish the exam.The comprehensive make-up exam can (and probably will) have a different format from the regular exams during the semester. Anyone missing the exam, for valid and/or justifiable reason as determined by the professor and in conjunction with the university policy, must take this exam or else get a zero on the exam missed.To be eligible for this exam, the student must sign up in advance, by notification in writing vie email to the T.A(s), at least a week before the makeup exam. If you do not sigh-up for the exam by aforementioned date, then you will not be eligible for the make-up exam (and will receive a zero on the exam missed).Only students who have the exams (score of zero) are eligible.


5.   Group Project Deliverables (GD):More details regarding this item will be provided in the course space. Some group projects items have individual deliverables embedded in it (e.g., each group members will individually submit (in the GD designated dropboxes) all the group deliverables that the group completes) to ensure all group members are pulling their equal weight. Late proposals will be penalized. I will deduct 10% per hour for late submissions.


6.   Class Attendance, Participation, and Conduct: Class attendance is imperative for proper understanding of the subject and for finishing ICAs. Failure to attend class will not exempt you from being responsible for all the missed course content, ICA, homework, class participation, and announcements, modifications to the attached tentative schedule. Participation in class discussion is an important component of any learning experience.Students are at academic risk if they miss any classes because of the hands-on nature of the class and the numerous class assignments that are conducted in class. You are expected to behave professionally in the class.Be polite, courteous, and respectful towards your peers, your TA and your professor.Conduct such as using the computer for tasks not related to this class, talking, reading newspaper/magazines, doing work not related to this class, sleeping, listening to music, sarcastic comments etc. will NOT be tolerated. Students are expected to pay attention during class, follow the instructors’ instructions, and to answer when called upon. All students are encouraged to ask questions (but not be disruptive in doing so – especially when get behind during the ICAs). Students who are disruptive, disrespectful, and distracting will be asked to leave the class, and, in the professor’s discretion, may be dropped from the course by the professor. In addition and due to student conduct, in the professor’s discretion, the student’s grade may be reduced. In order to qualify to receive over 90% points on the attendance and participation grade, you will HAVE to attend at least 40 out of 43 class periods.


V. Class Policies (Email policy islisted under Section I)


  1. Class Preparation and Effort:It is your career and the onus is on you to put in your best effort to learn this material.I DO NOT GIVE GRADES, you earn them.I have very high expectations from the student who take this course.This course is interesting, challenging and time consuming.The expected work load for this class will be 10-15 hours per week, depending on your previous course work in MIS. Come prepared for class.If you find that you are not able to keep up with class work (especially the in class assignments), then you might need to put in more than 10-15 hrs per week to learn the concepts covered in this class.If you are having difficulty with learning the class material and need additional assistance, then please schedule regular weekly session with the class TA.You need to make sure you have access to the right software, computer rooms, your class accounts, and course materials to complete the assigned work on time.Not having access to your accounts, computers, software, or any other materials are not valid EXCUSES for incomplete, incorrect, or late assignments.
  2. Software Requirements: The following software is necessary on your home computers Microsoft SQL Server 2012 Enterprise Edition & Tableau.

Microsoft SQL Server 2012 Enterprise Edition: The latest versions of the SQL Server 2012 software can be downloaded for free using the WSU's license agreement with the Microsoft's Academic Alliance (MSDNAA). To download the software, please go to:  Select the Microsoft DreamSpark link. The downloads are very large, and it is not recommended to download the software unless you have a high-speed internet connection. (Software Installation Instructions)


Tableau: To obtain a copy of Tableau for your personal computer please follow the following instructions: Click on the link and select Get Started. On the form, enter your university email address for “Business email”; and under "Organization", please input the name of your school. Use the following Desktop Key: TDEW-B64C-6930-D46A-8719


3.     Appeals: Grade appeals will be accepted until a week after the grades have been posted on LMS (except the recording errors).Overdue appeals will not be considered.The written request must include the following (1) the aspect of the assignment that you want us to re-evaluate, and (2) why the original grade should be reconsidered.


<!4.     In Case Late or Absent: If you miss class or are late for class, it is your sole responsibility to get caught up (especially true for ICAs). The professor suggests that you go over the class agenda posted on the class web-site and confer with classmate(s) as to what was covered during the lecture(s) and/or what was announced during the lecture(s).


5.      Class SQL Server Accounts & Personal Computer:We will be testing all of your accounts’ viability in Todd203 well before we start the ICAs.If you are not in class when the accounts are tested then it is your responsibility to make sure you have access to the class accounts created for you. Faculty or TAs will not be able to help if you do not have access to the account right before the start of ICAs. You are responsible for making your personal computer work for this course. If you are not able to do the class work on your personal computer, then please go to the lab periods or use Todd330 open hours to do your work.


6.      Your Mobile Devices:In class, use the Todd203 computers to do the ICAs & to take class notes.If you choose to use your own device in class then you are responsible for making it work.TA or the instructor will not be able to troubleshoot. In addition, please turn-off the ringers. If your mobile device rings in class, then I get to answer it.


7.      Incompletes: Incompletes are granted only with permission of the Instructor and are subject to the following guidelines:

                     i.            Students must request an incomplete in writing or by e-mail from the Instructor before the end of the semester.

                   ii.            The request must be signed and dated by the student (or identified by student's e-mail address), and must explain the reasons behind the request for the incomplete.

                 iii.            In order to be considered for an incomplete, there are two main conditions:

a.       a student must complete a minimum amount of the assigned course work.

b.      the student must have a mathematical possibility of passing the class. A passing grade is 60 percent or above for the entire course.

                 iv.            If extraordinary circumstances (e.g., family emergency, serious illness) are involved and are documented to the Instructor’s satisfaction, the professor/ Instructor retains the discretion to grant an incomplete even if the minimum conditions outlined above are not met.

If an incomplete is granted, then the standard WSU policy applies (i.e., all work must be completed within one full year from the end of the enrollment semester at issue. Otherwise, an automatic grade of F, or failing, will be entered on the student’s transcript).


<8.      Academic Regulations: A complete listing of the WSU academic regulations are available online (Academic Regulations; select "Printable" next to "List All Academic Regulations" to view a printable list of all regulations).


<!9.      Academic Integrity: I encourage you to work with classmates on assignments. However, each student must turn in original work. No copying will be accepted. Students who violate WSU's Standards of Conduct for Students will receive an F as a final grade in this course, will not have the option to withdraw from the course and will be reported to the Office Student Standards and Accountability. Cheating is defined in the Standards for Student Conduct WAC 504-26-010 (3). It is strongly suggested that you read and understand these definitions.


<![if !supportLists]>10.  <![endif]>Disability Accommodations: Students with Disabilities: Reasonable accommodations are available for students with a documented disability. If you have a disability and need accommodations to fully participate in this class, please either visit or call the Access Center (Washington Building 217; 509-335-3417) to schedule an appointment with an Access Advisor. All accommodations MUST be approved through the Access Center.


<11.  Important Campus Safety Information: Washington State University is committed to enhancing the safety of the students, faculty, staff, and visitors. It is highly recommended that you review the Campus Safety Plan ( and visit the Office of Emergency Management web site ( for a comprehensive listing of university policies, procedures, statistics, and information related to campus safety, emergency management, and the health and welfare of the campus community.


<12.  Grading: The class assignments and the corresponding point distribution for the assigned class work is listed below.


Course Work

Points (% of your overall grade)

1.      Exam 1 - Modules 1 & 2


2.      Exam 2: Modules 3 & 4


<![if !supportLists]>3.      <![endif]>In-Class-Assignment (ICA)#1 - Excel and Tableau Reports using SSAS account & Class Handout


<![if !supportLists]>4.      <![endif]>ICA#2 - MaxMin Manufacturing Datamart Design Implementation in your DB Engine Account & Class Handout


<![if !supportLists]>5.      <![endif]>ICA#3 - MaxMin Manufacturing Cube & Class Handout


<![if !supportLists]>6.      <![endif]>ICA#4  Source to Target Mapping


<![if !supportLists]>7.      <![endif]>ICA#5 Populating MaxMin Manufacturing


<![if !supportLists]>8.      <![endif]>Homework (HW)#1 - Module 1


<![if !supportLists]>9.      <![endif]>HW2 - Module 2


<![if !supportLists]>10.  <![endif]>HW3 - Module 3


<![if !supportLists]>11.  <![endif]>Group Project (GD)#1- Project Proposal & Sample Reports


<![if !supportLists]>12.  <![endif]>GD#2 - Datamart Design


<![if !supportLists]>13.  <![endif]>GD#3/4- OLAP Cube & Final Reports


<![if !supportLists]>14.  <![endif]>Syllabus Quiz


<![if !supportLists]>15.  <![endif]>Class Attendance and Participation






Percent of Final Grade


Percent of Final Grade












65% –69.9%


83% –86.9%






Below 60%






<![if !supportLists]>13.  <![endif]>MIS Department Standards: Our mission is to build a “world class” MIS program with high standards.  In order to help insure high quality and consistency across the MIS curriculum and throughout the MIS program, it is strongly recommended that at the end of each semester in each MIS class section, MIS faculty members and professors end the semester with a final, overall grade point average for each class that complies with the ranges shown below.  Below the table with these grade point average ranges is another table showing how grade points correspond to letter grades.


Course Level

Recommended Final

Class GPA

100 and 200 Level Courses

2.5 – 2.9

300 Level Courses (MIS 325)

2.7 – 3.1

400 Level Courses

2.8 – 3.2


 Letter Grade


Corresponding Grade Point
























<![if !supportLists]>14.  <![endif]>Professionalism: Students who are uncooperative, rude, abusive to the TA’s, professor, staff members, or other students, whether in class or outside class, will be penalized.  Students who habitually miss class, show up late, bring food or drink into labs or lectures, read the paper or a magazine during class, cheat on assignments, tests or exams, use computers in class for anything other than approved class-related activities, or are disruptive in any other way, will be penalized.


Policy on Cheating -- Students are expected to uphold the WSU standard of conduct relating to academic dishonesty (see WSU Student Handbook, WAC 504-25-015).  Students assume full responsibility for the content and integrity of the academic work they submit.  The guiding principle of academic integrity shall be that a student's submitted work, examinations, reports, and projects must be that student's own work unless the faculty member explicitly authorizes otherwise (e.g., the faculty member may assign a team project or may require the students to gather information on the Web).   Students shall be guilty of violating the honor code if they:


<![if !supportLists]>1.            <![endif]>Represent the work of others as their own.

<![if !supportLists]>2.            <![endif]>Use or obtain unauthorized assistance in any academic work.

<![if !supportLists]>3.            <![endif]>Give unauthorized assistance to other students.

<![if !supportLists]>4.            <![endif]>Modify, without professor approval, an examination, paper, record or report for the purpose of obtaining additional credit.

<![if !supportLists]>5.            <![endif]>Misrepresent the content of submitted work.


The penalty for violating the honor code is severe.  Any student violating the honor code is subject to receive a failing grade for the course and to be reported to the Office of Student Affairs.  If a student is unclear about whether a particular situation may constitute an honor code violation, the student should meet with the professor to discuss the situation.


Policy on Threatening or Intimidating Behavior – Threatening or intimidating behavior is prohibited by the Legal Code of the State of Washington.  It is unlawful to interfere by force or violence with any administrator, staff member, faculty member or student (RCW 28B.10.570).  Intimidating a public servant is a class B felony (RCW 9A.76.180).  Such behavior might include yelling at others, slamming doors in the presence of others, using profanity in the presence of others, and will result in legal, administrative, and/or academic penalties.


Course Schedule

(ICAs will be announced in class & will be posted on the Class Agendas)




Key Course Content Links

 Tentative Dues Dates for HW and Project Deliverables

( For ICAs due dates please review the class agenda)

Week 1


1. Course Overview

- Get acquainted with course space
- Content, Objectives, and Structure
- Fill out group forms - We will use this info to create project teams
- Test your SSAS Accounts in Todd 203 - you will need this to do ICA#1 and HW1

2. Four Business Intelligence Capabilities (BIC) for Enterprise Success

  1. Agenda for Aug 24
  2. Course SQL Server Accounts Information
  3. Software Installation Instructions (Part 1 on HW#1)



Module 1: BIC#1 - Visualization and Intelligence Delivery Capability

Module 1 Content



Module 1: BIC#1 - Visualization and Intelligence Delivery Capability



Week 2


Module 1: BIC#1 - Visualization and Intelligence Delivery Capability



Module 1: BIC#1 - Visualization and Intelligence Delivery Capability


Syllabus Quiz


Module 1: BIC#1 - Visualization and Intelligence Delivery Capability



Week 3


 Labor Day Holiday




Module 2: BIC#2 - Data Warehousing Capability

Module 2 Content



Module 2: BIC#2 - Data Warehousing Capability



Week 4


Module 2: BIC#2 - Data Warehousing Capability




Module 2: BIC#2 - Data Warehousing Capability




Module 2: BIC#2 - Data Warehousing Capability



Week 5


Module 2: BIC#2 - Data Warehousing Capability




Module 2: BIC#2 - Data Warehousing Capability




Module 2: BIC#2 - Data Warehousing Capability



Week 6


Module 2: BIC#2 - Data Warehousing Capability




Module 2: BIC#2 - Data Warehousing Capability




Module 2: BIC#2 - Data Warehousing Capability

Exam 1 Review



Week 7 - Career Fair (


Exam I




Module 3: BIC#3 – Analytical Capability

Module 3 Content



Module 3: BIC#3 – Analytical Capability



Week 8 - Homecoming & Midnight Madness


Module 3: BIC#3 – Analytical Capability





Module 3: BIC#3 – Analytical Capability




 Module 3: BIC#3 – Analytical Capability



Week 9


Module 3: BIC#3 – Analytical Capability




Module 3: BIC#3 – Analytical Capability




 Module 3: BIC#3 – Analytical Capability


Week 10





Module 4 – BIC#4 - Data Integration Capability 

Module 4 Content



Module 4 – BIC#4 - Data Integration Capability  



 Module 4 – BIC#4 - Data Integration Capability 



Week 11 - Dad's Weekend (Dads are welcome to attend the class on Friday)


Module 4 – BIC#4 - Data Integration Capability 




Module 4 – BIC#4 - Data Integration Capability 




 Module 4 – BIC#4 - Data Integration Capability 



Week 12




Module 4 – BIC#4 - Data Integration Capability 




Veterans Day Holiday




 Module 4 – BIC#4 - Data Integration Capability 


Week 13


 Module 4 – BIC#4 - Data Integration Capability  




Group Project Status report – Presentation




Group Project Status report – Presentation 


Week 14 - Thanksgiving Break & Apple Cup

Week 15


Group Project Status report – Presentation




Exam 2 Review




 Exam 2



Week 16 -  Dead Week  


Group Work


Group Presentations (GD3) will be held on Thursday/Friday   OUTSIDE of the class time.


Group Work



No Class


Week 17 – Exam Week