Report Portal

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.

Read more...

 

Tags: tabular, internals

 

2007-2015 VidasSoft Systems Inc.