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

Microsoft Power BI vs SAS Visual Analytics comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th), Reporting (4th)
Microsoft Power BI
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
315
Ranking in other categories
BI (Business Intelligence) Tools (1st), Reporting (1st)
SAS Visual Analytics
Average Rating
8.2
Number of Reviews
39
Ranking in other categories
Data Visualization (9th)
 

Mindshare comparison

BI (Business Intelligence) Tools
Data Visualization
 

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.
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.

Quotes from Members

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

Pros

"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"For planning, forecasting, in-boxing, modeling in general and for predicting numbers and doing work analysis, they are excellent."
"The solution's initial setup process is easy."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"We are able to generate quality reports easily which allows us to decrease response time."
"In terms of stability, I think that Cognos is more stable than Tableau and Power Bi because of its framework manager concept that allows us to import metadata and store it in the framework manager."
"IBM Cognos is an excellent solution for tax, planning, budgeting, profit and loss statements and balance sheets."
"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."
"I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
"It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite."
"Microsoft Power BI is an easy tool for data analysis."
"It's a straightforward setup."
"It's easy to create reports and it's easy to download the data from the corresponding report."
"I like having the ability to connect Excel files as data inputs."
"I find Power BI's reporting feature the most valuable. The solution has improved a lot. There are new features getting added day by day. In the past, they didn't even have the printing feature, but now they have it."
"Allows business users with a mission to solve their own problems, without an IT person."
"Data handling is one of the best features of SAS Visual Analytics."
"I like SAS Visual Analytics for its ability to provide an initial understanding of data through exploration, even before deep analytics."
"It's quite easy to learn and to progress with SAS from an end-user perspective."
"We've found the product to be stable and reliable."
"It provided the capability to visualize a bunch of data in an organized way."
"Simplifies report designs and quickly displays tables and graphs."
"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 alert generation feature also helps in sending out ad hoc messages to the business users if business thresholds have been crossed."
 

Cons

"Most of our company's customers want to be able to deploy IBM Cognos on a web application and use it as a desktop application, which is not possible currently."
"The data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help."
"There are a lot of limitations with the out-of-the-box tool."
"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 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."
"I would like to see the introduction of mapbooks for supporting some geographical information."
"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."
"We would like to see development of the product's UI function, to make it more of a UI tool that can be configured as required."
"They are improving it all the time. What would be nice is if they could respond to feature requests more quickly. They can provide faster support for new features."
"Microsoft needs to do some more research and development to make it more stable."
"We have used other solutions and the reporting functionality should be user-friendly and have a drag and drop feature should be available, but Microsoft BI doesn't have these features. When you are creating reports and you can't change as a user. Every time you need one developer or one technical person to make the changes."
"The product could have better analytics capabilities."
"I'm missing collaborations functionality to operate or to work connected with multiple people on a data source or on virtualization. There should be more collaborations functions, such as in Confluence. We haven't explored the solution sufficiently in this area, but at this time it doesn't look sufficient."
"We did have some issues building the Microsoft blog."
"The solution could benefit by allowing deeper data analytics."
"When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world."
"I haven't come across any missing features."
"In Brazil, there are few documents, courses, and other resources for studying and implementing the tool."
"The solution should improve its graphics."
"The installation process can be a bit complex."
"The licensing ends up being more expensive than other options."
"Some capabilities are missing compared to Power BI, especially when working with spreadsheet types."
"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."
"The solution is a little weak at the front end."
 

Pricing and Cost Advice

"IBM Cognos offers competitive pricing similar to other BI vendors in the market."
"It is averagely priced."
"On a scale from one to ten where one is low pricing and ten is high pricing, I would rate this solution at eight."
"Pricing should be improved."
"It's more expensive than similar solutions like Tableau and Power BI."
"The pricing and licensing policies are comparatively cheaper than other products in the market ."
"IBM Cognos is priced reasonable. However, it is more expensive than Power BI and Tableau."
"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."
"If it has to be applied on the cloud, then it costs around $10 per month per user. For a pro license and for a premium license it's around $20 per month per user. If it has to be applied on-premises then, depending on the course of your server, you have to buy a software assurance version of the database."
"Microsoft BI is considered to be competitively priced when compared to other similar solutions in the market."
"There is a license for this solution and we purchase them annually."
"I rate the product pricing a ten."
"The licensing can be complicated."
"Microsoft Power BI has reasonable pricing."
"The license 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."
"It was licensed for corporate use, and its licensing was on a yearly basis."
"SAS Visual Analytics is expensive, as is the rest of the platform."
"I work with the tool's free version...The tool's corporate version is very expensive and requires a monthly hire."
"$10,000 per annum for an enterprise license."
"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."
"The product is quite expensive."
"The product is expensive."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
816,406 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
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Educational Organization
41%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
Financial Services Firm
20%
Government
13%
Computer Software Company
10%
University
7%
 

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 ...
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...
 

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
SAS BI
 

Learn More

Video not available
 

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
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.
Find out what your peers are saying about Microsoft Power BI vs. SAS Visual Analytics and other solutions. Updated: January 2022.
816,406 professionals have used our research since 2012.