PowerPivot: improve the performances by sorting tables
While it is well know that in UDM data should be loaded sorted, to get better file compression and map structures. The world of PowerPivot (and BISM) is yet not explored. Working with a 50 millions rows table, I tested various scenarios to check if sorting affects BISM data structures too.
The fact table structure is very simple:
Read more...Tags: performance, tip, load, excel