What users are saying about
105 Ratings
136 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101
105 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.4 out of 101

Likelihood to Recommend

Alteryx Analytics

Alteryx is well suite for data integration /automation use cases as well as deeper predictive modeling. Alteryx is not a visualization tool. There are many connections and integrations to more robust visualization platforms.
No photo available

Pentaho

As far as generating and maintaining a data warehouse, Pentaho does an excellent job and I would highly recommend it. For analysis and gaining insight into your data, Pentaho is excellent. For visualization, dashboarding, or executive grade reporting it may not be as beautiful or flashy as your clients require
Jordan Squire profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.6
Pentaho
7.6
Pixel Perfect reports
Alteryx Analytics
8.0
Pentaho
7.6
Customizable dashboards
Alteryx Analytics
5.9
Pentaho
8.0
Report Formatting Templates
Alteryx Analytics
9.0
Pentaho
7.3

Ad-hoc Reporting

Alteryx Analytics
7.8
Pentaho
6.5
Drill-down analysis
Alteryx Analytics
7.2
Pentaho
7.2
Formatting capabilities
Alteryx Analytics
7.3
Pentaho
7.1
Integration with R or other statistical packages
Alteryx Analytics
9.1
Pentaho
6.3
Report sharing and collaboration
Alteryx Analytics
7.6
Pentaho
5.3

Report Output and Scheduling

Alteryx Analytics
8.1
Pentaho
6.8
Publish to Web
Alteryx Analytics
8.0
Pentaho
6.2
Publish to PDF
Alteryx Analytics
7.4
Pentaho
7.7
Report Versioning
Alteryx Analytics
9.0
Pentaho
6.8
Report Delivery Scheduling
Alteryx Analytics
8.2
Pentaho
7.1
Delivery to Remote Servers
Alteryx Analytics
Pentaho
6.2

Data Discovery and Visualization

Alteryx Analytics
7.8
Pentaho
6.3
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
Pentaho
6.3
Location Analytics / Geographic Visualization
Alteryx Analytics
7.5
Pentaho
6.7
Predictive Analytics
Alteryx Analytics
8.1
Pentaho
5.8

Access Control and Security

Alteryx Analytics
8.3
Pentaho
7.2
Multi-User Support (named login)
Alteryx Analytics
8.0
Pentaho
7.5
Role-Based Security Model
Alteryx Analytics
8.0
Pentaho
7.2
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Analytics
9.0
Pentaho
7.2
Single Sign-On (SSO)
Alteryx Analytics
Pentaho
6.9

Mobile Capabilities

Alteryx Analytics
4.0
Pentaho
6.4
Responsive Design for Web Access
Alteryx Analytics
4.0
Pentaho
6.2
Dedicated iOS Application
Alteryx Analytics
Pentaho
6.4
Dedicated Android Application
Alteryx Analytics
Pentaho
6.4
Dashboard / Report / Visualization Interactivity on Mobile
Alteryx Analytics
Pentaho
6.6

Application Program Interfaces (APIs) / Embedding

Alteryx Analytics
Pentaho
6.2
REST API
Alteryx Analytics
Pentaho
7.2
Javascript API
Alteryx Analytics
Pentaho
6.7
iFrames
Alteryx Analytics
Pentaho
5.6
Java API
Alteryx Analytics
Pentaho
6.2
Themeable User Interface (UI)
Alteryx Analytics
Pentaho
5.5
Customizable Platform (Open Source)
Alteryx Analytics
Pentaho
6.3

Pros

Alteryx Analytics

  • Excellent support for the tools through training/white papers and online support.
  • Ease of use - high common sense factor makes the program easy to learn and apply.
  • Compatibility with everything but specifically with commonly used key programs like Tableau.
Susan Knolla profile photo

Pentaho

  • Pentaho Data Integration (PDI), which is Pentaho's ETL tool, is a powerful visual scripting tool. It is a very mature ETL tool that can process large quantities of data quickly when provided with appropriate hardware.
  • Pentaho Analyzer which is Pentaho's Enterprise browser-based analysis and pivot table tool is powerful and intuitive. When provided with a well defined data warehouse schema it is easy for even non-technical users to quickly generate reports and graphs.
  • Pentaho allows you to connect to virtually any datasource provided there exists a JDBC connector, REST API, or some other API end point.
  • Pentaho has an open-source Community Edition which provides much of the functionality of the Enterprise Edition without any licensing fees.
Jordan Squire profile photo

Cons

Alteryx Analytics

  • Cost is a factor - while support and training are "free" the software price is high.
  • It helps to have some good Excel experience to make instant adoption even easier.
  • The trainers tend to go a bit fast so slow learners may need multiple sessions.
Susan Knolla profile photo

Pentaho

  • A major problem we have had with Pentaho is their enterprise licensing. As a client who understands very well what is offered within the free Community Edition we felt their mark up on their enterprise features was much too high. They wanted to charge us for migrating from MySQL to Amazon RedShift since RedShift is an "analytical database" while nearly every other database could be connected to for free. Due to licensing concerns we terminated our enterprise license.
  • Pentaho's visualization tools are very capable, but have a very steep learning curve and engineering cost. Due to this we ended switching from Pentaho for the majority of our internal dashboarding and reporting to purchasing Tableau licenses. If Pentaho could improve their visualization and dashboarding capabilities, they could truly be an end-to-end BI solution.
Jordan Squire profile photo

Likelihood to Renew

Alteryx Analytics

Alteryx Analytics 6.5
Based on 14 answers
I personally have moved to a different position that does not require data analysis tools. I really enjoyed working with Alteryx and think it is a great tool, but have moved to a different organization and role.
Mika Silverman profile photo

Pentaho

Pentaho 8.8
Based on 11 answers
Basically, the cost is very affordable, if you have already done everything and the project is working then you don't want to replace it because that means making a whole new project. Also I think its very good and the competitor will not overcome the functionality. So you will find your self spending a lot of time and money to get to the same place.
Itamar Steinberg profile photo

Usability

Alteryx Analytics

Alteryx Analytics 10.0
Based on 2 answers
Through a graphical UI one can perform engineering and development, other vendors do not have such a code-less interface.
Nick Lensing profile photo

Pentaho

Pentaho 5.0
Based on 1 answer
I would have liked some hands on help in trying to match what Customers were already used to. Plus having a team of Java/BI folks was difficult to assemble since what required to be done in an object oriented fashion could have easily been done via a SQL construct. This hash of technologies was difficult to manage.
Deepak Paramanand profile photo

Reliability and Availability

Alteryx Analytics

Alteryx Analytics 10.0
Based on 1 answer
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Dan Chapman profile photo

Pentaho

No score
No answers yet
No answers on this topic

Support

Alteryx Analytics

Alteryx Analytics 9.9
Based on 2 answers
Overall pretty good. Depending on the quality of the question posed the CS team will get back as they are available
Nick Lensing profile photo

Pentaho

Pentaho 9.9
Based on 2 answers
They were responsive to our questions when we raised issues.They gave us workarounds when required.They were quite knowledgeable when it came to issue analysis and providing fixes.They were forthright in informing us if a bug was not due for release soon.
Deepak Paramanand profile photo

Online Training

Alteryx Analytics

No score
No answers yet
No answers on this topic

Pentaho

Pentaho 9.5
Based on 2 answers
Course Taken: DI1000 Pentaho Data Integration FundamentalsSetup A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great! The CourseThe 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE. Course Description: https://training.pentaho.com/instructor-led-training/pentaho-data-integration-fundamentals-di1000
Stephanie Dozier profile photo

Implementation

Alteryx Analytics

Alteryx Analytics 10.0
Based on 1 answer
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Dan Chapman profile photo

Pentaho

Pentaho 5.0
Based on 1 answer
Get the right people in before starting implementation. Start small and build as you go approach is time consuming and involves lot of rework.Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set.Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.
Deepak Paramanand profile photo

Alternatives Considered

Alteryx Analytics

I haven't used any other programs nor have I seen any that do this. I think it stands alone as a tool which allows such ease of use in data organizing and cleansing. While formulas or pivot tables in excel can help they are not easily repeatable across a variety of (dirty) data sources whereas Alteryx is.
Susan Knolla profile photo

Pentaho

In comparison with Excel, that can also work with queries pivots and dashboards, Pentaho offers much more stability from a database point of view, more security options and provides a more stable table, pivots and dashboard designs. We are also completing the business intelligence experience for our users with Kyubit.
Mihaela Olariu profile photo

Return on Investment

Alteryx Analytics

  • Definitely, an increase in employee efficiency. With the right tools and hardware, Alteryx can reduce the processing time significantly.
  • Automation and/or automatic report scheduling frees up a lot of time that can be used elsewhere.
  • Licensing updates are somewhat not handled easily and quite often create issues with modules to run slowly and/or not being active.
No photo available

Pentaho

  • Because of the security issue we have had to spin up an additional reporting portal using another vendor. This means we have two reporting tools that we must maintain and support.
  • Since Pentaho is used by a limited audience it gets sidelined as a solution that requires our customers and partners to access their reporting via the web.
Stephanie Dozier profile photo

Pricing Details

Alteryx Analytics

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Alteryx Analytics Editions & Modules

Alteryx Analytics
On-premise Edition
Alteryx Designer
$3,9951
Alteryx Designer with Spatial
$12,9951
Alteryx Designer with Data
$29,9951
Alteryx Server
$45,0002
1. per user, per year
2. per server, per year
SaaS Edition
Alteryx Analytics Gallery
$1,5001
1. per user, per year
Additional Pricing Details
The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.

Pentaho

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Pentaho Editions & Modules

Pentaho
Additional Pricing Details

Add comparison