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)

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