|PowerPivot Compression: Mysterious Ways|
|Written by Rob Collie|
|Thursday, 29 March 2012 22:03|
Longtime readers of this blog have seen me tout the benefits of reducing columns in your data, even if that means adding a lot more rows (see also David cover it here).
Well, I recently discovered an exception to that "rule." And that same data set also yielded a VERY dramatic example of the benefits of sorting your data prior to import.
Let's cover one at a time. But first, some perspective.Read more...
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- List of suggested datasets to test PowerPivot
- Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
- Learning PowerPivot and DAX
- DAX cheat sheet
- Using Power Pivot and Power View for Profit Analysis