03-10-2022 06:55 AM
This session will be an overview of relational modelling aimed at those who came through a business of Excel path. We’ll review what a star schema is and define dimensions, facts, keys, and relationships. We’ll then define different table structures such as Role Playing, Slowly Changing, and Degenerate Dimensions, plus Factless Fact tables.
Part 1 in The analyst’s guide to advanced data modelling
This three-part series looks at design decisions to create well optimized data models. It is aimed at users primarily from a business or Excel background who work with Power BI. Attendees are expected to have basic knowledge and experience creating datasets and knowledge of using Power BI.
Follow Steve Campbell: https://www.linkedin.com/in/powerbisteve/
Please Subscribe to our Channel:
Visit PowerBI.tips: https://powerbi.tips
Star Schema Documentation from Microsoft:
YouTube Playlist for Recorded Videos:
Making a Star Schema from a Flat Table:
Slowly Changing Dimensions: