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

Alteryx vs Pentaho Business Analytics comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Alteryx
Average Rating
8.4
Number of Reviews
77
Ranking in other categories
Predictive Analytics (1st), Data Science Platforms (4th), Data Preparation Tools (1st)
Pentaho Business Analytics
Average Rating
8.0
Number of Reviews
42
Ranking in other categories
BI (Business Intelligence) Tools (21st), Cloud Operations Analytics (4th), Reporting (15th)
 

Mindshare comparison

While both are Business Intelligence solutions, they serve different purposes. Alteryx is designed for Predictive Analytics and holds a mindshare of 24.4%, down 25.7% compared to last year.
Pentaho Business Analytics, on the other hand, focuses on BI (Business Intelligence) Tools, holds 0.6% mindshare, down 0.6% since last year.
Predictive Analytics
BI (Business Intelligence) Tools
 

Featured Reviews

Vivek Vaibhav - PeerSpot reviewer
Mar 11, 2024
Has a good UI and drag-and-drop features which makes it easy to understand
There have been some issues with licensing, particularly with the increased prices. This has led some companies, including ours, to consider reducing the number of licenses or potentially discontinuing their use of Alteryx. Since most of our team members work with Alteryx, deploying workflows to clients who may not have licenses became a hurdle. Every user needed a license to run the workflows, which could pose difficulties, especially for clients who only needed occasional access for small data analyses. Unlike other software like Microsoft Power BI, which offers free trials or user licenses for basic functionality, Alteryx doesn't provide such options, potentially limiting its accessibility for occasional users. It should improve scalability.
Sayan König - PeerSpot reviewer
Feb 16, 2022
Flexible, easy to understand, and simple to set up
It's a data warehouse for finance and central bank reporting purposes, and an ETL tool in this environment It's easily understandable. The product is quick and flexible, with very good steps to make data transformation possible.  The initial setup is pretty straightforward. The repository should…

Quotes from Members

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

Pros

"Its initial setup is easy."
"Alteryx helps me do a lot of automation. The best thing about Alteryx is that you don't have to repeat the workflow over and over again. Unlike Excel, where you need to write formulas for each new file, Alteryx follows a consistent process. You can schedule and automate the workflow, even if the files change."
"The scheduling feature for the automation is excellent."
"Data processing is most valuable. It is one of the fastest data blockers out there in the market, which is a fascinating thing about Alteryx."
"The ease-of-use allows non-technical business users to directly create their own solutions without the use of additional development resources."
"The design portion of this tool is easy to use without code, which his something that something we can appreciate."
"The cloud deployment ensures it scales easily."
"Alteryx has helped us spend more time identifying results instead of performing analysis manually. It has helped us in our loading process, including scrubbing data and identifying data elements that need to be corrected. It enables us to understand our data sets a lot better."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"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."
"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."
"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

"The product's pricing needs improvement."
"Lacks an open source edition which would be helpful."
"Alteryx's predictive data models are pretty average and can be improved."
"A colleague of mind mentioned that the solution should have more options for the visualization of data."
"It seems to me that it is not always user friendly."
"They should work on its pricing."
"We are hoping that the NLP features will also support Chinese characters."
"There is currently no cloud solution and this would be valuable for many clients."
"Another concern is that Pentaho is not customizable or interactive."
"Logging capability is needed."
"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."
"The repository should be improved."
"Pentaho Business Analytics' user interface is outdated."
"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."
 

Pricing and Cost Advice

"If one is a high price, and ten is a low price, I rate the tool's price as a one. The tool is expensive."
"It can be a bit pricey, especially after the first year."
"Alteryx is generally more suited for medium—to large companies due to its potentially high licensing costs."
"The cost of the solution could be reduced."
"There are some implementation services and internal effort costs at the beginning but there is nothing else."
"Its price should be lower. The key thing that we see is that talking about ROI is an important element at the time of purchase. Cost becomes a factor in every discussion. Justifying the ROI for these kinds of workflows is always a challenge, and the only way to counter the challenge is by addressing the pricing."
"We have a yearly cost that we pay for the licensing. We do not pay any costs in addition to the licensing fees."
"My organization pays for it, and I do not look into the financial aspect of the licensing, but I know it is pretty 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."
"Free and commercial versions are available."
"Pentaho is expensive ."
report
Use our free recommendation engine to learn which Predictive Analytics solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Comparison Review

it_user6978 - PeerSpot reviewer
Jun 10, 2013
Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition
Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Manufacturing Company
10%
Computer Software Company
8%
Healthcare Company
6%
Financial Services Firm
25%
Computer Software Company
14%
Educational Organization
8%
Government
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
One of the differences is that with Alteryx you can use it as an ETL and analytics tool. Please connect with me directly if you want to know more.
What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
Alteryx is an extremely easy and flexible data tool, flexible in terms of drag and drop toolset and also has python, R integrations if your team requires this. It can handle over 2 billion rows of...
What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
I am not familiar with IBM SPSS Modeler, therefore, I cannot compare these two products. Regarding Alteryx I can say the following: - An excellent desktop tool for Data Prep and analytics. - Featu...
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?
The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive with references to an added number of features.
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 reporting module. You will need to search for deployment examples or need to have a ...
 

Also Known As

No data available
Pentaho, Kettle, Hitachi Pentaho Business Analytics
 

Overview

 

Sample Customers

AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy Queen
Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
Find out what your peers are saying about Alteryx, SAP, RapidMiner and others in Predictive Analytics. Updated: November 2024.
814,649 professionals have used our research since 2012.