Data Warehouse & Analytics Engineering
Data warehouse design, dimensional modelling, dbt advanced patterns, analytics engineering best practices and a capstone project
100% Free · All lessons unlocked
Course Content
Foundations
Core concepts and groundwork
OLTP vs OLAP — Design Differences
Reading
Star Schema — Facts, Dimensions and Surrogate Keys
Reading
Snowflake Schema and Data Vault 2.0
Reading
Slowly Changing Dimensions (SCD) Types 0–4
Reading
Grain, Additivity and Aggregate Tables
Reading
Practice — Design a DW Schema for a SaaS Product
Exercise
Core Skills
Essential techniques and patterns
Snowflake Architecture — Virtual Warehouses and Stages
Reading
Loading Data with COPY INTO and Snowpipe
Reading
Time Travel, Cloning and Fail-Safe
Reading
Streams and Tasks for CDC in Snowflake
Reading
Performance Tuning — Clustering Keys and Search Optimisation
Reading
Practice — Build a Snowflake Data Pipeline
Exercise
Applied Practice
Hands-on, real-world scenarios
dbt Semantic Layer and Metrics Definitions
Reading
Snapshots for SCD Type 2 in dbt
Reading
Advanced Macros, Hooks and Packages
Reading
dbt Exposures and the Full Data Catalogue
Reading
CI/CD for dbt Projects with GitHub Actions
Reading
Practice — Production-Grade dbt Project in Snowflake
Exercise
Advanced Topics
Deeper, more complex material
BI Tools Landscape — Metabase, Superset, Looker
Reading
Apache Superset — Connecting to DW and Building Dashboards
Reading
Metabase for Self-Serve Analytics
Reading
Embedding Analytics and Row-Level Security
Reading
Semantic Modelling — LookML and Cube.js
Reading
Practice — Superset Dashboard on dbt Gold Models
Exercise
Production & Scale
Building for the real world
Data Governance Frameworks — DAMA-DMBOK Overview
Reading
Data Catalogues — OpenMetadata and DataHub
Reading
Column-Level Encryption and Masking
Reading
GDPR and Data Residency for Pipelines
Reading
Access Control — RBAC and ABAC in Modern DW
Reading
Practice — Implement Data Masking in Snowflake
Exercise
Mastery & Capstone
Projects and final review
Project Brief — Full Analytics Engineering Platform
Reading
Design Star Schema and Load to Snowflake
Exercise
Build dbt Models, Tests and Docs
Exercise
Create Superset Dashboard with RLS
Exercise
Capstone — Production Data Warehouse Portfolio
Project
100% Free · All lessons unlocked
Topic Overview
What you'll learn
- Core concepts and fundamentals of Data Warehouse & Analytics Engineering
- Industry best practices and design patterns
- Hands-on exercises with real-world scenarios
- Performance optimization and advanced techniques
- Building production-ready applications