Microsoft Power BI vs SAP Crystal Reports comparison

Microsoft and SAP are both solutions in the Reporting category. Microsoft is ranked #1 with an average rating of 7.9, while SAP is ranked #9 with an average rating of 8.4. Microsoft holds a 26.7% mindshare in RT, compared to SAP’s 2.8% mindshare. Additionally, 93% of Microsoft users are willing to recommend the solution, compared to 96% of SAP users who would recommend it.

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Microsoft Power BI and SAP Crystal Reports based on real PeerSpot user reviews.

Find out in this report how the two Reporting solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Microsoft Power BI vs. SAP Crystal Reports Report (Updated: December 2024).

Buyer's Guide

Microsoft Power BI vs. SAP Crystals

December 2024

Download the complete report

Helped 824,067 peers since 2012

Categories and Ranking

IBM Cognos

Mindshare comparison

As of December 2024, in the Reporting category, the mindshare of IBM Cognos is 4.6%, down from 6.1% compared to the previous year. The mindshare of Microsoft Power BI is 26.7%, up from 25.2% compared to the previous year. The mindshare of SAP Crystal Reports is 2.8%, down from 4.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Reporting

Featured Reviews

Carlos Larrad Salgado

Deputy Director Operations Management Control at Mapfre

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.

Read full review

Amol Rane

Solutions Architect M365 at Sogeti UK

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.

Read full review

MVD Prasad

Assistant General Manager at Soma Enterprise

Helps analyze your data by creating richly formatted, pixel-perfect, and multiple reports from virtually any data source, delivered in over a dozen formats

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.

Read full review

Quotes from Members

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

Pros

"Previously, we were doing static reporting. Management would request a report, and it would take staff a week or more to provide it. With Cognos, we have dynamic reporting, and it has reduced both reporting and decision making times significantly. With the solution's dashboard, the company's management team has updated records at their fingertips. This means that they can directly access the data they need to make decisions."

"The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report."

"The solution's initial setup process is easy."

"Security administration tools are powerful and flexible."

"A positive feature is Report Studio, where we create beautiful, complex reports."

"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 three IBM Cognos features I find the most valuable are Dynamic Cubes, PowerPlay, and Watson."

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

More IBM Cognos pros

"The solution is very easy to use."

"It's pretty easy to set up the product."

"The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on."

"Key features are its dashboard functionality and ease of integration with various data sources."

"One of the key benefits of Power BI is how easy it is to develop reports."

"The data manipulation and data cleaning tasks are handled in the backend by Power Query in Microsoft Power BI."

"Microsoft BI's most valuable feature is flexibility."

"I like having the ability to connect Excel files as data inputs."

More Microsoft Power BI pros

"The overall environment is the best. Data management, graphs, and layout – everything is the best, in my opinion."

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

"It is an user-friendly solution."

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

"I find Crystal Reports very easy to use, even for a non-technical person."

"We use SAP Crystal Reports for operational reporting."

"The initial setup of the solution is pretty easy."

Cons

"I would like them to reinclude PowerPlay. One thing that I am missing in the current Cognos is what was formally named PowerPlay. They have basically removed PowerPlay from it, which is something that I fail to understand because it was the most wonderful tool for business intelligence that I've ever used. As far as I know, they don't provide this functionality anymore, so this is one thing that I dislike about Cognos."

"The AI-based features could be further enhanced by the solution."

"The technical support team’s response time is slow and needs to be improved."

"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."

"In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful. I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring."

"They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of the product."

"It would be better if it is was easier to implement without extensive training for it."

"I would like to see the introduction of mapbooks for supporting some geographical information."

More IBM Cognos cons

"I think that they can add more types of charts because the selection on the desktop version is limited."

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

"We face multiple issues, and the connection drops off multiple times while integrating Microsoft Power BI with OAC and pulling in the data."

"The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."

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

"A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."

"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 DAX in Microsoft BI is quite difficult."

More Microsoft Power BI cons

"Maybe some Power BI-related features could be added, like dashboards or direct editing in reports."

"The financing part needs improvement."

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

"A real improvement would be a simpler system that allows users to play with the visualization without needing specialized skills and code."

"If at all possible, a little bit of improvement on the analytical side is needed."

"There could be improvements made to the analytics capabilities."

"SAP Crystal Reports has some compatibility issues with third-party products."

"SAP Crystal Reports should provide better support for dynamic connectors."

Pricing and Cost Advice

"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."

"The licensing costs are a little bit higher for IBM Cognos. I don't think there is any additional cost apart from the licensing charges."

"Pricing should be improved."

"There is need to assess the purchase license accordingly so as to avoid audit penalties."

"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."

"My company uses IBM Cognos with another IBM product, so I think only one license is used."

"The pricing and licensing policies are comparatively cheaper than other products in the market ."

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

More IBM Cognos pricing and cost advice

"Power BI is cheaper than Tableau and Cognos."

"There is room for at least 45% discount as compared to the initial price."

"Power BI comes with enterprise Microsoft licensing. So for the user, you don't have to pay, but you do have to pay a one-time cost."

"Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? "

"No comment."

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

"I very much recommend the free trial mode."

"Compared to others, I think it is reasonable."

More Microsoft Power BI pricing and cost advice

"SAP Crystal Reports is a very expensive solution."

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

"This product costs a lot of money."

"I feel that SAP Crystal Reports is a reasonably priced product."

"We pay fifteen hundred dollars as licensing fee."

See which vendors are best for you

Use our free recommendation engine to learn which Reporting solutions are best for your needs.

See recommendations

824,067 professionals have used our research since 2012.

Comparison Review

it_user79932

Senior Manager - BI Head at NVidia

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…

Read full review

Top Industries

By visitors reading reviews

Educational Organization

55%

Financial Services Firm

Computer Software Company

Manufacturing Company

Educational Organization

42%

Financial Services Firm

Computer Software Company

Manufacturing Company

Financial Services Firm

11%

Computer Software Company

10%

Government

Manufacturing Company

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

See all answers

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.

See all answers

What needs improvement with IBM Cognos?

I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...

See all answers

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

See all answers

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

See all answers

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

See all answers

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

See all answers

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

See all answers

What do you like most about SAP Crystal Reports?

We use SAP Crystal Reports for operational reporting.

See all answers

Comparisons

Tableau vs IBM Cognos

Compared 10% of the time

Oracle Hyperion vs IBM Cognos

Compared 10% of the time

Amazon QuickSight vs IBM Cognos

Compared 8% of the time

SAP BusinessObjects Business Intelligence Platform vs IBM Cognos

Compared 7% of the time

Databricks vs IBM Cognos

Compared 2% of the time

More IBM Cognos Competitors

Tableau vs Microsoft Power BI

Compared 16% of the time

Domo vs Microsoft Power BI

Compared 9% of the time

Amazon QuickSight vs Microsoft Power BI

Compared 8% of the time

Databricks vs Microsoft Power BI

Compared 6% of the time

Workday Prism Analytics vs Microsoft Power BI

Compared 3% of the time

More Microsoft Power BI Competitors

TIBCO Jaspersoft vs SAP Crystal Reports

Compared 20% of the time

Microsoft SQL Server Reporting Services vs SAP Crystal Reports

Compared 10% of the time

MicroStrategy vs SAP Crystal Reports

Compared 8% of the time

Pentaho Business Analytics vs SAP Crystal Reports

Compared 6% of the time

Oracle OBIEE vs SAP Crystal Reports

Compared 6% of the time

More SAP Crystal Reports Competitors

Product Reports

Buyer's Guide

IBM Cognos

December 2024

Download IBM Cognos product report

Buyer's Guide

Microsoft Power BI

December 2024

Download Microsoft Power BI product report

Buyer's Guide

SAP Crystals

November 2024

Download SAP Crystal Reports product report

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

IBM

Microsoft

SAP

Overview

IBM Cognos Business Intelligence provides a wide range of tools to help you analyze your organization's data. IBM Cognos BI allows businesses to monitor events and metrics, create and view business reports, and analyze data to help them make effective business decisions.

IBM Cognos applies techniques to describe, summarize, and compare data, and draw conclusions. This allows users to see trends and discover anomalies or variances that may not be evident by simply reading data. Data sources that contain information from different areas of a business can be stored in separate packages. Users can see only information that they have been granted access to, based on their group or role.

IBM Cognos BI consolidates the following business intelligence functions into a single web-based solution:

IBM Cognos Insight: Create personal and managed workspaces for data analysis. Using these interactive workspaces, you can share insight results with managers. Cognos Insight supports write-back, and you can also use these workspaces to capture and integrate management goals, commitments, and forecasts.
IBM Cognos Workspace: With IBM Cognos Workspace, you can create rich, interactive workspaces using IBM Cognos content as well as data from external sources. You can view and open your favorite workspaces and reports, edit content in your workspaces, and share your workspaces via email.
IBM Cognos Analytics: IBM Cognos Analytics utilizes built-in AI and intuitive searches which helps users to quickly create the visualizations and a wide range of reports. Cognos Analytics provides cognitive and managed self-service, enabling you to gain insights from controlled and trusted data.
IBM Cognos Report Studio and IBM Cognos Query Studio: Easily create structured and query reports. IBM Cognos allows users to create application and report templates. In addition, report authors can reuse report objects to apply filters, fields, and styles to reports. Users can set the language of the user interface and report content according to the user's native language.
IBM Cognos Event Studio: Receive notifications of events that occur within your organization in real time. Event Studio enables the creation of agents that detect the occurrence of business events, failures, or anomalies, based on the change of specific events or data conditions. Notification can be sent via email, publication in the portal, or by triggering reports.
IBM Cognos Connection: This is the Web portal for IBM Cognos BI and is the central area for accessing all the IBM Cognos functions. In the web portal, users can schedule and distribute reports, create tasks, administer the server and the access permissions, and more.

Reviews from Real Users

IBM Cognos stands out among its competitors for a number of reasons. Two major ones are its powerful analysis tool and its reporting capabilities.

Prasad B., a senior software engineer at a financial services firm, notes, “The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report. We can receive automated reports as well. They are easy to schedule on a weekly or monthly basis. It is very fast. I mean in means of report output, it's very fast compared to the actual clients involved.”

Microsoft Power BI is a powerful tool for data analysis and visualization. This tool stands out for its ability to merge and analyze data from various sources. Widely adopted across different industries and departments, Power BI is instrumental in creating visually appealing dashboards and generating insightful business intelligence reports. Its intuitive interface, robust visualization capabilities, and seamless integration with other Microsoft applications empower users to easily create interactive reports and gain valuable insights.

Turn information from almost any data source into a sophisticated, interactive report with SAP Crystal Reports. This powerful, user-friendly application for small businesses and departments can help you deliver key insights to the right decision maker, at the right time, in the right format.

Click here for a free trial

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

Buyer's Guide

Microsoft Power BI vs. SAP Crystals

December 2024

Free Report: Microsoft Power BI vs. SAP Crystal Reports

Find out what your peers are saying about Microsoft Power BI vs. SAP Crystal Reports and other solutions. Updated: December 2024.

DOWNLOAD NOW

824,067 professionals have used our research since 2012.

See our Microsoft Power BI vs. SAP Crystal Reports report.

See our list of best Reporting vendors.

We monitor all Reporting reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.