Introduction
  • Introduction
  • About the Course
Traditional Data Warehousing
  • The Story So Far...
  • What is Data Warehousing
  • Why build a Data Warehouse
  • Basic DW Diagram
  • The Iron Triangle and Data Warehousing
  • The Data Journey
  • Data Warehousing Quiz #1
  • Data Warehousing Quiz #2
  • Data Warehousing Quiz #3
  • Summary
  • Introduction to Data Modeling
  • Introduction to SQL
  • SQL Quiz
  • Kimball Dimension and Fact Modelling
  • Bonus Lecture: Creating a Simple Dimensional Data Model
  • Bonus Lesson 1 Quiz
  • Inmon Relational Modelling
  • Big Data Modelling
  • Data Modeling Quiz
  • Architecture
  • Summary
  • Introduction to Extract, Transform, Load
  • Bonus Lecture 2: Preparation For the ETL
  • Extracting Data
  • Transforming Data
  • Loading Data
  • Bonus Document 1: Things to Keep In Mind About the ETL
  • Bonus Lecture 3: ETL Testing
  • ETL Quiz
  • ETL Quiz #2
  • Bonus Quiz #2: Playing Well With Others
  • Bonus Lecture: Interview Preview
  • Bonus Lecture: Interview with a Data Architect
  • ETL Tools
  • Summary
  • Introduction to Business Intelligence
  • BI Tools
  • Managing Report Development
  • Summary
  • The First Final Project
Transitioning to Modern Data Warehousing
  • Bonus: State of Data Warehousing in 2017
  • Data Lakes - Part I
  • Data Lakes - Part II
  • The BI/DW Project Manager in the Data Lake World
  • Real-Time Reporting
  • What's Streaming?
  • Fools Rush In...To Real-Time
  • Do Some Research into Distributed Architectures
  • The Traditional Data Warehouse -- 24 Hour Latency
  • Quick Reaction to Unelaborated Requirements
  • Requirements Redux
  • Last Look At Requirements
  • Lambda in the Cloud
  • Lambda On-Premises
  • Helpful Documentation
  • Organizing the Data Lake
  • Challenge Time: You Tell Me
Conclusion
  • What You've Learned
  • Epilogue