489 Data Warehousing

Week

 01 02 03 04 05 06 07 08 09 10
bullet

 

This Course Schedule is subject to change throughout the course.  Notification and appropriate adjustments to these requirements will be given in a timely manner!  

Week

Subject

Reading (Ponniah)

Activity

1

11/28-12/4

 

Introduction: why data warehousing?

DW Basics

- architecture

- W. Inmon & R. Kimball

- data marts

 

Chap. 1; skim Chap 3

 

Chap. 2

 

Ø  Website Search Assignment for Data Warehousing/BI Research(Report#1)

Ø  Practice Exercise(PE01): Simple ER è DM

2

12/5-11

 

DW Basics (con’t.)

- MOLAP, ROLAP

- fact and dimension tables

- star and snowflake schemas

DW Design

- designing dimensions

- designing facts

- multiple fact tables

 

pp. 394-8; pp. 226-34; pp. 259-62

 

 

 

 

Chap. 5 (skim pp. 109-119); Chap. 10

Ø  Analytical Paper(Report #2)

Ø  Practice Exercise(PE02): Information Packages

Ø  Practice Exercise(PE03): Conforming Dimensions

Ø  Lab 1:   Database Creation

3

12/12-18

 

DW Design (con’t.)

- advanced dimension design

- special types of facts

 

Chap. 11 pp. 249-265

Ø  Practice Exercise(PE04): Dimensional Modeling

4

1/9-15

 

DW Design (con’t.)

- exercises

ETL Process

- data sources

- extraction processes

 

 

 

Chap. 12; skim Chap. 13

Ø  Practice Exercise: Dimensional Modeling (continued)

Ø  Lab 2: Data Mart Design

5

1/16-22

ETL Process (con’t.)

- loading data

- tools  

- ETL Quadrant

Midterm Exam

 

 

 

Ø  Topics: Weeks #1-4

6

1/23-29

 

Data Cleansing & Implementation

- constraints & indexes

- security basics

- multiprocessing

- etc  

Pentaho Data Integration (Kettle)

bullet

Tutorials

bullet

Data Integration Steps

bullet

Documentation

 

Chap. 18; skim Chap. 4

 

Ø  Practice Exercise(PE05): Data Cleansing

Ø  Lab 3: Cleanse & Load

7

1/20-2/5

 

Dimensional Data Analysis

- SQL aggregation functions

- SQL analytical functions

 

 

Chap. 14;

Chap. 15

Ø  Practice Exercise(PE06): DW SQL Extensions #1

8

2/6-12

Summary Management

- materialized views

- query rewrite  

 

pp. 266-72, 485

Ø  Practice Exercise(PE07): DW SQL Extensions #2

Ø  Final Project Specifications & Requirements

9

2/13-19

Data Mining

- directed/supervised learning

- undirected/unsupervised learning

 

Chap. 17

Ø  Practice Exercise(PE08): DW SQL Extensions #3

10

2/20-3/4

 

 DW Security

- database issues

- enterprise issues

- case studies

 

pp. 502-4

Ø  Practice Activity: Case Study Reports (Report #3)

11

2/27-3/4

 

Project Defense/Exam

3/2/12(F) 10:15-12:15PM

 

 

 

top