IBM Cognos vs Microsoft Power BI vs Pentaho Business Analytics comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
7,146 views|4,118 comparisons
91% willing to recommend
Microsoft Logo
20,208 views|16,855 comparisons
92% willing to recommend
Hitachi Vantara Logo
1,399 views|1,032 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Cognos, Microsoft Power BI, and Pentaho Business Analytics 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).
769,976 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 product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report.""Integration with Office can enable the 'download' mode of storytelling.​""It has a very powerful edit feature which allows users to back out of changes (undo) without forcing them to recreate entire reports.""This solution allows you to input a wide range of file formats.""A positive feature is Report Studio, where we create beautiful, complex reports.""It's enabled us to report directly from our main application systems. We're removing islands of data and we're removing inefficiencies, where people or small divisions had their own store of information.""Mapbox integration for geospatial analytics down to longitude/latitude layers.""The initial setup is very straightforward."

More IBM Cognos Pros →

"It's a straightforward setup.""Our setup is very straight forward and can be done in a matter of hours.""Provides a full platform (database, ETL, reporting, analysis, and so on)""The uploading of information is very easy, as you just use an Excel sheet to start work right away and obtain the benefits of Power BI.""My understanding is that the initial setup is pretty easy.""The reports are easy to create.""The initial setup is easy.""The most valuable feature is integration with Python."

More Microsoft Power BI Pros →

"The most valuable feature of Pentaho is the Tableau report.""The initial setup is pretty straightforward.""I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced.""Easy to use components to create the job.""Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud.""We were able to install it without any assistance from tech support.""Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it."

More Pentaho Business Analytics Pros →

Cons
"One key area for improvement is the need to improve the self-service nature and functionality of the product in terms of visual analytics.""They should provide improved visual reporting.""It would be good if the solution had conditional formatting.""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 data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help.""It would be better if it is was easier to implement without extensive training for it.""The solution's support could be better.""The performance is a bottleneck and something that can be improved."

More IBM Cognos Cons →

"The interface could be improved.""The smart phone application could be improved, along with better graphics and faster updating.""​It needs more analytic tools.""Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI.""It should have more report outputs. They should expand the report outputs. Its documentation should also be better.""The product could have better analytics capabilities.""The initial installation is difficult.""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."

More Microsoft Power BI Cons →

"The repository should be improved.""Another concern is that Pentaho is not customizable or interactive.""Pentaho Business Analytics' user interface is outdated.""Logging capability is needed.""Version control would be a good addition.""Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process.""We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost.""Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention."

More Pentaho Business Analytics 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 →

  • "Free and commercial versions are available."
  • "Pentaho is expensive ."
  • "We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."
  • More Pentaho Business Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Reporting solutions are best for your needs.
    769,976 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 organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive with… more »
    Top Answer:The product to me is not as user-friendly as other players in the market. It also still needs improvement in the… more »
    Top Answer:Pentaho is a BIS(business intelligence system) that is designed to help customers make decisions based on their data… more »
    Ranking
    4th
    out of 50 in Reporting
    Views
    7,146
    Comparisons
    4,118
    Reviews
    13
    Average Words per Review
    449
    Rating
    8.2
    1st
    out of 50 in Reporting
    Views
    20,208
    Comparisons
    16,855
    Reviews
    27
    Average Words per Review
    619
    Rating
    7.9
    17th
    out of 50 in Reporting
    Views
    1,399
    Comparisons
    1,032
    Reviews
    4
    Average Words per Review
    526
    Rating
    7.3
    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
    Pentaho, Kettle, Hitachi Pentaho Business Analytics
    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.

    Pentaho is an open source business intelligence company that provides a wide range of tools to help their customers better manage their businesses. These tools include data integration software, mining tools, dashboard applications, online analytical processing options, and more.

    Pentaho has two product categories: There is the standard enterprise version. This is the product that comes directly from Pentaho itself with all of the benefits, features, and programs that come along with a paid application such us analysis services, dashboard design, and interactive reporting.

    The alternative is an open source version, which the public is permitted to add to and tweak the product. This solution has its advantages, aside from the fact that it is free, in that there are many more people working on the project to improve its quality and breadth of functionality.

    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
    Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
    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
    Computer Software Company19%
    University13%
    Financial Services Firm13%
    Educational Organization6%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Government12%
    Computer Software Company12%
    Educational Organization8%
    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 Enterprise42%
    Large Enterprise45%
    REVIEWERS
    Small Business50%
    Midsize Enterprise17%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise13%
    Large Enterprise61%
    Buyer's Guide
    Reporting
    April 2024
    Find out what your peers are saying about Microsoft, Tableau, Oracle and others in Reporting. Updated: April 2024.
    769,976 professionals have used our research since 2012.