Very Practical. So before we are told that it depends, from a practical point of view assuming the same data tables and same level of opmimization techniques employed for all the three, which one would you generally recommend.. Time is expensive so i would not not like to do thre designs test them and choose the best especially that as we increase the number of records results may be surprising..
For the company that I work for, I mostly have to go with a snowflake design just because of the sheer volume of data. If I would recommend any of them, it would be in this order: 1. Star Schema 2. Snowflake Schema 3. Flat File (for 1 page dashboard style, small dataset, and it's needed very, very quick without emphasis on accuracy)
Well done ! Very interesting results !
Yes, I was prepared for a different set of results, at least on the bigger file, but sometimes what we believe to be true might not be.
Very Practical. So before we are told that it depends, from a practical point of view assuming the same data tables and same level of opmimization techniques employed for all the three, which one would you generally recommend.. Time is expensive so i would not not like to do thre designs test them and choose the best especially that as we increase the number of records results may be surprising..
For the company that I work for, I mostly have to go with a snowflake design just because of the sheer volume of data.
If I would recommend any of them, it would be in this order:
1. Star Schema
2. Snowflake Schema
3. Flat File (for 1 page dashboard style, small dataset, and it's needed very, very quick without emphasis on accuracy)
@@MMS-PowerBI Thanks!! You knowledge of Data Modelling is TIP TOP!!