Become a Guardian of the Star Schema - Markus Ehrenmueller-Jensen
Details
Microsoft Data Platform Group Birmingham
Thursday 6 August 2026 at 13:00 BST
Session Title: Become a Guardian of the Star Schema
Speaker: Markus Ehrenmueller-Jensen
Session Abstract:
Are your visuals only reacting very slowly to changes of filters?
Are you suffering from the “DAX-is-complicated” syndrome?
Is the model view very crowdy?
All of these symptoms are very common, if your data model is not in the shape of a star schema.
In Power BI you should always first start with a star schema, before you start your adventure into more complicated challenges. Luckily, transforming any data model into a star schema is not as complicated as it might sound:
* Assign attributes to either a fact or dimension table
* Normalize the fact table
* Denormalize the dimension tables
* Add a date table
* Transform blanks and flags into meaningful descriptions
* Resolve hierarchies into dedicated columns
... and you are on your best way to become a Guardian of the Star Schema.
In this session Markus will take the time to introduce the problems and demonstrate each solution in a live-demo. Markus will teach you, how you can transform your data in Power Query and when it is time to reach out to DAX.
#### Additional notes
Agenda:
12.45 - 13:00 : Speaker Setup and Join
13:00 - 13:05 : Open Lobby to guests and Introductions
13:05 - 14:00 : Become a Guardian of the Star Schema
Venue: Wherever you have access to a computer or smart device!
This session will be online only!
Other Details:
*** Please note registration on MeetUp is required to gain access to the Teams link!***
Please contact us via email if you are having any issues joining, and we'll do everything we can to help.
Event Organiser Contact Details:
If you need any further details or have any requests for this or future Data Platform Group events, please get in touch.
Email: meetup@purplefrogsystems.com
X: @MSDataGroupBrum
BlueSky: [@msdatagroupbrum.bsky.social](https://bsky.app/profile/msdatagroupbrum.bsky.social)
Sponsors:
