CourseOutline

//**BBA(MIS) – Fall’ 2010**//
 * MIS343 - Data Warehousing**

Instructor: Syeda Saleha Raza Credit Hours: 3+1

**Objective:** The data warehouse continues to be one of the most organizationally complex and technically interesting projects in Information Technology. This course is a study of the techniques for design and construction of data warehouse. A specific focus will be given to various principles and techniques for Dimensional modeling, ETL, Data Quality and Cleansing, and OLAP. **Syllabus**

− **Fundamentals of Data Warehousing** OLTP Vs. OLAP, Evolution of a Data Warehouse, Architecture and Organization − **Data Modeling** ER Vs. Dimensional Modeling, Advanced Dimensional Modeling Techniques − **Data Staging and ETL** Issues related to extraction, transformation and loading of data warehouse. − **Data Access and Exploitation** Information in a data warehouse, Querying a DWH and SQL constructs for information access − **Data Quality and Cleansing** − **OLAP Implementation Techniques** ROLAP, MOLAP and HOLAP − **Advanced Analytical Queries** Supporting Ad hoc queries and knowledge access via MDX − **Physical Optimizations of Data Warehouses** Indexing, Joining and Query Optimization − **Overview of Datamining**

**Textbook** Data Warehousing Fundamentals ISBN: 0471412546 by: Paulraj Ponniah

**Reference books** Kimball Ralph, Ross Margy The Data warehouse Toolkit – The complete guide to dimensional modeling

Kimball, Ralph. “The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data”, John Wiley & Sons, Inc., ISBN: 0-471-15337-0.

**Grading**
 * Assignment || 05% ||
 * Quiz || 10% ||
 * Final Project || 15% ||
 * Term Exams || 30% ||
 * Final Exam || 40% ||

**Project** A class project of a small scale data warehouse will be designed that will cover the whole implementation of data warehouse, including Dimension Modeling, ETL & OLAP processing.

**Labs** Labs will be conducted on MS SQL Server 2005 platform and will cover the implementation of ETL and OLAP in SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) respectively.