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

"Security administration tools are powerful and flexible."
"It's enabled us to report directly from our main application systems. We're removing islands of data and we're removing inefficiencies, where people or small divisions had their own store of information."
"IBM Cognos is an excellent solution for tax, planning, budgeting, profit and loss statements and balance sheets."
"It has a very powerful edit feature which allows users to back out of changes (undo) without forcing them to recreate entire reports."
"It is a stable product."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"The dashboarding offered by this solution is very valuable to us."
"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."
"Reports, dashboards, and visualizations are most valuable."
"The most valuable features of Microsoft BI are its intuitiveness and ease to use."
"Power BI's integration with other tools is very good."
"It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
"We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source."
"Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day."
"In contrast to what we were using before I think that Power BI has given us more extensive results."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"The most valuable feature is that we can integrate with our own database, and it will displays the KPIs. This is highly required from the business side."
"Tableau's initial setup was straightforward."
"Easy for beginners to use"
"Its performance is pretty good, and the development time is very low."
"The most valuable feature is the drag and drop, then the simplicity to build dashboards which allows us to provide more usable data to our customers."
"Tableau has improved my organization in a variety of ways, one of its uses being that of data analysis. A feature I have found most valuable is the ease of use and straightforwardness, in addition to the flexibility of Tableau."
"Tableau is easy to use. That's the first and most important thing. I not only provide consulting but I also train people to use it, so with its ease-of-use it's not as difficult for me to train executives and management staff, because they don't have the IT background, unlike when I'm using Python."
"Tableau has many different connectors for different databases. It's very easy to connect to MySQL, SQL Server, Amazon EMR, Presto, Redshift, BigQuery, and so on."
 

Cons

"I would like for the platform to become more standard. If we make a development on our report and our dashboard, it will not be used in another solution. That means there is no portability for the developers."
"The AI-based features could be further enhanced by the solution."
"IBM Cognos's error messages seem to be a bit ambiguous. An error will be encountered and a message will be sent out very ambiguous and after investigating the error message it could be any number of issues. There was never a direct answer to the question or a direct answer to the error messages. Sometimes it would be a generic error message for 21 different solutions. It wasn't very specific, which required a lot of digging around and trial and error trying to fix the problem. The messaging in their error messaging is something needing improvement."
"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."
"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 need improvements, particularly with the Framework Manager, which has an outdated user interface from older versions like IBM Cognos 10 or 8. Additionally, the Event Studio, which offered great flexibility in previous versions, is no longer available in IBM Cognos Analytics 12. These are areas that could be improved to enhance the product."
"I would like to see is more easy building, movement in the reports, and dashboard functionality within reporting. Overall more simple elements within reports. If the elements are simple then you don't have to render a full page, but you can move separate parts in the page."
"I would like them to reinclude PowerPlay. One thing that I am missing in the current Cognos is what was formally named PowerPlay. They have basically removed PowerPlay from it, which is something that I fail to understand because it was the most wonderful tool for business intelligence that I've ever used. As far as I know, they don't provide this functionality anymore, so this is one thing that I dislike about Cognos."
"The solution's documentation needs improvement."
"Power BI could be improved by implementing more options for data integration. Nowadays, the cloud takes care of scalability and security. As we all know, data sources are increasing, so we get data from a variety of streams. But if we could get the downstream data into the database and update the reports more easily, Power BI would be better."
"The reporting part of Microsoft BI is rather limited compared to other reporting tools."
"If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work."
"The integration with third-party products could be more stable."
"Microsoft needs to provide more drivers to connect other data sources in a native way."
"The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors."
"The visual outlet or the visualization aspect can be improved because the settings piece is quite problematic. It requires a lot of time to set the visuals and check. It is quite fiddly to change all the settings and font sizes. It just needs better ability in terms of using templates or visualization templates to get the vision. Our users always benchmark based on the product, and they don't appreciate everything under the bonnet. The only rating is based on the actual reports in the settings for the dashboard. They should make it look a bit funky and a bit more aesthetically pleasing on the eye. It is quite a fiddly tool, but other than that, it is pretty slick. Because it is community-driven, the marketplace tends to be changing forever. You get the standard visualizations, and you've also got all other marketplace visualizations that require you to spend a bit more money and purchase things in the marketplace. With certain visualizations, there is no longevity. I had used certain visualizations, but they discontinued them, and I had to rebuild my reports, which is obviously very frustrating. There should be some sort of stabilization around how the marketplace visuals impact the users when they expire."
"It is not so great when it comes to data exchange/integration, data mining, etc."
"The tool's OpenAI integration was announced last year. However, it is late. Tableau is a good solution for end customers. However, there are some concerns regarding the stability and performance of its server architecture, including SaaS services. The server side appears unstable, and performance issues are noticeable, often accompanied by unclear error messages."
"It would be nice if we could export more raw data. Currently, there is a limit as to how much data you can export."
"The solution does have scalability issues."
"Small multiples (a.k.a. Trellis charts) are possible only through very hacky means. Update: Still remains a challenge."
"Its documentation can be improved so that a user can get a good hands-on experience. Tableau is well documented, and on their website, there are a lot of tutorials that are available for free. I started my learning process through those tutorials, but there are certain loopholes in those tutorials, which only got filled through a couple of good YouTube channels that talk about Tableau. YouTube helped me a lot. So, the documentation could be better, I understand that it is evolving day by day, and with more usage, there would be more such documentation."
"The extraction, transformation and loading of data in Tableau takes a lot of time and we do not have confidence that Tableau is showing all the data we need."
"When we put more information on a single screen, it gets compressed and superimposed in many places while scrolling."
 

Pricing and Cost Advice

"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"My company uses IBM Cognos with another IBM product, so I think only one license is used."
"It is pretty expensive."
"On a scale from one to ten where one is low pricing and ten is high pricing, I would rate this solution at eight."
"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
"It's more expensive than similar solutions like Tableau and Power BI."
"The pricing of this product is meant for medium to large-scale enterprises."
"Microsoft BI is very cost-effective and this is why we use it."
"Compared to others, I think it is reasonable."
"The license is on a yearly basis."
"They have a free Power BI Desktop version, but it has limitations."
"Power BI is subscription-based, and you have three options. The Pro edition, which is the standard one, is about $9 per user. The Premium edition, which provides AI and cloud capabilities but at a limited size, is for small to medium enterprises. It is about $20 per user. For large enterprises, such as manufacturing facilities, there is an option for the capacity. The capacity subscription is about $4,000 per capacity level. They also have an option for the on-premises version, but it is not common to see someone going for the on-premises version. The on-premises version requires a specific license that is attached to SQL Server. I believe it is about $17,000, but I'm not sure about it."
"The price of the license can be better."
"We're charged a monthly subscription fee of 500 rupees per person."
"Downloading Power BI Desktop is free."
"It is a bit difficult for some people when they hear $70.00 per month, as some solutions are available for less than $10.00 or for free."
"Deployment of dashboards to viewers and unit supervisors can be prohibitively expensive."
"It is a bit overpriced."
"The price of Tableau is high, although there are different types of licenses available."
"The cost of the solution should be improved."
"It's an annual fee with everything included but it's quite expensive."
"The cost is high."
"Tableau is an expensive solution."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
824,053 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
42%
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.
824,053 professionals have used our research since 2012.