ISQS 6339 Data Management & Business Intelligence

Spring 2013 Schedule

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

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)

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

 

Date

Day

Contents

Readings

Exercises

Notes

17-Jan

Thu

Introduction

 Slides

 

  

22-Jan

Tue

Anatomy of Business Intelligence

Slides, BI-1,

 

 

24-Jan

Thu

Anatomy of Business Intelligence

BI-1, Slides

Exer0: warming up with SQL Server 2008

 

29-Jan

Tue

Data warehousing

BI-2, DW1-2, Slides

Exer1 (DB vs. DW) 

 

31-Jan

Thu

Dimensional Modeling

BI-2, DW1-5, Slides,

 

  

5-Feb

Tue

Creating data mart

Quiz 1

BI-2, DW6,  Slides

Exer2

 

7-Feb

Thu

Creating data mart

BI-2, DW6, Slides

Exer3

 

12-Feb

Tue

ETL system development

BI-2, DW7,

Slides

 

Project Orientation  

14-Feb

Thu

ETL system development

Term Project Orientation

BI-2, DW7, Slides

Exer4,

HW #1 Due  (optinal)

Form project teams

19-Feb

Tue

ETL system development

Quiz 2 (dimensional modeling, ETL)

BI-3, DW-8, Slides

 

 

21-Feb

Thu

Cubism – Measures and Dimensions

BI-3, DW8

Exer5

 

26-Feb

Tue

Cubism – Measures and Dimensions

BI-3, DW8, Slides

Exer6

 

28-Feb

Thu

Introduction to Business Analytics

BI-3, Slides

Exer7

 

5-Mar

Tue

Getting Started with SAS Enterprise Guide

Quiz 3 (OLAP, Business Analytics)

EG-1, 2

HW #2 Due (optional)

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

7-Mar

Thu

Accessing data mart with SAS Enterprise Guide

EG-3

EG-EX1

   

12-Mar

Tue

Spring Break

 

 

 

14-Mar

Thu

Spring Break

 

 

 

19-Mar

Tue

No class (replaced by the symposium attendance)

 

BigData-EX1

 

21-Mar

Thu

Querying data mart with SAS Enterprise Guide

EG-4

EG-EX2

 

26-Mar

Tue

Summarized Outputs

Quiz 4 (SAS EG)

EG-5

EG-EX3

 

28-Mar

Thu

Statistical analysis with EG  (ANOVA, regression)

EGBS-2

EG-EX4

Project Stage 2: Data mart development

2-Apr

Tue

Introduction to Base SAS programming

SAS-1

Slides

 

 

4-Apr

Thu

Introduction to Base SAS programming

SAS-1

 EG-EX5

 

9-Apr

Tue

Big data and cloud computing

 

 

 

11-Apr

Thu

Hadoop & MapReduce

Quiz 5 (SAS-1 Programming)

 

BigData-EX2

 

16-Apr

Tue

HDFS, HIVE, NOSQL, and HBase

 

 

Project Stage 3: Populating the data mart

18-Apr

Thu

Guest speakers

·         12:30-1:00p: Jonghyun Kim, “Perl programming for SQL Server Admin”

·         1:00-1:50p: Dale Ganus, “Harnessing IT advancement for your career”

 

BigData-EX3

 

23-Apr

Tue

ZooKeeper, Storm, Pig

 

 

 

25-Apr

Thu

Mahout, Amazon EC2 case

Quiz 6 (Big data)

 

BigData-EX4

 

30-Apr

Tue

Final review

 

 

 

2-May

Thu

Term project presentation

 

 

Project Stage 4: Presentations

7-May

Tue

Term project presentation

 

 

 

11-May

Sat

Term project report

 

 

By 5:00p

14-May

Tue

Final Exam

 

 

 1:30-4:00p