PowerPivotPro is Coming to Boston

May 15 - 17, 2018


**Use the discount code “3ORMORE” when signing up 3 or more people.

MAY 15 - 16

Foundations: Power Pivot & Power BI

Super charge your analytics and reporting skills with Microsoft’s dynamic duo. Designed to handle huge volumes of data, these tools will transform the way you work. Two Days in our class and you are EMPOWERED!


  • Not just the “hard” skills, but also the “soft” stuff (when and why to use it, how to get the best results for your organization, etc.)
  • Learn Microsoft’s secret weapon behind Power Pivot & Power BI: DAX
  • You don’t need to be an IT professional – most of our students come from an Excel background
Boston Public Training Classes - PowerPivotPro
Boston Public Training Classes - PowerPivotPro

MAY 15 - 16

Level Up Series: Advanced DAX

Foundations taught us how to remove repetitive, manual work and make impactful insights. Advanced DAX is about making it rain money by better informing decisions!


  • Taught completely in Power BI Desktop
  • If Foundations is a 101 course, hands-on work experience with DAX is 201, and Advanced DAX is 301.
  • This class will teach you how DAX really works, how to build complex reports that are still digestible, and how to use that information to drive your business.

MAY 17

Level Up Series: Power Query for Excel & Power BI

Copy-paste? Dragging formulas down? SAME THING EVERY WEEK?… No more. Teach your computer how to build your reports for you. Set and forget!


  • This class will teach you how to connect to all of your data (no matter where it lives), shape it so DAX can run automagically, and have your computer remember the steps so you never have to do it again.
  • You don’t need to be an IT professional – most of our students come from an Excel background
  • Taught simultaneously in Excel and Power BI
Boston Public Training Classes - PowerPivotPro
PowerPivotPro Logo

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!