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
srlabhe
Super User
Super UserBelow is the advantacge
1. Identify the Key Dimensaions and its details and move those to Dim tables
2. Have the FActs in offcourse in Fact tables so that those can be aggregated in lower level and used accoridngly joining to Dim table
3. Separting the data in Facts and dimensions are nothing but normalizing it to avoid performance issues