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 |
|
||
23-Mar |
Thu |
Business
Intelligence & Big Data |
|
||
28-Mar |
Tue |
Dimensional
Modeling |
BI-2,
Slides4 |
Quiz
1 |
|
30-Mar |
Thu |
Data
warehousing with SQL Server 2016 |
BI-2,
DW4&5, Slides5 |
|
|
4-Apr |
Tue
|
Creating
data mart, Project Orientation |
BI-2,
DW6, , ProjOrient |
Quiz
2 |
|
6-Apr |
Thu |
ETL |
DW7, Slides6 |
||
11-Apr |
Tue |
Cubism
– Measures and Dimensions |
Project Stage 1: Project proposal (10%) Quiz
3 |
||
13-Apr |
Thu |
Introduction datamining |
|
||
18-Apr |
Tue |
Getting Started with SAS Enterprise Guide |
EG-1,
2, 3 |
Quiz4 |
|
20-Apr |
Thu |
Querying data mart with SAS Enterprise Guide |
EG-4,
5 |
Project Stage 2: SQL Server data mart Done (20%) |
|
25-Apr |
Tue |
Targeted
advertising |
Quiz
5 |
||
27-Apr |
Thu |
Topic
1: Big Data Management Topic
2: Big Data ETL |
|
||
2-May |
Tue |
Topic
3: Big Data Visualization Topic
4: Big Data Analytics |
|
Quiz6 |
|
4-May |
Thu |
Topic
5: Streaming Data Processing Topic
6: Realtime Data Analytics |
Project Stage 3: Collaborative study (30%) |
||
9-May |
Tue |
Big
data analysis |
|||
11-May |
Thu |
Final Exam |
|
|
4:30-7:00p |
12-May |
Fri |
Term project report |
|
|
Project Stage 4: Final
report (40%) By 11:59p |
|
|
|
|
|
|