What users are saying about
Top Rated
119 Ratings
102 Ratings
Top Rated
119 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101
102 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.5 out of 101

Add comparison

Likelihood to Recommend

Alteryx Analytics

I wish I had found and used Alteryx Analytics years ago. Having multiple data sources with a variety of naming conventions for our businesses we spent WEEKS cleaning/reorganizing/renaming fields in our data to be able to consolidate. We did this on one set of reports for one use. Each time we wanted an update this process would need to be repeated. This took tons of useless admin time. Had we had Alteryx we could have created 1 identifier, noted all the different naming conventions or issues, selected the ones we wanted and created the workflow to use it over and over and over again on any data we wanted. Build once - use multiple times. It would have been (and now is) a HUGE time saver. Plus any new anomalies are identified by the program as errors so you can "autocorrect" them in the same workflow. Alteryx is a miracle in my opinion.
Susan Knolla profile photo

Pentaho

The tool is fast, visually attractive and intuitive to use, but we also have an implementation of Qlik Sense and Pentaho pales in comparison to the overall capabilities. I recommend the tool, but everyone’s solution need is unique, so it may not be the right fit. Larger tools like Qlik are more versatile and easier to recommend. More expensive, yes, but you usually get what you pay for.
No photo available

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.9
Pentaho
7.1
Pixel Perfect reports
Alteryx Analytics
8.0
Pentaho
6.9
Customizable dashboards
Alteryx Analytics
6.7
Pentaho
7.4
Report Formatting Templates
Alteryx Analytics
9.0
Pentaho
7.0

Ad-hoc Reporting

Alteryx Analytics
8.5
Pentaho
6.3
Drill-down analysis
Alteryx Analytics
8.3
Pentaho
7.2
Formatting capabilities
Alteryx Analytics
8.2
Pentaho
6.8
Integration with R or other statistical packages
Alteryx Analytics
9.5
Pentaho
6.3
Report sharing and collaboration
Alteryx Analytics
8.0
Pentaho
5.1

Report Output and Scheduling

Alteryx Analytics
8.7
Pentaho
6.7
Publish to Web
Alteryx Analytics
8.2
Pentaho
6.2
Publish to PDF
Alteryx Analytics
8.5
Pentaho
7.6
Report Versioning
Alteryx Analytics
9.0
Pentaho
6.6
Report Delivery Scheduling
Alteryx Analytics
8.9
Pentaho
7.0
Delivery to Remote Servers
Alteryx Analytics
Pentaho
6.2

Data Discovery and Visualization

Alteryx Analytics
7.9
Pentaho
6.2
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
Pentaho
6.2
Location Analytics / Geographic Visualization
Alteryx Analytics
7.5
Pentaho
6.6
Predictive Analytics
Alteryx Analytics
8.3
Pentaho
5.9

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

Alteryx Analytics
Pentaho
6.1
REST API
Alteryx Analytics
Pentaho
6.9
Javascript API
Alteryx Analytics
Pentaho
6.5
iFrames
Alteryx Analytics
Pentaho
5.3
Java API
Alteryx Analytics
Pentaho
6.1
Themeable User Interface (UI)
Alteryx Analytics
Pentaho
5.6
Customizable Platform (Open Source)
Alteryx Analytics
Pentaho
6.4

Pros

  • 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
  • First thing what I have experienced about Pentaho is that it is user friendly. The best thing about Pentaho is Pentaho Data Integration. I have never used more user friendlier ETL tool like PDI. All the jobs and transformation steps are easy to understand. And I like the sample transformations and jobs that are provided with the package. It is so user friendly that, even if you don't know SQL, it will generate it for you. If you don't want to write scripts, that's fine, you can do it in PDI.
  • I have found that Pentaho can be integrated with any technology or framework. I have easily and successfully integrated it with HDFS, EMR, S3, CouchDB, many different RDBMSs. I would consider it as a strength of Pentaho. Also if you are stuck or you find any error, the type of logging will have an answer for you. I found the logging mechanism very effective.
  • I have mostly used Pentaho Analyzer and Schema Workbench at the BI side. It is user friendly too and we have a very few users who come to the developers to help them understanding the UI of PUC.
Nikhil Karkare profile photo

Cons

  • 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
  • Most of the companies use star schema in their Data Warehouses but they are not the pure star schemas. There are the bridge tables, group tables but when using Schema Workbench to design a cube, it gets very painful for the developers to accommodate such schema in it. To do this, I have to go to the XML file and add the new elements. I would love to see the feature where Schema Workbench can accommodate the bridge tables as they are the part of star schema too.
  • When it comes to ETL, I have found PDI to be the best tool, but at the report side, it is not as good as the other tools available in the market. Especially the users always complain about the graphs in the Pentaho Analyzer. I think. the UI needs a lot of improvement.
  • PDI is slow reading the JSON files. There is a fast JSON input step available in the marketplace but I think I would be great if Pentaho can make the JSON reading even faster.
  • When I export the repository, I see the files names are encoded with UTF-8 encoding. It would be great, if the spaces and the special characters can be preserved while exporting a BA repository.
Nikhil Karkare profile photo

Likelihood to Renew

Alteryx Analytics6.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
Pentaho8.8
Based on 11 answers
I will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration
Adam O'Connor profile photo

Usability

Alteryx Analytics10.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
Pentaho5.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 Analytics10.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
No score
No answers yet
No answers on this topic

Support

Alteryx Analytics9.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
Pentaho9.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

No score
No answers yet
No answers on this topic
Pentaho9.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 Analytics10.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
Pentaho5.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

Talend is primarily for data integration and has quite advanced capabilities. But the user has to be more technical. Alteryx makes the process simple and any user can make use of its features.Tableau was a good choice for data visualization. We needed beautiful charts and ways to represent data. Alteryx falls short in this aspect.
Sanket Bharaswadkar profile photo
I was not with the company when they selected Pentaho over any other tool. As per my experience, I would recommend Pentaho. One of the reasons are that it is open source. If you know JAVA, you can create your own plugins. I have found its customer support pretty good and quick. And the most important thing is the cost. If you are not using the DI server, you can just use the community edition and it should fulfil your purpose too.
Nikhil Karkare profile photo

Return on Investment

  • Alteryx does an excellent job of integrating consumer and spatial data to calculate and visualize things like locations within a certain drive-time radius.
  • For visualization purposes I had to move the data to excel for some decent graphs.
  • It can become very expensive.
No photo available
  • Pentaho has improved our overall business process.
  • Pentaho has helped the Managers and Directors to analyze the numbers going up and down from time to time.
  • We have a started a big project using Pentaho that is going to include all the business processes in the organization.
Nikhil Karkare 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