Power Pivot alchemy: patterns and techniques for Excel

PowerPivot Alchemy [by Bill Jelen and Rob Collie] is far less â€کtechie’ than other PowerPivot books…all you have to do is follow the pattern, and you will have something awesome to show for your time and attention.
â€‌ —Bill Jelen, MrExcel.
com

PowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data.


Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve.
This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a single analysis.
.