MIS343_DATA_WAREHOUSING

=Reference Course Outline for: MIS343** __ : Data Warehousing __ **=

**Course Lead:**
Imran Khan

Course Description:
This course provides all the students in dept theoretical knowledge and its applications in business world. In this course implementation of a successful data warehouse is also analyzed. 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.

Prerequisite(s):
CSE341-Database System

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.

Primary Coure Outline Link:
Primary Course Outline.

Typical Semester in which this course is offered:
Fall

Programs in which course is offered:
BS/BBA-MIS

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.

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 Oracle or MS SQL Server and will align with the theory portion mainly covering installation and configuration of the product, designing warehouses and OLAP Servers, ETL through Oracle Warehouse Builder or 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.//