January
M Tuesday W Thursday F
22 
23 
Before Class:
Syllabus
Chapter 1: Equipping the Organization for Effective Decision Making

Class:
Introduction
Syllabus
Chapter 1: Equipping the Organization for Effective Decision Making (39:00) (notes, SMART Goals Handout)
24 
25 
Chapter 2: Making the Most of What You've Got--Using Business Intelligence
Using Business Intelligence (5:05)
Max Min, Inc. Introduction (3:07)

Due:
Quiz: Introduction, Chapters 1 & 2
Deadline for full refund
26 
Chapter 16: Building the Mine--Working with the Data Mining Model (34 pages)
Chapter 16: Building the Mine--Working with the Data Mining Model

Due:
Quiz:
Final Exam Review Game
29 
30 
Before Class:
Chapter 3: Seeking the Source--The Source of Business Intelligence

Class:
Data Marts Introduction (41:08) (private: sign-in with CSU ID to view)
31 

February
M Tuesday W Thursday F
1 
Chapter 4: Two, Two, Two Models in One--The BI Semantic Model
The BI Semantic Model Introduction (3:11)
Multidimensional Model (6:06) (private: sign-in with CSU ID to view)
The Tabular Model (1:52)
CougarVIEW Maintenance
2 
5 
Due:
Quiz: Chapters 3 & 4
6 
Before Class:
Chapter 5: First Steps--Beginning the Development of Business Intelligence

Class:
SQL Server Management Studio & SQL Server Data Tools Introductions (29:42)
7 
8 
Chapter 6: Building Foundations--Creating Data Marts
Building Data Marts (5:33) (private)
9 
12 
Due:
Quiz: Chapters 5 & 6
13 
Before Class:
Chapter 7: Transformers--Integration Services Structure and Components

Class:
Integration Services Introduction (1:07:33) (private)
14 
15 
Test VPN Connection (step 1 of Project 1)
CougarVIEW Maintenance
16 
19 
20 
Class:
Integration Services II (1:08:04) (private)
21 
22 
Integration Services: Data Flow Transformations (18:19) (private)
Integration Services: Data Flow Destinations (4:51) (private)
23 
26 
Due:
Quiz: Chapter 7
27 
Before Class:
Chapter 8: Fill 'er Up--Using Integration Services for Populating Data Marts

Class:
Using Integration Services I (1:09:53) (private)
28 

March
M Tuesday W Thursday F
1 
Using Integration Services II - Change Data Capture (12:21) (private)
Using Integration Services III - Production (8:42) (private)
CougarVIEW Maintenance
2 
5 
Due:
Quiz: Chapter 8
6 
Before Class:
Chapter 9: Cubism--Measures and Dimensions (34 pages)

Class:
Cubism--Measures and Dimensions (50:31) (private)
7 
8 
(work on Project 1)
9 
12 
Due:
Quiz: Midterm Review Game Questions
13 
Class:
Midterm Review Game (Chapters 1 - 9) (1:02:40)

Due:
Project 1: Designing and Creating Data Marts
14 
Due:
Quiz: Chapter 9
15 
(prepare for midterm)
CougarVIEW Maintenance
16 
Due:
Midterm Exam (Due Saturday)
19 
Spring Break
20 
21 
Spring Break
22 
23 
26 
27 
Before Class:
Chapter 10: Bells and Whistles--Special Features of OLAP Cubes (57 pages)

Class:
SQL Server Bells and Whistles (Part I) (1:11:45) (private)
28 
29 
30 

April
M Tuesday W Thursday F
2 
3 
Before Class:
Chapter 11: Writing a New Script--MDX Scripting (44 pages)

Class:
SQL Server Bells and Whistles (Part II) (12:36) (private)
MDX Scripting (Part I) (59:24) (private)
4 
5 
MDX Scripting (Part II) (5:02) (private)
CougarVIEW Maintenance
6 
Class:

Due:
Quiz: Chapter 10
Project 2: Populating Data Mart Using Integration Services
9 
Due:
Quiz: Chapter 11
10 
Before Class:
Chapter 12: Pulling It Out and Building It Up--MDX Queries (35 pages)

Class:
MDX Queries (58:08) (private)
11 
12 
(work on Project 3)
13 
16 
Due:
Quiz: Chapter 12
Project 3: Creating A Data Cube
17 
Before Class:
Chapter 13: Setting the Table--Creating a Tabular BI Semantic Model (49 pages)

Class:
Creating a Tabular BI Semantic Model (13:28) (private)
18 
19 
TBA
CougarVIEW Maintenance
20 
23 
Due:
Quiz: Chapter 13
24 
Before Class:
Chapter 14: A Fancy Table--Tabular BI Semantic Model Advanced Features (43 pages)

Class:
Tabular BI Semantic Model Advanced Features (Part 1) (30:39) (private)
Tabular BI Semantic Model Advanced Features (Part 2) (41:54) (private)
25 
26 
27 
30 

May
M Tuesday W Thursday F
1 
Class:
Final Project Introduction (8:08) (private)
2 
3 
4 
Due:
Quiz: Chapter 14
7 
8 
9 
10 
Final:
  • Section 01: 8:00 - 10:30 AM in CCT 450
  • Section V01: 8:00 - 10:30 AM in CCT 450 or with a proctor
11 

Legend

Read
YouTube video
Assignment (submit through CougarVIEW)
CougarVIEW Quiz
Project (submit through CougarVIEW)