How does Power Pivot store and compress data?

When I start writing a bl og article, I don't exactly know what to expect. Though. this is basically true in everyday conversation with me, as well. It's hard to know what words are about to fly out of my mouth. It's scary for everyone involved. That said. I expect this article to be kind of. epic. Equal parts technical, totally made up, and totally useful Smile As mentioned in this previous post on performance gotchas, . well, many things. but mostly that Power Pivot performance issues are all about memory. And that I loves me some Kasper's Magic VBA Script that tells you how much memory each column of your model is using.