ISQS 6339 Data Management & Business Intelligence

Spring 2015 Schedule

Class meetings: TR 12:30-1:50p, BA003

Textbooks: Business Intelligence – A Managerial Approach (BI)

Delivering Business Intelligence with Microsoft SQL Server 2008 (DW, optional)

SAS® Programming I: Essentials (SAS-1)

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

 

Date

Day

Contents

Readings

Exercises

Notes

15-Jan

Thu

Introduction

 Slides

 

  

20-Jan

Tue

Anatomy of Business Intelligence

Slides, BI-1,

 

 

22-Jan

Thu

Anatomy of Business Intelligence

BI-1

Slides

Exer0: warming up with SQL Server 2008

 

27-Jan

Tue

Data warehousing, Dimensional Modeling

Quiz 1

BI-2, DW1-2, Slides

Exer1 (DB vs. DW) 

 

29-Jan

Thu

Dimensional Modeling

BI-2, DW1-5

 

  

3-Feb

Tue

Creating data mart

BI-2, DW6, Slides

Exer2

 

5-Feb

Thu

Creating data mart, ETL

BI-2, DW6, Slides 

Exer3

 

10-Feb

Tue

ETL system development

Term Project Orientation

Quiz 2

BI-2, DW7, Slides

 

Project Orientation  

12-Feb

Thu

ETL system development

BI-2, DW7,

Slides

Exer4,

HW #1 Due  (optional)

Form project teams

17-Feb

Tue

Cubism – Measures and Dimensions

BI-3, DW-7, Slides

 

 

19-Feb

Thu

Cubism – Measures and Dimensions

BI-3, DW8

Exer5

 

24-Feb

Tue

Cubism – Measures and Dimensions

Quiz 3

BI-3, DW8, Slides

Exer6

 

26-Feb

Thu

Customize a cube and data mining

BI-3

Exer7

 

3-Mar

Tue

Data warehousing with Hadoop

 Slides

HW #2 Due (optional)

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

5-Mar

Thu

Data warehousing with Hadoop

Quiz 4 (open book)

Slides

BigData-EX1

 

10-Mar

Tue

Data Visualization & Reporting: SAS Enterprise Guide

EG-1, 2

EG-EX1

 

12-Mar

Thu

Data Visualization & Reporting: SAS Enterprise Guide

EG-3, 4

EG-EX2

 

17-Mar

Tue

Spring Break

 

 

 

19-Mar

Thu

Spring Break

 

 

 

24-Mar

Tue

Data Visualization & Reporting: SAS Enterprise Guide

Quiz 5 (open book)

EG-5

EG-EX3

 

26-Mar

Thu

Data preparation for data mining

SAS-1-4

Slides

EG-EX4 (optional)

EG-EX5

Project Stage 2: SQL Server Data mart Done (25%)

31-Mar

Tue

Data preparation for data mining

SAS 5-6

 

Meeting for Topic 1

2-Apr

Thu

Quiz 6 (open book)

 

 

Meeting for Topic 2 

7-Apr

Tue

Topic 1: Data warehousing

 

Meeting for Topic 3  

9-Apr

Thu

Rescheduled for Big Data Symposium on 4/10

 

BigData-EX2

10-Apr

Fri

2015 Big Data Symposium

 

 

 

14-Apr

Tue

Topic 2: Publicly available big data services (Hortonworks, CloudEra, HaaS, EC2)

 

Project Stage 3: Hadoop project proposal (10%)

Meeting for Topic 4

16-Apr

Thu

Topic 3: MapReduce and Data mining

 

BigData-EX3

Meeting for Topic 5

21-Apr

Tue

Topic 4: Big data ETL-1

 

Meeting for Topic 6

23-Apr

Thu

Topic 5: Big data ETL-2

 

 

Meeting for Topic 7

28-Apr

Tue

Rescheduled for Big Data Symposium on 4/10

 

 

 

30-Apr

Thu

Topic 6: Hadoop programming platform

 

BigData-EX4

Project Stage 4: Hadoop data mart implementation plan (25%)

5-May

Tue

Topic 7: Big data visualization & tools

 

 

12-May

Tue

Final Exam

 

 

 1:30-4:00p

12-May

Tue

Term project report

 

 

By 11:59p (30%)