skip to Main Content

Download Book Sample Files HERE.

Book Errata Submission Form HERE.

2nd Edition of the #1 Selling Power Pivot Book: Now with Power BI, and in FULL COLOR!

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

We have repeatedly witnessed the “Power tools” transformative impact on the bottom line – far more robust and elegant than Excel alone, and much more agile and affordable than traditional BI tools. Their shared state of the art calculation engines (DAX and M) turn any PC into an analytical supercomputer, but the real secret is people – these tools are 100% learnable by today’s users of Excel. The data revolution lays not in the hands of an elite few, but in YOUR hands, and we want to help you seize that opportunity.

  • Example-Driven: each concept, function, and technique is accompanied by a tangible example. Everything is both explained AND demonstrated.
  • Visual: the book features more than 300 illustrations, diagrams, and screenshots. You SEE everything.
  • Jargon-Free: no prior experience required with programming or business intelligence technologies. If you’ve created a PivotTable before, you are ready.

In Living Color!

Look Inside!

Buy the Book or E-Book

Reader Reactions

“Even perfection has room for improvement.” is now proven. 2nd Edition is even better than the 1st.

if you could buy only one book on Power Pivot, you should buy this one

The book isn’t just an instruction guide. It starts with a small history lesson into the development of PowerPivot that, were it written by someone else, would have seemed pretentious, in the context of this book, however, it is highly informative, engaging, and actually useful.

The enthusiasm/knowledge of both authors is infectious and the layout of the examples extremely easy to follow. I have recommended it to many of my colleagues as a must read introduction to Power Pivot and Power BI.

Excel Pros – the world HAS CHANGED in your favor!

Rob and Avi do an excellent job as always of providing colorful examples that inspire the reader to take matters into their own hands and transform the way that they analyze data for the better.

This book is a real eye-opener and it’s saved me a huge amount of time by stepping me from the basics to advanced in a very short time. Many thanks to the authors!