Dimensional Modeling — Analytics Engineering (dbt & Data Warehousing)…
Facts and dimensions as the foundation
Steps in Dimensional Modeling
- Dimensional Modeling Fundamentals — beginner · Facts and dimensions as the foundation of analytical modeling
- Star Schema vs Snowflake Schema — beginner · Two classic approaches to structuring a dimensional model
- Slowly Changing Dimensions — beginner · Tracking how dimension attributes change over time
- Fact Table Grain and Design — beginner · Choosing the right level of detail for a fact table
- Modeling One Big Table (OBT) vs Star Schema — beginner · A more denormalized alternative gaining popularity in modern warehouses
Part of
- Analytics Engineering (dbt & Data Warehousing) roadmap — the full learning path