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

Microsoft Power BI vs SAP Crystal Reports comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th)
Microsoft Power BI
Ranking in Reporting
1st
Average Rating
8.0
Number of Reviews
315
Ranking in other categories
BI (Business Intelligence) Tools (1st)
SAP Crystal Reports
Ranking in Reporting
9th
Average Rating
8.4
Number of Reviews
49
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Reporting category, the mindshare of IBM Cognos is 4.4%, down from 6.1% compared to the previous year. The mindshare of Microsoft Power BI is 26.5%, up from 25.3% compared to the previous year. The mindshare of SAP Crystal Reports is 2.8%, down from 4.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

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.
MVD Prasad - PeerSpot reviewer
Jan 9, 2024
Helps analyze your data by creating richly formatted, pixel-perfect, and multiple reports from virtually any data source, delivered in over a dozen formats
We were dedicated to Crystal Reports, and now they have shifted to SAP reports. While both functionalities are similar, there might be some enhancements or additional features to look forward to in the SAP version. However, I haven't encountered any issues. I've consistently used SAP Crystal…

Quotes from Members

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

Pros

"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools."
"If they want dashboarding, storytelling, and analyzing why KPIs are met or not, then Cognos is a better candidate than Qlik Sense."
"Mapbox integration for geospatial analytics down to longitude/latitude layers."
"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."
"The most valuable feature is developing reports from different data sources, making it a reliable data source."
"IBM Cognos improves the effectiveness of the sales team."
"Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards."
"In the early stage of an implementation, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected."
"We've used Microsoft BI for the general use cases around reporting and dashboarding."
"It's a very easy-to-use solution."
"You can integrate Microsoft Power BI with various other solutions like Intune."
"It is a little easier at buildings charts and graphs than Tableau."
"Technical support is quite good."
"The most valuable feature of Microsoft Power BI is the drill-through feature that takes you to a details page the users want to see."
"The initial setup of the solution is pretty easy."
"We use SAP Crystal Reports for operational reporting."
"SAP Crystal Reports offers a plethora of features, many of which were available much earlier than in the Crystal Reports we previously used. We extensively use its capabilities for generating general reports, working with Kaspersky data, and even incorporating images into our reports. The range of functions available in SAP Crystal Reports is diverse, and we leverage them across various systems for our needs."
"The most valuable feature of the solution is that it is a fantastic way of generating reports."
"I find Crystal Reports very easy to use, even for a non-technical person."
"The most valuable feature is that from a user's point of view, it is easy to use and requires just a simple click to generate a report."
"It is an user-friendly solution."
"The overall environment is the best. Data management, graphs, and layout – everything is the best, in my opinion."
 

Cons

"The solution seems to slow down the servers."
"There are many problems with the product's stability part, making it an area where improvements are required."
"One key area for improvement is the need to improve the self-service nature and functionality of the product in terms of visual analytics."
"Extending features on dashboards so it becomes a real dashboard building application, not only a data exploration tool."
"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 visualization aspect needs to be improved and I believe, this is being resolved in upcoming versions."
"It would be better if it is was easier to implement without extensive training for it."
"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."
"Power BI's drillthrough feature could be improved. I didn't like drillthrough and those options much, but I did like it in MicroStrategy."
"The integration in Microsoft BI could improve for other solutions, such as Oracle DB and PostgresSQL. Additionally, the reporting from the databases to Microsoft BI should be in real-time and the overall performance could be better."
"These licenses are in US dollars. With a long-term license, the client is unaffected when the exchange rate goes up. However, if the exchange rate goes down, you don't get refunded from the excess money you've paid. I guess that is a risk you take in business."
"I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."
"It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved."
"I'm looking for something that can make it much easier to incorporate Power BI visuals or dashboards into, let's say, Power Apps – custom Power Apps or anything like that. The most important thing would be to seamlessly embed reports in applications. For example, to have buttons that can be navigated through multiple solutions – from Power Apps to Power BI to SharePoint – via links or something like that."
"The solution could be quicker at rendering data."
"Better mapping capabilities and easier administration access would be beneficial, especially for understanding who has viewed reports."
"SAP Crystal Reports has some compatibility issues with third-party products."
"There could be improvements made to the analytics capabilities."
"If at all possible, a little bit of improvement on the analytical side is needed."
"Maybe some Power BI-related features could be added, like dashboards or direct editing in reports."
"It has significantly enhanced security features, especially when compared to the standard security features of the earlier PeerSpot version I purchased. I've observed improvements in security, and overall, it's quite commendable. Regarding potential enhancements for the next release of this solution, I haven't closely examined SAP Crystal Reports 53. I've only encountered it briefly, perhaps once or twice. However, I anticipate that it likely offers advanced features distinct from its predecessor. I believe there may be notable improvements and additions in the latest version, and I look forward to exploring them further."
"The financing part needs improvement."
"SAP Crystal Reports should provide better support for dynamic connectors."
"A real improvement would be a simpler system that allows users to play with the visualization without needing specialized skills and code."
 

Pricing and Cost Advice

"The pricing of this product is meant for medium to large-scale enterprises."
"IBM Cognos offers competitive pricing similar to other BI vendors in the market."
"I don't know the exact cost, but I believe Cognos is quite expensive, especially when it comes to the support consultants and the procedures that need to be applied."
"There is a standard license required to use this solution. There are some additional tools but I am not sure if they are an extra cost."
"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."
"It is my understanding that the cost is very low. It's not very expensive."
"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 premium capacity is very costly in respect of the market in Egypt, amounting to $5,000 monthly."
"The solution’s pricing 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."
"It depends upon the tier of your Office 365 subscription. On E5, which is a Microsoft Azure subscription, you get it for free. If you are on a lower tier, you can subscribe for $10 a month per user, which is really cheap."
"We pay on a monthly basis which is approximately $10 per user on the Microsoft Power BI Pro license. At the moment we are still down at 400 users, but once we reach 500 users, we will move to the premium edition. The premium is $5,000 for unlimited users. Currently, with the 40 users, the cost is roughly $500."
"It is part of our Office 365 license."
"Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost."
"We pay fifteen hundred dollars as licensing fee."
"This product costs a lot of money."
"The cost of licensing can be a significant factor to consider when upgrading or transitioning to a new version of SAP Crystal Reports. It's important to evaluate the benefits and features offered by the new version against the associated costs to ensure it aligns with your organization's needs and budget."
"SAP Crystal Reports is a very expensive solution."
"I feel that SAP Crystal Reports is a reasonably priced product."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
814,649 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%
Computer Software Company
10%
Financial Services Firm
10%
Government
9%
Manufacturing Company
9%
 

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 needs improvement with SAP Crystal Reports?
Maybe some Power BI-related features could be added, like dashboards or direct editing in reports. We use query langu...
What is your primary use case for SAP Crystal Reports?
We use SAP Crystal Reports for reporting. We use it for financial reports like statements of accounts, trial balances...
What do you like most about SAP Crystal Reports?
We use SAP Crystal Reports for operational reporting.
 

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
No data available
 

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
City of Buenos Aires, ASR Group, Citrix, EarlySense, Usha International Limited, Automotive Resources International (ARI), LivePerson, Coelba (Grupo Neoenergia), RZD Russian Railways, National Basketball Association - NBA, TALLY WEiJL, El Machetazo, Young Heroes, Mozzart, Mitsui Knowledge Industry (MKI) , Surgutneftegas Open Joint Stock Company, The VELUX Group, AOK Bundesverband, AL-KO KOBER GROUP
Find out what your peers are saying about Microsoft Power BI vs. SAP Crystal Reports and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.