ISQS 3358-1 Business Intelligence

Fall 2016 Schedule (Subject to updates)

Class meetings: TR 12:30-1:50p, BA 103

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

 

Date

Day

Contents

Readings

Exercises

Notes

Aug-30

Tue

Introduction

Slides

 Map to a TTU Server 

Sep-01

Thu

Database review

Slides

Exer0

Citrix1, Citrix2

Sep-06

Tue

Anatomy of Business Intelligence

BI-1, Slides

Sep-08

Thu

Data warehousing with SQL Server 2005

BI-1, Slides

Exer1

Create a proj

Sep-13

Tue

BI theories, implementation, and future

BI-1

Sep-15

Thu

Data warehousing

BI-2, Slides

Sep-20

Tue

Dimensional Modeling

BI-2, DW4

Exer2 (Exploring IMW Data mart)

Quiz 1 (Review)

Sep-22

Thu

Dimensional Modeling

BI-2, DW5, Slides

 

Sep-27

Tue

Creating data mart

BI-2, DW6, Slides

Exer3

Sep-29

Thu

Creating data mart

BI-2, DW6

Oct-04

Tue

ETL system development

DW7, Slides

Exer4

Quiz 2 (Review)

Oct-06

Thu

ETL system development

DW7

Oct-11

Tue

Term Project Orientation

Slides

Exer5

Form project team

Oct-13

Thu

ETL system development

DW7, Slides

Oct-18

Tue

Cubism Measures and Dimensions

DW8

Exer6

Oct-20

Thu

Cubism Measures and Dimensions

DW8

Group meeting with instructor

Oct-25

Tue

Additional features of OLAP cubes

DW9, Slides

 

Quiz 3 (Review)

Project proposal due

Oct-27

Thu

Group meeting with instructor

 

Exer7

Nov-01

Tue

Getting Started with SAS Enterprise Guide

SAS EG Ch1-2

 

 Quiz 4 (Review)

Nov-03

Thu

Accessing data mart with SAS Enterprise Guide

SAS EG Ch1-2

EG-EX1

Group meeting with instructor

Nov-08

Tue

Querying data mart with SAS Enterprise Guide

SAS EG Ch3

EG-EX2

Group meeting with instructor

Nov-10

Thu

Querying data mart with SAS Enterprise Guide

SAS EG Ch4

Data mart development due

Nov-15

Tue

Introduction to big data

BI-4, Slides

Nov-17

Thu

Introduction to big data

BI-4, Slides

Quiz 5

Nov-22

Tue

Querying data mart with SAS Enterprise Guide

SAS EG Ch4

EG-EX3

Populating the data mart

Nov-24

Thu

Thanksgiving Day

 

 

 

Nov-29

Tue

Big data analytics

BD-EX1

Dec-01

Thu

Big data analytics

BD-EX2

Quiz 6

Dec-06

Tue

Team presentations

BD-EX3

Dec-09

Fri

 

 

 

Team Report due with Analysis outcomes from the data mart

Dec-10

Sat

Final Exam

 

 

1:30-4:00p