Forum Discussion
Star Schema Model Question
Trying to set up a model for our system and am struggling with how to best set this up. I made a simple model to illustrate. But let’s say we have 2.5 Mil InvoiceLines, 70,000 Customers, 100 Locat...
So, doing it like below? Which is what i would normally do, but was just reading about Star Models vs Snow Flake models in Power BI, and that is making me look at it in different ways.
the way you model it really depends on what you trying to do. I wouldn't usually put a locationid in a customer table, specifically if there was more than one location to cutomer. I find it very rarely one needs to create a snowflake, but thats my personal opinion. It really depends on how big your model is and also what you are wanting to do with it.
