Impact of the Power Pivot not included in all versions of Office 2013 decision, visualized dramatically.

This is a Pretty Dramatic Dip and Recovery.  What Else Could Explain It?  I’m all ears.

No DAX Required

Nothing fancy here, just a chart of page views of a very specific page on this site – the What is PowerPivot? page.  I use that page as an indicator of new interest – most people viewing it are “early” in their Power Pivot journeys. 

That dip starting in February is incredible.  What else could explain it other than the decision to remove Power Pivot from most “flavors” of 2013?  Eight months later, after Power Pivot re-appeared in Excel 2013 Standalone, we’re back to the same “slope” of the line that we had in February.  Maybe a little better.

Of course, Power Pivot usage was STILL growing, a LOT, during the dip.  And in fact growing by a lot more than the same months in 2012.  It’s just that the RATE of growth fell during those months.  The faucet of new users was still flowing, and flowing fast.  It was just “turned down” from full speed for a few months.

But imagine where we’d be WITHOUT this 6-8 month dip in growth rate.  The curve leading up to February looks awfully exponential doesn’t it?  Let’s take a look…


Monthly rate of adoption projects to have been at LEAST 35% higher today if Power Pivot had been left in all versions of 2013.

New Monthly Interest Projects to Have Been 35% Higher Right Now Without the SKU Snafu

Oh, and the “recovery” is just due to the Standalone decision.  Imagine if it had just been left in ALL versions from the beginning, not just Standalone.

So, don’t let anyone tell you the SKU thing had trivial impact.

Also, it proves surprisingly difficult to get an Excel trendline to only “pay attention” to part of the original data.  To create the chart displayed above, that projects forward from Feb while still displaying March-Oct, I had to make two charts, get their vertical axes synchronized, and then “merge” the two chart images using layers and transparency in Paint.NET.

Chart pros – there’s a better way, right?  No, I didn’t use Google.  I suck.