skip to Main Content

Ground Zero for PowerPivot Going Critical?

Today’s Scene  (Just add a Foot of Snow)

An obsessive and intrusive habit

Quick anecdote.  For a couple of years now I have been accosting people in public places when I see them using Excel.  On an airplane?  In an airport?  In a doctor’s office waiting room?  You aren’t safe in any of those places.

If you’re using Excel, some weirdo is gonna walk up to you and ask you two questions:

  1. Do you use PivotTables?
  2. (If Yes) Do you use PowerPivot?

The first answer tends to be “Yes” about a third of the time.  That’s disproportionately high relative to the broader population, in which only about 5-10% of people use pivots.  There’s a selection bias in play here of course, because someone who uses Excel enough that it’s on their screen when I walk by is more likely than average to be an Excel pro, and therefore more likely than average to use pivots.

But for two years the second answer has always been “no.”  I then explain that they should be, they express shame, they promise to check it out.  Sometimes they even get a demo.

Until Today!

Recall that just a few days ago, I predicted this would be the year where we start running into PowerPivot via random personal connections and conversations.

This morning, at 10:15 eastern time, at the Starbucks on Cedar and Fairmount in Cleveland Heights OH, I noticed a well-dressed man sitting with his laptop, engrossed in Excel 2007 or 2010 (couldn’t tell, just saw the Ribbon).

Being a “work from home day,” I took stock of my own ensemble:  Unshaven?  Check.  T-shirt and tennis shoes under a coat covered in dog fur?  Check.  Beanie-style snowboarding hat with a pom-pom ball on top?  Check.

Perfect.  I moved in for the kill.

I’m positive he thought I was going to ask him for money or something, and the smile that came over his face when he heard the pivot question was one of sheer joy and reliefSmile

OK, so “yes” he uses pivots.  Now for the second question, the one that engenders shame when the person has to say “no” to a question that so clearly, I think they should say “yes” to… 

ME:  “Do you use PowerPivot?”
HIM:  “No, I don’t, but my team does.  We use a lot of SharePoint.”

Quite the rollercoaster in that sentence.  In sequence, my brain flashes the following reactions:

  1. “He said no.  Yep, just like every other random sample to date.”
  2. “Whoa, his team does???  Wait, he doesn’t know what PowerPivot is does he?  He’s bluffing!”
  3. “Hold it hold it!  Anyone who follows up a PowerPivot question with a SharePoint reference actually DOES know it.  And quite well!”

Fantastic.  I let him get back to work rather than chatting him up.  Took some serious willpower.

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has One Comment
  1. Hi Rob,

    Very good. Last Nov I presented Power Pivot to 200 CIMA management accountants in the UK and at the beginning of the talk only around 3 people knew about Power Pivot. I hope your CIMA articles will go some way to addressing this.

    I’m hoping to run a Power Pivot workshop in the Spring so fingers crossed the awareness/usage is a bit better.



Leave a Comment or Question