Forum Discussion
cparker4486
Helper III
Helper IIIMy data source is a large Excel file. Should I split it into fact and dimension tables?
Hello, I'm dealing with standard invoice data: invoice number, date, price per unit, cost per unit, quantity, salesperson, shipping destination (city, state, ZIP), etc. What is the advantage ...
Generally, a star schema will give you better performance.
Here is some additional info:
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
https://www.youtube.com/watch?v=vZndrBBPiQc
cparker4486Helper III
Helper IIIAfter my post, I read on the forum someone describe the fact/dim tables as: facts are values you want to filter by and dims are values you want to summarize.
Somehow that made a lot of sense.
Thanks for the links.
djurecic
Super User
Super UserYes, I agree with that. You're welcome and happy data modelling 😀