IBM Cognos vs Microsoft Power BI vs Oracle Hyperion comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
9,284 views|5,390 comparisons
91% willing to recommend
Microsoft Logo
34,187 views|29,049 comparisons
92% willing to recommend
Oracle Logo
3,345 views|2,180 comparisons
86% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Cognos, Microsoft Power BI, and Oracle Hyperion based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools.
To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: April 2024).
768,886 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
"We use IBM Cognos for enterprise analytics and reporting.""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.""Stability-wise, I rate the solution a ten out of ten.""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.""One of the strong suits of Cognos is its robust corporate reporting capability.""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.""Security administration tools are powerful and flexible.""The most valuable feature is developing reports from different data sources, making it a reliable data source."

More IBM Cognos Pros →

"The most valuable feature is shareability, where we can publish work to the cloud and share it with team members.""Helped identify bad data, enabling the corrections needed to the data for management.""There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly.""Its data visualization provides the user the ability to quickly look at data and focus on relevant information, allowing them to make an immediate decision.""We can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way.""It's similar to Excel, but it's much more powerful than Excel.""It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite.""Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it."

More Microsoft Power BI Pros →

"We like the reporting and tracking of financials.""The scalability is good.""Stable and scalable solution with a valuable data integration feature which allows the slicing and dicing of data. It also has a workforce planning feature that allows you to bring in your HR data.""It's very easy to use and the functionality is quite complete.""One can see that it's a mature product because it addresses all the requirements that you must need for financial consolidation and for budgeting and planning. It's really easy to use.""It is easy to use. It is very intuitive. Even though there is a lot of functionality that comes out of the box, you can customize the solutions to meet your needs. You have the ability to have business rules that produce all kinds of calculations. We're international, and we do all our FX conversions through that.""Oracle Hyperion has helped make things work faster in our company.""It's a very good program and it's useful for consolidation."

More Oracle Hyperion Pros →

Cons
"We would like to see development of the product's UI function, to make it more of a UI tool that can be configured as required.""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.""The solution's support could be better.""Extending dynamic cubes aggregate awareness with calculated measures.""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 solution seems to slow down the servers.""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."

More IBM Cognos Cons →

"Integrating it with the physics build model or the engineering model should be included.""The reporting needs to be improved.""Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users.""The integration with other solutions could be improved for reporting aspects.""Sometimes while developing, the front end is not easily customizable and it has limitations. We cannot go and do any UI we want. We have to stick to the limitations of the product.""They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it.""The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors.""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."

More Microsoft Power BI Cons →

"I would like to see more integrations with third-party vendors such as BigSense and SAP. I'm looking forward to seeing more interface-related content.""There can be an improvement in many regards with the dimensions, the metadata, the interfaces, as well as the integration.""The solution is about to cease to exist, so it doesn't really matter if they add anything to it. It's at end-of-life.""I found the initial setup to be complex.""The Oracle technical support in our area is terrible.""There's something known as a data block that Hyperion generates for each and every transaction. Sometimes it does not generate and we need to identify those issues and fix them manually.""Oracle EPM Cloud solutions have simplified the security model. Nevertheless, it would be better having a more differentiated security model.""I have a problem with Hyperion when I need to log some changes in the budget. It's hard to know who made which changes in the budget."

More Oracle Hyperion 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 →

  • "As Oracle's pricing is on the higher end, most businesses prefer to have their own private cloud."
  • "Compared with MSBA, it is quite reasonable."
  • "To get a full license, which gives you access to most of the different Hyperion programs, it costs $2000 to $2500 a month."
  • "We pay for licensing yearly."
  • "Oracle Hyperion is not an inexpensive solution."
  • "The licenses cost approximately $1,000."
  • "The solution is affordable."
  • "Oracle Hyperion's licensing structures are quite expensive for some companies, especially medium-sized companies because of the user-based license."
  • More Oracle Hyperion Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    768,886 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:The tool is very scalable and powerful. It helps us with financial reporting and performance reporting. It is a very… more »
    Top Answer:Integrating Oracle Hyperion, a multidimensional database, with relational databases poses challenges due to the… more »
    Top Answer:We use the solution for partition planning, HCM, and financial reporting.
    Ranking
    Views
    9,284
    Comparisons
    5,390
    Reviews
    10
    Average Words per Review
    396
    Rating
    8.2
    Views
    34,187
    Comparisons
    29,049
    Reviews
    23
    Average Words per Review
    553
    Rating
    7.9
    Views
    3,345
    Comparisons
    2,180
    Reviews
    9
    Average Words per Review
    630
    Rating
    8.0
    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
    Hyperion
    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.

    Oracle Business Analytics Suite.
    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
    ITNL, Aditya Birla Nuvo Ltd., Zaklady Farmaceutyczne Polpharma S.A., Daelim Industrial Co. Ltd., Barco N.V., SITA, McGregor Fashion Group B.V., PCCW Ltd.
    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%
    Government9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    REVIEWERS
    Manufacturing Company18%
    Retailer15%
    Financial Services Firm12%
    Computer Software Company9%
    VISITORS READING REVIEWS
    Manufacturing Company12%
    Computer Software Company12%
    Financial Services Firm11%
    Retailer6%
    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 Business28%
    Midsize Enterprise9%
    Large Enterprise62%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise12%
    Large Enterprise68%
    Buyer's Guide
    BI (Business Intelligence) Tools
    April 2024
    Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools. Updated: April 2024.
    768,886 professionals have used our research since 2012.