Patterns and Techniques for Excel PowerPivot Alchemy (Paperback) - Common

by Bill Jelen

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.

Genres: Nonfiction, Bisexual

Unknown Binding

First published October 1, 2013

About the author

Bill Jelen is the host of MrExcel.com and the author of 50 books about Microsoft Excel including Pivot Table Data Crunching, Excel Gurus Gone Wild, and Guerrilla Data Analysis Using Microsoft Excel. He writes monthly Excel columns for Strategic Finance magazine.
He has been awarded the MVP in Excel for 10 years by Microsoft.
He has made over 60 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
His has produced over 2000 episodes of his daily video podcast Learn Excel from MrExcel.
Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial
analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for
readers all over the world.

Reviews

[Mark Polino · Rating 5 out of 5]

The Excel and PowerPivot stuff in PowerPivot Alchemy is terrific. I found myself dog-earing pages from the beginning. If you have even a passing interest in PowerPivot, get this book.

I'm going to nit pick though. Some of the illustrations are actually too large. I've hit that stage in life where most things now look a little small, but these suckers are huge. A tip gets split over several pages because of the size of the illustrations and I'd rather have the tip together to make is easier to work through. Also, a cleaner break between some tips would help offset this too.

So the only thing I have to complain about with PowerPivot Alchemy is some of the formatting. It's that good.

[Bill Jelen · Rating 5 out of 5]

Rob Collie follows up his best-selling DAX Formulas book with a book of techniques for Power Pivot. This Alchemy book is not as intense as the DAX book - it is filled with patterns that you can follow to achieve complex reports in Power Pivot.