PowerPivot Alchemy: Patterns and Techniques for Excel

Front Cover
Tickling Keys, Inc., Jun 1, 2014 - Computers - 295 pages
0 Reviews
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.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Dashboard Tricks and Visualization Techniques
1
Slicers The Gateway to Interactivity
23
Conquering Common Calculated Column Conundrums
75
Modeling and Portable Formulas
103
Power Query
171
Power View
199
Power Map
221
Thank you
232
Index
234
More from Holy Macro Books
240
Copyright

Other editions - View all

Common terms and phrases

About the author (2014)

A former Microsoft engineering leader, Rob Collie is an entrepreneur, author, and consultant who believes Excel is enjoying a renaissance in power and importance - a trend that provides massive opportunities for the millions of Excel practitioners worldwide. His passion is empowering and the Excel Professional to seize those opportunities. When he's not training, consulting, or writing, Rob can be found in his laboratory, devising new tools and techniques for the Excel community. He also operates the world's leading PowerPivot website (PowerPivotPro.com) and occasionally sleeps. Bill Jelen is the host of MrExcel.com and the author of 43 books about Microsoft Excel. He is a Microsoft MVP in Excel and a contributor to Strategic Finance Magazine.

Bibliographic information