Alteryx is primarily used for data transformation and ETL processes within our environment. We also utilize its machine-learning capabilities for regression and classification tasks. Our team leverages it for back-end calculations to enhance visualization performance.
Vice President at a financial services firm with 10,001+ employees
Streamlines data transformation processes, but the integration with visualization tools could be better
Pros and Cons
- "The product's most valuable features include its ease of use for non-technical users and machine learning capabilities."
- "The product could benefit from improved integration with visualization tools or even the inclusion of built-in visualization features."
What is our primary use case?
How has it helped my organization?
The platform's user-friendliness, particularly for non-technical users, has allowed for more efficient data processing and the integration of machine learning within our workflows. It has streamlined our data transformation processes, ultimately improving the performance of our visualizations.
What is most valuable?
The product's most valuable features include its ease of use for non-technical users and machine learning capabilities. The flexibility to integrate custom code is also an important aspect of the platform for our use case.
What needs improvement?
The product could benefit from improved integration with visualization tools or even the inclusion of built-in visualization features. It would reduce the need to use multiple tools and pay for additional licenses.
Buyer's Guide
Alteryx
December 2024
Learn what your peers think about Alteryx. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,053 professionals have used our research since 2012.
What do I think about the stability of the solution?
I rate the solution's stability a seven out of ten.
What do I think about the scalability of the solution?
I rate the solution's scalability a seven out of ten.
What's my experience with pricing, setup cost, and licensing?
Alteryx is generally more suited for medium—to large companies due to its potentially high licensing costs.
What other advice do I have?
I rate Alteryx a seven out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Aug 27, 2024
Flag as inappropriateSoftware Engineer at a computer software company with 10,001+ employees
Boosting cost efficiency and workflow deployment with strong data integration
Pros and Cons
- "Alteryx is user-friendly and allows easy creation of workflows compared to Informatica PowerCenter."
- "Alteryx is user-friendly and allows easy creation of workflows compared to Informatica PowerCenter."
- "When configuring target tables, it is difficult to see the full text when deciding on load operations."
What is our primary use case?
My primary use case for Alteryx is ETL more than analytics. I mainly use it for loading data from one server to another and loading files to databases. It is good for data integration. I find it very user-friendly compared to tools like Informatica PowerCenter. It allows me to easily create workflows and deploy them.
How has it helped my organization?
Alteryx has helped save costs compared to Informatica licenses. It's one of the primary reasons people are migrating to tools like Alteryx that can easily do the work of more costly popular tools. It has also made deploying new workflows quicker, taking only five to ten minutes to move to production.
What is most valuable?
Alteryx is user-friendly and allows easy creation of workflows compared to Informatica PowerCenter. The inbuilt functions are good, and it's useful for working with files. You can see the intermediate results in workflows, which is very helpful.
What needs improvement?
When configuring target tables, it is difficult to see the full text when deciding on load operations. Performance can be slow when updating existing records. Documentation could be improved for recurring issues.
For how long have I used the solution?
I have been using Alteryx for one year, on and off.
What do I think about the stability of the solution?
There haven't been significant downtimes, and I didn't need to reach out to Alteryx for support because available documents usually provide enough information to resolve issues.
How are customer service and support?
I have not contacted Alteryx customer service or technical support as I have been able to find solutions through available documentation and community support.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I previously used Informatica PowerCenter but find Alteryx more user-friendly. In PowerCenter, building workflows is more difficult compared to Alteryx.
What about the implementation team?
My senior colleague is responsible for deployment. She is able to see everything clearly, including how workflows trigger and how logs work.
What was our ROI?
Alteryx provides cost savings compared to other solutions like Informatica when it comes to licensing.
What's my experience with pricing, setup cost, and licensing?
Alteryx is more cost-effective compared to Informatica licenses, offering savings.
Which other solutions did I evaluate?
I was previously using Informatica PowerCenter, however, Alteryx offers good advantages, including extra analytics features.
What other advice do I have?
Make sure to improve the documentation for recurring issues. Alteryx is somewhat user-friendly and easier to work with compared to Informatica PowerCenter.
I'd rate the solution eight 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.
Last updated: Nov 11, 2024
Flag as inappropriateBuyer's Guide
Alteryx
December 2024
Learn what your peers think about Alteryx. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,053 professionals have used our research since 2012.
Has a straightforward setup process and an efficient ability to connect to various data sources in real-time
Pros and Cons
- "Alteryx significantly reduces the time spent searching for specific information."
- "The product's pricing needs improvement."
What is our primary use case?
I use the platform for a variety of tasks. For example, I extract data from our Salesforce system and prepare it for analysis. It allows customized monitoring of the pipeline. I often prepare data to be imported into Power BI for further analysis. I also use it for personal data tracking and extracting data from our internal time-logging tool to monitor project progress with customers. It helps me stay updated without manually logging in and reviewing reports that may not contain the precise information I need.
What is most valuable?
The product's most valuable aspect is its ease of use. It allows me, even as a field person, to create workflows and perform data preparation tasks quickly. Its speed and ability to connect to various data sources in real-time are also significant benefits.
What needs improvement?
The product's pricing needs improvement.
For how long have I used the solution?
We have been using Alteryx daily for approximately four years. We consistently update to ensure we run the latest version with all the latest updates.
What do I think about the stability of the solution?
The product stability is fine.
What do I think about the scalability of the solution?
The platform is scalable.
How are customer service and support?
The technical support team is good; responses are usually received within a day.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup was very straightforward. The community support, information on their website, training, and resources are excellent. Anyone can learn the basics in minutes and set it up easily.
It took less than an hour to deploy Alteryx. I handle maintenance on my own. There is no significant need for resources. When updates are required, I download and install them, which takes about 15 minutes.
What was our ROI?
The platform saves me several hours weekly in data preparation, which would require additional personnel. Although I have not calculated the exact figures, it breaks even for me. The return on investment can be substantial for customers, depending on their usage.
What's my experience with pricing, setup cost, and licensing?
The product pricing is a concern. I use Alteryx because my company provides it, but it would be too expensive if I had to pay for it myself. Many customers also feel it is too costly, especially in regions like Brazil. While it offers extensive features, including predictive analytics, for those who mainly use it for data preparation and blending, the cost can be prohibitive.
What other advice do I have?
Alteryx significantly reduces the time spent searching for specific information. It handles all my analytics tasks efficiently. Once the workflows are set up, it processes the data and outputs it for further analysis in Power BI. Without Alteryx, these tasks would take much longer.
The cloud version could be improved, as it is less capable than the desktop version. Overall, however, it is an excellent tool.
I rate it a nine.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
Last updated: Jun 22, 2024
Flag as inappropriateGraduate Assistant at a university with 501-1,000 employees
Easy to set up and good filtering but has bit of a learning curve
Pros and Cons
- "The initial setup is easy."
- "If there is any way to make the learning curve less steep, that would be ideal."
What is our primary use case?
We used the solution to design our models and databases, and then we used it to automate it through Excel.
What is most valuable?
The fact that it can turn up all the functions that Excel takes hours to do in a faster way is a very valuable feature. Inputting from various sources is easy. The fact that it can filter or do other kinds of inputs is very useful for Alteryx. Also, the thing with Excel, as opposed to Alteryx, is that Excel can only take up to a number of rows, and after that, it freezes. In my previous work experience, I had to deal with 10,000 or even more rows. Excel was not feasible at all as opposed to Alteryx, which just automated tasks and gave us the results in a few minutes. The reliability was much better.
The initial setup is easy.
What needs improvement?
I have not yet been exposed to Alteryx as much to comment on negative experiences. I'm taking a class this semester that has to do with Alteryx. I'm pretty sure that once I'm learning the projects and utilizing Alteryx more, then I can give back more feedback.
The usability could use some improvements. There are icons that you choose in terms of inputting the tool or even for filtering and then running different functions, there are different ways of designing your input tools and output tools, and that could get confusing.
I would suggest that if there's any way of simplifying it so that instead of tools or instead of understanding how it works, we could focus more on its usability and the output of it. For me, it was a bit challenging to figure out how to work with Alteryx. If there is any way to make the learning curve less steep, that would be ideal.
For how long have I used the solution?
I've used the solution for a year and a half.
What do I think about the stability of the solution?
The stability is good, and, unlike Excel, it can handle large amounts of data and not freeze.
There have been actually hiccups and issues with Alteryx, however, to deal with that, what we did was we went back and saw what the issue was, and mainly the issue was due to Excel. Maybe the value, function time, or strength value was not supporting it. We had to edit many functions and strengths to rerun it through Alteryx. That's one thing that's good in Alteryx: if we run and it's not working, it gives us an output and tells us where we are going wrong so that we can go back and troubleshoot on the problematic areas.
How are customer service and support?
I haven't had a chance to deal with the tech support due to the fact that mostly whenever things went wrong with Alteryx, we were able to fix it by ourselves or with the engineering team. Engineering was able to troubleshoot it and fix it by looking at the output given by Alteryx in the email. It tells you where things are going wrong. For that reason, we did not have the opportunity to go and ask for advice from support.
Which solution did I use previously and why did I switch?
I have had experience in automating projects in Excel and Alteryx, among others.
I have more experience in Alteryx itself than in Designer. A lot of databases were modeled, and we went and changed or updated the models, attributes, and entities. Then, what we did is we created them in Excel and we just auto-run it whenever we needed to.
How was the initial setup?
It's not complex, and it's also not straightforward. It depends on which database and how many functions you are using or how much you are designing through Alteryx. If there are a lot of structures and if there are a lot of values that you're doing through Alteryx, then it would be hard. That said, from my experience, it's actually not that tough.
What's my experience with pricing, setup cost, and licensing?
I don't deal with licensing. I can't speak to the exact cost of the solution.
What other advice do I have?
At first, you need to know the capabilities of Alteryx. It's a good idea to attend a lot of webinars or do a project. That would be really helpful to understand how powerful Alteryx is. Alteryx is used a lot in financial industries, according to what I have seen. It becomes really taxing to do everything in Excel or spreadsheets. Something that would take an hour or two hours to do it manually can take five to 10 minutes for Alteryx. Therefore, try a small project or understand the intricacies of Alteryx and that will get you started.
I'd rate it seven out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Capacity Planner at a financial services firm with 10,001+ employees
Efficient, with great automation capabilities but technical support is not as good as it once was
Pros and Cons
- "Automation is the most valuable aspect for us. The ability to wrap business logic around the data is very helpful."
- "What they're struggling with is it's not as mature as Tableau in the user management area. It was tougher to manage the server part of it right away, especially since the user base has grown."
What is our primary use case?
We were analyzing data trying to find anomalies with the servers and things that were going wrong. Normally in what we do, it can be a very manual process looking for that kind of stuff. Therefore, using this product, I created a workflow that went out and looked across all devices for problems that are happening, and managed to cut down the number of issues that were being created daily.
How has it helped my organization?
The amount of labor that it takes us to find issues is pretty high. When you put the automation in place, that frees up your time to concentrate on the advanced analytics. We recognized right away in that first year that the amount of FTEs that we would have to acquire to do that work was a significant amount of money. It just stepped us into automation of many things that we do. That frees us up to be able to do a more mature analysis, and not that day-to-day stuff that you we have to track.
Not everybody's budget allows for having a team of 20. We just don't have that. It's saving us a lot of money in FTEs.
What is most valuable?
Right away we knew this has a lot of value, even from the perspective of data manipulation and automation.
There are all sorts of use cases that we could come up with. It does take a little bit of learning and figuring out how to work the tool, however, we've been really successful with it. I even went and presented at one of their conferences our use case.
Automation is the most valuable aspect for us. The ability to wrap business logic around the data is very helpful.
It not only helps us with efficiency. You can also flip the steps apart to make that data flow in various ways.
Most tasks run in less than two minutes and provide us with what we need very quickly. I can wrap rules around the data to look for certain things or to notify people.
The amount of manual labor that we're saving by writing those workflows is huge.
What needs improvement?
The solution does have a bit of a learning curve.
I initially managed the product completely. Then, when the user base grew, another group just took it over. What they're struggling with is it's not as mature as Tableau in the user management area. It was tougher to manage the server part of it right away, especially since the user base has grown. When you get hundreds of users in there, trying to manage access to the product is a little tougher than Tableau.
For how long have I used the solution?
I've used the solution for maybe around five years or so.
What do I think about the stability of the solution?
The solution is quite stable. It's not as mature as Tableau in that stability area, however, it's pretty reliable. We don't have a lot of problems with it. Initially, we created a lot of cases as we didn't understand how to best manage the product. Now, very rarely do I open a case with support and have issues.
How are customer service and technical support?
They recently moved to a different support model. Initially, when we came to the product, the support was pretty good. Now, when we open cases, it seems not so good. They're asking customers to pay more money to get a higher level of support. Of course, due to the fact that we don't open that many cases, it's not important to us to get to that higher level. That said, the response time given and the attention to us is not as good as it was initially.
Which solution did I use previously and why did I switch?
When trying to pull large datasets into Tableau right away we realized that we had to do something different. Prior to Alteryx being available, I would use scripting to stage the data. I happened to notice an ad on LinkedIn for Alteryx, and I thought, "Wow, this is exactly what I need." I talked management into buying it. I was the first one in the company to start using the product.
What about the implementation team?
We used outside vendors to come in and help in certain parts of the implementation.
What's my experience with pricing, setup cost, and licensing?
It's more expensive than Tableau, for example.
There has been some scrutiny on the overall costs. We're trying to go to more open-source, with more products that don't cost so much. I have to continually work with folks on proving that the value of what we pay in licenses.
The solution has recently changed its support process and is now pressuring users to pay for a higher level of support services. That could potentially be an extra charge for some companies.
What other advice do I have?
We are just customers and end-users.
I would advise other companies considering the solution that the training is important. They've been great working with us on free training for this, that, and the other. The company really does provide a lot of those resources. The community is very good. The knowledge base that's out there in the community is great. A company should just tap into that and any free training they can. It takes a little bit of time to get proficient at it, however, the payoff is there.
Overall, I would rate it at a seven out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Solution Consulting, Growth, Analytics at Akinon
Provides spatial tools for geographic analysis and data enrichment
Pros and Cons
- "One-stop shop for data preparation, blending, prediction, and optimization in a single workflow."
- "More statistics tools: We can use to compare SPSS statistics with some automated advisory."
What is most valuable?
- One-stop shop for data preparation, blending, prediction, and optimization in a single workflow.
- In-database analytics native to SQL Server, Oracle, Teradata, and SAP HANA
- Spatial tools for geographic analysis and data enrichment
How has it helped my organization?
We provided the whole consulting delivery on a single tool with reporting and automated PowerPoint presentations.
What needs improvement?
- GPU or multi-core CPU utilization
- WYSIWYG reporting with interactive filters and graphics
- Mobile integration: Triggers analytic apps through mobile phone and gets results interactively.
- More statistics tools: We can use to compare SPSS statistics with some automated advisory.
For how long have I used the solution?
We have been using this solution since 2014.
What was my experience with deployment of the solution?
There were no deployment issues, and it went pretty fast. You sometimes need a license file if you are behind a firewall.
What do I think about the stability of the solution?
When the workflows are huge and complex, it may take some time to refresh it.
What do I think about the scalability of the solution?
There were no issues with scalability.
How are customer service and technical support?
Customer Service:
Customer service is pretty responsive, based on the UK and US time zones.
Technical support is pretty responsive and knowledgeable. The community support is exceptional, too. It is a very crowded community with lots of practical solutions.
Which solution did I use previously and why did I switch?
- SPSS modeler: Not easy to prep features. It needs data enrichment using spatial features. Deployment is not straightforward.
- SAS Analytics, EG, EM, DataFlux forecasting: Very expensive solutions with steep learning curves
How was the initial setup?
The setup was simple. It was pretty much "next, next, and next".
What about the implementation team?
We did the implementation in-house.
What was our ROI?
With a $5K USD designer tool, we already did some big data. There were lots of fruitful projects. I would estimate a six of seven times ROI in a few months.
What's my experience with pricing, setup cost, and licensing?
A designer and scheduler for $13K/year in total is pretty much earning you the money back in time and in other resources.
The server is a big bet and you need at least 10-15 people with designers or 60-70 people for the continuous use of analytic apps. Otherwise, it's too early to scale up and out.
Which other solutions did I evaluate?
- KNIME: A modeling tool not easy to learn, track/audit, or deploy quickly.
- RapidMiner: Good analytics capabilities, deep learning. However, not good for ETL, data quality, or spatial enrichment.
- SAS: Extremely expensive, archaic, and no need to take the risk.
- SPSS modeler: Second best for modeling, but not enough spatial. It is hard to deploy and has a lack of vision.
What other advice do I have?
This solution has a very bold vision.
Disclosure: My company has a business relationship with this vendor other than being a customer: Started using the tool for consulting purposes in 2014. During my tenure at Experian, I founded the Istanbul Alteryx users group in 2015 to share knowledge. We have 290 subscribers as of today. I started my own consulting business and became a referral partner in late 2015. I sold the first Alteryx license in MENA. In 2016 we started a reselling agreement with Alteryx.
I'm now a beta tester and volunteer at Alteryx for Good Co-lab helping NGOs and NFPs with Analytics propositions.
Assistant Manager at a retailer with 10,001+ employees
Allows end users to see clean and structured data, but the formula used should be automated
Pros and Cons
- "Alteryx makes it easy for the end customer to see clean data in a structured form."
- "The formula we currently use in Alteryx can be automated."
What is our primary use case?
We use Alteryx to modify and modernize data based on different types of data requests. The data and the data source may be in different forms, resulting in unstructured data in the database. We use Alteryx to give good shape and size to such unstructured data.
What is most valuable?
Alteryx makes it easy for the end customer to see clean data in a structured form. Alteryx has many features, such as info data, data cleansing formula, the select tool, union, summarize, and text-to-form. We use Alteryx in the database for reporting, documentation, email, and data preparation.
What needs improvement?
To use Alteryx, you need to think like the people who write software codes. The formula we currently use in Alteryx can be automated. This would be helpful for people using Alteryx who are not from a coding background and can write the formula differently. Whoever is using Alteryx should feel some convenience using it. We found most of the useful features built into Alteryx, but they all are on a paid basis.
For how long have I used the solution?
I have been using Alteryx for nine to ten years.
What do I think about the stability of the solution?
I have not faced any challenges with stability.
What do I think about the scalability of the solution?
Alteryx is really scalable. It adds value and fits our business. More than 300 users are working with Alteryx in our organization in India. I do not have the exact figures, but 2000 users globally use the solution in our organization.
How are customer service and support?
During COVID, they had on-call engineers for very good technical support. I would like to have that support again because they have now closed it, which is difficult for people who need it. They should continue that kind of support again. It would be good if they could provide technical support on screen.
Which solution did I use previously and why did I switch?
We did not use a different solution but we are planning to use Google Cloud Platform.
How was the initial setup?
The implementation is not a big thing for Alteryx. It is simple and easy to use.
What was our ROI?
We have seen ROI with this solution. However, if we explore other tools in the market, we will probably get a better ROI.
What's my experience with pricing, setup cost, and licensing?
The solution has a more costly license than other tools in the market.
What other advice do I have?
Alteryx is the best solution for people who want their data in a structured way. It is a bit complicated for a new user. The complexity of the tool is evident by the fact that only if you provide an exact input to this tool it will give you the output. However, if you know a little about Alteryx, it is a very good tool for you. We are using an on-cloud deployment for this solution.
Overall, I rate Alteryx a seven out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Manager at Bain & Company
Fast data processing, highly scalable, and good community support
Pros and Cons
- "Data processing is most valuable. It is one of the fastest data blockers out there in the market, which is a fascinating thing about Alteryx."
- "They can provide some pre-built tools for predictive analytics instead of us having to build all the tools. It should also be improved from the visualization aspect. It should have better visualization capabilities. There are tools out there that have better visualization capabilities, which Alteryx is lacking currently."
What is most valuable?
Data processing is most valuable. It is one of the fastest data blockers out there in the market, which is a fascinating thing about Alteryx.
What needs improvement?
They can provide some pre-built tools for predictive analytics instead of us having to build all the tools.
It should also be improved from the visualization aspect. It should have better visualization capabilities. There are tools out there that have better visualization capabilities, which Alteryx is lacking currently.
For how long have I used the solution?
I have been using this solution for more than six years.
What do I think about the scalability of the solution?
I have done a lot of work on Alteryx and deployed it on client servers, and Alteryx is a highly scalable solution in my opinion.
It is mostly used by the analytics team, which includes analyst associates and project leaders. The consulting team also uses it pretty often. We would like to increase its usage because it is a pretty good software to work with.
How are customer service and technical support?
I believe their technical support is pretty great. I mostly use the Alteryx community, which is really helpful. It is maintained by Alteryx people.
Which solution did I use previously and why did I switch?
I used SQL previously, but it was not very good for quick and dirty analysis. So, I switched to Alteryx.
How was the initial setup?
It is straightforward. It is on the cloud, but the major functions that we have are on the desktop itself. The cloud solution is good for client deployments.
What's my experience with pricing, setup cost, and licensing?
My organization pays for it, and I do not look into the financial aspect of the licensing, but I know it is pretty expensive.
What other advice do I have?
I would rate Alteryx a nine out of ten.
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: December 2024
Popular Comparisons
SAP Analytics Cloud
Anaplan
RapidMiner
DataRobot
ibi WebFOCUS
Pecan AI
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 tool is better for analysis and analytics: SPSS or Alteryx?
- Which solution provides the best ROI: KNIME, Alteryx or RapidMiner?
- 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?