F09_MIS343_Datawarehousing

=BBA (MIS) - V= =Instructor: Shabbir Mukhi=
 * MIS343 Data Warehousing **

Course Description (As per IBA Prospectus)
This course analyzes the implementation of a successful data warehouse. Topics included are data warehousing fundamentals, project planning, business requirements definition, dimensional modeling, technical architecture, physical configuration options, product selection, physical database design, data staging process, data staging techniques, end use applications, deployment, management and growth. .

Objective
Data warehousing is an expanding subject area with more and more companies realizing the potential of a well set up OLAP system. Such a system provides a corporation with the means to analyze data in order to aid tasks such as targeting sales, projecting growth in specific areas, or even calculating general trends, all of which can give it an edge over its competition. By the end of this course students should be able to figure out what it takes to built a Data Warehouse and the steps required to build one. Final project will equip the students with the hands-on experience.

Lecture Plan

 * 1) History: Analysis and Operational System
 * 2) Needs and Why’s of Data Warehouse
 * 3) Comparison: DW and Operational Systems
 * 4) OLAP
 * 5) Data Marts
 * 6) Three Tier Architecture of DW
 * 7) Introduction to Data Mining
 * 8) DW ROI and Cost Analysis
 * 9) DW Project Team
 * 10) Designing a Data Warehouse
 * 11) From tables and spreadsheets to data cubes
 * 12) Multi-Dimensional Model: Star, Snowflake and Fact Constellation
 * 13) Dimensions and Measures
 * 14) Concept Hierarchies
 * 15) Star-Net Query Model
 * 16) OLAP Servers: ROLAP, MOLAP and HOLAP
 * 17) Data Staging and ETL : Data pre-processing (Cleaning, Integration and Transformation)


 * 1) Storage Tiers [DW 2.0 Concepts]
 * 2) Handling Unstructured Data [DW 2.0 Concepts]

Lab Sessions
Labs will be based on MS SQL Server 2005 and will align with the theory portion mainly covering installation and configuration of the product, designing warehouses and OLAP Servers, ETL through MS SQL Integration Services and OLAP Front-End.

Text Book

 * 1) Data Warehousing Fundamentals by Paulraj Ponniah

Reference Book

 * 1) Building the Data Warehouse by W. H. Inmon
 * 2) The Data Warehouse Toolkit by Ralph Kimball
 * 3) MS SQL Server 2005 Online Books (By Mircosoft Press included in the installation CDs)

//Note: The above lecture plan is a predicted pathway and the actual delivery may vary depending on the class knowledge of the pre-requisites, comprehension of the course and the overall interest.//