ISQS 6339 Data Management & Business Intelligence

Spring 2012 Schedule

Class meetings: MW 12:30-1:50p, BA287

Textbooks: Delivering Business Intelligence with Microsoft SQL Server 2008 (DW)

Business Intelligence – A Managerial Approach (BI, optional)

SAS® Programming I: Essentials (PRG)

Querying and Reporting Using SAS® Enterprise Guide® (EG)

SAS® Enterprise Guide®: ANOVA, Regression, and Logistic Regression (EGBS)

 

Date

Day

Contents

Readings

Exercises

Notes

23-Jan

Mon

Introduction

 Slides

 

  

25-Jan

Wed

Anatomy of Business Intelligence

Slides

 

 

30-Jan

Mon

Anatomy of Business Intelligence

DW1-2, BI-1, Slides

Exer1 (DB vs. DW) 

 

1-Feb

Wed

Data warehousing

DW1-2, BI-2, Slides

 

 

6-Feb

Mon

Dimensional Modeling

Quiz 1 (BI-1, 2)

DW1-5, BI-2, Slides,

Exer2

  

8-Feb

Wed

Creating data mart

DW6, BI-2, Slides

 

13-Feb

Mon

Creating data mart

Term Project Orientation

DW6, BI-2, Slides

Exer3

Form project teams

15-Feb

Wed

Creating data mart

DW6

 

  

20-Feb

Mon

ETL system development

Quiz 2 (dimensional modeling)

DW7, Slides

Exer4

 

22-Feb

Wed

ETL system development

DW7-8

 

27-Feb

Mon

ETL system development

DW8

Exer5

 

29-Feb

Wed

ETL system development

DW8

 

5-Mar

Mon

Cubism – Measures and Dimensions

Quiz 3 (ETL)   

DW9, Slides

Exer6

 

7-Mar

Wed

Cubism – Measures and Dimensions

DW9, Slides

Project Stage 1: Proposal (Topic, analytic themes, high-level dimensional model, available datasets)  

12-Mar

Mon

Spring Break

 

 

 

14-Mar

Wed

Spring Break

 

 

 

19-Mar

Mon

Additional features of OLAP cubes

DW10

Exer7

   

21-Mar

Wed

SAS Programming

Slides,

PRG 1-2

 

26-Mar

Mon

SAS Programming

 PRG-3-5

Exer8

Project Stage 2: Data mart development

28-Mar

Wed

SAS Programming

 PRG-5-7

 

 

2-Apr

Mon

SAS Programming

Exercise 9 Instructions

PRG-8-9

Exer9

 

4-Apr

Wed

Getting Started with SAS Enterprise Guide

Quiz 4 (SAS Prog)

EG-1, 2

 

9-Apr

Mon

No class

 

 

 

11-Apr

Wed

Accessing data mart with SAS Enterprise Guide

EG-3

Exer10a

Project Stage 3: Populating the data mart

16-Apr

Mon

Querying data mart with SAS Enterprise Guide

EG-4

Exer10b

 

18-Apr

Wed

Summarized Outputs

EG-5

Exer11

 

23-Apr

Mon

Statistical analysis with EG  (ANOVA, regression)

Quiz 5 (Enterprise Guide)

EGBS-2

 

25-Apr

Wed

Statistical analysis with EG  (ANOVA, regression)

EGBS-3

Exer12

 

30-Apr

Mon

Quiz 6 (SAS EG problem solving)

Final Review

 

 

 

2-May

Wed

Merged to May-2’s class meeting

 

 

 Project Stage 4: Presentations

7-May

Mon

Term project presentation

 

 

11a-2p

10-May

Thu

Final Exam

 

 

4:30-7:00p

12-May

Sat

Term project due