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
20th
Ranking in Reporting
16th
Average Rating
8.0
Reviews Sentiment
5.8
Number of Reviews
43
Ranking in other categories
Cloud Operations Analytics (4th)
 

Mindshare comparison

As of December 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.3% compared to the previous year. The mindshare of Microsoft Power BI is 22.4%, up from 22.4% 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

"We are able to generate quality reports easily which allows us to decrease response time."
"It has a very powerful edit feature which allows users to back out of changes (undo) without forcing them to recreate entire reports."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"Cognos' most valuable features are the bundled studios, simple UI, and advanced features like the ability to create data modules."
"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."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"The most valuable feature is developing reports from different data sources, making it a reliable data source."
"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."
"It's a great tool for visualization data, and it's free for engineers."
"The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
"With Power BI, you're able to store your data within spreadsheets and SharePoints, and then have Power BI pull the data out and report on it. So we actually saved a ton of money not needing to load the data into databases, which is a big prerequisite for many other reporting tools."
"I think the visualization part is valuable."
"We like the drag and drop interactability visualization. We really like that. It's user-friendly."
"It seems stable. I haven't heard of any difficulties from my clients that utilize Power BI."
"It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis."
"The initial setup is pretty straightforward."
"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."
"The most valuable feature of Pentaho is the Tableau report."
"Easy to use components to create the job."
"We were able to install it without any assistance from tech support."
"It is robust, offers market intelligence, and utilizes modules effectively."
"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."
 

Cons

"The technical support team’s response time is slow and needs to be improved."
"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"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."
"There are many problems with the product's stability part, making it an area where improvements are required."
"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."
"IBM Support can be slow at times, but they can usually deliver in a timely manner."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"IBM Cognos's error messages seem to be a bit ambiguous. An error will be encountered and a message will be sent out very ambiguous and after investigating the error message it could be any number of issues. There was never a direct answer to the question or a direct answer to the error messages. Sometimes it would be a generic error message for 21 different solutions. It wasn't very specific, which required a lot of digging around and trial and error trying to fix the problem. The messaging in their error messaging is something needing improvement."
"The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version."
"The integration with third-party products could be more stable."
"The admin view could be improved by making it more simplified to manage a users' activity and other things."
"It should be more user-friendly and simple."
"Most of the dashboarding tools have prebuilt graphs. So, you have to stick with them, unless you are going to use a third-party tool to create them, and then you are going to upload them to the BI tool. In Power BI, they started supporting this functionality and created a tool for that, but it isn't yet complete and mature. It is still exceeding the expectations and is better than most of the BI tools when it comes to creating custom graphs, but it needs more enhancement and simplification. It would be good to have a design tool provided by Power BI to design the graphs that we want and set the figures that we want on them."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"Compared to other applications, like Tableau, Microsoft BI doesn't have as many functions that allow you to do more in-depth analysis and represent the findings."
"Real-time updating needs improvement."
"Logging capability is needed."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"The tool is very good, and yet it has some problems as it relies heavily on Java."
"Pentaho Business Analytics' user interface is outdated."
"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."
"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."
 

Pricing and Cost Advice

"Pricing should be improved."
"It is pretty expensive."
"IBM Cognos offers competitive pricing similar to other BI vendors in the market."
"On a scale from one to ten where one is low pricing and ten is high pricing, I would rate this solution at eight."
"My company uses IBM Cognos with another IBM product, so I think only one license is used."
"The pricing of this product is meant for medium to large-scale enterprises."
"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."
"IBM Cognos is priced reasonable. However, it is more expensive than Power BI and Tableau."
"Licensing fees are paid on a yearly basis."
"I think it's a good price, from what I've heard. I know it's competitive with other Power BI tools."
"The pricing is very reasonable compared to any other tool."
"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."
"You don't need a license for development, but if you want to publish to external users, you need a license. The licensing is very costly, but I think that since the advantages and benefits of Power BI are so high, people are willing to pay. I can't blame them."
"I used the tool's free version."
"I used a two months free trial to see if it had what I needed."
"They are charging us by users in storage, and there is a license fee. My financial people handle all that. The client has already worked out a contract with Microsoft, and basically, we're getting government prices."
"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."
"Pentaho is expensive ."
"Free and commercial versions are available."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
824,106 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
55%
Financial Services Firm
7%
Computer Software Company
4%
Manufacturing Company
4%
Educational Organization
42%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
Financial Services Firm
25%
Computer Software Company
13%
Government
8%
Educational Organization
6%
 

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?
For those starting to use this tool, there is a free version available which is beneficial. The company also finds th...
What needs improvement with Pentaho Business Analytics?
The tool is very good, and yet it has some problems as it relies heavily on Java. The platform works with Java, and i...
What is your primary use case for Pentaho Business Analytics?
I work in business intelligence with Pentaho. I am associated with the marketing industry as well as the automotive i...
 

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.
824,106 professionals have used our research since 2012.