Spring 2007 Schedule (ISQS 3358)
Class meetings: MWF 9:00-10:50a,
BA363 (Lab) / BA255 (Lectures)
Reading Material Notations: DL – the
BI textbook by David Loshin; EG – the SAS EG course notes
|
Date |
Day |
Contents |
|
Exercises |
|
|
Mar 5 |
Monday |
Introduction |
DL 1 & 2 |
|
|
|
Mar 7 |
Wednesday |
The Value of BI |
DL 1 & 2, Slides |
Hands-on SAS
Enterprise Guide (EG), register to the class website, form groups, Working
with data in different formats |
|
|
Mar 9 |
Friday |
Data warehousing |
IMW case study, data pre-processing |
|
|
|
Mar 12-16 |
|
Spring break |
|
|
|
|
Mar 19 |
Monday |
Data mart, OLAP |
DL 6 |
EG reporting |
|
|
Mar 21 |
Wednesday |
BI modeling |
EG reporting |
Quiz 1 (DL 1, 2, 6) |
|
|
Mar 23 |
Friday |
Data quality |
DL 5, EG 4 |
EG query |
Lab 1 (Lab Assgn 1) |
|
Mar 26 |
Monday |
Data
transformation |
EG
4&5, slides |
Joining
tables, Summarized output |
Project 1 due, Lab 2 |
|
Mar 28 |
Wednesday |
Data
quality |
DL 9, EG
6 |
Advanced
query |
|
|
Mar 30 |
Friday |
Information
Integration |
DL 10, EG
5&6, slides |
Advanced query,
Custom format |
Quiz 2
(DL 5, 9), Lab 3 |
|
Apr 2 |
Monday |
Data
mining intro |
DL 14, slides |
Decision tree demon, SAS EM intro |
Lab 4 |
|
Apr 4 |
Wednesday |
Decision tree |
SAS reading (PDF
(2.24MB)) |
EG 5.3 |
Project 2 due, Lab 5 |
|
Apr 6 |
Friday |
Classification |
DL 7, slides |
EM decision tree |
Quiz 3 (DL 10, 14, decision tree) |
|
Apr 9 |
Monday |
Eastern |
|
|
|
|
Apr 11 |
Wednesday |
Classification |
EM decision tree |
Lab 6 |
|
|
Apr 13 |
Friday |
Clustering |
Clustering with SAS EM |
Project 3
due |
|
|
Apr 16 |
Monday |
Association Analysis |
Associate analysis with SAS EM |
Quiz 4 (DL 7, 15, data mining) |
|
|
Apr 18 |
Wednesday |
Probability and statistics basic |
Excel for statistics |
Lab 7 |
|
|
Apr 20 |
Friday |
Forecasting |
DL 12, Slides |
SAS EG Analytics |
Project 4
due, Lab 8 |
|
Apr 23 |
Monday |
Online marketing intelligence |
Propensity to buy |
Quiz 5 (DL 8, 12, Association
analysis) |
|
|
Apr 25 |
Wednesday |
Online marketing intelligence |
Handouts |
Abandon analysis |
Lab 9 |
|
Apr 27 |
Friday |
BI program and project management |
DL 3 & 4, slides |
SAS EG Review |
Lab 10 |
|
Apr 30 |
Monday |
Final Exam Review |
|
Quiz 6 (DL 3, 4, Web mining. Note: This is an optional quiz to make up
any previously missed one.) |
|
|
May 2 |
Wednesday |
|
|
|
Project 5 due |
|
May 7 |
Monday 1:45 – 3:45 p.m. |
Final Exam (open book), BA 363 |
|
|
|