Surprising Example of PowerPivot Compression
User Rating: 2 / 5
A long time ago I promised a guy named Sam that I would dig up some examples of PowerPivot compression. I then, of course, forgot all about it until today. Sorry Sam.
But today I was playing with a data set on my desktop machine that was really getting me down. The data was provided as a (regular, non-PowerPivot) Excel file with 500K rows in it. And my machine labored to do anything at all with that data – opening it took forever. Deleting a single row took forever. And so on.