Fall 2008 Schedule (ISQS 6339)
TTh 2:00-3:20p, BA 363
(Computer Lab)
--------------------------------------------------------------------------------------------------------------------------------------
Textbooks and
references:
Delivering
Business Intelligence with Microsoft SQL Server 2005
SAS
|
Date |
Day |
Contents |
Readings &
References |
Exercises |
Notes |
|
Stage
1: Introduction to Business Intelligence |
|||||
|
26-Aug |
Tuesday |
Introduction |
Ch1, slides |
|
|
|
28-Aug |
Thursday |
Database Review |
|
|
|
|
2-Sep |
Tuesday |
Anatomy of Business
Intelligence |
Ch2, slides |
|
|
|
4-Sep |
Thursday |
Data warehousing
with SQL Server 2005 |
Ch3, slides |
|
|
|
Stage 2:
Principles of Data Warehousing |
|||||
|
9-Sep |
Tuesday |
Unified Dimensional
Model |
Ch4 |
Exer1 |
Quiz 1, HW1 due |
|
11-Sep |
Thursday |
Dimensional
Modeling |
Ch5 |
|
|
|
16-Sep |
Tuesday |
Dimensional
Modeling |
Ch6, Slides |
Exer2 |
|
|
18-Sep |
Thursday |
Creating and
populating data mart |
Ch6 |
|
|
|
23-Sep |
Tuesday |
Review |
Ch6, Slides |
Exer3 |
Quiz 2, HW2 due |
|
25-Sep |
Thursday |
ETL system
development |
Ch7, Slides |
|
|
|
30-Sep |
Tuesday |
ETL system
development |
Ch7 |
Exer4 |
|
|
2-Oct |
Thursday |
ETL system
development |
Ch7 |
|
Form
project team |
|
7-Oct |
Tuesday |
ETL system
development |
Ch7 |
Exe5 |
Quiz 3 (ETL) |
|
9-Oct |
Thursday |
Cubism – Measures
and Dimensions |
Ch8, Slides |
|
Find a
project topic |
|
14-Oct |
Tuesday |
Cubism – Measures
and Dimensions Getting |
Ch8 |
Exer6 |
HW3
due |
|
16-Oct |
Thursday |
Started with SAS |
SAS EG Ch1-2 |
|
Project
deliverable 1: Proposal (Topic, analytic themes, high-level dimensional
model, available datasets) |
|
21-Oct |
Tuesday |
Accessing data mart
with SAS Enterprise Guide |
SAS EG Ch3, Slides |
Exe7 |
Quiz 4 |
|
23-Oct |
Thursday |
OLAP cube
Deployment |
Ch9, Slides |
|
HW4
due, Project deliverable 2: Data mart development |
|
28-Oct |
Tuesday |
Additional features
of OLAP cubes |
Ch9 |
(The exercise is replaced by HW5) |
|
|
30-Oct |
Thursday |
Project 1
discussion |
DW-17 |
|
|
|
4-Nov |
Tuesday |
Querying data mart
with SAS Enterprise Guide |
SAS EG Ch4 |
Exer8 |
HW5
due |
|
6-Nov |
Thursday |
SAS EG |
SAS EG Ch5 |
|
Project deliverable 3: Populating the data mart |
|
Stage 3: Data Preparation for Analytics
with SAS |
|||||
|
11-Nov |
Tuesday |
Data preparation
for analytic tasks with SAS |
Exer9 |
Quiz 5 (SAS
Programming) |
|
|
13-Nov |
Thursday |
SAS Data Step
Programming |
|
|
|
|
18-Nov |
Tuesday |
SAS programming |
|
Exer10 |
HW6
due |
|
20-Nov |
Thursday |
SAS programming |
|
|
Project
deliverable 4: Analysis
report |
|
25-Nov |
Tuesday |
SAS programming |
Exer11 |
||
|
27-Nov |
Thursday |
No Class (Thanksgiving) |
|
|
|
|
2-Dec |
Tuesday |
SAS programming |
|
Exer12 |
HW7
due,
Quiz 6 (SAS Programming) |
|
9-Dec |
Tuesday (1:30p to
4:00p) |
Final
Exam (BA 363) |
|
|
Project 2 Due |
|
|
|
|
|
|
|