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

Microsoft Power BI vs SAS Visual Analytics vs Tableau comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Mindshare comparison

BI (Business Intelligence) Tools
Data Visualization
BI (Business Intelligence) Tools
 

Featured Reviews

James Balbach - PeerSpot reviewer
Robust system consistently elevates data visualization and seamlessly updates with user-driven advancements
Power BI is a general-use visualization system. I can express the performance of our network through high-level key performance indicators. It allows me to show detailed improvements in quality and safety and patient experience. I create improvement dashboards for task forces and work teams. I have built analytic dashboards that guide analytics, enabling research and dataset manipulation.
Robert Heck - PeerSpot reviewer
A great solution for big organizations, complex business requirements, and highly sophisticated and specialized statistics
There are a few little things that are predefined and can be done out of the box immediately. There is no business intelligence application that is predefined, which is something some customers or prospects would love to have. Small and mid-sized companies would struggle with it because they prefer something standard that has been predefined by somebody else. For instance the system does not come with a pre-defined accounting, budgeting or planning model for a particular industry. Some competitors come with such a model (e.g. for retail companies) which makes the implementation of course easier if the customer can comproise with this predefined model. SAS does not provide such models but does not demand customers to comply with a foreign business model.
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

"I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
"What's most valuable in this tool is that it gives its users detailed error messages. It's a very stable data analytics tool, and it offers good scalability."
"Microsoft BI's initial setup is very straightforward."
"The solution overall is very useful. The reports that are generated and the reporting functionality management are beneficial."
"Microsoft BI is very easy to set up and use."
"It provides good visibility."
"I like the flexibility it offers."
"Scalability-wise, I rate the solution a nine out of ten."
"Quick deployment to dashboards and analytics features (using SAS Visual Statistics and Enterprise Guide). Easy to create a simple forecast and discover business insights using segmentation tools."
"The technical support services are good."
"I like SAS Visual Analytics for its ability to provide an initial understanding of data through exploration, even before deep analytics."
"Simplifies report designs and quickly displays tables and graphs."
"Data handling is one of the best features of SAS Visual Analytics."
"The most solution's notable aspect, in my view, is the ability to integrate various data sources and harness advanced technologies such as machine learning and artificial intelligence. This helps with quality assurance processes."
"Visual Analytics is very easy to use. I use Visual Analytics for all the typical use cases except text mining. I used it to analyze data and monitor statistics, not text mining. I also use it for data visualization as well as creating interactive dashboards and infographics."
"We've found the product to be stable and reliable."
"Compared to other products, visualization features are really good."
"It is easy to use, and it can handle a large amount of data."
"A valuable feature of Tableau is that it is a useful tool for small setups. I shuffle between Tableau and MicroStrategy, so I use Tableau for personal purposes more than enterprise. I like the light version of Tableau for personal usage and doing some use cases on my own. When it comes to something small, I use Tableau for setups, rather than any other tool."
"The number one thing was just the ease of getting something up quickly. The other thing that was good about it was that it was fairly fast for decent-sized data sets in terms of performance and run time."
"Tableau's most valuable features are user-friendliness and have a connection between multiple source systems. You can publish a report by using Tableau Public and there you can make your data online, not only batches of data, you can use it as an online analytical tool."
"All features are valuable. It is very user-friendly, and it is mostly drag-and-drop. If we have the dataset available, then we can develop any dashboard very quickly."
"Tableau has comprehensive, insightful charts, which allow you to build stunning dashboards and enrich your support decision-making."
"It most valuable feature is its ease of developing visualizations, not just charts and graphs."
 

Cons

"The solution doesn't integrate well with third-party tools."
"Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop."
"I think that they can add more types of charts because the selection on the desktop version is limited."
"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."
"I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that. Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has."
"Licensing could be improved."
"Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions."
"Integration with artificial intelligence would help. Humans take time to review the data and eliminate errors. Artificial intelligence based on machine learning and understanding can bring the same functionality."
"The product is expensive and needs the integration of more languages."
"There are certain shortcomings in the tool's support services, making it an area where improvements are required."
"The reason we haven't rolled it out across the board is due to the fact that the licensing is so expensive."
"In Brazil, there are few documents, courses, and other resources for studying and implementing the tool."
"There is a need for coding when it comes to digital reporting which can be intimidating."
"Colours used on report objects"
"Better connectivity with other data origins, better visualization, and the ability to create KPIs directly would all help."
"The installation process can be a bit complex."
"The cost of owning the solutions from Tableau is much higher compared to any other analytical solutions."
"I have used Power BI as well as Tableau. There are a couple of interesting features that I like in Power BI, but they are not present in Tableau. For example, in Power BI, if I am looking at country-wise population, I can type and ask for the country that has the maximum population, and it will automatically give an answer and address that query. This kind of feature is not there in Tableau. Similarly, in Power BI, for integrating with the latest ML algorithms, we have decision trees and primarily multiple machine learning algorithms. The decision tree essentially visualizes the patterns in the data. We don't have such a feature in Tableau. If Tableau can integrate with the machine learning algorithms and help us to do visualizations, it would be a wonderful combination. Most of the people are going for Tableau primarily for visualization purposes. However, in the data science industry, users want to do model building as well as tell a story. As of now, Tableau is fulfilling the requirements for visualization purposes. If they can bring it up to a level where I can use it for machine learning purposes as well as for visualization, it would be very helpful. Many people who want to do data science don't want to write a code. Tableau is anyway a drag and drop tool, and if they can provide those options as well, it will be a powerful combination."
"The customization requires a lot of effort and should be simplified. The performance could be better."
"To be the best in the market, Tableau has to improve its user interface and also look into developing implementing the best machine learning algorithms."
"Lacks machine learning algorithms that you can implement using R, SPSS Modeler, and Python."
"Tableau could be improved by introducing a data manipulation layer within the tool itself. Currently, data manipulations require using additional tools like Alteryx. If Tableau included these capabilities, it would reduce the need for external dependencies. The tool gets slower when we feed huge amounts of data."
"I also work as an SME on the platform side. Tableau is very nice and jazzy for the end-users, but there are pain points for the admins. Performance is something about which we hear a lot of complaints, such as the dashboard doesn't open in time. It performs well on the desktop but not on the server. I know that there is always a limitation when it comes to a huge amount of data or the complexity of the calculations, but we often hear from end-users about the performance on the server side. It is easy to drag and drop all the columns and do what we want, but if it is not going to load better on the server, users are not going to like it."
"Reports should be downloadable as PDF files."
 

Pricing and Cost Advice

"Licensing is on a monthly basis, but I am not sure."
"The only other cost, besides the licensing fee, would be to cover support."
"The pricing for the solution is relatively higher compared to other alternatives."
"MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
"It is based on the usage. If you're using it, you pay for it, and if you're not using it, you stop paying for it."
"Microsoft BI is very cost-effective and this is why we use it."
"It is a cheap solution for our needs."
"Microsoft BI requires licenses."
"The product is expensive."
"It was licensed for corporate use, and its licensing was on a yearly basis."
"The product is quite expensive."
"Visual Analytics is expensive for a small company like mine. You also need to deploy it on a server or cloud, so you pay for the license as well as the cost of the cloud or the server that you will deploy on."
"$10,000 per annum for an enterprise license."
"Licensing is simple."
"It's approximately $114,000 US dollars per year."
"I work with the tool's free version...The tool's corporate version is very expensive and requires a monthly hire."
"Pricing could be better. I believe they should offer better pricing for deployment in small to mid-sized companies."
"The product's price is relatively inexpensive and manageable for enterprise-level companies."
"We are paying an annual licensing fee."
"The value for money is definitely there."
"The solution is very expensive. If you have many users then it is going to cost your company a lot of money."
"The price could be higher for the quality of software, so they revised the pricing in this version, and I agree with the price for top version. The top version costs about $70 per month, and the price is cheap for the quality."
"The pricing for Tableau is the same as the other products in the market."
"Tableau is an expensive solution compared to Power BI."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
832,138 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…
 

Top Industries

By visitors reading reviews
Educational Organization
43%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
Financial Services Firm
20%
Government
13%
Computer Software Company
10%
University
8%
Educational Organization
43%
Financial Services Firm
10%
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
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 ...
What do you like most about SAS Visual Analytics?
The most solution's notable aspect, in my view, is the ability to integrate various data sources and harness advanced...
What is your experience regarding pricing and costs for SAS Visual Analytics?
It's about an average of five. It's easy to scale, but it comes with cost.
What needs improvement with SAS Visual Analytics?
Some capabilities are missing compared to Power BI, especially when working with spreadsheet types. Furthermore, Exce...
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 ...
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....
 

Also Known As

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

Overview

 

Sample Customers

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
Staples, Ausgrid, Scotiabank, the Australian Institute of Health and Welfare, the Blue Cross and Blue Shield of North Carolina, Oklahoma Gas & Electric, Xcel Energy, and Triad Analytics Solutions.
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, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: January 2025.
832,138 professionals have used our research since 2012.