See how importing large data sets into PowerPivot can dramatically reduce file size.
(00:03) 500,000 row non-Normalized Data Set in Excel
(01:31) Example of Normalized Data
(02:02) Import data from External Excel workbook into PowerPivot Columnar Database
(04:10) File size is much smaller for Non-Normal data Set example and for Normalized Data