Forum Discussion
Helper INormalization
danielboi , It always better to have a dimension table and be in a Star schema
refer
https://www.youtube.com/watch?v=vZndrBBPiQc&feature=youtu.be
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
Super Userdanielboi , It always better to have a dimension table and be in a Star schema
refer
https://www.youtube.com/watch?v=vZndrBBPiQc&feature=youtu.be
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
danielboiThank you Amit. I read that "over-normalizing" could be detriment to read performance. That was triggering my question. 🙂
- amitchandak
danielboi , I think you can work very well with a single table. But when you need to use all and all selected then, in that case, having a dimension table help. I can use it all in one dimension without disturbing others. There many advantages of Star schema, once complex needs start coming, you will have most of the solutions around it.
- danielboi
amitchandak I followed your advice and what shall I say. It is worth gold. The income statement were downloaded per year in one workbook with actual, fc and budget each on a separate sheet. Took 25 minutes to go through 3 years worth of data. Now that I moved everything out to dim-tables, it is done below 30 seconds!
I got the comment regarding the detriment of over-normalizing from Ferrari's/Russo's book Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Looked it up again. Was my fault. They were talking about the snowflake schema, which could slow things down.
So many thanks again for pointing me into the right direction.