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

Mindshare comparison

As of December 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.3% compared to the previous year. The mindshare of Microsoft Power BI is 22.4%, up from 22.4% compared to the previous year. The mindshare of SAP Analytics Cloud is 5.1%, down from 5.9% 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
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.
RamasamyTelungupalayam - PeerSpot reviewer
Seamless integration, collaborative features, and enhances data exploration
There are several areas for improvement in SAP Analytics Cloud. Firstly, features available in SAP Lumira are missing in SAP Analytics Cloud. Secondly, the predictive analytics functions, although promising, are currently only suitable for Proof of Concepts (POCs) and not for industrial-scale use. Lastly, the pricing model for the planning functionality is quite high and presents an entry barrier.

Quotes from Members

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

Pros

"We are able to generate quality reports easily which allows us to decrease response time."
"The initial setup is very straightforward."
"This solution allows you to input a wide range of file formats."
"For planning, forecasting, in-boxing, modeling in general and for predicting numbers and doing work analysis, they are excellent."
"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."
"The dashboarding offered by this solution is very valuable to us."
"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."
"Using custom controls, it is possible to extend the application with even more functionality and make the application intuitive and attractive."
"Power BI, once made available, can connect to various data sources, irrespective of the application, whether it be HR or business applications. The bank has many applications, but all eventually need to generate reports for tracking, distribution, or problem-finding based on analysis. Power BI was made available as part of the productivity suite to all businesses, which can connect to their applications and provide the reports and analysis they require."
"Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
"One of the most valuable features of Power BI is the ease of use. It is comfortable and there is not a steep learning curve for this solution. If you have some idea of the data and basic visualization ideas, you can use this solution comfortably."
"It is a powerful tool that helps our data analysis processes."
"It is more user-friendly compared to SSRS."
"The most valuable feature is integration with Python."
"Management reporting solution that's very stable and scalable."
"The interface is very fluid."
"The most useful feature of SAP Analytics Cloud is planning because it helps users with making predictions and forecasts. Clients can forecast, make data allocations, and other actions. The solution is useful for planning."
"Offers both business intelligence as well as inbuilt AI and machine learning capabilities."
"In the most recent release, the schedule publication was officially updated and it's been added on MS Office 365. I like how we had an EPM for B to C perspective; it's a great enhancement. Also, I believe the B to B connectivity has been improved. Android support for mobile is really good also. Power BI has always had android support in place, so manual support for SAP Analytics Cloud is also a very good feature."
"It is easy to integrate with SAP ERP and BW systems, allowing smooth data transfer and live connections without much development."
"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."
"The new Application Design option offers lots of customization options by being able to script in Typescript (similar to Javascript)."
"The Smart Predict, Smart Insights, and Smart Discovery predictive analysis features are quite good."
"The most valuable features are the analytical application and the user story."
 

Cons

"There are many problems with the product's stability part, making it an area where improvements are required."
"We need more predictive analytical functions, not only diagnostic or decryptic 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."
"They should provide improved visual reporting."
"Data modeling needs to be improved. We use the ETL process, and when we get errors, we then need to identify which structural change is required. The error messaging should be better. They should be descriptive rather than semantic."
"The solution's support could be better."
"The visualization aspect needs to be improved and I believe, this is being resolved in upcoming versions."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"Better mapping capabilities and easier administration access would be beneficial, especially for understanding who has viewed reports."
"When there are large amounts of data being processed there are additional tools needed to handle it."
"Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization. It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go."
"The only challenge I have found is that they do not have a Mac version."
"There are certain features that are only available in the cloud version. It would be beneficial if they could be brought down to the on-premise version without the necessity of using the enterprise SQL database, as that can be very costly. We need more cost-effective features that are available in the cloud to be accessible on-premise."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
"I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple."
"When we have a big report with lots of data, the solution slows down quite a lot."
"An additional feature that needs to be added to SAP Analytics Cloud is exporting because right now, you can only export to PDF and PowerPoint. It would be good to have multiple export options, for example, to Excel and other apps. Pricing is an area for improvement in SAP Analytics Cloud, apart from exporting."
"SAC, which is the cloud version, lost some good features from the previous planning product, like BPC or BPS."
"SAP Analytics Cloud requires a lot of coding and I would like the coding to be somewhat minimal."
"Technical support could be more helpful and responsive."
"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."
"It still lacks a lot of functionalities as compared to other tools such as Power BI or Tableau. Sorting is not working as well as it works in Tableau. A lot of other things are also not at the same level. Their technical support is not perfect and could be better. It takes a lot of time to have lacking functionalities implemented. Its integration with the BW backend should be better. Both solutions are from the same vendor. They position SAP Analytics Cloud as a reporting tool on top of the BW environment, but the integration between both is not yet 100%. For example, user management is still not synchronized."
"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."
"Sometimes we have difficulty connecting to a SharePoint list."
 

Pricing and Cost Advice

"IBM Cognos is priced reasonable. However, it is more expensive than Power BI and Tableau."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
"The solution is affordable."
"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 ."
"The pricing of this product is meant for medium to large-scale enterprises."
"On a scale from one to ten where one is low pricing and ten is high pricing, I would rate this solution at eight."
"The pricing for the solution is relatively higher compared to other alternatives."
"The solution's costs are quite reasonable given the range of features provided."
"It is part of our Office 365 license."
"Microsoft BI for desktop is free to use, and you can download and use it."
"Power BI is subscription-based, and you have three options. The Pro edition, which is the standard one, is about $9 per user. The Premium edition, which provides AI and cloud capabilities but at a limited size, is for small to medium enterprises. It is about $20 per user. For large enterprises, such as manufacturing facilities, there is an option for the capacity. The capacity subscription is about $4,000 per capacity level. They also have an option for the on-premises version, but it is not common to see someone going for the on-premises version. The on-premises version requires a specific license that is attached to SQL Server. I believe it is about $17,000, but I'm not sure about it."
"I'm not very familiar with the licensing aspect, as it operates in the cloud as a SaaS (Software as a Service) model. Essentially, you pay based on cloud cost models, which might include hourly rates or similar billing structures introduced by Microsoft. Many organizations utilize it and pay for its services, somewhat like Office 365. It's a cloud-based platform that provides the necessary services, including support, for development, and you pay accordingly for the usage."
"No comment on pricing."
"Licensing is on a monthly basis, but I am not sure."
"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."
"The product is expensive."
"Compute and storage features should be sold separately."
"The pricing is based on an annual license and is rated a four out of ten."
"The price is competitive. There is a power user license and normal user license, but the normal user license is reasonable."
"Its licensing is on a monthly basis."
"It Wasn't directly involved in the pricing discussions, but when I joined the organization, they had already purchased the SAP Analytics Cloud solution. The organization faced challenges due to its perceived expense, leading to restrictions on granting access to many users."
"The tool's pricing is medium, and licensing costs are yearly."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
823,875 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
55%
Financial Services Firm
7%
Computer Software Company
4%
Government
4%
Educational Organization
42%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
Educational Organization
25%
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: December 2024.
823,875 professionals have used our research since 2012.