ISQS 3358 Business Intelligence

Spring 2016 Schedule

Class meetings: MWF 11:00-1:50p, BA103

Textbooks: Business Intelligence – A Managerial Approach (BI)

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

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

 

Week

Date

Day

Contents

Readings

Exercises

Notes

0

22-Jan

F

Introduction

 Slides

 

  

1

25-Jan

M

Anatomy of Business Intelligence

Slides, BI-1

Install Citrix Receiver

 

1

27-Jan

W

Anatomy of Business Intelligence

BI-1

Slides

 

 

1

29-Jan

F

Data warehousing

BI-1

Getting start with MS BIDS

 

2

1-Feb

M

Data warehousing, Dimensional Modeling

BI-2, DW1-2, Slides

DW-EX1

 

2

3-Feb

W

Dimensional Modeling

Quiz 1 (review)

BI-2, DW1-5

 

 

2

5-Feb

F

Dimensional Modeling

BI-2, DW1-5

 

 

3

8-Feb

M

Creating data mart

BI-2, DW6, Slides

  

3

10-Feb

W

Creating data mart

Guest speech: How to install SQL Server BIDS in your laptop

BI-2, DW6

DW-EX2

 

3

12-Feb

F

Creating data mart

BI-2, DW7

DW-EX3

 

4

15-Feb

M

Creating data mart

Quiz 2  (review)

BI-2, DW7

 

 

4

17-Feb

W

ETL system development

BI-2, DW,

Slides

DW-EX4

 

4

19-Feb

F

ETL system development

Term Project Orientation

BI-2, DW7

Slides 

 

 

5

22-Feb

M

ETL system development

BI-3, DW-7

 

Project Orientation  

5

24-Feb

W

ETL system development

BI-3, DW8

DW-EX5

Form project teams

5

26-Feb

F

Cubism – Measures and Dimensions

BI-3, DW8,

Slides

 DW-EX6

 

6

29-Feb

M

Cubism – Measures and Dimensions

BI-3, Slides

 

 

6

2-Mar

W

Cubism – Measures and Dimensions

Quiz 3 (review)

BI-3

DW-EX7

 

6

4-Mar

F

Publicly available big data services (Hortonworks, CloudEra)

Hadoop & Spark

 

7

7-Mar

M

Publicly available big data services (Hortonworks, CloudEra)

BigData-EX1

 

7

9-Mar

W

Data warehousing with Hadoop (HDFS, HIVE, NoSQL/NewSQL, and HBase)

HDFS/Hive

 

 

7

11-Mar

F

Build up a Big Data Platform

 

 

8

14-Mar

M

Spring Break

 

 

 

8

16-Mar

W

Spring Break

 

 

 

8

18-Mar

F

Spring Break

 

 

 

9

21-Mar

M

ETL (kettle, Flume, Sqoop)

 

 

9

23-Mar

W

ETL (kettle, Flume, Sqoop)

Quiz 4 (review)

 

 

 

9

25-Mar

F

Graph database (Neo4J)

Neo4J

BigData-EX2

Proposal (Topic, analytic themes, dimensional model, available datasets, 10%)

10

28-Mar

M

Easter – no class

 

 

 

10

30-Mar

W

Graph database (Neo4J)

 

BigData-EX3

 

10

1-Apr

F

Graph database (Neo4J)

Data Hub

 

11

4-Apr

M

Data Visualization & Reporting: SAS Enterprise Guide

EG-1, 2

BigData-EX4

11

6-Apr

W

Data Visualization & Reporting: SAS Enterprise Guide

EG-3

Analy-EX1

 

11

8-Apr

F

Data Visualization & Reporting: SAS Enterprise Guide

EG-4

Analy-EX2

 

12

11-Apr

M

Data Visualization & Reporting: SAS Enterprise Guide

EG-5

 

  

12

13-Apr

W

Quiz 5 (review)

 

12

15-Apr

F

Big data visualization

Analy-EX3

13

18-Apr

M

Rescheduled

 

13

20-Apr

W

Big data visualization

Tableau Tutorials

Analy-EX4

 

13

22-Apr

F

Big data visualization

 

 

14

25-Apr

M

Big data visualization

 

Analy-EX5

Data mart & data analysis (40%)

14

27-Apr

W

Big data visualization

Quiz 6 (review)

 

 

 

14

29-Apr

F

2016 Big Data Symposium

 

15

2-May

M

Final review

 

15

4-May

W

Final review

 

 

Presentation videos due (25%)

15

6-May

F

Rescheduled

 

 

 

16

9-May

M

Final review

 

 

Final report

By 11:59p (25%)

16

12-May

R

Final Exam

 

 

 1:30-4:00p