mis343dw

=MIS343: Data warehousing= =Semester:= Fall 2011

Instructor:
Imran Khan

Program:
BBS-MIS, BS(CS)

Course Description
This course provides all the students in dept theoretical knowledge as well as its applications in business world. This course is organized in such a way that it will begin with an overview of concepts, moving on to planning and requirements, then to architecture and infrastructure, on to data design, then to organized information delivery, and concluding with deployment and maintenance. You can relate each concept and technique presented in this course to the data warehousing industry and marketplace. Student will benefit from the substantial number of industry examples. They will also design and implement a small data mart in Oracle Warehouse Builder and Oracle Database respectively. Extensive lab excercises are also included.

Course Objectives:
By the end of this course Students will be able to: - recognize the information crisis at every large scale enterprise - learn how data warehousing has become mainstream - understand business intelligence for an enterprise - get to know about each component or building block that makes up a data warehouse - understand Web-enabled data warehouse - distinguish between data warehouse projects and OLTP system projects - consider the warning signs and success factors - discuss how and why defining requirements is different for a data warehouse - understand the role of business dimensions - learn about information packages and their use in defining requirements - note the special considerations for ETL and metadata - understand the challenges for metadata management - introduce dimensional modeling and contrast it with entity-relationship modeling - review the basics of the STAR schema - find out what is inside the fact table and inside the dimension tables - determine the advantages of the STAR schema for data warehouses - learn about aggregate tables and determine when to use them - gain a true insight into why ETL is crucial, time consuming, and arduous - understand and apply the concepts of Data warehousing in the commercial business application.

Course Outline
1 Data Warehouse (DW) Introduction, The Compelling Need for DW (Ch#1) 2 Inmon’s 12 Rules, Difference b/w OLTP & OLAP 3 The Data Warehouse: The Building Blocks (Ch#2) 4 The Data Warehouse: The Building Blocks (Ch#2) 5 Trends in DW (Ch#3) 6 Planning and Project Management (Ch#4) 7 Defining the Business Requirements (Ch#5) 8 Requirement as the Driving Force for DW (Ch#6) 9 The Architectural Components (Ch#7) 10 The Architectural Components (Ch#7) 11 Infrastructure as the Foundation for DW (Ch#8) 12 Infrastructure as the Foundation for DW (Ch#8) 13 The Significant Role of Metadata (Ch#9) 14 The Significant Role of Metadata (Ch#9) 15 Principle of Dimensional Modeling (Ch#10) 16 Principle of Dimensional Modeling (Ch#10) 17 Dimensional Modeling: Advanced Topics (Ch#11) 18 Dimensional Modeling: Advanced Topics (Ch#11) 19 Data Extraction, Transformation and Loading (Ch#12) 20 Data Extraction, Transformation and Loading (Ch#12) 21 Data Quality: A Key to Success (Ch#13) 22 Matching Information to the Classes of Users (Ch#14) 23 OLAP in Data warehouse (Ch#15) 24 Data Mining Basics (Ch#17) 25 Data mining models and techniques 26 OLAP and Data mining (PR) 27 Project Presentations 28 Project Presentations

Text Books
Bk[1] Data Warehousing Fundamental A comprehensive guide for IT professional Second Edition By Paulraj Ponniah Bk[2] Building the Data warehouse Fourth Edition by W. H. Inmon Bk[3] The Data Warehouse Lifecycle Toolkit Second Edition by Ralph Kimble, Reeves, Margy Ross, warren B43Thornthwaite

Reference Books
BK[4] Building a Data warehouse for Decision Support Second Edition By Vidette Poe, Patricia Klauer, Stephen Brobst Bk[5] Mastering Data Warehousing Design Relational & Dimensional Techniques By Claudia Imhoff, Nicholas Galemmo, Jonathan G. Geiger

Web Resources
1. [] 2. [] 3. [] 4. []

Grading Policy

 * Midterm || 30 ||
 * Final Examination || 30 ||
 * Quiz (3 to 5) || 10 ||
 * Assignment (3 to 5) || 10 ||
 * Project || 20 ||
 * Total || 80 ||
 * Total || 80 ||