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.
Renato Vazamin - PeerSpot reviewer
Single environment for multiple phases saves us time, and has good visualizations
We had that solution installed previously in another solution, Selvaya, but I don't think we used it at the time. We are now using SAS Detect Investigation as a complementary solution, in which we have part of the process, use a gene, SAS collects information and identifies some business situations, and the business guys use Visual Analytics to explore the results of the process. We previously used the FICO platform, but we switched because FICO's pricing was not scalable. Bringing more data or workloads to the platform required a significant investment in order to scale. We needed to change because we have a lot of data to process every day. FICO was also a little more complicated than SAS Visual Analytics.
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 data manipulation and data cleaning tasks are handled in the backend by Power Query in Microsoft Power BI."
"It's a straightforward setup."
"The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use."
"Users already using Excel can generate new reports and dashboards within minutes."
"Provides data feeds for enterprise KPI reporting."
"There are some great automation elements in the product."
"It is very well integrated with other Microsoft products, including PowerApps and Excel, as well as Access, so it fits well into our workflow."
"The data can be accessed from anywhere."
"I like SAS Visual Analytics for its ability to provide an initial understanding of data through exploration, even before deep analytics."
"It's a stable, reliable product."
"I believe that the possibilities for exploring data and formulating visual results are quite good because it allows the business analyst to have different perspectives on the data."
"The visualization capabilities and the email functionality are most beneficial."
"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."
"I would rate the overall solution a ten out of ten."
"The tool's most valuable features are its ease of use and advanced data visualization capabilities."
"The technical support services are good."
"It's very user-friendly. It's not like Power BI, Tableau is very user-friendly. Anybody can use Tableau. It's very easy to adopt things. I can visualize the stats."
"When compared to Power BI, Tableau has more readily available resources."
"The most important feature in Tableau is visual analytics."
"It is a complete solution allowing a lot of integrations, different graphics, multiple operations and analyzes our date and gives us meaning from it."
"Tableau is very flexible and easy to learn. It has drag-and-drop function analytics, and its design is very good. It is a very good tool, and it basically brings life into data with good design. We have been creating a lot of interactive visualizations and dashboards. It has a public version. There are public communities from where you can get a lot of examples for practice."
"It is a very stable product. It doesn't break."
"Tableau reduces manual labor and resources, providing cost-effective solutions for our operations."
"I have found many of the self-service features valuable."
 

Cons

"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."
"Powerpoints are not available in the report server."
"It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."
"​It needs more graphics and overlays."
"Microsoft BI's visualization could be better. Though Power BI's visualization has steadily improved over the years, it's not on the level tools like Tableau and SAS or some of the more expensive products on the market."
"I would like to be able to use more predicting data science features without having to use R."
"I found data cleaning in the solution to be quite difficult. If I could add a feature, I'd include Excel's Flash Fill function. This allows you to set a formula for one row and column and automatically apply it to thousands of rows, making data sorting much easier."
"It's quite difficult to learn how to use Power BI."
"The product is expensive and needs the integration of more languages."
"The licensing ends up being more expensive than other options."
"SAS Visual Analytics could improve by making it more accessible for users outside the organization."
"There is a need for coding when it comes to digital reporting which can be intimidating."
"Better connectivity with other data origins, better visualization, and the ability to create KPIs directly would all help."
"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."
"The charts and tables could use better sorting, primarily using other variables than the ones on the figure. If they could implement views like in the older version (previous to Viya), it would be very nice."
"I haven't come across any missing features."
"Tableau has so many functions, so sometimes it's hard to find the right solution quickly. I have to search multiple menu bars to find the right command."
"The data processing in Tableau is pathetic compared to Qlik."
"The development part should be better. We are putting a lot of effort in during development, so if we face any struggles, we have to find workaround solutions on the internet."
"The charting is overly complex in comparison with Power BI's"
"The only issue with the solution is with its prices at a regional level."
"The data entered into Tableau must be clean. Otherwise, it won't work properly."
"If you mainly need a tool for BI reporting, it's not the best option. Tableau needs better abilities to generate simple reports, integrate, create databases, and work with data lakes."
"When we put more information on a single screen, it gets compressed and superimposed in many places while scrolling."
 

Pricing and Cost Advice

"This solution came free, it was offered by Microsoft with our E3 license."
"Power BI's price is reasonable, especially if you can put it in some bigger package and use it with other products. The value of a solution doesn't just come from its features as a standalone product. The price should also reflect how easy it's to set up, clean data, and integrate with other solutions."
"The solution is less expensive than other PowerBI tools, which is why most people go with it, although it does cost more than MSBI tools."
"Its price is very low. It is like $10 per user, per month. The clients pay for their own licenses. It is not on us. There are no costs in addition to the standard licensing fees. That's the beauty. With other systems, you need to spend a couple of thousand dollars just to get started, and then you need to spend $500 per year for the license, which becomes much more costly. You have a system here where for $120 to $140 a year, you can start with two people and start developing and deploying. You can see why the cost difference is huge, especially when you are on a low scale, like us, and you're not building something very huge."
"I am satisfied with its price. Its price is very less as compared to Tableau and QlikView."
"Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money."
"As far as I am aware you do not need a license for the solution."
"This product offers good value for the money."
"The cost of the solution can be expensive. There is an additional cost for users."
"$10,000 per annum for an enterprise license."
"The product is 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."
"I work with the tool's free version...The tool's corporate version is very expensive and requires a monthly hire."
"Licensing is simple."
"The product is quite expensive."
"SAS Visual Analytics is expensive, as is the rest of the platform."
"For big business, Tableau could be expensive as having a lot of Tableau server users (entering with a browser to reports) could be a bit expensive."
"Tableau is an expensive solution compared to Power BI."
"It is fairly expensive. I have no idea what they paid. We were on an enterprise license, so whatever it is they licensed at the enterprise level is what we paid."
"ROI is very high, but it requires a data preparation/blending tool."
"There is a license for the use of this solution and it is on a per-user basis. The server is free but the users you have to pay for."
"The licensing model of Tableau has changed since we initially purchased it three years ago and it is more complicated, and I have found it to be more expensive. They have lost market shares to Microsoft BI. My company will probably change solutions this year because of the increased pricing model."
"Tableau is a little cheaper as compared to Power BI and other technologies that we have used in the past. However, if the business users in our organization want to make presentations, Tableau has been asking us to purchase a Tableau Creator license, and $35 per month is expensive for business users. Power BI is giving a free desktop version for business users to connect to any data source and build their own dashboards. That's why we have proposed to use Power BI for most of the business users in our organization."
"Paying for users you never setup or buying expensive desktop licenses for users who can solve their users with web editing on the server are the two biggest expenses."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
845,485 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%
Government
5%
Financial Services Firm
20%
Government
12%
Computer Software Company
10%
University
7%
Educational Organization
44%
Financial Services Firm
10%
Computer Software Company
6%
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: March 2025.
845,485 professionals have used our research since 2012.