All Courses
Dimensional & Data VaultIntermediate → AdvancedNEW
Data Modelling
Master the data modelling skills that separate senior data engineers from juniors — dimensional modelling, star schemas, fact and dimension tables, SCDs, and Data Vault 2.0.
4.9rating0 students3h total3 lessons
What you'll learn
Design star schemas with correct grain, fact tables, and dimension tables
Choose between additive, semi-additive, and non-additive facts
Build a date dimension and conformed dimensions across fact tables
Implement SCD Types 1, 2, 3, 4, and 6 with full SQL
Track history automatically with dbt snapshots
Understand Data Vault 2.0 — Hubs, Links, Satellites
Load Data Vault tables with insert-only patterns
Decide when to use Kimball vs Data Vault
Final Project
Design the full data model for an e-commerce platform: star schema + SCD Type 2 customer dimension + Data Vault raw vault
Curriculum
3 lessons · 3hCourse Info
Lessons3 lessons
Total time3h
LevelIntermediate → Advanced
Students0
Rating4.9 / 5.0