Business Data Analytics & Advanced Excel · Intermediate level

Intermediate level · Module 2 of 6 · 16 guided hours

Data Modelling in Power BI

Design star-schema models with relationships and a date table so reports are correct and fast.

Learning objectives

  • Design a star schema with fact and dimension tables
  • Create and manage relationships correctly
  • Build a date table and keep the model tidy

Topics

  • fact and dimension tables
  • star schema
  • relationships and cardinality
  • filter direction
  • date tables
  • model hygiene

Lessons

  1. Lesson 1 Star Schemas

    Separate facts from dimensions and arrange them in a star schema.

    fact tabledimension tablegrainstar schema

  2. Lesson 2 Relationships

    Create one-to-many relationships with the right filter direction and avoid common modelling errors.

    one-to-manycardinalityfilter directionambiguous paths

  3. Lesson 3 Date Tables and Model Hygiene

    Add a proper date table and tidy the model so report builders find the right fields.

    date tablemark as date tablehiding columnsdisplay folders

Practical activity

Model sales, budget, products, branches and dates as a star schema and check that totals by branch and month are correct.

Expected outcomes

  • Correct, efficient models
  • Reports that slice consistently

Assessment

Model review against a star-schema checklist and correctness tests.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.