FreeBeginner to intermediate

Data Modelling

Every reliable report sits on a well-designed model. Learn to turn business questions into entities and keys, draw entity-relationship diagrams in crow's-foot notation, normalise away repeated data, and design the star schemas that Power BI and data warehouses run on. Every lesson is built around diagrams, and you practise on real databases in your browser.

About 8 hours
9 lessons
Final project
Certificate of completion

Curriculum

01What Is a Data Model?Why data needs a design before it needs a dashboard, and the three levels a model moves through - conceptual, logical and physical.20 min
02Entities, Attributes and GrainTurn things into tables and facts into columns, choose data types, and state the grain - what one row means.25 min
03KeysPrimary keys, foreign keys, natural and surrogate keys, and composite keys - the columns that hold a model together.25 min
04Relationships and CardinalityOne-to-one, one-to-many and many-to-many relationships, optional vs mandatory, and why many-to-many needs a bridge table.30 min
05Entity-Relationship DiagramsRead and draw ERDs in crow's-foot notation, and use one to plan any query across several tables.30 min
06NormalisationRemove repetition step by step - first, second and third normal form - so every fact is stored exactly once.35 min
07Dimensional ModellingModel for analysis with facts and dimensions, choose the grain first, and build the star schema that Power BI works best with.35 min
08Stars, Snowflakes, Dates and HistoryWhen to snowflake a dimension, why every model needs a date dimension, and how to keep history when attributes change.35 min
09Modelling in PracticeA repeatable process for designing a model, turning it into tables, and testing it with real queries before anyone builds a report on it.40 min

Loading…