Forum Discussion
Solved
Fact / Dimensional Table Approach
Hey Folks, Trying to create a quick Power BI dashboard to show some folks - having a little trouble on determing the right approach for the Dimensional / Fact tables. I started with a spotify dat...
I see what you mean.
I would look into separate bridge tables for bridge_track_artist (join on artist_id or artist) and bridge_track_genre (join on genre_id or genre). May require additional modeling work.
This would get rid of many to many but honestly, I'm not sure how much benefit you'll get from this, outside of knowing you've built a "best practice" model.
To me the song table is it's own dimension and the fact table would be more along what songs were played over a period of time. The songs themselves are really dimensions and the plays of the songs would be the facts for this data in my opinion.