DBW624 - Introduction To Datawarehousing

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.

Discrimination/Harassment
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.