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 Enterprise Guide v4 (EG) (Available for the registered students)

 

Date

Day

Contents

Readings & References

Exercises

Notes

Stage 1: Introduction to Business Intelligence

26-Aug

Tuesday

Introduction

Ch1, slides

 

 

28-Aug

Thursday

Database Review

slides

 

 

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

SAS EG Ch1-2, EG1, EG2

 

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

Slides

 

Quiz 5

Project deliverable 3: Populating the data mart

13-Nov

Thursday

SAS Data Step Programming

Slides

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