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

Microsoft Power BI vs Pentaho Business Analytics comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in BI (Business Intelligence) Tools
7th
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
No ranking in other categories
Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Ranking in Reporting
1st
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
315
Ranking in other categories
No ranking in other categories
Pentaho Business Analytics
Ranking in BI (Business Intelligence) Tools
21st
Ranking in Reporting
15th
Average Rating
8.0
Reviews Sentiment
5.8
Number of Reviews
42
Ranking in other categories
Cloud Operations Analytics (4th)
 

Mindshare comparison

As of November 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.4% compared to the previous year. The mindshare of Microsoft Power BI is 23.0%, up from 22.8% compared to the previous year. The mindshare of Pentaho Business Analytics is 0.6%, down from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
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
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.
Sayan König - PeerSpot reviewer
Flexible, easy to understand, and simple to set up
The repository should be improved. There should be the possibility to have versioning, to make it combinable with some Git repositories or something like that, to check out the processes and make sure it has a traceable history. The solution could really be improved. There are too many bugs in our version.

Quotes from Members

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

Pros

"Cognos' most valuable features are the bundled studios, simple UI, and advanced features like the ability to create data modules."
"One of the strong suits of Cognos is its robust corporate reporting capability."
"The initial setup was straightforward."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"Stability-wise, I rate the solution a ten out of ten."
"Cognos is the best application with dashboards,batch reporting, jobs, events and ad-hoc reporting for business users."
"The main difference that I like about Cognos compared to other solutions is its data splitting functionality. We have all our company data inside the Cognos environment and so we prefer to split the information Cognos itself. It's more efficient this way."
"Microsoft BI's most valuable feature is flexibility."
"It has greatly improved our reporting capabilities."
"Provides data feeds for enterprise KPI reporting."
"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"There is continual improvement year-over-year."
"I have found the most valuable feature of this solution is the Natural Language tool."
"We have found the solution to be stable."
"The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter."
"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."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"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."
"The most valuable feature of Pentaho is the Tableau report."
"We were able to install it without any assistance from tech support."
"The initial setup is pretty straightforward."
"Easy to use components to create the job."
 

Cons

"There are many problems with the product's stability part, making it an area where improvements are required."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"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."
"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."
"It would be better if it is was easier to implement without extensive training for it."
"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."
"The performance is a bottleneck and something that can be improved."
"Cognos charts are not as fast as those of the other tools, even with DQM (dynamic query mode)."
"SQL Server Reporting Services (SSRS) is not user friendly."
"The mobile app is very poor."
"If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3."
"Power BI doesn't support some open-source data sources that are new, such as SnowSQL, Iceberg, or ClickHouse."
"Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik."
"When we have a big report with lots of data, the solution slows down quite a lot."
"I would like to see more visualization options."
"Microsoft BI’s integration and visualization could be improved."
"Logging capability is needed."
"Another concern is that Pentaho is not customizable or interactive."
"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."
"The repository should be improved."
"Version control would be a good addition."
"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."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Pentaho Business Analytics' user interface is outdated."
 

Pricing and Cost Advice

"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"It is averagely priced."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"The solution is affordable."
"IBM Cognos is priced reasonable. However, it is more expensive than Power BI and Tableau."
"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."
"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."
"Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI."
"Our license is paid yearly and we have found that we have to be careful not to over-extend our usage in order to avoid upgrading our capacity plan."
"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."
"Power BI is cost-effective compared to other reporting tools."
"The cost of licensing depends on the number of people that are going to be using the reports, and we are satisfied with it at $10 per user."
"It would be better if the price was cheaper."
"Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money."
"In the beginning, the solution cost approximately $1,000 per month, we have a Microsoft startup subscription. There is a subscription pack for startups company which we are able to have for one year."
"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."
"Free and commercial versions are available."
"Pentaho is expensive ."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
816,562 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
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Educational Organization
41%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
Financial Services Firm
24%
Computer Software Company
14%
Government
8%
Educational Organization
8%
 

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 is your experience regarding pricing and costs for Pentaho Business Analytics?
The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive wi...
What needs improvement with Pentaho Business Analytics?
The product to me is not as user-friendly as other players in the market. It also still needs improvement in the repo...
What is your primary use case for Pentaho Business Analytics?
Pentaho is a BIS(business intelligence system) that is designed to help customers make decisions based on their data ...
 

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
 

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
Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
Find out what your peers are saying about Microsoft Power BI vs. Pentaho Business Analytics and other solutions. Updated: November 2024.
816,562 professionals have used our research since 2012.