Given the response so far to my first book, I decided to commit to a “sequel” for release in 2013.

The existing book is all about the fundamentals – how to “think in DAX,” primarily, which is obviously the best place to start.  This new book is going to collect all of the best specific tricks and techniques from my 3+ years of blogging and hands-on PowerPivot usage.

If this were chess, the first book teaches you the rules, and this new companion book will teach very specific patterns and tactics.  Continuing the chess metaphor, you’d learn Queen’s Gambit in this book Smile

Back in the PowerPivot world, this book will cover things like:  sorting by slicers, same-store-sales, correcting for seasonality, readout formulas, a bunch of different cube formula tricks, etc…

And even better:  since I don’t have time to write another book on my own, Bill Jelen, MrExcel himself, will be co-authoring this one with me!

Question is, what should we name it?  I learned, the hard way, that name counts a lot.  I’d rename my first book, in hindsight, if I could – the use of the words “formulas” and “pro” make it sound a lot drier and more intimidating than it is.

So before Bill and I commit to a name, would you mind telling us which one of these sounds the most inviting to you?

  Subscribe to PowerPivotPro!


Rob Collie

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology. 

This Post Has 5 Comments

    1. Amazon limits those lists to 40 flicks. I love Kelly’s Heroes, especially the tank driver.

      “Stop with the negative waves!”

      “But you are American army.”
      “Oh no, baby. We ain’t.”

      If you (or anyone else) wants to put together your alternate quotable movies list, I’ll link to it 🙂

  1. Can’t wait to read it !!!
    Will you have real-life examples and patters in the book?. My interest is real-time data update (Say every 10 minutes or so) in power pivot using SharePoint technology. Will be great to cover this topic also.

Leave a Comment or Question