PowerPivot Alchemy: Patterns and Techniques for Excel

by Rob Collie, Bill Jelen

Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. "Alchemy" sets aside the fundamentals of past books and provides a series of practical, easy-to-follow "patterns" for dozens of common analysis, reporting, and dashboarding needs. Three "bonus" chapters introduce you to the newer members of the "Power BI" family - Power Query, Power View, and Power Map. Whether you are starting your transformation from "old school" Excel User to Modern Data Professional or a veteran of the Power BI arts, this book will dramatically expand your data superpowers.

Genres: Nonfiction, Bisexual

295 pages, Paperback

First published October 1, 2013

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.