File Size and Compression

[one3nine0]

I have two tables in Powerpivot 2010, Invoices and a Date Table. The invoices table is only 450,000ish rows

In Excel I have the data in a pivot table filtered by date, product, and order type

The table itself shows Sales Person, Sales Person ID, and Number of units sold.

When I save the file, the file size is 29mb. That seems excessive. At my prior job i had millions of rows in powerpivot 2016 that were only 5-10 mb in size.

Is there less compression power in the 2010 version? Is there a way to compress the file size even more?

 

[pvr928]

Hi one3nine0

Not sure about compression differences between Powerpivot 2010 and 2016, but have you tried saving the file as binary (.xlsb)? Compared to an .xlsx file, in my experience with large files a .xlsb file is around 40% the size of a .xlsx file.

Cheers

pvr928

 

[one3nine0]

Thanks pvr. Unfortunately it only shrunk the file size by 0.1mb

I wonder if its something to do with my data rather than excel or powerpivot...

 

[pvr928]

It could be: https://powerpivotpro.com/2015/12/compression-with-power-pivot/

There are quite a few articles now about how the PP engine works and how it relates to compressibility.

Cheers

pvr928

 

[one3nine0]

I've read a few and although they talk about the compressibility of data in excel, not a lot I've seen show how to shrink a file with less than 1 million rows.

I also have 0 calculated columns and 0 measures, which is why I don't understand why my file size is so large.