Data modelling · Intermediate · 5 h

Dimensional modelling

Declare the grain, separate facts from dimensions, and build a star schema in SQL.

Why employers care: Warehouses and BI tools assume star schemas. Interviewers for analytics and data engineering roles ask candidates to model a business process on a whiteboard.

In the roadmaps for: Data Analyst, Data Engineer