IBM Cognos vs Microsoft Power BI vs SAP Crystal Reports comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
7,258 views|4,224 comparisons
91% willing to recommend
Microsoft Logo
19,900 views|17,006 comparisons
92% willing to recommend
SAP Logo
3,532 views|2,791 comparisons
96% willing to recommend
Comparison Buyer's Guide
Executive Summary

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

Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Reporting.
To learn more, read our detailed Reporting Report (Updated: April 2024).
768,740 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The dashboarding offered by this solution is very valuable to us.""The initial setup is very straightforward.""A positive feature is Report Studio, where we create beautiful, complex reports.""The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.""Cognos is the best application with dashboards,batch reporting, jobs, events and ad-hoc reporting for business users.""I have worked on the features like dashboards and stories, and I do like them a lot.""When it comes to decision-making, the product is very useful and used in many departments since a lot of people prefer the reports to be generated by IBM Cognos.""IBM Cognos improves the effectiveness of the sales team."

More IBM Cognos Pros →

"The solution is stable with reasonable performance.""Easy to use and the visualization is valuable.""What I like most is that I can do everything in Power BI that I can do in Excel.""The data can be accessed from anywhere.""It's a very easy-to-use solution.""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.""There is a lot of variety in Power BI. In particular, the visuals are quite rich and the feature set has been growing rapidly in the last two years. Possibly the best part for me is that there are a lot of ways to connect with data sources.""Reports, dashboards, and visualizations are most valuable."

More Microsoft Power BI Pros →

"I find Crystal Reports very easy to use, even for a non-technical person.""We use SAP Crystal Reports for operational reporting.""The most valuable feature of the solution is that it is a fantastic way of generating reports.""The initial setup of the solution is pretty easy.""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.""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."

More SAP Crystal Reports Pros →

Cons
"Compared to Tableau and PowerBI, the IBM interface is easier to use. However, the drag-and-drop functionality isn't as straightforward. Formatting is also more challenging in the cloud than in other applications, like Power BI. Also, if you encounter an issue, it takes more time to resolve it on the formatting side.""Extending dynamic cubes aggregate awareness with calculated measures.""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 seems to slow down the servers.""There are some small features that are missing. It would be nice if the graphics were better. You can use external sources for charts, but it's quite complex to use and not easy to implement. If you want a new chart, you can download it from multiple tools and implement it into IBM Cognos.""I would like to see the introduction of mapbooks for supporting some geographical information.""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.""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."

More IBM Cognos Cons →

"Areas of Power BI that could be improved are the learning curve for developers who come from non-technical backgrounds.""They can improve it in terms of rule-based security. Currently, it has very limited rules.""They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. They can make it easier to create some of the reports. They can also include predefined templates that you can directly use.""Powerpoints are not available in the report server.""It should have more report outputs. They should expand the report outputs. Its documentation should also be better.""Sluggish performance when handling large amounts of data.""Microsoft needs to provide more drivers to connect other data sources in a native way.""The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."

More Microsoft Power BI Cons →

"There could be improvements made to the analytics capabilities.""The financing part needs improvement.""SAP Crystal Reports should provide better support for dynamic connectors.""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.""SAP Crystal Reports has some compatibility issues with third-party products.""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."

More SAP Crystal Reports Cons →

Pricing and Cost Advice
  • "There is need to assess the purchase license accordingly so as to avoid audit penalties."
  • "The pricing and licensing policies are comparatively cheaper than other products in the market ."
  • "IBM Cognos offers competitive pricing similar to other BI vendors in the market."
  • "Pricing should be improved."
  • "The pricing of this product is meant for medium to large-scale enterprises."
  • "It is my understanding that the cost is very low. It's not very expensive."
  • "Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."
  • "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."
  • More IBM Cognos Pricing and Cost Advice →

  • "There is room for at least 45% discount as compared to the initial price."
  • "MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
  • "All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights."
  • "I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill."
  • "Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? ​"
  • "Make it low in cost. It is a no-brainer!"
  • "Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost."
  • "Paid for itself in the first month."
  • More Microsoft Power BI Pricing and Cost Advice →

  • "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."
  • "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."
  • More SAP Crystal Reports Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Reporting solutions are best for your needs.
    768,740 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:It depends on the Data architecture and the complexity of your requirement Some great tools in the market are Qlik… more »
    Top Answer:We use the account statement report. When you use an account in HSBC, you receive various types of accounts, such as the… more »
    Top Answer:Compared to Tableau and PowerBI, the IBM interface is easier to use. However, the drag-and-drop functionality isn't as… more »
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would… more »
    Top Answer:Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are… more »
    Top Answer:SAP Crystal Reports should provide better support for dynamic connectors. The solution should export reports to Excel in… more »
    Top Answer:We were dedicated to Crystal Reports, and now they have shifted to SAP reports. While both functionalities are similar… more »
    Top Answer:We use SAP Crystal Reports for operational reporting.
    Ranking
    4th
    out of 50 in Reporting
    Views
    7,258
    Comparisons
    4,224
    Reviews
    10
    Average Words per Review
    396
    Rating
    8.2
    1st
    out of 50 in Reporting
    Views
    19,900
    Comparisons
    17,006
    Reviews
    23
    Average Words per Review
    553
    Rating
    7.9
    9th
    out of 50 in Reporting
    Views
    3,532
    Comparisons
    2,791
    Reviews
    6
    Average Words per Review
    416
    Rating
    8.5
    Comparisons
    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
    Learn More
    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
    Top Industries
    REVIEWERS
    Financial Services Firm14%
    Computer Software Company11%
    Insurance Company8%
    Healthcare Company8%
    VISITORS READING REVIEWS
    Educational Organization58%
    Financial Services Firm7%
    Computer Software Company5%
    Government5%
    REVIEWERS
    Financial Services Firm15%
    Manufacturing Company13%
    Computer Software Company11%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    REVIEWERS
    Healthcare Company17%
    Financial Services Firm17%
    Construction Company8%
    Government8%
    VISITORS READING REVIEWS
    Government10%
    Computer Software Company10%
    Financial Services Firm9%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business23%
    Midsize Enterprise15%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business8%
    Midsize Enterprise61%
    Large Enterprise31%
    REVIEWERS
    Small Business39%
    Midsize Enterprise16%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise41%
    Large Enterprise45%
    REVIEWERS
    Small Business29%
    Midsize Enterprise27%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business23%
    Midsize Enterprise14%
    Large Enterprise62%
    Buyer's Guide
    Reporting
    April 2024
    Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Reporting. Updated: April 2024.
    768,740 professionals have used our research since 2012.