PowerPivot Alchemy
Patterns and Techniques for Excel
Published on 17. June 2014
Book
Paperback/Softback
223 pages
978-1-61547-021-1 (ISBN)
Description
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.
More details
Language
English
Place of publication
Uniontown
United States
Target group
Professional and scholarly
Illustrations
black & white illustrations, figures
Dimensions
Height: 274 mm
Width: 207 mm
Thickness: 17 mm
Weight
566 gr
ISBN-13
978-1-61547-021-1 (9781615470211)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Bill Jelen is the host of MrExcel.com and the author of 40 previous books about Microsoft Excel. He has been named a Microsoft MVP for 7 years and is a contributor to "CFO Magazine" and "Strategic Finance Magazine." He lives in Akron, Ohio. Rob Collie is chief technology officer at Pivotstream LLC, where he and other Excel pros utilize PowerPivot to provide actionable business information to dozens of Fortune 500 corporations. He spent 13 years at Microsoft where he led teams of software engineers on projects including PowerPivot v1, multiple versions of Excel, Windows Installer (MSI) v1, the Bing search engine, and MSN Fantasy Sports. He is also the world's most prolific PowerPivot blogger, running the PowerPivotPro.com and PowerPivotFAQ.com websites since late 2009. He is the author of "DAX Formulas for PowerPivot" and "PowerPivot for Excel." He lives in Cleveland Heights, Ohio.