Data Warehousing

Data Warehousing TechnologiesData Warehousing Fundamentals, John Wiley & Sons

Course Description:

The Course will cover the following materials:

Data Warehouse Technologies. Data Marts. Metadata. Data warehouse Development. Architecture. Infrastructure. Platforms. Software Tools. STAR Schema. Snowflake Schema. ETL Functions. Data Quality. User Interface Features. Web-Enabled Data Warehouses. Data Mining. Physical Design. Deployment Issues. Maintenance.

Course Objectives:

· Provide a solid introduction to the topic of Data Warehousing.

· Show the difference between database and data warehousing.

· Introduce the ETL Model.

· Use the Star Schema to design a Data Warehouse.

Learning Outcomes:

After completing this course, the student should demonstrate the knowledge and ability to:

· Design a data warehouse or data mart to present information needed by management in a form that is usable for management clients.

· Implement a high quality data warehouse or data mart.

· Effectively administer a corporate data resource in such a way that it will truly meet management’s needs.

· Evaluate standards and new technologies to determine their potential impact on your information resource.

Teaching Resources:

Main Text Book:

Paulraj Ponniah, Data Warehousing Fundamentals, John Wiley & Sons, Inc. 2001.
Book Web site: http://www3.interscience.wiley.com/cgi-bin/bookhome/93516216
(Note: The book is available Online)

Supplementary Books:

• Jiawei Han and Micheline Kamber, Data Mining: Concepts and Techniques, 2^nd Ed., Morgan Kaufmann, 2006.
  ISBN 1-55860-901-6
  Book Web site: http://www-faculty.cs.uiuc.edu/~hanj/bk2/index.html . Note : From this Website, students can download the Original Book Slides prepared by the Authors of the Book.

· H. Liu and H. Motoda, Feature Selection for Knowledge Discovery and Data Mining, Kluwer, 1998.

Evaluation Plan:

Students will be evaluated in this course using a combination of assessment methods, including
Written Exams: First Exam: 20 Marks, Second Exam : 20 , Final Exam: 40 Marks
Assignments and Project : 20 Marks

Course Plan: Get the PDF version of the Course Syllabus
Week 1 : Introduction : The Compelling Need for Data Warehousing (Get Slides)

· Course Description
· Introduction to Data Warehouse and Data Warehousing
· Date Warehousing and Data Mining
· The Heart and aim of Data Warehousing
· A short history of Date Warehousing

Week 2: Data Warehouse: The Building Blocks (Get Slides)

Week 3:

• Data Mining Basics (Chapter 17) (Get Slides)
• Trends in Data Warehousing (Chapter 2) (Get Slides)

Week 4: Planning and Project Management (Get Slides)

Week 5: Defining the Business Requirements (Get Slides)

Click here to download the files:

-

	DATA WAREHOUSING
1.	Chapter 1 (ppt)
2.	Chapter 2 (ppt)
3.	Chapter 3 (ppt)
4.	Chapter 4 (ppt)
5.	Chapter 5 (ppt)
6.	Chapter 6 (ppt)
7.	Chapter 7 (ppt)
8.	Additional Material (zip file)