Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago

Power BI Data Modelling Snowflake to Star Schema

I have recently realised that the STAR schema is the recommended data model for power BI, and even the snowflake schema isnt the recommended approach   An event can have many details (Agenda ...
Need Help
DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago

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?

 

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago
can you share some dummy data or data in text form and i can create it for you as an example.