Try our new research platform with insights from 80,000+ expert users

Microsoft Power BI vs Tableau comparison

Sponsored
 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 8, 2024
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in BI (Business Intelligence) Tools
7th
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
No ranking in other categories
Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Ranking in Reporting
1st
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
315
Ranking in other categories
No ranking in other categories
Tableau
Ranking in BI (Business Intelligence) Tools
2nd
Ranking in Reporting
2nd
Average Rating
8.4
Reviews Sentiment
6.4
Number of Reviews
294
Ranking in other categories
Data Visualization (1st), Embedded BI (1st)
 

Mindshare comparison

As of December 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.3% compared to the previous year. The mindshare of Microsoft Power BI is 22.4%, up from 22.4% compared to the previous year. The mindshare of Tableau is 19.8%, up from 18.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Q&A Highlights

it_user83559 - PeerSpot reviewer
May 15, 2014
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
Amol Rane - PeerSpot reviewer
Supports AI initiatives in terms of predictive analytics
The only issue is with permissions. Sometimes, despite granting granular permissions, dashboards are visible to people who shouldn't have access. It's difficult to understand why the permissions slip out. Sometimes dashboards are visible to stakeholders even though they should not have permission. It's a bit difficult to understand why the permissions slip out. The dashboards lack a user-friendly appearance, and the permissions should be easier to understand. At this point, we have to go through a lot of details. It takes a lot of time to understand the permissions, so if there were better options available within the Power BI setup, it would be quite beneficial, especially for admins. So, there should be a more user-friendly dashboard appearance and easier-to-understand permissions.
ROMIL SHAH - PeerSpot reviewer
Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time
When it comes to visualizations, Tableau has a limitation as compared to Power BI. It has a limited set of visualizations. Power BI has the entire marketplace, so you can connect and import many visualizations and use them, whereas Tableau has only 10 or 15 visualizations. There should be more visualizations, and there should also be data integration with more cloud providers. Tableau has recently launched a paid version for the documentation. So, documentation has become a little bit challenging when it comes to Tableau development because we do not have any tool to export the data out of it. It is a license-based feature that you need to purchase to prepare documentation. So, on the documentation front, for preparing clear documentation for any dashboard, it would help if we get an embedded option, rather than buying a license for each user for the documentation. To document anything, if I have to connect to each workbook and see what has been written as a formula and then document in the Word document, it is pretty time-consuming. We have the Microsoft stack, and we are currently evaluating Power BI because Tableau has a limitation of 50 columns for a drill-down report. If we want more than 50 columns, we have found a hack, but there is no ready-made option for doing it. So, we have to use another tool in case we need a drilled report with more than 50 columns. There are many instances where users need 80 or 90 columns for their analysis, and switching between two technologies becomes a challenge. It is not a cost-effective approach for us. Their support should be improved. We are not happy with their support. Whenever we raised queries, we were pointed to a few blogs, and we didn't get a proper solution from them. Their licensing should also be improved. They want us to purchase a Tableau Creator license for business users, whereas Power BI Desktop is free for business users. They should come up with a basic license with one or two connectors that our business users can use for preparing their visualizations. Tableau also charges us per user for users who want the data only through email.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature is developing reports from different data sources, making it a reliable data source."
"The tool can join data from different sources, write back to databases, generate alerts, and be customized to our preferences. It's an enterprise BI tool that's more powerful than just visualization tools like Power BI or Tableau."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"The basic platform comes with several meta-modelling tools."
"When it comes to decision-making, the product is very useful and used in many departments since a lot of people prefer the reports to be generated by IBM Cognos."
"The dashboarding offered by this solution is very valuable to us."
"The initial setup is very straightforward."
"IBM Cognos improves the effectiveness of the sales team."
"The product is intuitive and user-friendly."
"It is easy to work with and very chic."
"What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
"It's a straightforward setup."
"The solution is stable with reasonable performance."
"The solution is very easy to use."
"The product's most valuable features are DAX functions for formulas and calculations."
"Microsoft BI's most valuable features are the user interface, which is easy to use and light."
"Provides a very good sound analysis quotient."
"One of the most valuable features is that the solution allows users to build interactive dashboards. This allows the end user to modify the criteria or the filtering if need be. As far as for my personal use as a QA Engineer, I really value how extensive their API document support has been."
"The solution is being delivered to our customer, who appreciates the insights generated from the reports. It is easy for them to drill into the details and use interactive charts."
"Its visualizations are good, and its features make the development process a little less time-consuming. It has an in-memory extract feature that allows us to extract data and keep it on the server, and then our users can use it quickly."
"Although Tableau isn't the best for us when it comes to processing and working on live data, it is very good at extracting data for analysis."
"The maps and colors and interface are all fantastic."
"Self-service is most valuable. Users can pick up quickly and do the resolution. There are a lot of out-of-the-box features, and it satisfies most of the needs. If users are properly trained, they can deal with any situation."
"The data blending capabilities is a huge factor for our team."
 

Cons

"It would be nice to offer free online training on the tool for end-users."
"One key area for improvement is the need to improve the self-service nature and functionality of the product in terms of visual analytics."
"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."
"It would be better if it is was easier to implement without extensive training for it."
"It is a costly product; it is comparatively expensive."
"The technical support team’s response time is slow and needs to be improved."
"The solution seems to slow down the servers."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"From a scalability and performance perspective and based on my understanding and feedback from end users, there's room for improvement in data processing, scaling up, and leveraging the cloud. That could be an enhancement area for me to look into."
"The dashboards lack a user-friendly appearance."
"I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."
"There are some problems with the functionality of this solution. The dashboard is not very user friendly and is quite complicated."
"The integration with third-party products could be more stable."
"Their technical support can be better. They normally take too long to escalate and resolve a case."
"There is no specific area that I have a problem with. It's just that, with whatever feature you come across, every visual has its own formatting and behavior. What you get in one visual for a feature, you don't seem to get in another."
"There are certain features that are only available in the cloud version. It would be beneficial if they could be brought down to the on-premise version without the necessity of using the enterprise SQL database, as that can be very costly. We need more cost-effective features that are available in the cloud to be accessible on-premise."
"There should be more GIS features, such as location analysis, which is quite limited. There are very few location-based functionalities."
"The process of embedding the dashboards on external portals and websites could be improved."
"The charting is overly complex in comparison with Power BI's"
"Other tools are more competitively priced."
"I would like the solution to have certain features allowing the delivery of reports to the email."
"Its price is a concern. It is more expensive than Power BI. The other thing that I never liked about Tableau is its ability to handle large sets of data. To present the data in the dashboards, we have to stage it up exactly like it is going to come into the dashboard. We use another tool called Alteryx that does that for us. So, we manipulate the data, get it staged, and then push it into Tableau. Tableau is terrible at handling large data sets, and we knew right away that we couldn't use Tableau to do data manipulation."
"I have noticed that Tableau is not very compatible with ClickHouse. There's no direct connection to ClickHouse; you have to set up an ODBC connection."
"There's no mature ETL tool in Tableau, which is quite a negative for them."
 

Pricing and Cost Advice

"The solution is affordable."
"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"The licensing costs are a little bit higher for IBM Cognos. I don't think there is any additional cost apart from the licensing charges."
"I don't know the exact cost, but I believe Cognos is quite expensive, especially when it comes to the support consultants and the procedures that need to be applied."
"There is a standard license required to use this solution. There are some additional tools but I am not sure if they are an extra cost."
"I rate the product price as four or five on a scale from one to ten, where one is a low price, and ten is a high price."
"It is averagely priced."
"The pricing of this product is meant for medium to large-scale enterprises."
"Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI."
"There is room for at least 45% discount as compared to the initial price."
"We pay for users who are publishing on the cloud. The desktop version is free. Its licensing is on a yearly basis."
"The cost of licensing depends on the number of people that are going to be using the reports, and we are satisfied with it at $10 per user."
"The solution is priced well for what they offer. However, the premium version is very expensive."
"We have premium licenses, but you can use it for free. You can share the content with anyone else, so you can use it for free."
"The premium capacity is very costly in respect of the market in Egypt, amounting to $5,000 monthly."
"Pricing, that's where Microsoft beats Tableau. It is priced much cheaper."
"I wish there was more of a subscription model with the pricing when it comes to Tableau, so you can get all the latest version upgrades/features if you pay monthly/annually."
"The pricing is $70 per month. You have to pay about $800 or something in that ballpark annually for one license."
"Its price is a concern. It is more expensive than Power BI. My guess would be that it is $1000 or less per year. We might go for Power BI in the future because of its umbrella with Microsoft licensing. It is much cheaper for us to use Power BI, and some folks will go in that direction because they don't want to pay the higher license."
"It is reasonable and cheap as compared to other major tools. It has a good price, and people go for it because of its pricing."
"This solution is a bit expensive. The pricing options have become more difficult over the years. I think they are bordering on pricing themselves out of the market. They need different pricing options for various-sized businesses. Where my organization is a large organization, we are happy to pay a higher price because we can leverage the products very extensively. For smaller enterprises, different pricing options would be good."
"Tableau is not as cost-effective as Microsoft BI."
"Its price is higher than Power BI and QlikView. Tableau costs around $70 per user per month, whereas Power BI is around $8 to $9. QlikView is around $30. Tableau has various prices for various models such as Creator, Designer."
"We always consider pricing when considering a new solution. We are a non-profit and price is a huge concern."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
823,795 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Answers from the Community

it_user83559 - PeerSpot reviewer
May 15, 2014
May 15, 2014
Rich- What is it that current leadership perceives as lacking in the current reporting tool set? Why change if the only benefit is features or a products capabilities? Can the products features and capabilities be exploited? By who and when? How does that make money for the company? Increased profit? Cost reduction? Increased resource utilization? Fewer days for order to cash? Reduced colle...
2 out of 21 answers
Feb 4, 2014
What might be “easy” for some is often “difficult” for others. Some users might find their experience with Tableau can be applied to quickly getting up to speed with Report Builder; others might find their mastery of Tableau gets in the way of learning the new software. I’m sure if asked, some colleague’s would say they find Tableau hard to use. Even so, I think what you really need to know is how much training would be needed after converting over to MS BI. I would suggest that to find the answer, you should ask the organization’s best Tableau users to try out a few typical daily tasks in Report Builder and let them evaluate how difficult or easy they are to complete. Their responses can be used to develop a training program for the other users. I would also suggest this link http://technet.microsoft.com/en-us/library/dd239338.aspx. It provides tutorials for various tasks in Report Builder, which may be able to give you a feel for how simple or complex it is to build a dashboard, chart or report in Report Builder.
it_user79746 - PeerSpot reviewer
Feb 4, 2014
I am still early in my Tableau experience. I do know that MS has a thing called PowerPivot which is part of the MS answer to Tableau, interesting that so many other BI providers are having to adapt to the competition provided by Tableau, but that also requires enterprise Sharepoint. Where I work they are just coming out of what we might call BI 1.0 and trying to get to BI 2.0, which is why I am there.
 

Top Industries

By visitors reading reviews
Educational Organization
55%
Financial Services Firm
7%
Computer Software Company
4%
Government
4%
Educational Organization
42%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
Educational Organization
41%
Financial Services Firm
11%
Computer Software Company
7%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I wou...
Is Power BI a complete platform or only a visualization tool?
Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize info...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are ...
Tableau vs. Business Objects - Which is a better solution for visualization and analysis?
Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have be...
Which would you choose - Tableau or SAP Analytics Cloud?
Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use....
What do you like most about Tableau?
Tableau is a fantastic tool that provides impressive dashboards and customized reports.
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
Tableau Desktop, Tableau Server, Tableau Online
 

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
Accenture, Adobe, Amazon.com, Bank of America, Charles Schwab Corp, Citigroup, Coca-Cola Company, Cornell University, Dell, Deloitte, Duke University, eBay, Exxon Mobil, Fannie Mae, Ferrari, French Red Cross, Goldman Sachs, Google, Government of Canada, HP, Intel, Johns Hopkins Hospital, Macy's, Merck, The New York Times, PayPal, Pfizer, US Army, US Air Force, Skype, and Walmart.
Find out what your peers are saying about Microsoft Power BI vs. Tableau and other solutions. Updated: November 2024.
823,795 professionals have used our research since 2012.