I'm a contractor who works on different teams. Right now, I'm working on three different projects.
Data Analyst at Data Management Consulting
It cuts down on time spent cleaning and transforming the data, improving productivity
Pros and Cons
- "Alteryx effectively visualizes the flow of data and what happens at each stage. I also like that it's a no-code solution. I also like that you can troubleshoot certain parts of the workflow by putting them in a sandbox."
What is our primary use case?
How has it helped my organization?
Alteryx has cut down on time spent cleaning and transforming the data. It improved productivity. Transitioning from PoC to other users was seamless. The users upskilled quickly, so they could take ownership without a steep learning curve.
What is most valuable?
Alteryx effectively visualizes the flow of data and what happens at each stage. I also like that it's a no-code solution. I also like that you can troubleshoot certain parts of the workflow by putting them in a sandbox.
For how long have I used the solution?
I have been using Alteryx off and on since 2020.
Buyer's Guide
Alteryx
November 2024
Learn what your peers think about Alteryx. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
814,649 professionals have used our research since 2012.
What do I think about the stability of the solution?
Alteryx is stable.
How are customer service and support?
Alteryx customer service was great. They gave me a trial version, and the client company bought licenses. The technical support and the sales guys were all helpful and supportive.
Which solution did I use previously and why did I switch?
I use Excel and Power Query. I don't use Alteryx personally because I don't have the funds for an enterprise solution.
How was the initial setup?
Setting up Alteryx was straightforward. The drag-and-drop menus are fantastic, and the icons are great. There isn't a steep learning curve. You become familiar with it quickly.
Alteryx wasn't deployed in the previous project. It was somewhat irregular. We ultimately did the dashboard in Power BI, but nobody was using Power BI as a data cleaning and transformation tool, so we used Alteryx as a proof of concept, We also deployed the cleaned data to use in a dashboard, and the dashboard was delivered to the client.
What other advice do I have?
I rate Alteryx seven out of 10. I recommend using the 14-day trial version to learn how it works. You can use some of their in-house data to try real information or run a parallel. The trial version is super helpful for making a decision and understanding the capabilities. That's what kind of sold me.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Director at Decision Science
Speeds up the time to obtain business answers/insights on data
Pros and Cons
- "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."
- "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."
What is our primary use case?
- Data acquisition, accessing all types of data services no matter the format, vendor or platform, I can connect, read and process the data.
- Data blending and descriptive, creating consolidated data sets, such as joins, unions, summarize, and all basic and advanced data manipulation tasks.
- Advanced analytics, like predictive and prescriptive analysis, which are very good tools.
- Preparation
It involves reading multiple data sources, in different formats, reshaping and blending them together to answer business questions. We generate models for predictions and optimization.
How has it helped my organization?
Alteryx speeds up the time to obtain business answers/insights on data. It can quickly process huge amounts of data. It allows you to have your business prepare their own data sets, and it can even be used by IT people. The speed of processing is impressive to get something in minutes that would normally take you a couple of days or weeks.
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.
What is most valuable?
- The codeless concept and speed of processing are unique. Super intuitive to use and easy to master. No coder needed.
- I did not find a data source that I could not connect to yet.
- In/out, preparation, blending, parsing, and transformation tools are the fundamental ones to start analysis.
- Spatial operations and analytics are super powerful for analysis which requires these types of models/operations.
What needs improvement?
Even when it already includes some AI models, this area could be improved.
Another area which could be improved is the visualizations. It would be great to create the final users' visualization within Alteryx.
Finally, the UI does not reflects the amazing tool Alteryx is.
For how long have I used the solution?
Three to five years.
What do I think about the stability of the solution?
It is absolutely stable. It has not crashed. It takes seconds to process huge amounts of data without too many resources on the machine.
What do I think about the scalability of the solution?
There are no scalability issues. It is enterprise ready, and can multiple your processing power.
How are customer service and support?
It is one of the most complete and great customer service that I experienced with a software company/ecosystem.
The customer support is fast, complete and proficient. The partner ecosystem is extensive, and all have a couple of very advanced resources to provide support.
Finally, Alteryx has an online community (Check it out at http://community.alteryx.com ), with a lot of people willing to help users.
Which solution did I use previously and why did I switch?
I used several ETL tools, but none had the scope of Alteryx nor the ability to perform the analysis itself.
How was the initial setup?
The initial setup was very straightforward using a wizard.
Next, Next, Next, OK process. Super easy, intuitive, and problem-free.
What about the implementation team?
Both vendor team and in-house. In all cases, it was a straightforward experience. The vendor was very proficient and Alteryx always had our backs.
What was our ROI?
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.
What's my experience with pricing, setup cost, and licensing?
Opt for the three year subscription. It is 20% less than the yearly one.
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).
Which other solutions did I evaluate?
I evaluated Datawatch and QlikView.
Datawatch: Performance was not great and it was not so straightforward to implement.
What other advice do I have?
Download the trial and test it. You will be amazed. It is the complete package for people who work with data.
Most important criteria when selecting a vendor:
- Provide a good product.
- Have good support.
- Needs a clear vision of the future with a very solid roadmap.
Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an Alteryx Partner.
Buyer's Guide
Alteryx
November 2024
Learn what your peers think about Alteryx. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
814,649 professionals have used our research since 2012.
Senior Data Architect, Total Rewards Analytics and Insights at a retailer with 10,001+ employees
Offers very good data transformation with good scheduling and a straightforward setup
Pros and Cons
- "The scheduling within the solution is excellent."
- "It's a technical product and those that don't have proper training will have to deal with a steep learning curve."
What is our primary use case?
We primarily use the solution for data processing and ETL.
What is most valuable?
Overall, I'd have to say the tool is pretty awesome.
The solution offers very good data transformation.
Users are able to read in from any source, combine heterogeneous sources, and providing output or input to the next downstream step. You can put these things together or you can create very complex or simple flows and then tie them together.
The scheduling within the solution is excellent.
The initial setup is straightforward.
What needs improvement?
I can't recall a feature that may be lacking. Overall, we've been happy with the solution.
It's a technical product and those that don't have proper training will have to deal with a steep learning curve.
For how long have I used the solution?
I've been using the solution for over five years now. It's been a while.
What do I think about the stability of the solution?
The solution is reliable and quite durable. We haven't dealt with bugs or glitches. It doesn't crash or freeze. It's very stable. We're happy with it.
What do I think about the scalability of the solution?
The solution scales quite well. If a company needs to expand it, it should be able to do so easily.
How are customer service and technical support?
We don't deal with technical support often. We typically have had other people to do that for us within our organization. That said, the support has been there to accommodate us in terms of the different and pretty stiff information security policies and standards. We're mostly satisfied with the level of service.
How was the initial setup?
The initial setup is not complex at all. We found it easy. It was straightforward.
What's my experience with pricing, setup cost, and licensing?
I don't handle the licensing aspect of the product. I can say that we have to have an enterprise license. Currently and periodically that gets challenged and they try to take it away and we honestly have a hard time finding a tool that could replace it. Therefore, we wind up keeping it. It's happened several times.
What other advice do I have?
We're a corporate user and end-user of the product.
While I don't know the version number off the top of my head, I can say with certainty that we are using the latest one.
The solution is going to be best for technical users or people that have hands-on experience with data such as data scientists or people that can be creative and deal with multiple different databases and different permutations in the structured query language right across those different databases.
It's fairly standard, however, not completely, and so, people in that realm tend to be able to function well, people that are analysts may struggle and have a bit of a learning curve that they have to deal with. I've been doing this throughout the information life cycle - about 35 years plus. Therefore, for me, it's my second nature. Others that haven't been exposed to technology over that timeframe may struggle.
I'd rate the solution ten out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Director, Digital Experience & Media at Qdoba Restaurant Corporation
Good data preparation and machine learning capabilities have helped improve decision making
Pros and Cons
- "Alteryx has made us more agile and increased the speed and effectiveness of decision making."
- "The server is too expensive for what you get and it really a designer desktop on a server."
What is our primary use case?
We have many use cases for this solution.
For example, we used it for data prep and blending as well as machine learning. We built customer 360, have used it for labor optimization, and demand forecasting.
How has it helped my organization?
Alteryx has made us more agile and increased the speed and effectiveness of decision making.
What is most valuable?
All of the features are valuable to us.
The data prep and blending are great but so is the machine learning functionality.
We used spatial analysis, which is a good feature.
What needs improvement?
The server is too expensive for what you get and it is really a designer desktop on a server. It is not worth the money.
For how long have I used the solution?
We have been using Alteryx for four years.
What do I think about the stability of the solution?
It is fairly stable and we have had no major issues.
What do I think about the scalability of the solution?
With respect to scalability, it is rather good at handling large data sets.
How are customer service and technical support?
Grazitti Interactive is very responsive and very helpful.
Which solution did I use previously and why did I switch?
We did not use another solution prior to this one.
How was the initial setup?
The initial setup is very easy.
What about the implementation team?
We used Grazitti Interative. They are excellent!
What was our ROI?
We did not calculate a specific ROI.
What's my experience with pricing, setup cost, and licensing?
The server pricing is high.
Which other solutions did I evaluate?
We did not evaluate other options before choosing Alteryx.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Head of Data Analytics COE at bank islam
Efficiently handles a massive amount of data and is quite a stable solution
Pros and Cons
- "Its initial setup is easy."
- "They should work on its pricing."
What is our primary use case?
We use the solution for its customer segmentation feature.
What is most valuable?
The solution works efficiently in handling a huge amount of data.
What needs improvement?
They should improve the solution's pricing.
For how long have I used the solution?
We have been using the solution for two and a half years.
What do I think about the stability of the solution?
It is quite a stable solution. I rate its stability as a nine.
What do I think about the scalability of the solution?
We have six users of the solution, including engineers and data scientists. I rate its scalability as a seven.
How was the initial setup?
The solution's initial setup is time-consuming but easy to process.
What about the implementation team?
We installed the solution with the help of our in-house team.
What's my experience with pricing, setup cost, and licensing?
The solution is expensive. We have purchased its yearly license.
Which other solutions did I evaluate?
I evaluated Spark for its functions. In comparison, Alteryx manages massive data more smoothly.
What other advice do I have?
The solution requires three executives for the maintenance. I recommend it and rate it as an eight.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Advance Analytics PO at a pharma/biotech company with 10,001+ employees
Nice dashboard and good customizations but can be complex
Pros and Cons
- "There are a lot of good customization capabilities."
- "The solution can be quite complex in some aspects."
What is our primary use case?
We primarily use the solution for all machine learning projects, including perspective molding. We're using it for our marketing efforts.
What is most valuable?
It keeps on upgrading, which is nice. It's always updating with new releases.
A majority of people at our organization like the drag and drop features.
The database is very good.
Overall, the solution as a whole is extremely useful.
The initial setup is easy.
The security on the solution is pretty good.
It has a very nice dashboard.
There are a lot of good customization capabilities.
What needs improvement?
With some of the features in the database, they don't offer certain things, like Keynote or transposing. I'm not sure, if, with the latest update, they've added these capabilities in or not.
The solution can be quite complex in some aspects.
For some specific coders, it's still is a kind of concern that they don't have coding options available. We're moving to Dataiku due to the fact that it caters to both coders and clickers (those who prefer drag and drop).
For how long have I used the solution?
I'd say I've been working with the solution for two to three years now. I've been using Alteryx for all my data scientist projects.
What do I think about the stability of the solution?
The solution, for the most part, is pretty stable. We don't seem to have too many issues with it.
What do I think about the scalability of the solution?
The solution can scale to some extent.
We have about 200 to 300 users on the solution currently.
How are customer service and technical support?
While the community support offered by the solution is great, if you need to directly contact technical support, it's not so good. Often there are long queues and it takes a while to get help.
Which solution did I use previously and why did I switch?
I've been using Alteryx for all my data scientist projects up until recently. However, now I'm shifting to Dataiku, which my organization is offering instead.
How was the initial setup?
The initial setup is not too complex. It's pretty straightforward. We found it to be rather easy. However, there are certain implementations that can be a little more complex.
What about the implementation team?
We handled the implementation ourselves in-house.
What's my experience with pricing, setup cost, and licensing?
I'm not sure of the exact cost of the solution. It's not an aspect of the product I deal with directly.
What other advice do I have?
We're just a customer. We don't have a business relationship with Alteryx.
I haven't updated to the latest version yet. I'm unsure which version of the solution I'm currently using.
We are, as an organization, shifting and moving away from the solution. We are now going to utilize a new tool that is being selected. Due to some complexities in Alteryx, we are moving away from it.
Overall, I'd rate it seven out of ten. It has a lot going for it, however, we need a solution that's less complex and offers more coding capabilities.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Analytics Insights - Manager at a consultancy with 10,001+ employees
Has everything I need, but the community forum should be easy to use
Pros and Cons
- "It has everything that one needs. Whatever you want to do with the data can be done with Alteryx."
- "I mostly used it for flat files, but I have many colleagues who reported that to tune a query, in case they want to directly connect to the database, there is no option to optimize the performance of the query, as we have in Informatica."
What is our primary use case?
It is mostly used for data validation rules. For example, for many legacy systems files, we check whether the count in one file is matching the logic that we have in another file. If it doesn't, then we fill that particular data load. The ultimate destination for that is a database, but to avoid data mismatch or the garbaging of data because someone didn't put files in a proper format, we are doing the validation with Alteryx. So, it's basically for data cleaning and removing some line characters from the data in the files so that there are no data issues while using SQL Loader.
How has it helped my organization?
I haven't worked much with Alteryx because my primary work is in Informatica. I work with it only when I don't have any option or it is too tedious to work in Informatica for a particular file or schedule a load. For example, if the load will fail in Informatica, or it will not allow the rest of the stream to continue, I use Alteryx. In Alteryx, I have that option. I can have a dedicated flow that will run for that particular file. For my 100% ETL work, 10% work is in Alteryx, and 90% is in Informatica. So, I haven't explored it much, but whenever any requirement comes, I work on it. So far, I was able to utilize it for whatever I need. Everything I needed was already there.
What is most valuable?
It has everything that one needs. Whatever you want to do with the data can be done with Alteryx. However, we haven't implemented it on a large scale because we don't have a physical server. We have a virtual server for this, and there are limitations to that. So, we use it for smaller data chunks, not bigger data volumes. It is mostly for files, not for databases.
What needs improvement?
There is a community for Alteryx, but it is so spread out. For example, if I face an issue with Informatica, I have Informatica forums that keep on adding to that. They have a very cohesive structure when it comes to the issues and their error messages. They are very easy to use for Informatica issues, but in the case of Alteryx, the information is too spread out, and it is difficult to find the answer to a particular issue that someone faces. If Alteryx can organize its forum and the issues in a better way, it will be easy for developers.
I mostly used it for flat files, but I have many colleagues who reported that to tune a query, in case they want to directly connect to the database, there is no option to optimize the performance of the query, as we have in Informatica. With Informatica, we can use hints and other things and they directly hit the database, but with Alteryx, that is not the case. So, when it comes to database connectivity, the performance is not as good as a flat file as a source.
For how long have I used the solution?
I have been using Alteryx for around 10 months.
What do I think about the stability of the solution?
It never crashed in the last 10 months.
What do I think about the scalability of the solution?
I assume it would be scalable without any issues. Most of my work has been related to files without any databases or other connectors.
We have more than 5,000 people using it. This is a free tool across our organization. So, everyone uses it in case they want.
How was the initial setup?
I only installed Studio on my laptop. The server was installed way before I joined. So, I can't comment on that, but the Studio setup was easy. It was almost like Tableau.
What other advice do I have?
It has Excel and diagram functionalities. So, not much technical knowledge is required to use it. If you are aware of both or have Tableau and Excel experience, then you are good to go.
I would rate it a seven out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
QA Validation at a pharma/biotech company with 1,001-5,000 employees
Easy to summarize data, easy to scale, good reporting features, and excellent technical support
Pros and Cons
- "All of the data science features in terms of unioning and joining data together are valuable."
- "The only weakness I would say is on the visualization side of having that dynamic incapability."
What is our primary use case?
I use this solution for KPIs and trending.
What is most valuable?
All of the data science features in terms of unioning and joining data together are valuable. The formula tools are good, and it provides an easy way to summarize data.
It has some really good, solid, basic reporting functions.
It's not as robust as a lot of the dynamic interactive tools, but it certainly gets into the more static reporting very effectively.
What needs improvement?
The only weakness I would say is on the visualization side of having that dynamic incapability.
I know that it is dependent upon having the on-premise and cloud server environments, but even there, the product functionality is somewhat limited.
This would reduce the need to integrate it with other products.
For how long have I used the solution?
I have been using Alteryx for a couple of years.
I am not using the latest version. I am one version out, and I am in the process of having it updated to the latest.
I generally stay up to date with each release.
I am using the desktop version.
What do I think about the stability of the solution?
I don't think that there any more issues with stability than would be expected for a product of this type. Those occasional things happen, but it's nothing that is significant.
What do I think about the scalability of the solution?
Alteryx is easy to scale.
We have three people who are using this solution in our organization.
How are customer service and technical support?
Technical support is very good. They get high marks.
I would rate them a ten out of ten.
Which solution did I use previously and why did I switch?
We had used JMP, which is a product by SAS, and it really didn't have any capability of doing the automation that Aletryx has, other than some really bespoke programming language. It is a type of script language.
It is very awkward to learn and use it.
How was the initial setup?
The initial setup is definitely straightforward.
What other advice do I have?
I would definitely advise others to give it a fair look. It's a great product.
It is not marketed as a solution to all different types of aspects of analytics. I'm not going to downgrade it just because that's not within the scope of what they're marketing the product for.
Based on what it has been marketed for, I would rate Alteryx a ten out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Alteryx Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
Microsoft Power BI
Informatica Intelligent Data Management Cloud (IDMC)
Databricks
Tableau
Amazon QuickSight
Teradata
Microsoft Azure Machine Learning Studio
KNIME
IBM Cognos
Amazon SageMaker
SAP Analytics Cloud
Qlik Sense
Anaplan
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
Buyer's Guide
Download our free Alteryx Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- What is the Biggest Difference Between Alteryx and IBM SPSS Modeler?
- What Is The Biggest Difference Between Alteryx and KNIME?
- How do Alteryx, Denod, and Azure Data Factory overlap (or complement) each other?
- Do you recommend Alteryx?
- Which solution provides the best ROI: KNIME, Alteryx or RapidMiner?
- Which tool is better for analysis and analytics: SPSS or Alteryx?
- What is your opinion of the 2021 Gartner Magic Quadrant for Analytics & BI Platforms?
- What is ITOM (IT Operations Management)?
- What is the easiest to use analytics platform?
- When evaluating Predictive Analytics, what aspect do you think is the most important to look for?
New addition: Starting in version 2018.1 as beta and G.A. in version 2018.2, Alteryx now offers a Python SDK, so in addition to the R native integration, Alteryx now offers everything that a Business User, IT user or Data Scientist needs.