ISQS 3358 Business Intelligence
Spring 2008 Schedule
Class meetings: MW
2:00-3:20p, Lab 154
|
Date |
Day |
Contents |
|
Exercises |
Notes |
|
9-Jan |
Wednesday |
Introduction |
Ch1, slides |
|
|
|
14-Jan |
Monday |
Using Business
Intelligence |
Ch2, slides |
|
|
|
16-Jan |
Wednesday |
Data warehousing
with SQL Server 2005 |
Ch3, slides |
|
|
|
21-Jan |
Monday |
Martin
Luther King Jr.’s Birthday – No class |
|
|
|
|
23-Jan |
Wednesday |
Unified Dimensional
Model |
Ch4 |
Exer1 |
|
|
28-Jan |
Monday |
Dimensional
Modeling |
Ch5 |
|
Quiz 1, HW1 due |
|
30-Jan |
Wednesday |
Dimensional
Modeling |
Ch6, Slides |
Exer2 |
|
|
4-Feb |
Monday |
Creating and
populating data mart |
Ch6 |
|
|
|
6-Feb |
Wednesday |
Review |
Ch6, Slides |
Exer3 |
|
|
11-Feb |
Monday |
ETL system
development |
Ch7, Slides |
|
Quiz 2, HW2 due |
|
13-Feb |
Wednesday |
ETL system
development |
Ch7 |
Exer4 |
|
|
18-Feb |
Monday |
ETL system
development |
Ch7 |
|
|
|
20-Feb |
Wednesday |
ETL system
development |
Ch7 |
Exe5 |
Form project
team |
|
25-Feb |
Monday |
Cubism – Measures
and Dimensions |
Ch8, Slides |
|
Quiz 3 (ETL) |
|
27-Feb |
Wednesday |
Cubism – Measures
and Dimensions Getting |
Ch8 |
Exer6 |
Find a
project topic |
|
3-Mar |
Monday |
Started with SAS |
SAS EG Ch1-2 |
|
HW3
due (Optional) |
|
5-Mar |
Wednesday |
Accessing data mart
with SAS Enterprise Guide |
SAS EG Ch3, Slides |
Exe7 |
Project
deliverable 1: Proposal (Topic, analytic themes, high-level
dimensional model, available datasets) |
|
10-Mar |
Monday |
OLAP cube
Deployment |
Ch9, Slides |
|
Quiz 4 |
|
12-Mar |
Wednesday |
Additional features
of OLAP cubes |
Ch9 |
(The exercise has
been replaced by HW5) |
HW4
due, Project deliverable 2: Data mart development |
|
17-Mar |
Monday |
Spring Break |
|
|
|
|
19-Mar |
Wednesday |
Spring Break |
|
|
|
|
24-Mar |
Monday |
No class |
|
|
|
|
26-Mar |
Wednesday |
Querying data mart
with SAS Enterprise Guide |
SAS EG Ch4 |
Exer8 |
|
|
31-Mar |
Monday |
SAS EG |
SAS EG Ch5 |
|
HW5
due (Optional) |
|
2-Apr |
Wednesday |
Data preparation
for analytic tasks with SAS |
Exer9 |
|
|
|
7-Apr |
Monday |
SAS Data Step
Programming |
|
|
Project
deliverable 3: Populating the data mart |
|
9-Apr |
Wednesday |
SAS programming |
|
Exer10 |
|
|
14-Apr |
Monday |
SAS programming |
|
Quiz 5 (SAS
Programming) |
|
|
16-Apr |
Wednesday |
SAS programming |
|
Exer11 |
HW6
due |
|
21-Apr |
Monday |
SAS programming |
|
|
Project
deliverable 4: Analysis
report |
|
23-Apr |
Wednesday |
SAS programming |
|
Exer12 |
|
|
28-Apr |
Monday |
Overview of DW
Topics: MDX Scripting, Data Mining, Reporting |
|
HW7
due,
Quiz 6 (SAS Programming) |
|
|
2-May |
Friday |
|
|
|
|
|
5-May |
Monday |
Final Exam |
|
|
1:30-4p |
|
7-May |
Wednesday |
Project final report due |
|||
|
9-May |
Friday |
|
|
|
Project 2 due (Graduate students only) |