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, Slides3

 

Create a BI project

28-Mar

Tue

Dimensional Modeling

BI-2, Slides4

Exer1

Quiz 1

30-Mar

Thu

Data warehousing with SQL Server 2016

BI-2, DW4&5, Slides5

Exer2

 

4-Apr

Tue

Creating data mart, Project Orientation

BI-2, DW6, , ProjOrient

Exer3

  Quiz 2

6-Apr

Thu

ETL

DW7, Slides6

Exer4

11-Apr

Tue

Cubism – Measures and Dimensions

DW8, DW9, Slides7, Slides8

Exer5 & Exer6

Project Stage 1: Project proposal (10%)

Quiz 3

13-Apr

Thu

Introduction datamining

UDM-Case

 

18-Apr

Tue

Getting Started with SAS Enterprise Guide

EG-1, 2, 3

EG-EX1&2

Quiz4

20-Apr

Thu

Querying data mart with SAS Enterprise Guide

EG-4, 5

EG-EX3

Project Stage 2: SQL Server data mart Done (20%)

Define SAS EG private library

25-Apr

Tue

Targeted advertising

Slides

EG-EX4

Quiz 5

27-Apr

Thu

Topic 1: Big Data Management

Topic 2: Big Data ETL

 

BigData-1

2-May

Tue

Topic 3: Big Data Visualization

Topic 4: Big Data Analytics

 

BigData-2

Quiz6

4-May

Thu

Topic 5: Streaming Data Processing

Topic 6: Realtime Data Analytics

BigData-3

Project Stage 3: Collaborative study (30%)

9-May

Tue

Big data analysis

Tableau Tutorials

BigData-4

11-May

Thu

Final Exam

 

 

 4:30-7:00p

12-May

Fri

Term project report

 

 

Project Stage 4: Final report (40%)

By 11:59p