Microsoft Power BI vs Qlik vs Tableau

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

I will put the highlight in this blog for the 3 BI platform.




Qlik is highly rated for ease of use, complexity of analysis and business benefits (according to its reference customers). Compared with its chief competitors, Tableau and Microsoft, Qlik scores significantly higher on complexity of analysis — which we attribute to its stronger ability to support multiple data sources, a robust calculation engine and associative filtering and search.


Somehow, Qlik should be the most expensive as compare to Tableau and Microsoft.


Cost of software was cited as a barrier to adoption by 29% of Qlik’s reference customers, putting it in the top quartile for this barrier. Qlik Sense uses token-based pricing, which closely aligns to a named user but with some concurrency supported. The degree to which Qlik is considered expensive depends on the point of comparison. Based on user reference responses from last year’s Magic Quadrant, Qlik’s licensing is competitively priced relative to Tableau and is less costly than that of the megavendors. However, in larger deployments (of more than 500 users), its pricing is 70% higher than chief competitor Tableau and almost double Microsoft’s three-year license fee. Recent contract reviews by Gartner do show increased flexibility in negotiating terms for larger deployments




Tableau continues to execute better than any vendor in the BI market and its land-and-expand sales model has performed extremely well, resulting in a dramatic increase in large enterprise deals — many of which started out as small desktop deployments that grew organically over time within organizations. Tableau has the third-largest average deployment size of all the vendors included in this Magic Quadrant — at 1,927 users — driven by 42% of organizations reporting average deployments of more than 1,000 users (which probably reflects the approach that Tableau has taken of leveraging an underlying data warehouse if one exists).


Again the price getting higher


While expansion continues to be strong for Tableau, pricing and packaging is being more heavily scrutinized because larger deals typically involve IT and/or procurement. When asked about limitations to a wider deployment, 44% of Tableau’s survey references cited the cost of software as a barrier. With increased price sensitivity in this market, new lower-priced market entrants — coupled with Tableau’s reluctance to respond with a more attractive enterprise pricing model — have probably affected its sales execution survey rating this year and contributed to the drop in its position on the Ability to Execute axis compared with last year (where Tableau dramatically outperformed the competition).




I am not sure in future but up to now, Microsoft is the cheapest.


Microsoft’s cloud-based delivery model and low per-user pricing offers a low TCO — one of the top three reasons why customers selected it, in addition to ease of use for business users and the availability of skilled resources. While Microsoft has long offered low per-user pricing, customers are advised to consider the TCO, which includes hardware costs, development and support costs. Previously, Microsoft had a high cost of ownership in its on-premises deployment model (despite low licensing costs), because of the complexity of implementing multiple servers. The new Power BI addresses this issue with both a streamlined workflow for content authors and because the hardware and server architecture is in the Microsoft Azure cloud.


Microsoft needs to make the deployment strategy clearer.


Microsoft Power BI 2.x was released in July 2015. The newness of the product and its cloud-only delivery model may contribute to Microsoft’s ranking in the bottom third for deployment size, with an average of 192 users. Eleven percent of surveyed customers cited the inability to support a large number of users as a limitation to broader deployment. (Note that Power BI 1.0 customers, where deployment sizes may be higher based on both product maturity and on-premises deployment, were not included in the survey.) Microsoft has published a statement of direction — intending to harmonize its on-premises and cloud products — but the strategy is unclear. The current Excel-based add-ins with publishing to on-premises SharePoint is one option. Alternatively, customers may author in Power BI Desktop and then publish to an on-premises partner product such as Pyramid Analytics or Panorama Necto.



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