What users are saying about
Top Rated
119 Ratings
5 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
5 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 9.4 out of 101

Add comparison

Likelihood to Recommend

Alteryx Analytics

Alteryx can do so much more than I use it for, so I believe the only case where Alteryx wouldn't be needed is when a department/team had a full development team to prep data pre-analysis or already has a central data store fully stood up and standardized. Alteryx works extremely well with a multitude of BI and database solutions and would be a great fit for any team trying to speed up the typical daily grind of data prep and ETL so their analytics and data team can be more agile, accurate, and automated.
Joe Root profile photo

H2O

Use H2O.ai whenever you need easy to use tool, when you must be cost efficient (you can not charge the client extra money for software licenses used), need a tool with lots of algorithms that are normally used in data analytics, or need to work on one machine (it is either not allowed to move data to cloud storage or simply not necessary to connect to Hadoop, etc.). Also, you can call H2O directly from Python which makes analysis more efficient.
Viktor Mulac profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.9
H2O
Pixel Perfect reports
Alteryx Analytics
8.0
H2O
Customizable dashboards
Alteryx Analytics
6.7
H2O
Report Formatting Templates
Alteryx Analytics
9.0
H2O

Ad-hoc Reporting

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

Report Output and Scheduling

Alteryx Analytics
8.7
H2O
Publish to Web
Alteryx Analytics
8.2
H2O
Publish to PDF
Alteryx Analytics
8.5
H2O
Report Versioning
Alteryx Analytics
9.0
H2O
Report Delivery Scheduling
Alteryx Analytics
8.9
H2O

Data Discovery and Visualization

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

Access Control and Security

Alteryx Analytics
8.3
H2O
Multi-User Support (named login)
Alteryx Analytics
8.0
H2O
Role-Based Security Model
Alteryx Analytics
8.0
H2O
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Analytics
9.0
H2O

Mobile Capabilities

Alteryx Analytics
4.0
H2O
Responsive Design for Web Access
Alteryx Analytics
4.0
H2O

Pros

  • Data ingestion: Alteryx is capable of connecting with a multitude of data sources from SQL databases to cloud-hosted solutions like Salesforce, Tableau, or Google Analytics. Also supports OleDB & ODBC connections.
  • Dynamic data munging: Alteryx has a great variety of processing tools to clean and prep data including: dedupe, formulas, joins, union, sort... Performing these functions really quickly on even moderately equipped laptops or desktops. It's dynamic in that it can easily handle changes in data by allowing extra columns to flow through.
  • Macros: have a process that you are consistently running in separate workflows? Build a macro, be it a batch or iterative, Alteryx can do it. I've built 40-50 macros and use at least 4+ in every workflow I design so data is handled the same way in every workflow for consistency and cutting down on copy/pastes.
Joe Root profile photo
  • Excellent analytical and prediction tool
  • In the beginning, usage of H20 Flow in Web UI enables quick development and sharing of the analytical model
  • Readily available algorithms, easy to use in your analytical projects
  • Faster than Python scikit learn (in machine learning supervised learning area)
  • It can be accessed (run) from Python, not only JAVA etc.
  • Well documented and suitable for fast training or self studying
  • In the beginning, one can use the clickable Flow interface (WEB UI) and later move to a Python console. There is then no need to click in H20 Flow
  • It can be used as open source
Viktor Mulac profile photo

Cons

  • I've had issues with the scheduler tool getting frozen or stuck in previous versions. For about the last 2-3 months the latest software version has been much more reliable. Previously I had to restart the Alteryx service on my machine at least once a week, which meant my workflows weren't running while the service had been stuck and data wasn't moving.
  • Some of the connectors, like the Tableau Online connector, should become supported by Alteryx. The online community is fantastic and has created a ton of useful macros and it would be great if Alteryx would adopt, support, and enhance some of the most widely used and useful.
Joe Root profile photo
  • No weaknesses found yet
  • This is not really a drawback, but rather a warning - the Drivereless AI is not a replacement for a data scientist yet, and will not replace data scientists in the next decade neither. The Driverless AI feature delivers reliable results only if the analyst is sure about the meaning of input data. The data quality is usually a major issue and no tool can detect the meaning of data in the input. Data scientists are also required for business interpretation of the findings. So be careful, and do not rely on this feature without a good understanding of what it really does in each step.
Viktor Mulac profile photo

Likelihood to Renew

Alteryx Analytics6.5
Based on 14 answers
I will likely continue to use Alteryx because it allows quick, customizable data analysis. Often, I will be given a business question, which I might not know how to answer, but after getting into Alteryx, dragging and dropping some tools, I can formulate the answer. At the same time, this is definitely a niche software (not something that would ever be adopted by my entire company), which makes it a bit less appealing to some.
No photo available
No score
No answers yet
No answers on this topic

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
No score
No answers yet
No answers on this topic

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
No score
No answers yet
No answers on this topic

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
No score
No answers yet
No answers on this topic

Alternatives Considered

Alteryx's UI is fantastic insomuch that training can really be self-driven, albeit with several Google searches a day and visits to the Alteryx community. The other solutions we looked at were much less intuitive and not nearly as flexible, automated, and didn't give you the capability to watch the data be changed through every step of the process like Alteryx can do through browses and data samples.
Joe Root profile photo
Both are open source (though H2O only up to some level). Both comprise of deep learning, but H2O is not focused directly on deep learning, while Tensor Flow has a "laser" focus on deep learning. H2O is also more focused on scalability. H2O should be looked at not as a competitor but rather a complementary tool. The use case is usually not only about the algorithms, but also about the data model and data logistics and accessibility. H2O is more accessible due to its UI. Also, both can be accessed from Python. The community around TensorFlow seems larger than that of H2O.
Viktor Mulac profile photo

Return on Investment

  • 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
  • By using H2O the analyst can focus on analysis itself, not spend too much time with coding etc.
  • Reuse of algorithms and easy model sharing saves time and money
  • An easy learning curve assures low training costs
  • By moving to a paid version, even the Driverless AI, you will still need data scientists and analysts, but maybe not so many!
Viktor Mulac 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.

H2O

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
H2O Editions & Modules
H2O
Additional Pricing Details