ISQS 3358 Business Intelligence
Spring 2009 Schedule
Class meetings: MW
2:00-3:20p, Lab 363
Textbooks: Business Intelligence – A Managerial
Approach (BI)
Delivering Business Intelligence with Microsoft SQL
Server 2005
(DW, optional)
|
Date |
Day |
Contents |
|
Exercises |
Notes |
|
7-Jan |
Wed |
Introduction |
|
|
|
|
12-Jan |
Mon |
Anatomy of Business
Intelligence |
BI-1, Slides |
|
|
|
14-Jan |
Wed |
Data warehousing
with SQL Server 2005 |
BI-1, Slides |
Exer1 (DB vs. DW) |
Lab 363 |
|
19-Jan |
Mon |
Martin
Luther King Jr. Day – No class |
|
|
|
|
21-Jan |
Wed |
BI theories,
implementation, and future |
BI-1 |
|
HW1 due |
|
26-Jan |
Mon |
Data warehousing |
BI-2, Slides |
|
|
|
28-Jan |
Wed |
Dimensional
Modeling |
BI-2, DW4, Slides |
Exer2 (Create DW
with SSMS) |
Quiz 1 (BI-1) |
|
2-Feb |
Mon |
Dimensional
Modeling |
BI-2, DW5 |
|
|
|
4-Feb |
Wed |
Creating
data mart |
BI-2,
DW6, Slides |
Exer3 |
HW2 due |
|
9-Feb |
Mon |
Creating
data mart |
DW6 |
|
Quiz 2 (BI-2) |
|
11-Feb |
Wed |
ETL
system development |
DW7 |
Exer4 |
|
|
16-Feb |
Mon |
ETL
system development |
DW7, Slides |
|
|
|
18-Feb |
Wed |
ETL
system development |
DW7 |
Exer5 |
|
|
23-Feb |
Mon |
Term
Project Orientation |
|
Form project team |
|
|
25-Feb |
Wed |
Cubism
– Measures and Dimensions |
DW8, Slides |
Exer6 |
Quiz 3 |
|
2-Mar |
Mon |
Cubism
– Measures and Dimensions |
DW8 |
|
|
|
4-Mar |
Wed |
Additional
features of OLAP cubes |
DW9 |
|
HW 3 (optional) due |
|
9-Mar |
Mon |
Additional
features of OLAP cubes
|
|
Exer7 |
Project
deliverable 1: Proposal (Topic, analytic themes, high-level dimensional
model, available datasets), Quiz 4 |
|
11-Mar |
Wed |
Getting
Started with SAS |
SAS
EG Ch1-2 |
Exer8 |
|
|
16-Mar |
Mon |
Spring Break |
|
|
|
|
18-Mar |
Wed |
Spring Break |
|
|
|
|
23-Mar |
Mon |
Discussion:
Business Analytics and Data Visualization |
BI-3, Slides |
|
|
|
25-Mar |
Wed |
Discussion:
Business Analytics and Data Visualization |
BI-3, Slides |
|
Project deliverable 2: Data mart
development HW 4 due |
|
30-Mar |
Mon |
Accessing
data mart with SAS Enterprise Guide |
SAS
EG Ch3 |
Exer9 |
|
|
1-Apr |
Wed |
Querying
data mart with SAS Enterprise Guide |
SAS
EG Ch4 |
|
HW5 due, Quiz 5 |
|
6-Apr |
Mon |
Querying
data mart with SAS Enterprise Guide |
SAS
EG Ch4 |
Exer10 |
Project
deliverable 3: Populating the data mart
|
|
8-Apr |
Wed |
Summarized
Outputs |
SAS
EG Ch5 |
Exer11 |
|
|
13-Apr |
Mon |
No
class |
|
|
|
|
15-Apr |
Wed |
Advanced
Queries |
SAS
EG Ch6 |
Exer12 |
|
|
20-Apr |
Mon |
Introduction to
Data Mining |
BI-4, Slides |
|
Quiz 6 Project
deliverable 4: Analysis
report |
|
22-Apr |
Wed |
Introduction to
Data Mining |
BI-4 |
|
|
|
27-Apr |
Mon |
Review |
BI-5 |
|
HW 6 due |
|
1-May |
Fri |
|
|
|
Project
report due |
|
4-May |
Mon |
Final Exam |
|
|
4:30-7:00p |
|
6-May |
Wed |
|
|
|
|