Microsoft Power BI vs Qlik vs Tableau 2018

Gartner 2018 reports shows Tableau, Qlik, and Microsoft are the leader in Analytics and Business Intelligence Platforms. The full Gartner url is at the bottom. The Gartner link will be expired in sometime later, that was my experience with Gartner link.

As compare to 2017 SAP, and IBM dropped badly. SAS is moving behind as well.



Low-priced incumbent: Many organizations own Microsoft Power BI, often through enterprise software agreements; so, even when Microsoft is not yet deployed, the vendor has changed the modern analytics and BI shortlist from a greenfield evaluation to being the incumbent. Microsoft significantly grew its subscriber base in 2017. Microsoft has put downward pricing pressure on the analytics and BI market with its low per-user and now virtual server subscription price. License cost was the second most important reason for reference customers choosing Microsoft Power BI, with 12% of them citing this as a reason for selecting it.

Ease of use and visual appeal: Microsoft’s customer reference scores place it in the top quartile for ease of use, with 14% of customers citing this as the main buying criterion. Power BI’s reference scores also place it in the top quartile for visual appeal. Winning customers within the first few minutes has been part of Microsoft’s “five by five” strategy — five seconds to sign up and five minutes to “wow” the customer. There are a number of features within the product that contribute to its overall ease of use, including its primarily cloud deployment model. Microsoft was early to the industry in terms of a natural language/search interface with Microsoft Q&A (Question and Answers), which allows users to create a visualization using search terms.

Product vision: Microsoft continues to execute on its roadmap. Microsoft Quick Insights (a feature within Power BI) is a basic form of augmented data discovery, initially available in the cloud service. In 4Q17, however, it was also introduced in the desktop client for variance analysis — to identify what has most contributed to changes in sales, for example, from one quarter to the next. The conversational chatbots with Microsoft Cortana also are differentiators, and Microsoft Surface Hub is touch-enabled and supports the display of Power BI content on wall-size displays in executive board rooms. The ability to provide a closed-loop process from insight to action is supported by the integration of Power BI with Microsoft Flow and within its business application, Microsoft Dynamics 365. Virtual reality and Power BI integration with Holo Lens are currently works in progress.

Customer experience: Microsoft and Sisense shared the highest customer reference scores in this Magic Quadrant for achievement of business benefits. In particular, in terms of making better information and insights available to more users. The high achievement of this business benefit is enhanced by both the low price and cloud deployment. User enablement and the availability of skilled resources are other elements of the overall customer experience for which Microsoft is evaluated as above average. The vendor has a strong community of partners, resellers and individual users; and this community extends the product with prebuilt apps, visualizations and video tutorials, in addition to the content provided directly by Microsoft.


Mode 2 analytics, Azure cloud only: Power BI has mainly focused on the requirements for Mode 2 (agile, self-service) analytics, while its on-premises SQL Server Reporting Services serves the needs of Mode 1 (for scheduled, distributed reports). For Microsoft customers, this has resulted in a two-product deployment with different capabilities and different deployment approaches. Microsoft’s reference customers cited absent or weak functionality (14%) as a limitation to wider deployment, with 27% (the highest percentage of respondents for this Magic Quadrant) citing a range of other problems. These other problems include frequent updates disrupting functionality and documentation that does not match the release cadence; also, intermittent problems with the Enterprise Gateway used to connect live to on-premises data stores.

Breadth of use: As previously, Microsoft’s scores from its reference clients place it in the bottom quartile for breadth of use. Breadth of use looks at the percentage of users using the product for a range of BI styles: from viewing reports, creating personalized dashboards and doing simple ad hoc analysis, to performing complex queries, data preparation and using predictive models. The majority of Microsoft’s reference customers (59%) mainly use Power BI’s parameterized reports and dashboards, rather than using it for more complex tasks. This pattern of use suggests that the more advanced data preparation is performed outside Power BI and/or that IT is building common dashboards for many to consume. The average proportion of business users authoring their own content with Microsoft Power BI is 20%, in the bottom quartile of vendors for this Magic Quadrant.

Multiple products: The core of Microsoft Power BI is a self-contained product. However, a number of elements in Microsoft’s roadmap that are part of the product vision span multiple products and require integration. For example, insight to action requires Microsoft Flow. The Data Catalog is a separate product and curated datasets may be provided from Microsoft directly or through a partner. In addition, some capabilities are not native, but possible through SharePoint or Microsoft Teams. NLQ via a search box is supported natively in Power BI, but more robust voice and conversational analytics is supported through the Cortana personal digital assistant. Data scale-up options have improved, with larger models supported in the Premium version, but the scale-up options to Azure Data Lake, Azure SQL or to on-premises storage are not straightforward. While Microsoft owns the intellectual property for a number of elements of vision, a turnkey integration is a work in progress.

Sales experience: The majority of Microsoft’s reference customers evaluated their sales experience as good to excellent. However, in relative terms, Microsoft is slightly below average for this Magic Quadrant. In part, this may be because Microsoft Power BI has lacked a dedicated analytics and BI salesforce, which changed in mid-2017. While Microsoft Power BI is a low-priced option, clients expressed frustration about changes in the pricing and packaging and the lack of clarity about what Power BI functionality is included with Microsoft Dynamics 365. Microsoft Dynamics 365 uses Power BI embedded for reports and dashboards, but non-Dynamics 365 content requires a Power BI Pro or Premium license.



About chanmingman

Since March 2011 Microsoft Live Spaces migrated to Wordpress ( till now, I have is over 1 million viewers. This blog is about more than 50% telling you how to resolve error messages, especial for Microsoft products. The blog also has a lot of guidance teaching you how to get stated certain Microsoft technologies. The blog also uses as a help to keep my memory. The blog is never meant to give people consulting services or silver bullet solutions. It is a contribution to the community. Thanks for your support over the years. Ming Man is Microsoft MVP since year 2006. He is a software development manager for a multinational company. With 25 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He has been using Visual Studio (.NET) since the Beta back in year 2000. He and the team have developed many projects using .NET platform such as SCM, and HR based applications. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.
This entry was posted in .Net, Cloud, Community, Computers and Internet and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.