Unit 1: Introduction to Dimensional Modeling
Unit 2: Designing Dimensional Models
Unit 3: Practical Considerations
Data Modeling for Analytics Engineers: Dimensional Modeling & dbt
Master data modeling techniques with dimensional modeling and dbt to build efficient and scalable data warehouses for analytics.
Unit 1: Slowly Changing Dimensions (SCDs)
Unit 2: Advanced SCD Types and Data Vault
Unit 1: dbt Fundamentals
Unit 2: Building Data Models with dbt
Unit 3: Testing and Documentation
Unit 1: Fundamentals of Data Model Optimization
Unit 2: Indexing and Partitioning
Unit 3: Materialized Views and Optimization Best Practices