Results from a simple test of compression:
I downloaded the Power Pivot sample file in Excel format from the CodePlex site. Review my recent post here for details:
- The file is called ContosoStoreData with columns from A to S with 307 Rows as shown here. The file size is 88KB on disc.
- I copied the data and pasted into an excel spread sheet (not using the PowerPivot)and saved it as ContosoNormal. The file size of was 48KB on disc
- Next I imported ContosoNormal into an Excel Spreadsheet under PowerPivot control and named the new file, ContosoNormalReverted. It had the same number of columns as ContosoNormal and the same number of rows(307). The file size was 52KB on disc.