Compression with Power Pivot
I have read a lot about how good Power Pivot compression is over the last couple of years, and I have a pretty good understanding of how it all works. But there were some doubts in my mind after some recent reading, so I thought I would simply do some tests to firm up my understanding – I am sharing that testing and learning in this blog today.
There are a number of compression algorithms that Power Pivot uses. Today I am going to talk about just one of them – Run Length Encoding – and do some testing to see what happens under a couple of different scenarios.