What users are saying about

Alteryx Analytics

Top Rated
111 Ratings

Pentaho

100 Ratings

Alteryx Analytics

Top Rated
111 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

Pentaho

100 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 am admittedly a Customer Evangalist for Alteryx and believe that Alteryx should be considered as a solution enabler in most cases. Alteryx allows for connection to data of many types and sources. If Alteryx complicates or lengthens the execution time of a process because of the need to move data from one point to another, I'd likely rearchitect the solution.Call Alteryx and see how quickly they respond to your needs. Client Services is available most hours either by phone, email or chat. You can post to their community boards. They are very responsive and seek high customer satisfaction. They are very accessible and if you want to talk to their Chief Customer Officer, she'll get on the phone with you.
Mark Frisch profile photo

Pentaho

Overall as an OEM vendor of analytics, I would say it was about average. They did help us get to market sooner than if we developed everything in-house, but I felt the dashboards were pretty ugly and I wouldn't say I was super impressed. I found the Analyzer OLAP tool to be very useful and that part would have been harder to develop in-house, but I would skip the dashboards next time and go straight to developing those in-house, which is what we ended up with in the end
No photo available

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.6
Pentaho
6.8
Pixel Perfect reports
Alteryx Analytics
8.0
Pentaho
6.6
Customizable dashboards
Alteryx Analytics
5.8
Pentaho
7.0
Report Formatting Templates
Alteryx Analytics
9.0
Pentaho
6.9

Ad-hoc Reporting

Alteryx Analytics
8.5
Pentaho
6.2
Drill-down analysis
Alteryx Analytics
8.1
Pentaho
7.1
Formatting capabilities
Alteryx Analytics
8.2
Pentaho
6.6
Integration with R or other statistical packages
Alteryx Analytics
9.6
Pentaho
6.3
Report sharing and collaboration
Alteryx Analytics
7.9
Pentaho
5.0

Report Output and Scheduling

Alteryx Analytics
8.6
Pentaho
6.7
Publish to Web
Alteryx Analytics
8.0
Pentaho
6.2
Publish to PDF
Alteryx Analytics
8.6
Pentaho
7.5
Report Versioning
Alteryx Analytics
9.0
Pentaho
6.6
Report Delivery Scheduling
Alteryx Analytics
8.9
Pentaho
6.9
Delivery to Remote Servers
Alteryx Analytics
Pentaho
6.2

Data Discovery and Visualization

Alteryx Analytics
8.1
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.7
Pentaho
6.5
Predictive Analytics
Alteryx Analytics
8.7
Pentaho
5.9

Access Control and Security

Alteryx Analytics
8.3
Pentaho
7.4
Multi-User Support (named login)
Alteryx Analytics
8.0
Pentaho
7.5
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.1
Responsive Design for Web Access
Alteryx Analytics
4.0
Pentaho
5.5
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.0

Application Program Interfaces (APIs) / Embedding

Alteryx Analytics
Pentaho
6.0
REST API
Alteryx Analytics
Pentaho
6.7
Javascript API
Alteryx Analytics
Pentaho
6.3
iFrames
Alteryx Analytics
Pentaho
5.1
Java API
Alteryx Analytics
Pentaho
5.9
Themeable User Interface (UI)
Alteryx Analytics
Pentaho
5.6
Customizable Platform (Open Source)
Alteryx Analytics
Pentaho
6.4

Pros

  • It's great at blending data from different sources. I loved how easy it was.
  • There is a huge variety of visualizations that are available as well.
  • A lot of drag and drop options available for different workflows.
  • Open APIs available are a great help.
No photo available
  • Connect via JDBC
  • Integrates with Odoo (formerly OpenERP)
  • Grouping, summing seem to work well even though they are not intuitive as far as set up goes.
  • The multiple report output types are great (PDF, CSV, Excel, Word, Text, etc)
  • Connect via the web client of Odoo
  • Easy to build in parameters for filtering in the report
Adam O'Connor profile photo

Cons

  • The map visualization is terrible. If you're planning on outputting presentation worthy maps, Alteryx is not the software for it!
  • The program has glitches - sometimes everything will be created perfectly (data joining as it should, appropriate fields selected, etc), but the program will fail to read in or "update" the workstream and cause errors
  • Though Alteryx is touted as "Big Data" friendly, we have seen those limits reached (billions of records) and been disappointed with run times.
No photo available
  • Heavy software to install
  • Requires licensing to enable all features
  • Difficult to integrate with other servers
No photo available

Likelihood to Renew

Alteryx Analytics6.5
Based on 14 answers
I am not the decision maker, but I would renew this product.
No photo available
Pentaho8.8
Based on 11 answers
Pentaho Data Integration is making my day-to-day work with data more effective. I have found that Pentaho Data Integration can connect to more data sources more easily than SSIS. Being open standards Pentaho can run in almost any environment - meaning it can run in the cloud as well as in client's environment and supports different operating systems.
Julia Gusman 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

Breadth of Deployment

Our company kept it contained in the marketing department. Other departments may not understand it.
No photo available
Typically system analysts, business analysts and departmental managers were our target audience. 10-15 users was the most we could reach before we decided to go with another suite of Products. But who ever used it did appreciate the end to end flow of data that they could see as opposed to the data obfuscation they noticed before.
Deepak Paramanand profile photo

Alternatives Considered

SAS is great and without it a lot of businesses would be out of business but Alteryx allows a much more user friendly interface and minimal code is needed. I think SQL was the only code I really needed when using Alteryx. R has been introduced within Alteryx and now it can be used for regressions and statistical analyses. (Great idea by the way Alteryx) Tableau as well has been introduced within Alteryx if I'm not mistaken so now within one program, you can manipulate your data, run a regression and build a model, and then present your findings in a very professional, interactive manner.
No photo available
In terms of price, pentaho seems to be the clear winner for functionality that you get--especially with the community edition. If you don't need to license anything out, even the enterprise edition is fairly reasonably priced. With this in mind, it's a winner in the sense that it provides 95% of the data integration functionality that these other tools do without having to spend a fortune to do so.
Ivan Miller profile photo

Collaboration and Sharing

Alteryx Analytics7.2
Based on 16 answers
Very easy to share across users and teams.
Shaun Beckett profile photo
Pentaho7.3
Based on 14 answers
Pentaho offers the possibility of sending to XLS, PDF or CSV, once saved on your local computer you can share with anyone. Reports used for PDF must have a special design from the start. Also, a special schedule to send report can be created in the .xaction and is working fine.
Mihaela Olariu profile photo

Data Integration

Alteryx Analytics8.9
Based on 16 answers
Seamless integration with Salesforce, Marketo, Tableau,Qlik. Alteryx makes it very easy for users to connect to other sources.
Shaun Beckett profile photo
Pentaho7.4
Based on 14 answers
Usability for previous day data.
Mihaela Olariu profile photo

Return on Investment

  • Alteryx has significantly improved employee efficiency. It's helped reduce turnaround time by ~30% already and we expect this to to do more as we leverage more of the tools.
  • Alteryx has also been used to automate repetitive processes to free up employees to focus on more of the analytical tasks.
  • The only negative to the business impact is how licenses are handed. They often expire without notice and can negatively affect clients.
Adrian Harvey, MBA profile photo
  • Good client feedback - caters to specific requirements
  • Low learning curve for new staff
  • Good community backup
No photo available

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