*** The official course schedule is maintained in Canvas. This was the initial fall 2018 schedule and is not guaranteed to be accurate.
| WK# | Date of Class session | Topic(s) | Text Reference (read prior to class) | Assignments | Concept Quizzes & Assignments due | ||||||||||||
| Wk1 | Aug 23 | Introduction to course | |||||||||||||||
| Aug 24 | Data Warehouse & Business Intelligence (DW/BI) Basic concepts | Kimball & Ross (K&R), Chapter 1 – Data Warehousing, Business Intelligence, and Dimensional Modeling Primer | |||||||||||||||
| Wk2 | Aug 28 | Basic concepts continued | |||||||||||||||
| Aug 30 | Retail Sales Case Study (4 step design process, date dimension, degenerate dims) | K&R, Chapter 3 – Retail Sales | assignment 1 – POS model – assigned | quiz1 – DW/BI primer | |||||||||||||
| Aug 31 | Discussion / Data Model exercises | ||||||||||||||||
| Wk3 | Sep 4 | Inventory Case Study (value chain, fact table types, bus architecture, conformed dimensions) | K&R, Chapter 4 – Inventory | quiz2 – retail sales | |||||||||||||
| Sep 6 | Intro to AppStream lab – Kris Barth & Lori Beebe
Procurement (single vs. Multiple transaction fact tables, slowly changing dimensions) |
K&R, Chapter 5 – Procurement | Assignment 1 – due | ||||||||||||||
| Sep 7 | SQL Primer and exercises | If you don’t have experience with SQL, go through SQL tutorial prior to class. http://sqlzoo.net/ | |||||||||||||||
| Wk4 | Sep 11 | Order Management (Fact Normalization, Dim role playing, Junk dims, accumulating snapshots) | K&R, Chapter 6 – Order Management | Assignment 2 – registrar model – assigned | Quiz3 – Inventory | ||||||||||||
| Sep 13 | Bottom Up Data Modeling –Neil Belcher | Quiz4 – procurement | |||||||||||||||
| Sep 14 | Bottom Up Analysis Lap for Project teams
– Neil Belcher |
||||||||||||||||
| Wk5 | Sep 18 | Lecture: ETL System Design, Intro to WhereScape | K&R, Chapter 20 – ETL | Assignment 3 WhereScape – assigned | Assignment 2 – due
Quiz5 – Order Management |
||||||||||||
| Sep 20 | Accounting (year-to-date facts, fixed vs ragged hierarchies, consolidated fact tables) | K&R, Chapter 7 – Accounting |
|
||||||||||||||
| Sep 21 | WhereScape exercises | Project Teams announced.
Project data made available |
|||||||||||||||
| Wk6 | Sep 25 | Data Integration Guest lecture –Derek Messie –John Parker | Assignment 4 Boomi – assigned | Assignment 3 – due
Quiz6 – ETL |
|||||||||||||
| Sep 27 | Guest Lecturer from WhereScape – Chris Stewart | Quiz7 – Accounting | |||||||||||||||
| Sep 28 | Boomi working session | ||||||||||||||||
| Wk7 | Oct 2 | SQL for Data Profiling and Dimensional Models | Assignment 5 SQL – assigned | Assignment 4 – due | |||||||||||||
| Oct 4 | Guest Lecturer – Data Integration – Jeff Burk from Dell Boomi | Quiz8 – Data Integration | |||||||||||||||
| Oct 5 | Meet clients and gather requirements | ||||||||||||||||
| Wk8 | Oct 9 | Fall Break – No class | |||||||||||||||
| Oct 11 | Big Data | Read the following two articles in preparation for class lecture: http://searchbusinessanalytics.techtarget.com/feature/Big-data-vendors-should-stop-dissing-data-warehouse-systems
http://www.b-eye-network.com/view/17017 |
|||||||||||||||
| Oct 12 | Project specific data profiling | ||||||||||||||||
| Wk9 | Oct 16 | Data Visualization and Tableau | Assignment 6 Tableau – assigned | Assignment 5 – due | |||||||||||||
| Oct 18 | Data Visualization continued | ||||||||||||||||
| Oct 19 | Project Specific WhereScape working session | ||||||||||||||||
| Wk10 | Oct 23 | DW/BI Lifecycle | K&R, Chapter 17 – Kimball
DW/BI Lifecycle Overview |
Assignment 6 – due
Quiz9 – Data Visualization & Big Data |
|||||||||||||
| Oct 25 | Team Project check-in | ||||||||||||||||
| Oct 26 | SQL – common functions | ||||||||||||||||
| Wk11 | Oct 30 | Tableau Visualizations – Guest Lecture –Cindy Sedlacek -Karel Sedlacek |
Quiz10 – DW Life Cycle | ||||||||||||||
| Nov 1 | OBIEE & BI Publisher – Guest Lecture
-Neil Belcher -Patty Carnell -Tim Pollard |
Team Milestone 1 – Requirements, Data Model, ETL documentation – due | |||||||||||||||
| Nov 2 | Team Work Session – ETL & Data Modeler expertise will be available for questions. | ||||||||||||||||
| Wk12 | Nov 6 | AWS Analytics – Guest Lecture – Mike Kuentz | |||||||||||||||
| Nov 8 | Amy Cheatle & Patrick Graham will introduce ePortfolio and how to use for your team projects.
Team Work Session – ETL & Data Modeler expertise will be available for questions. |
||||||||||||||||
| Nov 9 | Team Project – working session – WhereScape expertise will be available | ||||||||||||||||
| Wk13 | Nov 13 | Data Visualization requirements gathering | Team milestone 2 – populated Data Model – due | ||||||||||||||
| Nov 15 | Team Project check in/work session | ||||||||||||||||
| Nov 16 | Team Project – Tableau working session. Tableau expertise will be available to review your progress and give advice. | Team Project Tableau Work check in | |||||||||||||||
| Wk14 | Nov 20 | Advanced DW/BI considerations | |||||||||||||||
| Nov 22 | Thanksgiving break – no class | ||||||||||||||||
| Nov 23 | Thanksgiving break – no class | ||||||||||||||||
| Wk15 | Nov 27 | Campus Life Enterprise Services Facilities – Student Team Project Presentations | |||||||||||||||
| Nov 29 | IT Security Office Certified Desktop Compliance – Student Team Project Presentations | ||||||||||||||||
| Nov 30 | Team Presentations | Team Projects milestone 3 due (10am) | |||||||||||||||