Compare Alteryx vs. KNIME

Alteryx is ranked 1st in Data Science Platforms with 13 reviews while KNIME is ranked 2nd in Data Science Platforms with 10 reviews. Alteryx is rated 9.0, while KNIME is rated 8.2. The top reviewer of Alteryx writes "Does a good job of end-to-end integration as well as accessing data from multiple sources or email modes". On the other hand, the top reviewer of KNIME writes "Has good machine learning and big data connectivity but the scheduler needs improvement ". Alteryx is most compared with KNIME, Dataiku Data Science Studio and Microsoft BI, whereas KNIME is most compared with Alteryx, RapidMiner and Weka. See our Alteryx vs. KNIME report.
Cancel
You must select at least 2 products to compare!
Alteryx Logo
30,132 views|23,861 comparisons
KNIME Logo
Read 10 KNIME reviews.
22,954 views|17,868 comparisons
Most Helpful Review
ArqumKhalid
Find out what your peers are saying about Alteryx vs. KNIME and other solutions. Updated: January 2020.
399,540 professionals have used our research since 2012.
Quotes From Members

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

Pros
The ease-of-use allows non-technical business users to directly create their own solutions without the use of additional development resources.This is a drag-and-drop tool which is easy-to-use and yet can be customized by creating your own components.The solution offers excellent predicting power. The accuracy and confidence have been great.The product is very stable and super fast, five-star. It's significantly more stable than it's nearest competitor.Alteryx is so advanced. It's just drag and drop.Shortens the time required to start analyzing data and looking for insights, minimizing the tasks that do not add value to the business and maximizing the analysis phase.Alteryx speeds up the time to obtain business answers/insights on data.It is one of the most complete and great customer service that I experienced with a software company/ecosystem.

Read more »

This open-source product can compete with category leaders in ELT software.This solution is easy to use and especially good at data preparation and wrapping.It provides very fast problem solving and I don't need to do much coding in it. I just drag and drop.Key features include: very easy-to-use visual interface; Help functions and clear explanations of the functionalities and the used algorithms; Data Wrangling and data manipulation functionalities are certainly sufficient, as well as the looping possibilities which help you to automate parts of the analysis.Clear view of the data at every step of ETL process enables changing the flow as needed.We leverage KNIME flexibility in order to query data from our database and manipulate them for any ad-hoc business case, before presenting results to stakeholders.The product is very easy to understand even for non-analytical stakeholders. Sometimes we provide them with KNIME workflows and teach them how to run it on their own machine.Easy to connect with every database: We use queries from SQL, Redshift, Oracle.

Read more »

Cons
There is currently no cloud solution and this would be valuable for many clients.The GUI interface functions but it could stand to be updated to a more modern look and feel.The solution could work on the BI side of the tool to make it a bit better.The only area where the product lags is documentation and videos on the analytical app and the batch macro.It would be great if Alteryx could take third party tools and incorporate them.Even when it already includes some AI models, this area could be improved.It would be great to create the final users' visualization within Alteryx.The event handling, such that the file system watcher, is in need of improvement.

Read more »

The ability to handle large amounts of data and performance in processing need to be improved.It needs more examples, use cases, and MOOC to learn, especially with respect to the algorithms and how to practically create a flow from end-to-end.They could add more detailed examples of the functionality of every node, how it works and how we can use it, to make things easier at the beginning.The visualization functionalities are not good (cannot be compared to, for instance, the possibilities in R).The program is not fit for handling very large files or databases (greater than 1GB); it gets too slow and has a tendency to crash easily.​The data visualization part is the area most in need of improvement.The overall user experience feels unpolished. In particular: Data field type conversion is a real hassle, and date fields are a hassle; documentation is pretty poor; user community is average at best.Data visualization needs improvement.

Read more »

Pricing and Cost Advice
We have a yearly cost that we pay for the licensing. We do not pay any costs in addition to the licensing fees.The pricing is $5000 per year per production license.Opt for the three year subscription. It is 20% less than the yearly one.ROI is huge. There are some secondary benefits, like analysts getting their post 5 PM time back or the ability to shorten all closing processes to a half or less.It is $4,000 a year, so it is cheap versus other solutions. It also accomplishes three times the volume on the job in the same time (as the other solutions).​It can be a bit pricey, especially after the first year.

Read more »

KNIME desktop is free, which is great for analytics teams. Server is well priced, depending on how much support is required.

Read more »

report
Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
399,540 professionals have used our research since 2012.
Answers from the Community
Miriam Tover
author avatarPaul Simpson (Northrop Grumman Corporation)
Consultant

Although both Alteryx and KNIME can be found in the 2019 Gartner Magic Quadrant for Data Science and Machine Learning Platforms, and they do have in common the paradigm of a visual workflow, they do have differences. Alteryx has a well-earned reputation for letting the user easily connect to different kinds of data sources and bring them into a workflow to create datasets for use in analysis. They are very good at this, and I've heard engineers speak well about that ability, preferring to use Alteryx for their ETL than to learn ways of doing the same work in SQL Server. Alteryx bought yhat, a data science platform, and have been gradually adding capabilities for predictive analytics into the Alteryx workflow. My own experience trying a data science predictive project in Alteryx showed me that the company still has a long way to go. The same predictive project was far slower with Alteryx on my laptop than using R code (in RStudio) on my laptop, and there were not many tools in Alteryx that could do what I could do with R coding. At least Alteryx does allow both R and Python script blocks of your own creation to be inserted as steps in the workflow. But, in my opinion, Alteryx is definitely NOT a suitable data science platform, as of this writing.

KNIME, on the other hand, is a more complete data science platform. I have used it just enough to get a feel for what it can do. It also allows your own code blocks as part of the workflow. I can't recall if it is R, Python or both. Also, like Alteryx, KNIME has developed connectors for many kinds of data sources. I have not tried that same R project in KNIME that I did in Alteryx, so I can't really compare its ability as a data science platform to the Alteryx. I would expect that Alteryx has a free trial version, and I know that KNIME is free software (they make money off of things like KNIME Server). If I were to recommend one or the other, I would recommend KNIME. But, if your company has standardized on Alteryx, you'll have a hard time convincing them to let you use KNIME. If money is not an issue, I would look for a data science platform that does the job better than either of these. I would consider RapidMiner, Dataiku and DataRobot. You can see the movement of all the above-mentioned tools from Gartner's placement of them in the 2018 and 2019 magic quadrants here: https://towardsdatascience.com/data-science-platforms-the-2019-magic-quadrant-can-help-you-decide-1e58251653de

Ranking
1st
Views
30,132
Comparisons
23,861
Reviews
13
Average Words per Review
399
Avg. Rating
8.9
2nd
Views
22,954
Comparisons
17,868
Reviews
10
Average Words per Review
352
Avg. Rating
8.2
Top Comparisons
Compared 30% of the time.
Compared 7% of the time.
Compared 42% of the time.
Compared 13% of the time.
Compared 7% of the time.
Also Known As
KNIME Analytics Platform
Learn
Alteryx
Knime
Overview

Alteryx is a self-service data analytics solution, that provides a platform that can prep, blend, and analyze all of your data, then deploy and share analytics in hours. It can automate time-consuming and manual data tasks while performing predictive, statistical, and spatial analytics in the same workflow. It uses a drag and drop tool with an intuitive user interface with no coding and programming required. Alteryx licenses are subscription-based and include all product updates and support to their customers.

KNIME is the leading open platform for data-driven innovation helping organizations to stay ahead of change. Use our open-source, enterprise-grade analytics platform to discover the potential hidden in your data, mine for fresh insights or predict new futures.
Offer
Learn more about Alteryx
Learn more about KNIME
Sample Customers
AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy QueenInfocom Corporation, Dymatrix Consulting Group, Soluzione Informatiche, MMI Agency, Estanislao Training and Solutions, Vialis AG
Top Industries
REVIEWERS
Software R&D Company15%
Non Tech Company15%
University8%
Financial Services Firm8%
VISITORS READING REVIEWS
Software R&D Company25%
Financial Services Firm14%
Comms Service Provider11%
Manufacturing Company7%
VISITORS READING REVIEWS
Software R&D Company25%
Comms Service Provider16%
Financial Services Firm9%
Manufacturing Company7%
Company Size
REVIEWERS
Small Business48%
Midsize Enterprise15%
Large Enterprise37%
VISITORS READING REVIEWS
Small Business15%
Midsize Enterprise8%
Large Enterprise77%
REVIEWERS
Small Business21%
Midsize Enterprise36%
Large Enterprise43%
VISITORS READING REVIEWS
Small Business18%
Midsize Enterprise1%
Large Enterprise81%
Find out what your peers are saying about Alteryx vs. KNIME and other solutions. Updated: January 2020.
399,540 professionals have used our research since 2012.
We monitor all Data Science Platforms reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.