Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
https://www.youtube.com/powerbitips?sub_confirmation=1
Visit PowerBI.tips: https://powerbi.tips
Star Schema Documentation from Microsoft:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
YouTube Playlist for Recorded Videos:
https://youtube.com/playlist?list=PLn1m_aBmgsbHLbnEpCMcPeo8T7o1N6vRb
Making a Star Schema from a Flat Table:
https://databear.com/data-preparation-part-6-star-schema-power-bi/
Slowly Changing Dimensions:
https://en.wikipedia.org/wiki/Slowly_changing_dimension
UseRelationship DAX
https://dax.guide/userelationship/
https://dax.do/FPoC0f3NAH4x6k/
watch?v=97OEAGrGiNI