Power BI: Relationships and Star Schema Modelling

Wishlist Share

About Course

Good Power BI reports start with a good model. Learn how fact and dimension tables form a star schema, how to create and manage relationships, what cardinality and cross-filter direction mean, why only one relationship between two tables can be active, and how to use USERELATIONSHIP for role-playing dates.

Tutwoo is an independent learning provider. This course is written from the official documentation and guidance listed in the sources, which can change, so always check the current version. It is not endorsed by any of the organisations listed and is not an accredited qualification.

© 2026 Tutwoo UK Limited. This course was created in-house by Tutwoo and is our original work. It is for your own learning only: please do not copy, share, record or resell it.

What Will You Learn?

  • Design a star schema with fact and dimension tables
  • Create relationships in Model view or with Manage relationships
  • Choose correct cardinality and cross-filter direction
  • Use inactive relationships and USERELATIONSHIP in DAX measures

Course Content

Course Lessons

  • Star schema: facts and dimensions
  • Creating and managing relationships
  • Cardinality and cross-filter direction
  • Active and inactive relationships and USERELATIONSHIP

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕