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

Pentaho Business Analytics vs Tableau comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 1, 2025

Review summaries and opinions

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

Categories and Ranking

Pentaho Business Analytics
Ranking in BI (Business Intelligence) Tools
19th
Ranking in Reporting
16th
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
43
Ranking in other categories
Cloud Operations Analytics (4th)
Tableau
Ranking in BI (Business Intelligence) Tools
2nd
Ranking in Reporting
2nd
Average Rating
8.4
Reviews Sentiment
6.4
Number of Reviews
295
Ranking in other categories
Data Visualization (1st), Embedded BI (1st)
 

Mindshare comparison

As of February 2025, in the BI (Business Intelligence) Tools category, the mindshare of Pentaho Business Analytics is 0.5%, down from 0.6% compared to the previous year. The mindshare of Tableau is 18.2%, down from 18.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

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.
ROMIL SHAH - PeerSpot reviewer
Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time
When it comes to visualizations, Tableau has a limitation as compared to Power BI. It has a limited set of visualizations. Power BI has the entire marketplace, so you can connect and import many visualizations and use them, whereas Tableau has only 10 or 15 visualizations. There should be more visualizations, and there should also be data integration with more cloud providers. Tableau has recently launched a paid version for the documentation. So, documentation has become a little bit challenging when it comes to Tableau development because we do not have any tool to export the data out of it. It is a license-based feature that you need to purchase to prepare documentation. So, on the documentation front, for preparing clear documentation for any dashboard, it would help if we get an embedded option, rather than buying a license for each user for the documentation. To document anything, if I have to connect to each workbook and see what has been written as a formula and then document in the Word document, it is pretty time-consuming. We have the Microsoft stack, and we are currently evaluating Power BI because Tableau has a limitation of 50 columns for a drill-down report. If we want more than 50 columns, we have found a hack, but there is no ready-made option for doing it. So, we have to use another tool in case we need a drilled report with more than 50 columns. There are many instances where users need 80 or 90 columns for their analysis, and switching between two technologies becomes a challenge. It is not a cost-effective approach for us. Their support should be improved. We are not happy with their support. Whenever we raised queries, we were pointed to a few blogs, and we didn't get a proper solution from them. Their licensing should also be improved. They want us to purchase a Tableau Creator license for business users, whereas Power BI Desktop is free for business users. They should come up with a basic license with one or two connectors that our business users can use for preparing their visualizations. Tableau also charges us per user for users who want the data only through email.

Quotes from Members

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

Pros

"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."
"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."
"The initial setup is pretty straightforward."
"It is robust, offers market intelligence, and utilizes modules effectively."
"Easy to use components to create the job."
"We were able to install it without any assistance from tech support."
"It's the ease of use. It is also a self-service tool so it decreases the burden on having centralized IT-type teams or developers."
"The best part about Tableau is the visualization."
"Easy to create graphs and visualizations."
"This solution has transformed us from an Excel reporting environment to one of visual exploration."
"Tableau has greatly enhanced our organization's data-driven decision-making processes by enabling us to create visually compelling reports and dashboards."
"The data visualization piece is most valuable. We do ad-hoc analysis or one-time shot things, but there are things that we have to track every single day. When our management and our customers want to see how things are changing, the dashboarding provides that information. Tableau is key in providing that data on a refresh basis. We use a data blending tool that pumps the data into Tableau, and we just schedule it to run every single day. So, the automation of the data and being able to present it to people who are interested are the most valuable features."
"The feature that is currently most valuable is the import feature where I can link to an Excel data source. I'm not using it with any other data source, such as SQL Server. I directly link it to an Excel sheet, and if I change anything in that Excel sheet, the changed data immediately gets reflected in the virtualization. This is something that is very convenient for me as of now."
"Scheduled extract and the multiple connectors are fantastic!"
 

Cons

"Logging capability is needed."
"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."
"Pentaho Business Analytics' user interface is outdated."
"The tool is very good, and yet it has some problems as it relies heavily on Java."
"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."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"The repository should be improved."
"Other tools are more competitively priced."
"Creating empty extracts is not easy."
"To be the best in the market, Tableau has to improve its user interface and also look into developing implementing the best machine learning algorithms."
"I have noticed that Tableau is not very compatible with ClickHouse. There's no direct connection to ClickHouse; you have to set up an ODBC connection."
"Tableau is a company that does not respect partners."
"When you're working on a dashboard, you can't select multiple components at a time and align them, so you have to go one by one. This is very cumbersome."
"I think Tableau could be improved with cheaper or more flexible licensing, though this is a generic improvement and applies for any product. It would be better if they had more flexible payment and licensing plans so that they could suit small- and mid-sized organizations."
"Licensing and pricing options could be made better so that more users would be able to use it."
 

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."
"Tableau can be costly (but this can be indefinable, such as user experience vs. cheaper etc.)"
"The solution is very expensive. If you have many users then it is going to cost your company a lot of money."
"It is expensive when you compare it with Power BI. It should be cheaper."
"Tableau is an expensive solution."
"Its price is reasonable. Everything is included in the license."
"The pricing for Tableau is the same as the other products in the market."
"Tableau has core-based and user-based licensing, and it is tied to scalability. The core-based licensing is about you buying a certain number of cores, and there is no restriction on the number of users who can use Tableau. The restriction is only on the number of cores. In user-based subscription licensing, there is a restriction on the number of users. Big companies and government organizations with a lot of users typically go for core-based licensing. User-based subscription licensing is a more common model. It has user roles such as creator, explorer, and viewer. A creator is someone who does the groundwork or development work. An explorer is someone who is into middle management but is not technically savvy, such as a category head. A viewer is like a typical decision-maker in senior management. For each role, Tableau is priced differently. The viewer role has the minimum price, and the creator role has the highest price. This pricing is available on their website. Everybody can see it."
"It is a bit difficult for some people when they hear $70.00 per month, as some solutions are available for less than $10.00 or for free."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
837,501 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
Financial Services Firm
28%
Computer Software Company
12%
Government
8%
Educational Organization
6%
Educational Organization
44%
Financial Services Firm
10%
Computer Software Company
6%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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 would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
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 the pricing to be good.
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 it has brought some issues to the company.
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 Sense, Power BI, OBIEE, Tableau, etc. I have recently started using Cognos Enter...
Tableau vs. Business Objects - Which is a better solution for visualization and analysis?
Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have been working on and off Tableau for about a year, but getting to work on it consta...
Which would you choose - Tableau or SAP Analytics Cloud?
Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use. This relatively short amount of time can make all the difference for companies ...
 

Also Known As

Pentaho, Kettle, Hitachi Pentaho Business Analytics
Tableau Desktop, Tableau Server, Tableau Online
 

Overview

 

Sample Customers

Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
Accenture, Adobe, Amazon.com, Bank of America, Charles Schwab Corp, Citigroup, Coca-Cola Company, Cornell University, Dell, Deloitte, Duke University, eBay, Exxon Mobil, Fannie Mae, Ferrari, French Red Cross, Goldman Sachs, Google, Government of Canada, HP, Intel, Johns Hopkins Hospital, Macy's, Merck, The New York Times, PayPal, Pfizer, US Army, US Air Force, Skype, and Walmart.
Find out what your peers are saying about Pentaho Business Analytics vs. Tableau and other solutions. Updated: February 2025.
837,501 professionals have used our research since 2012.