PowerPivot Alchemy: Patterns and Techniques for Excel
- Authors
- Collie, Rob & Jelen, Bill
- Publisher
- Holy Macro! Books
- Date
- 2021-02-08
- Size
- 20.01 MB
- Lang
- en
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.