Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Modeling 3 - Dimensional Data Modeling
Introduction
Introduction (1:57)
Course Goals (2:05)
Intro to Data Warehousing (6:42)
Dimensional Modeling Basics
Approaches to building a data warehouse (5:20)
Dimension tables explained (5:34)
Fact tables explained (6:34)
Identifying dimensions (3:16)
Data Warehouse Setup
What is duckdb (5:58)
First DuckDB hands-on (2:20)
Creating tables in duckdb (2:40)
Installing dbeaver (6:49)
Working With The Data Warehouse
Exploring scd0 and scd1 (19:57)
Exploring scd2 (13:52)
Exploring transaction fact table (6:28)
Exploring accumulating fact table (7:17)
Conclusion
Conclusion (0:52)
Exploring transaction fact table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock