skip to Main Content

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.

Rob Collie

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 13 Comments
  1. Microsoft seems to fall into the SKU screwup with every release of a product. You let the marketing monkeys try to differentiate the market, and nobody can figure out what they’ve done. Does anyone without access to a Cray have any understanding of the different SKUs of Office 365? Or how about upgrading? Ask five MS support people what you’re entitled to and what you need to purchase, and you;ll get at least 5 answers.

    It’s easy to make a trendline that only considers some of your data. Add another series to the chart, which only has the points you want included in the trendline. Hide the lines and/or markers, and add a trendline to this added series.

  2. How about the relatively new news that Power Map will not be in any on-premise SKU effective May 31, 2014? (Scroll all the way down to the bottom and read footnote #6 here: ) It will not come with the stand-alone boxed version of Excel.
    It would be easier for everyone if Microsoft would simply post a very large graphic along the lines of, “We will continue to trip you up at every turn unless you capitulate now and subscribe to the correct version of Office 365”.

    1. Personally I am “ok” with that. Power Map is a novelty in my view, it’s not even the only “map chart” associated with the Excel product! Power Pivot is an industry changer, a total remake of the Excel pro’s relationship with formulas.

      We have to “let” them have *some* differentiation, their SKU problems are real.

      Now, hypothetically speaking, if I were a broad spectrum Excel author, maybe I went by the name Senor Spreadsheet or something, and I were halfway done writing a book about Power Map… I would feel very differently.

      1. Still… just because people are willing to pay for their BI-tools, Doesn’t mean they want to get forced into paying for it. Big difference!

        And with all the changes, there isn’t enough trust that MS will keep the product in the 365 subscription. At least with QlikView it seems you know what you are buying.

        Hopefully MS will get their act together shortly… I much prefer the powerpivot route.

  3. For trending only a partial set of your data in Excel 2013.

    Create a chart with your full data set.
    Then, highlight just the partial set of data, {Ctrl-C} to copy it.
    Select your chart, then choose Paste | Paste Special, then select “Add New Series”, {Enter}
    Right-Click on the Partial Data representation in the Chart,… choose Add Trendline

    Then set the Trendline parameters you want… most importantly, enter a number of periods in the “Forecast | Forward” box, to show your future projection.

    Wordy, but really easy!

    1. Can’t do that in a Power Pivot chart without a lot of extra hassle. We need to be able to set the trendline itself to ignore actual data starting at a certain point, with that certain point ideally being variable (think, refedit). Or we need DAX that generates a trendline measure. Either one would be bitchin. I think I’d rather have the latter.

  4. Office 365? We are backing out of our limited Outlook implementation – partly persistent billing issues and partly added complexity (requiring Microsoft’s help) to do things that were straightforward with in house exchange server. I can’t imagine risking Excel this way.

  5. Rob, Its time to update the xl user groups page. I have had 4 friends sign up in the last week alone but the figures are still sitting on 6 for Melbourne attendance.

  6. In the old days (prior to 97) there was no Office (only darkness 🙂 )

    – So if you were in the business of writing poetry you could buy just Word, For every thing else there was Excel 🙂 – Standalone.

    In 97 they “Integrated” all the “Standalone’s” in to Office (making VBA as the common programming language)

    In 2013 – they are back to standalone Excel – shows the confused state in which MS is currently with respect to is “office” strategy.

  7. 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.

  8. If I have Office Home and Student 2013, I now need to buy Excel separately a second time. Or not. MS licensing support is worthless. That is true though, correct? I have to buy it twice for PowerPivot and the maps? (yeah, the maps are important to me).

Leave a Reply

Your email address will not be published. Required fields are marked *