ISQS 6339 Data Management & Business Intelligence

Spring 2017 Schedule

Class meetings: TR 2:00-4: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)

 

Date

Day

Contents

Readings

Exercises

Notes

21-Mar

Tue

Introduction & review

 Slides0, Slides1

 TTU Network Drives

Parallels installation

23-Mar

Thu

Business Intelligence & Big Data

BI-1, Slides2

Create a project

28-Mar

Tue

Data warehousing with SQL Server 2016

BI-2, Slides3

Exer1

Quiz 1

30-Mar

Thu

Dimensional Modeling

BI-2, DW4&5, Slides4

Exer2

4-Apr

Tue

Creating data mart

BI-2, DW6, Slides5

Exer3

  Quiz 2

6-Apr

Thu

ETL system development

DW7, Slides6

Exer4

 

11-Apr

Tue

Cubism – Measures and Dimensions

DW8, DW9, Slides7

Exer5

Quiz 3

13-Apr

Thu

Getting Started with SAS Enterprise Guide

EG-1, 2, 3

Analy-EX1&2

 

18-Apr

Tue

Querying data mart with SAS Enterprise Guide

EG-4, 5

Analy-EX3&4

Quiz4

20-Apr

Thu

An introduction to Data Mining

 

Analy-EX5&6

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

25-Apr

Tue

Targeted advertising

 

 

Quiz 5

Meeting for Topic 1

27-Apr

Thu

Classification modeling

 

BigData-1

Meeting for Topic 2, 3

2-May

Tue

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

Topic 3: MapReduce and Data mining

 

BigData-2

Quiz6

Meeting for Topic 4, 5

4-May

Thu

Topic 4: Big data ETL

Topic 5: Hadoop programming platform

Topic 6: Big data visualization & tools

 

Meeting for Topic 6, 7

9-May

Tue

Big data visualization

Tableau Tutorials

BigData-3

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

11-May

Thu

Final Exam

 

 

 4:30-7:00p

12-May

Fri

Term project report

 

 

By 11:59p (30%)