Way back in 2014 I decided to check out what Google Trends had to say about Power Pivot and Power Query global Interest. In case you don’t know, Google Trends will show you the relative frequency of people searching for certain words – it is a good indicator of interest in a topic. I published a blog article with a Google Trends chart way back in 2014 on this same page (this you are now reading the updated version). At that time I said that the sad thing about the chart was that the trends were linear, and I would like to see something more exponential!
Well in 2015 Microsoft released the first generally available version of Power BI and since then continuous improvements have been made to Power BI, Power Pivot, and Power Query. Most importantly, Microsoft has been listening to the users to determine what improvements should be built and deployed.
I thought it would be a good time to revisit that original Google Trends chart I produced almost 4 years ago. Here it is:
As you can see above, the Power BI trends are indeed exponential, exactly what I was hoping for 3 years ago. Power Query continues to grow slowly, and Power Pivot is in decline. One other interesting observation is that these search terms drop off a cliff each year between Christmas and New Year – A true sign that it is business interest that drives this product.
What’s in a Name?
Power BI is clearly the big thing here, but the other 2 products are the real work horses. People are increasingly learning about the branded product Power BI, and decreasingly being aware of the engines that make the product run – I guess that is not overly surprising although I do find it disappointing, particularly when it comes to Power Query. Power Query is the engine that extracts, loads and transforms raw data from anywhere it resides, and gets it into the Power BI database. Power Query also is available in Excel (called Get and Transform Data). The fact that Microsoft continues to ignore this product as a brand in itself means that most people that could benefit from this cross application technology, don’t even know it exists.
Actually, technology used inside Power Pivot for Excel, Power BI Desktop, PowerBI.com and SSAS Tabular is the same technology across all products = the Vertipaq database engine. Vertipaq compresses and stores the data and then makes all the modelling and (DAX) calculations possible at lightening speed. Microsoft doesn’t use the name Vertipaq much anymore, but I think there is a need to have a common name that describes this technology across all platforms. For this reason I am going to bring the Vertipaq name back in my communication moving forward.
There is a new Microsoft naming faux pas I see on the horizon – it seems that the newly deployed cloud based Power Query capability will be called DataFlow (or is it Data Flow?). I’m sure that DataFlow be confused with Microsoft Flow by most people. Why can’t they just call it Power Query in the Cloud, or something similar that contains the actual words “Power Query”? I guess I will never know. But then again I would have nothing to complain about if Microsoft stopped doing this 🙂