Forum Discussion
Power BI Data Modelling Snowflake to Star Schema
you can denormalise (merge) the 2 dim event tables together .
it also always depends, on how much data you have etc. the issue around snowflake is the relationships, you need to have a good understanding if you for example are using bidirectional relationships. Always better to assess you needs against recommended
its not hard to denormalise though because the in-memory model compresses distinct data
I still down know how I merge the two event table together though when it comes to the keys
I have no clue how to go about it. Do I then just have one ID in the Event dimension and have multiple rows for each event
I dont understand how this will work against the Fact table ?
So in the merged Event dim should I have
EventID AgendaID
1 1
1 2
1 3
1 4
And then you have the fact table joined to the Event ID?
- can you share some dummy data or data in text form and i can create it for you as an example.