Data Warehousing & Modeling

Data modelling decides whether analysts can answer questions themselves or must queue for engineering help. Courses here cover normalisation and dimensional modelling, star and snowflake schemas, fact and dimension design, slowly changing dimensions, and newer approaches including Data Vault and the wide-table patterns modern warehouses favour. You will also cover warehouse and lakehouse architecture, partitioning and clustering for performance, cost-aware query design, and semantic or metric layers that keep a single definition of revenue across every dashboard. The bridge between raw pipeline output and trustworthy business intelligence.