DBW624 - Introduction to Datawarehousing

Outline info
Last revision date 2018-07-20 11:57:19.393
Last review date 2018-07-20 11:57:31.8

Subject Title
Introduction to Datawarehousing

Subject Description
The data warehousing marketplace continues to be one of the fastest growing areas of technology application. Whether it's used with CRM, ERP, e-Commerce, Financial Analysis, Sales Analysis or any of a large number of other disciplines, data warehousing has become an essential business tool for making informed decisions. This subject introduces students to data warehousing concepts. The subject uses a hands-on project to design and develop a data warehouse. Star schema fact tables and dimension tables will be examined. Multidimensional databases are emphasized as the students build on their database knowledge. A team project will be used to handle the process of moving data from an OLTP system to a DW with management reports through the cube and pivotal tables. Microsoft SQL server 2005 Analysis Services will be used to develop OLAP cubes and Microsoft Excel for OLAP reporting.

Credit Status
1 credit in the CPA/CPAC Programs

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Explain the goals of data warehousing

2. Create OLAP reports from the data cube using Excel

3. Explain accepted Datawarehouse terminology

4. Identify the stages of the data warehousing lifecycle

5. Denormalize relational tables into high level summary tables

6. Apply the star schema model to a business case problem

7. Compare star schema and snowflake schema

8. Design and Implement a multidimensional data cube using SQL Server Analysis Services

9. Create OLAP-enabled web pages

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.


Topic Outline
Concepts 15%

  • Reasons for data warehousing
  • Terminology
  • Data warehousing compared to OLTP
  • Components of a data warehouse
  • The data warehouse lifecycle
  • Managing the data warehouse

Data Warehouse Design 30%
  • Discussion of how DW database design differs from transactional database design
  • Grain
  • Facts and dimensions
  • Star and snowflake schema
  • Denormalize from OLTP, planned redundancy
  • Data marts and conformed dimensions
  • Strategies for maintaining the data warehouse
  • Meta data in a DW
  • Security in a DW

OLAP Cubes Design with SQL Server Analysis Services 50%
  • Analysis Services components and architecture
  • Define dimensions with Dimension Editor
  • Dimension levels and hierarchies
  • Define cubes and measure with Cube Editor
  • Process dimensions and cubes
  • Cube storage design
  • Create calculated members
  • Virtual cubes
  • Manage Partitions
  • Implement drillthrough and cube writeback
  • Cube security
  • Roles of Data Transformation Services (DTS)

Data Mining 5%
  • Fundamental data mining terminology and concepts
  • Use of built-in Analysis Manager wizards

Mode of Instruction
Classroom lectures and discussions are supplemented by lab sessions with the instructor, reinforced by assigned readings and assignments between classes. 

It is the student's responsibility to save documents, articles and notes that the instructor has provided on BlackBoard or in class. Students will not be able to access BlackBoard as of the last day of the student’s class.

Prescribed Texts
The Microsoft Data Warehouse Toolkit: with SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset, 2nd Edition. Thornwaite and Kimball. ISBN: 978-047-0640388

Reference Material
SQL Server 2008-  Analysis Services, Scott Cameron.
Microsoft Press,  ISBN# 978-0-7356-2620-1 

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.

Modes of Evaluation
Since this is a professional credit subject, marking standards reinforce professional practice by demanding legible, tidy work. Written materials should be well organized and grammatically correct, with proper spelling and punctuation.


  • Students must retain a duplicate of all assignments.
  • Computer assignments should be documented to the instructor's standards.
  • Assignments must be handed in on the scheduled due date. Late assignments are penalized.
  • For particulars, please obtain standards, dates, etc. from your instructor.

Absenteeism and Tests
  • Students should be aware that absenteeism will impact on their ability to achieve satisfactory grades.
  • If you miss a test, you must provide the reason in writing to the instructor prior to the next scheduled class. If your reason is accepted, you will be permitted to write a make-up test. Otherwise, you will be given a zero for the test. You must submit an original doctor’s certificate identifying the date, length of time of expected absence and the specific reason for your absence, or other appropriate documentation.

Term Work and Final Exam
  • Students must attain a combined grade of at least 50% on term work and the final exam. Students must pass the final exam in order to pass the subject. 
  • For further information on evaluation and academic standing, see a copy of the Academic Policy available at Seneca registration offices.

Grading is based on the following marking scheme:

Assignments (minimum of 2)
 Midterm Test
Final Evaluation

Approved by: Denis Gravelle