No more typing reviews! Try our Samantha, our new voice AI agent.

Microsoft Power BI vs SAS Visual Analytics vs Targit Decision Suite 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 Mindshare Distribution
ProductMindshare (%)
Microsoft Power BI9.3%
Tableau Enterprise6.7%
Amazon QuickSight3.7%
Other80.3%
BI (Business Intelligence) Tools
Data Visualization Mindshare Distribution
ProductMindshare (%)
SAS Visual Analytics1.8%
Tableau Enterprise11.0%
Domo5.7%
Other81.5%
Data Visualization
Reporting Mindshare Distribution
ProductMindshare (%)
Targit Decision Suite0.8%
Microsoft Power BI17.4%
Tableau Enterprise16.5%
Other65.3%
Reporting
 

Featured Reviews

Antonio Flor - PeerSpot reviewer
Lead Anaplanner at Chaucer Group
Data integration has improved reserving and expense control while collaboration drives fast dashboards
Regarding drawbacks or weak points in Microsoft Power BI, it may not be directly related to the tool itself, but with our architecture, as we couldn't get a service account, which is an email address that has no relationship with the employees, just to establish the connection with Anaplan. We couldn't get it to work on SSO, so we use an employee account which could be a point of weakness, meaning if the person leaves, that connection will break. If the person goes on holiday and we need to refresh, we have to change the connection as well, but we have to live with that since we're not using SSO on the service account. Regarding the natural language processing feature, we're trying to avoid using it too much because it can slow down the connection, so as much as possible, we try to build the logic and any transformation in Anaplan, and then deliver an end product to Microsoft Power BI.
AN
Senior Manager: ICT Compliance at DEPARTMENT OF PUBLIC SERVICE AND ADMINISTRATION
Enables effective data management and reporting with a straightforward setup
SAS Visual Analytics is helpful as it allows us to perform any queries we need. The ability to query information from our Excel data into SAS to view specific data is invaluable. In terms of reporting, it is easy to extract quick reports and provides graphical representations of the data, which is a great feature.
it_user289458 - PeerSpot reviewer
Data Science Intern at a tech vendor with 5,001-10,000 employees
I can now create more meaningful charts--radar, donut, pareto, scatter, range, point, boxplot, etc., but it doesn't support Linux or commodity hardware.
* The tool is very easy to use, we got on-premise training from Panorama, within days we were proficient enough to play with the tool. * The customer service is very responsive, they answered our queries. * I saw lot of people complaining about the lack of community forum, but they do have a forum which is quite active. * The tool is extremely easy to use, with a click you can import data and create the visualizations. * The things I like most is it supports variety of charts, I was quite bored with my previous BI tool which mostly supported bar, line and pie charts. I can now create more meaningful charts radar, donut, pareto, scatter, range, point, boxplot, etc.

Quotes from Members

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

Pros

"It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis."
"From what I have seen, the solution seems to be very stable."
"Microsoft BI is scalable."
"Microsoft BI's most valuable features are the user interface, which is easy to use and light."
"Comparing with Microsoft BI, we found Microsoft to have better handling, graphics, features, and easier development and coding."
"The most valuable features are the easy creation of reports, dashboards, and the ability to perform analysis."
"It's a wonderful application, it meets our needs."
"Users already using Excel can generate new reports and dashboards within minutes."
"What I really love about the software is that I have never struggled in implementing it for complex business requirements. It is good for highly sophisticated and specialized statistics in the areas that some people tend to call artificial intelligence. It is used for everything that involves visual presentation and analysis of highly sophisticated statistics for forecasting and other purposes."
"I would rate the overall solution a ten out of ten."
"SAS VA is an amazing tool for handling complex data models."
"Data handling is one of the best features of SAS Visual Analytics."
"Exposure of full population transactional data to customer facing roles with ability to analyse trends and patterns empowers our citizen data scientists to answer their own business questions regarding customer trends and to forecast future trends."
"It's quite easy to learn and to progress with SAS from an end-user perspective."
"It is a very stable solution."
"Everything we want out of this solution we get in terms of the user requirements and features."
"The tool is extremely easy to use, with a click you can import data and create the visualizations."
 

Cons

"I would like to see a change in the premium capacity."
"Integration with products that are not Microsoft could be more improved."
"The reporting part of Microsoft BI is rather limited compared to other reporting tools."
"The installation requirements are quite demanding and only computers with relatively high processing power and large primary memory are able to run some SQL Reporting and Analysis tools."
"The BI reporting still relies on historical transactions."
"Microsoft is behind IBM when it comes to security features."
"Power BI could be improved by implementing more options for data integration. Nowadays, the cloud takes care of scalability and security."
"For our reporting services, it would be good to have the capability for email-based subscriptions. I want to be able to change the sender dynamically, without having to rely on running through an exercise passage."
"The deployment isn't smooth. Deploying Visual Analytics on the cloud takes a lot of work, or you can use some providers that give you SAS as a service. For example, there is a provider called SaasNow. They host SAS Visual Analytics and the license. You can buy the license and deploy it there without the hassle of installation because deploying the software isn't easy."
"It will be better if SAS can accommodate survey data as some organisations would like to load their survey results and analyse in SAS."
"The solution is a little weak at the front end."
"The visualization should be better in SAS Visual Analytics. It is easy to use but when compared to other solutions it is lacking and the support is not very good."
"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."
"Regarding performance, they have some issues. They have always had some issues there."
"It takes a lot of effort to stabilize. We need to change some hardware and configurations to stabilize the solution."
"Data preparation and data management need work, as without Enterprise Guide, if you use SAS/VA alone (not SAS/VA pro), it will be hard to do the data preparation."
"No support for Linux or commodity hardware. Limited support for big data analytics."
 

Pricing and Cost Advice

"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 pricing is reasonable."
"Make it low in cost. It is a no-brainer!"
"Compared to others, I think it is reasonable."
"I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill."
"They are charging us by users in storage, and there is a license fee. My financial people handle all that. The client has already worked out a contract with Microsoft, and basically, we're getting government prices."
"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."
"Power BI premium is really expensive for our market. A lot of small and medium companies would like to purchase it, but they can't afford it."
"Licensing is simple."
"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."
"SAS Visual Analytics is expensive, as is the rest of the platform."
"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."
"It was licensed for corporate use, and its licensing was on a yearly basis."
"The product is expensive."
"$10,000 per annum for an enterprise license."
Information not available
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
885,837 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Senior Manager - BI Head with 5,001-10,000 employees
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
Financial Services Firm
14%
Manufacturing Company
8%
Government
8%
Computer Software Company
6%
Financial Services Firm
15%
Government
10%
Construction Company
8%
University
7%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business135
Midsize Enterprise58
Large Enterprise167
By reviewers
Company SizeCount
Small Business13
Midsize Enterprise8
Large Enterprise19
No data available
 

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 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?
In terms of configuration, I would like to see AI capabilities since many applications are now integrating AI. It may...
What is your primary use case for SAS Visual Analytics?
I started to work with SAS Visual Analytics ( /products/sas-visual-analytics-reviews ) in 2015. We use it for analysi...
Ask a question
Earn 20 points
 

Also Known As

SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
SAS BI
Targit BI Suite
 

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.
Platon, bubobubo, JetReports, Radley
Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: March 2026.
885,837 professionals have used our research since 2012.