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

Microsoft Power BI vs SAP Analytics Cloud 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
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
Reporting (4th)
Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Average Rating
8.0
Number of Reviews
315
Ranking in other categories
Reporting (1st)
SAP Analytics Cloud
Ranking in BI (Business Intelligence) Tools
4th
Average Rating
8.0
Number of Reviews
69
Ranking in other categories
Predictive Analytics (2nd)
 

Mindshare comparison

As of November 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.4% compared to the previous year. The mindshare of Microsoft Power BI is 23.0%, up from 22.8% compared to the previous year. The mindshare of SAP Analytics Cloud is 5.3%, down from 6.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Jul 27, 2022
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
Jul 17, 2024
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.
RamasamyTelungupalayam - PeerSpot reviewer
Sep 12, 2024
Seamless integration, collaborative features, and enhances data exploration
Our primary use cases for SAP Analytics Cloud are dashboarding and planning. It's integrated with our ERP systems, and we use it to pull data, create models, display charts, and develop dashboards SAP Analytics Cloud has improved our organization by providing collaborative features, such as…

Quotes from Members

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

Pros

"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."
"The solution's initial setup process is easy."
"We are able to generate quality reports easily which allows us to decrease response time."
"Even while a user is using a cube for reporting, there will not be a situation as ' Cube file locked; unable to build or deploy'."
"Self-service is possible through the use of dashboards, which are also very intuitive. Stories can be used to pin snapshots, tell the story for meetings, etc."
"The comprehensiveness or broadness of the software functions or business intelligence functions that it provides is valuable. It is also quite easy to use and user-friendly."
"The correlation analysis is excellent. It's one of the best that I have used to date."
"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."
"Microsoft BI's most valuable feature is flexibility."
"Implementation is very quick and the solution is very user-friendly."
"The various different ETL tools within it and the ability to have different data refreshes and scheduled refreshes [real-time data refresh capabilities] have most significantly improved the data analysis processes."
"It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation. Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution. Their technical support is very good. They are extremely responsive, helpful, and hands-on."
"The solution is stable."
"My understanding is that the initial setup is pretty easy."
"It provides good visibility."
"Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features."
"The product's most valuable features are reporting and planning, driverless planning, business vertical-wise planning, dashboarding, forecasting tools, and business forecasting."
"There is a real-time reporting mechanism in place. SAP Analytics Cloud operates on the SAP S/4HANA database, ensuring real-time reporting is always available. This capability allows the business to monitor cash inflows and outflows at any given moment easily."
"We mainly use Analytics Cloud because it integrates with other SAP solutions. Our ERP is an SAP product, and our back-end is SAP Business Warehouse, so integration is an essential factor."
"It is a comprehensive BI solution that provides reporting, planning, and predictive analytics in one solution. You don't have to buy three different products. It is very flexible. It can be implemented very quickly. It has a lot of out-of-the-box scenarios that you can use for quick deployment."
"The solution is stable."
"It's many features make it the best in the market."
"I would recommend this solution for companies that are SAP dependent with users working in this environment."
"The SKU, the story build all are user- friendly. For the story build one just has to drag and drop it. And for the table, you just need some sort of selections and everything there."
 

Cons

"It would be nice to offer free online training on the tool for end-users."
"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."
"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 to see the introduction of mapbooks for supporting some geographical information."
"It would be good if the solution had conditional formatting."
"The solution seems to slow down the servers."
"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."
"Need improvement towards Visualization."
"The upgrade process could be improved."
"I would like to see more AI capabilities in future releases. There's a strong interest in AI, including technologies like GPT, which facilitate real-time interactions."
"Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process."
"It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."
"It has come a long way in terms of how it was working two years ago, but there are some things that you still can't do with it. For example, permission management and user access management are still a bit limited. It is basically based on the idea that everybody from the organization can see everything or limit the type of data they can see. If I want you to see only one report and the other guy to see another report, I can't do it. There should be a better way to manage permissions and users. It should also support external users much better."
"It should be more user-friendly. There are very small or tiny icons that you need to move very carefully. If you go a little bit up and down, some of the values change. Its user interface should be improved. It should be like Tableau. Its performance is also slow and should be improved. I definitely feel some sort of speed issues with Power BI. The integration of Excel with Power BI would also be good."
"The dashboard could be simplified."
"If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users."
"In the live connection model, we can't create calculated dimensions, however, in the import model we can create them."
"The price, integration, and modeling capabilities could be better. I have to use an integration engine to integrate our products and databases. SAP Analytics Cloud is made specifically for KPIs and business intelligence. The modeling capabilities are kind of poor. You always have to model the data and then present it visually in SAP Analytics Cloud. In the next release, I would like to have a lite version for planning to create scenarios quickly. For me personally, planning is the most complicated feature of SAP Analytics Cloud."
"Connection and integration with other applications have a lot of restrictions at the moment."
"Live Data Models are very slow and the setup can be improved, with tools such as Cloud Connector being inbuilt into SAP Analytics Cloud. Likewise, we need to write application code from scratch, rather than tweaking existing code, as we might with Excel macros. Moreover, when using responsive pages, the widgets get adjusted according to the mobile screen. As a result, when I place two or three KPI tiles, they can only be viewed tile-by-tile. We want to see the full dashboard on the mobile screen and zoom in to click on a particular section of the dashboard and go further into that. But displaying tile-by-tile makes it very annoying and the upper management using this dashboard might not be aware there are any more tiles to view."
"Some of the standard visualizations, such as a speedometer or a goal chart, are not there and should be added."
"I would like to see improved support for third-party systems, lower cost of acquisition, and better graphics and interface design."
"The technology used by the tool is old, making it an area where improvements are required."
"They need a better scalability rate."
 

Pricing and Cost Advice

"It is my understanding that the cost is very low. It's not very expensive."
"It is averagely priced."
"The pricing of this product is meant for medium to large-scale enterprises."
"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."
"I rate the product price as four or five on a scale from one to ten, where one is a low price, and ten is a high price."
"Pricing should be improved."
"The pricing and licensing policies are comparatively cheaper than other products in the market ."
"I rate the product pricing a ten."
"I have never worked on licensing, but I have heard that it is reasonable."
"I rate the product price an eight on a scale of one to ten, where one is low price and ten is high price."
"Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
"It would be better if the price was cheaper."
"Microsoft Power BI has reasonable pricing."
"There are a few options available for purchasing a license. Typically the number of users you have will determine the price of the license. The more users you have the more you will pay."
"Both cost-wise and implementation-wise, this product is a good choice."
"I don't have the exact price for SAP Analytics Cloud, but it could be improved and made cheaper, especially when compared to Power BI."
"This solution is pricey."
"It is a bit expensive, but really worth it, especially if you are already using other SAP tools."
"Its price is slightly on the higher side."
"It's quite expensive and costs a lot to maintain, especially with licensing."
"SAP Analytics Cloud can be quite expensive."
"Its pricing is okay as compared to its competitors."
"The price is competitive. There is a power user license and normal user license, but the normal user license is reasonable."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
815,854 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
57%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Educational Organization
41%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
5%
Educational Organization
24%
Manufacturing Company
13%
Computer Software Company
9%
Financial Services Firm
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 ...
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 SAP Analytics Cloud?
In the data warehouse, you're free to make changes. You can make everything text, meaning it's always a string. Even ...
What is your experience regarding pricing and costs for SAP Analytics Cloud?
The pricing model for SAP Analytics Cloud is quite competitive, but the cost for the planning functionality is high a...
 

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
SAP BusinessObjects Cloud
 

Learn More

 

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
Live Oak Bank
Find out what your peers are saying about Microsoft Power BI vs. SAP Analytics Cloud and other solutions. Updated: October 2024.
815,854 professionals have used our research since 2012.