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
and dimensional model |
Ch3, slides |
|
|
|
Stage
2: Implementation of Data Warehousing |
|||||
|
9-Sep |
Tuesday |
Getting Started
with SQL Server 2005 |
Ch4, slides |
Exer1 |
Quiz 1, HW1 due |
|
11-Sep |
Thursday |
Data warehousing
methodology |
Ch5 |
|
|
|
16-Sep |
Tuesday |
Dimensional
Modeling |
Ch6, Slides |
Exer2 |
|
|
18-Sep |
Thursday |
Creating and
populating data mart |
Ch6 |
|
|
|
23-Sep |
Tuesday |
ETL system
development |
Ch7, Slides(I) |
Exer3 |
Quiz 2, HW2 due |
|
25-Sep |
Thursday |
ETL system
development |
Ch7 |
|
|
|
30-Sep |
Tuesday |
ETL system
development |
Ch7, Slides(II) |
Exer4 |
|
|
2-Oct |
Thursday |
ETL system
development |
Ch7 |
|
|
|
7-Oct |
Tuesday |
ETL system
development |
Ch7 |
Exer5 |
Form
project team |
|
9-Oct |
Thursday |
Getting Started
with SAS Enterprise Guide |
|
Quiz 3 (ETL) |
|
|
14-Oct |
Tuesday |
Getting Started with SAS Enterprise Guide Tasks |
SAS EG Ch3, EG3 |
Exer6 |
HW3
due Class meeting is changed to 3:30-4:50p, lectured by Chinhwa Tan Find a
project topic |
|
16-Oct |
Thursday |
Creating Simple
Query with SAS Enterprise Guide |
SAS EG EG4 |
Exer7 |
|
|
21-Oct |
Tuesday |
Cubism – Measures
and Dimensions |
Ch8, Slides |
|
Project
deliverable 1: Proposal (Topic, analytic themes, high-level dimensional
model, available datasets) Quiz 4, HW4 due |
|
23-Oct |
Thursday |
Cubism – Measures
and Dimensions |
Ch8 |
Exer8 |
|
|
28-Oct |
Tuesday |
Creating Summarized
Output |
SAS EG Ch5 |
|
Class meeting is to be rescheduled
|
|
30-Oct |
Thursday |
OLAP cube
Deployment |
Ch9, Slides |
Exer9 |
Project
deliverable 2: Data mart development |
|
4-Nov |
Tuesday |
Additional features
of OLAP cubes |
Ch9 |
|
HW5
due |
|
6-Nov |
Thursday |
An Introduction to MDX |
Ch10, 11 |
|
Lectured by Yang Yu |
|
Stage 3: Data Preparation for Analytics
with SAS |
|||||
|
11-Nov |
Tuesday |
Data preparation
for analytic tasks with SAS |
|
Quiz 5 Project
deliverable 3: Populating the data mart |
|
|
13-Nov |
Thursday |
SAS Data Step Programming |
Exer10 |
Lectured by Yang Yu |
|
|
18-Nov |
Tuesday |
SAS programming |
|
|
HW6
due |
|
20-Nov |
Thursday |
SAS programming |
|
Exer11 |
|
|
25-Nov |
Tuesday |
SAS programming |
|
|
Project deliverable 4: Analysis
report |
|
27-Nov |
Thursday |
No Class (Thanksgiving) |
|
|
|
|
2-Dec |
Tuesday |
SAS programming |
|
Exer12 |
Project 1 due HW7
due, Quiz
6 (SAS Programming) |
|
5-Dec |
Friday (1:30p to
4:00p) |
Final
Exam (BA 363) |
|
|
To confirm
the availability of the lab |
|
|
|
|
|
|
|