skip to Main Content

PowerPivotPro Website Stats Since Inception:  Global PowerPivot Adoption Curve Probably Has Similar Shape, Just Bigger Numbers

Views per Month:  Grew by 10k in 20 Months, then by 20k in 10 Months,
then by 30k in 9 Months.  This is classic exponential growth.

Addicted to Numbers:  An Old Theme Returns!

imageBrace yourself for a shocker: I’m a bit obsessive about numbers. I’m actually addicted to monitoring MY numbers, and I have many to monitor: website stats, book sales, etc. I probably check each of my stats three times a day. At least.

Funny thing is, these stats don’t directly translate into much. The book sales are a nice little bonus, and they help for sure while I’m working (without pay) on my startup, but it’s not like they pay the mortgage.

imageAs I said in an older post that I like to think of as a “classic,” the addiction to stats is not driven by money, but by the human desire to make numbers go UP.

For instance, a friend of mine recently started playing an iPhone game called Puzzle Craft. I looked over his shoulder and saw that it was a mindless “draw a line with your finger on the screen and match jewels” game, which in itself is ok, but nothing addictive. 

However, I detected a hint of “progression” in the game, which means I eventually had to try it.

Two weeks later I did, and immediately, the “executive” centers in my brain regretted the decision.  “Numbers going up” are, sometimes, a completely meaningless reward – in fact, one game designer believes that this kind of game actually reflects a LACK OF ETHICS by the game designers, because the rewards are unearned.

And I totally see where he’s coming from.  He’s right.  A fascinating read, whether you’re a “gamer” or not, and I recommend it:


Click to Read the Full Interview – Again, I Recommend it Even if you Do NOT Play Games

Celebrate Something Meaningful With Me Smile

The most recent Amazon review of my book sparked this whole post:

The Latest PowerPivot Book Review

“Celebrate Along with the Writer” – YES! Smile

Reviews like this really charge my batteries.  But what, exactly, are we celebrating?

We’re celebrating nothing less than a total revolution in the way we use Excel to analyze and share information.  The greatest gift any of us have ever been given, at least in the professional sense.

And, as the graph at the top of this post shows, the phenomenon is catching, with a distinctively exponential-shaped curve.

Welcome to the revolution Smile

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 6 Comments
  1. Well, I have yet to see a single job offering yet that desires both an Excel and PowerPivot expert. They either want an Excel developer or a BI professional. And believe me, I look at EVERY job opening.

    Oh, and BWT, where are the guitar players? I think that we got short-changed on this post. 🙂

  2. @David,

    IMO the reason that we’re not seeing those type of job postings is because PowerPivot is really just Excel 3.0. I’ve never seen a posting ask for an Excel expert AND a pivot/VLookup expert either because they’re now one in the same. Pivot/VLookup was Excel 2.0 and exponentially raised the bar for Excel pros. PowerPivot does it again in a way none of us could have imagined.

    Pivots/VLookup used to be how we differentiated between the experts and the wannabes — PowerPivot now becomes that litmus test. If you make an Excel 2.0 pro watch an Excel 3.0 pro produce a report TODAY you will get your answer to who the expert is.

    While I agree it stinks that we’re taking so much time to learn PowerPivot just to avoid becoming obsolete, I think this progress GREATLY improves the future state of our profession. Employers don’t actually want Excel or BI or PowerPivot or pivot/VLookup experts — they want people who can make data magic happen quickly and cheaply.

    HR filters our resumes into buckets like “Excel” or “BI” because it used to be that Excel pros could make a little bit of magic happen and BI pros could make a LOT of magic happen. The line between Excel/BI for an analyst fades monotonically with the power of these tools. It will be practically non-existant in 5 years considering the shift in the SQL world to realign towards the same tabular BI semantic model PowerPivot uses.

    In 5 years we’ll really just be distinguishing between people who are versed in the Data Magic arts and those who are not. There will of course always be SQL developers, functional DBAs and QA testers, but the “business” will only need a Uber-Data-Analyst that will be able to summarize masses of data so large into insights so precise that we cannot begin to know what those capabilities will be right now. My guesses though are that Excel pros will be able to do ETL and limited warehousing within Excel itself in 2018.

  3. @Anthony The reason why it is not happening is that, believe it or not, ~90% (just a number I made up, but likely true based on job postings) of businesses either have never heard of PowerPivot or don’t have a clue of what it can do. And, even in companies where it is readily available to any analyst, the usage rate is much less than 10% (another number I made up, but likely valid). Lastly, I cannot wait 5 years, so I do not look at it as a philosophical discussion point.

  4. Rob I’ll have to teach you the derivative trader’s Mindset- If we like the company or index we sit on the long aide and we think up. If we dont like it we sit on the short side and we sound like something out of the 60’s or 70’s Get DOWN. Come to Poppa. Thank you Bob Seger.

Leave a Comment or Question