Fall 2007 Schedule (ISQS 6339)
TTh 12:30-13:50p, BA 271 (Lectures) or
BA 363 (Computer Lab)
--------------------------------------------------------------------------------------------------------------------------------------
Textbooks and references:
The
Microsoft Data Warehouse Toolkit, Joy Mundy and Warren Thornthwaite, Wiley,
2006 (DW)
Business
Intelligence: The Savvy Manager's Guide; Morgan Kaufmann,
June 2003 (BI)
Data
Preparation for Analytics Using SAS, Gerhard Svolba, SAS Press Series (SAS)
SAS
|
Date |
Day |
Contents |
Readings & References |
Exercises |
Notes |
|
Stage 1: Introduction
to Business Intelligence |
|||||
|
28-Aug |
Tuesday |
Introduction |
BI-1,
Slides |
|
|
|
30-Aug |
Thursday |
BI Trend and Dimensional Lifecycle |
BI-2,
DW-1 |
|
|
|
4-Sep |
Tuesday |
BI Project Methodology |
BI-3,4,7,
DW-1, Slides |
|
|
|
6-Sep |
Thursday |
BI Applications |
BI-5,6,
DW-2, Slides |
Exer1 (Database) |
|
|
Stage 2: Principles of
Data Warehousing |
|||||
|
11-Sep |
Tuesday |
Business process dimensional model |
DW-2,
BI-6, Slides |
Exer2 (Database) |
Quiz 1 (BI Fundamentals) |
|
13-Sep |
Thursday |
Business process dimensional model |
DW-2 |
Exer 2 (Cont’d) |
|
|
18-Sep |
Tuesday |
Microsoft DW/BI Toolset |
DW-3,
Slides |
|
|
|
20-Sep |
Thursday |
Physical data warehouse database design |
DW-4,
DW-5 |
Exer 3 (design SCD tables) |
|
|
25-Sep |
Tuesday |
ETL system design |
DW-5 |
|
Quiz 2 (Dimensional Modeling) |
|
27-Sep |
Thursday |
ETL system development |
DW-6, Experiment package |
Exer 4 (Container) |
|
|
2-Oct |
Tuesday |
ETL system development |
DW-6,
Slides |
Exer 5 (load a SCD) |
HW3 Due |
|
4-Oct |
Thursday |
Analysis services OLAP database |
DW-7,
EG-2, Slides |
Exer 6 (Explore Cube, EG-2) |
|
|
9-Oct |
Tuesday |
Analysis services OLAP database |
DW-7 |
Quiz 3 (ETL) Project 1: analytic
themes, high-level dimensional model (no deliverable) |
|
|
11-Oct |
Thursday |
Analysis services OLAP database |
DW-7,
EG-3 |
Exer 7 (EG-3) |
|
|
16-Oct |
Tuesday |
BI Applications with Reporting
Services |
DW-9,
EG-4, slides |
|
Project 1: Detailed dimensional
model development (deliverables) |
|
18-Oct |
Thursday |
BI Applications with Reporting
Services |
DW-9,
EG-5 |
Exer 8 (SSRS) |
|
|
23-Oct |
Tuesday |
Project 1 discussion |
DW-10,
slides |
|
Quiz 4 (SSAS,
DW/BI Applications) Project 1: Populating the data
warehouse (deliverables) |
|
25-Oct |
Thursday |
BI Applications with Reporting
Services |
DW-10 |
Exer 9 (EG OLAP) |
|
|
30-Oct |
Tuesday |
BI Applications with Reporting
Services |
DW-12,
13 |
|
Project 1
Due (Data warehouse demonstration) |
|
1-Nov |
Thursday |
Project 1 discussion |
DW-17 |
|
|
|
Stage 3: Data Preparation for Analytics with SAS |
|||||
|
6-Nov |
Tuesday |
Analytic business questions |
SAS-GS, Slides |
|
|
|
8-Nov |
Thursday |
Data preprocessing demonstration |
SAS-GS |
|
|
|
13-Nov |
Tuesday |
Data preparation for analytic
tasks |
SAS-GS |
|
Quiz 5 (Applications with SSRS,
SAS Enterprise Guide) |
|
15-Nov |
Thursday |
Data mart modeling |
SAS-GS |
|
|
|
20-Nov |
Tuesday |
Data mart coding |
SAS-GS |
|
|
|
22-Nov |
Thursday |
No Class (Thanksgiving) |
|
|
|
|
27-Nov |
Tuesday |
Data mart coding |
SAS-GS |
|
|
|
29-Nov |
Thursday |
Sampling scoring and automation |
SAS-GS |
|
Quiz 6 (Data mart, SAS
Programming) |
|
4-Dec |
Tuesday |
Review – SAS Data Preparation |
SAS-GS, Slides |
|
|
|
6-Dec |
Thursday |
Data mart case |
SAS-GS, Slides |
|
|
|
8-Dec |
Saturday (12:30-2:30p) |
Final
Exam (BA 363) |
|
|
|
|
10-Dec |
|
|
|
|
Project 2 Due |