Alteryx OverviewUNIXBusinessApplication

Alteryx is the #1 ranked solution in top Predictive Analytics tools, #1 ranked solution in top Data Preparation Tools, and #2 ranked solution in top Data Science Platforms. PeerSpot users give Alteryx an average rating of 8.4 out of 10. Alteryx is most commonly compared to KNIME: Alteryx vs KNIME. Alteryx is popular among the large enterprise segment, accounting for 75% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 21% of all views.
Alteryx Buyer's Guide

Download the Alteryx Buyer's Guide including reviews and more. Updated: June 2023

What is Alteryx?

Alteryx can be used to speed up or automate your business processes and enables geospatial and predictive solutions. Its platform helps organizations answer business questions quickly and efficiently, and can be used as a major building block in a digital transformation or automation initiative. With Alteryx, you can build processes in a more efficient, repeatable, and less error-prone way. Unlike other tools, Alteryx is easy to use without an IT background. The platform is very robust and can be used in virtually any industry or functional area.

With Alteryx You Can:

  • Prep, blend, and analyze data
  • Deliver faster, better business outcomes
  • Automate analytics and data science
  • Embed intelligent decisioning
  • Deploy and share analytics in hours

Alteryx Features Include:

Some of the most valuable Alteryx features include:

Scalability, stability, flexibility, fast performance, no-code analytics, data processing, business logic wrapping, scheduling, ease of use, data blending from different platforms, geo-referencing, good customization capabilities, drag and drop functionality, intuitive user interface, connectors, machine learning, macros, simple GUI, integration with Python, good data transformation, good documentation, multiple database merging, and easy deployment.

Alteryx Can Be Used For:

  • Combining and manipulating data within spreadsheets: Alteryx can be used in situations where complex data manipulation occurs. It can handle large data quickly, and the process is much simpler to see and understand.

  • Database access and supplementing SQL development: Alteryx has several sets of database connectors and functions, including many functions that your average database does not. Alteryx can work with data from multiple databases or areas within a database. It allows users to filter, sort, calculate, etc. as they would commonly do in SQL or an ETL tool.
  • API, cloud, and hybrid access: Alteryx can read and write data in databases, files, REST APIs, and a myriad of other locations (with the correct permissions). When a workflow is published, you can also call a workflow through a REST API to start it.

  • Data science: Alteryx provides pre-built models that are extremely useful for data scientists who may have limited programming skills and also gives you the ability to add R or Python code directly within a workflow.

  • Geospatial analysis: Alteryx gives users drag-and-drop tools to geocode, plot, and map locations, customers, competitors, or anything that has a location (employee, truck, pipeline, etc.).

  • Reports and dashboards: Alteryx provides built-in tools that enable the building of reports and dashboards.

Alteryx Benefits

Some of the benefits of using Alteryx include
:

  • Saves time: Alteryx helps shorten 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.

  • Clear tool configurations: Alteryx provides simple and concise tool configurations that are quick and easy to set.

  • Excellent workflow compatibility.

  • Reduced development time: Alteryx has an extensive gallery of user-developed analytic applications that helps to reduce development time.

  • Fast data loading: Alteryx has tools that make it very effective when working with big data sets.

  • No-code, low-code analytic building blocks: You can prep, blend, and analyze data to enable highly configurable and repeatable workflows.

  • Machine learning: Alteryx allows you to quickly create properly trained algorithms that are ready to deploy.

Reviews from Real Users

"Automation is the most valuable aspect for us. The ability to wrap business logic around the data is very helpful." - Theresa M., Senior Capacity Planner at a financial services firm

"Alteryx has made us more agile and increased the speed and effectiveness of decision making." - Richard F., Director, Digital Experience & Media at Qdoba Restaurant Corporation

"The scheduling feature for the automation is excellent." - Data Analytics Engineer at a tech services company

"The product is very stable and super fast, five-star. It's significantly more stable than its nearest competitor." - Director at a non-tech company

“A complete solution with very good user experience and a nice user interface.” - Solutions Consultant at a tech services company

"There are a lot of good customization capabilities." - Advance Analytics PO at a pharma/biotech company





Alteryx Customers

AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy Queen

Alteryx Video

Alteryx Pricing Advice

What users are saying about Alteryx pricing:
  • "The desktop platform costs $5,000 per year. It's very costly."
  • "It's probably on the pricey side, but they provide some really useful ways to grow and test."
  • "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).​"
  • Alteryx Reviews

    Filter by:
    Filter Reviews
    Industry
    Loading...
    Filter Unavailable
    Company Size
    Loading...
    Filter Unavailable
    Job Level
    Loading...
    Filter Unavailable
    Rating
    Loading...
    Filter Unavailable
    Considered
    Loading...
    Filter Unavailable
    Order by:
    Loading...
    • Date
    • Highest Rating
    • Lowest Rating
    • Review Length
    Search:
    Showingreviews based on the current filters. Reset all filters
    President with 51-200 employees
    Real User
    Plenty of capability and works well for those who don't want to program and don't use algorithms heavily
    Pros and Cons
    • "You get more support with Alteryx, and it's good for non-sophisticated users who can benefit from the support included in the price."
    • "I think they should really work on integrating or have a capacity to integrate some algorithmic code. I think that's one of the most important things they need to be doing."

    What is our primary use case?

    At the time, I used the solution for data preparation and data handling, which is cleaning the data and then working with the data, and linking different data effects. 

    The solution is on-premise. I use it on my desktop.

    What is most valuable?

    Alteryx is great for someone who doesn't want to program and doesn't fiddle too much with the machine learning algorithms. If you need to do sophisticated things (if you're a real data scientist), then Alteryx is not the right way to go. For most users, there is plenty of capability and that's enough for more mundane use. The solution is rich and very flexible.

    They have the capability to integrate some oiutside coding, but I didn't invest enough time to understand how that can be done and what the limitations are. If someone needs to do it, I'm not sure if they will be able to save time in the process or if that is cumbersome or not. I haven't tested whether or not integrating R code is flexible enough to accomodate specific developments with both platforms. Integrating optimized algorithms for the sake of automation would be great.

    What needs improvement?

    The biggest limitation is that the solution doesn't allow you to do sophisticated things in terms of fiddling with their implementations of machine learning and deep learning components.

    I think they should really work on integrating or have a capacity to integrate tailor-made algorithmic code. I think that's one of the most important things they need to be doing.

    What do I think about the stability of the solution?

    Alteryx is very stable.

    Buyer's Guide
    Alteryx
    June 2023
    Learn what your peers think about Alteryx. Get advice and tips from experienced pros sharing their opinions. Updated: June 2023.
    710,326 professionals have used our research since 2012.

    How are customer service and support?

    I haven't needed technical support, but they seem to be very available to talk. The people that I spoke to in Alteryx were very reactive and present. The moment you download the software, someone will call you, try to get in contact with you, and try to understand what your needs are.

    How was the initial setup?

    I only installed the desktop and it's like any PC-type software. It's done in a few minutes, so it's easy. The server part is something else, and I haven't tested it so I can't elaborate on it.

    What's my experience with pricing, setup cost, and licensing?

    I tested the solution for a long time so I never actually bought the software, although Alteryx is very costly. In comparison, KNIME is free.

    To start with Alteryx, you need to pay for the desktop. The desktop platform costs $5,000 per year. You probably get more support with Alteryx, and it's good for non-sophisticated users who can benefit from the support included in the price.

    Which other solutions did I evaluate?

    KNIME is probably the alternative to Alteryx for someone who needs a package. The package can do a lot of things without needing too much programming and with zero code. It's very good for someone who needs access to algorithmic content without needing to develop it. However, I don't have concrete experience using it.

    They are both very good packages for someone who wants to develop dashboards or use algorithms without knowing the nuts and bolts or with limited coding. They are very practical. The difference between the two platforms is very limited. They are equivalent.

    I used Alteryx for data preparation, and KNIME can do it just the same. The two are very close in terms of concept and the way the two softwares work, but there are lots of tools for data preparation. Right now, I use a lot of loose programming. I develop scripts with R, and that is the most effective way I've seen because I can do whatever I like. I have 100% flexibility.

    I think that a real data scientist would go with R or Python and use Spark. It's a totally different world, and these softwares need much more investment in time and effort to understand how to use them. It's a lot of work, whereas Alteryx and KNIME are for the casual user. They are more for the people who are in companies and need to work on data without clearly understanding the mathematics behind it.

    What other advice do I have?

    I would rate this solution 9 out of 10. 

    Alteryx is the kind of software that a corporation would want to go with and to deploy on for people who are not really data scientists and that have to use data, design dashboards, have to clean and prepare data and so on. That's an effective way to use Alteryx. To go for a sophisticated data science type of added value, a data scientist would want to work with programming languages and use a lot of the libraries that are available. At some point, they would want to put all this code and integrate this code into the platform so that less sophisticated users can use the analysis done outside operational lines.

    This is definitely the kind of software that is a time-saver if you want to start working on different data sources or a lot of data sources, and you want to work with the data, angle the data, cross-link and so on. It's very good and very easy to use. It's visual, so it's easier to understand what you are doing. When it comes to putting some intelligence into it, it's enough for most people. There is enough that is loaded into software that can help you. The Alteryx interface may be easier to understand than KNIME. You are able to do some nice things with it in just a week.

    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.
    PeerSpot user
    Manager, Transformation & Hyperautomation at a real estate/law firm with 10,001+ employees
    Real User
    Powerful technical support, simple installation, with useful data prep and blending tools
    Pros and Cons
    • "I believe that the ability to leverage the gallery for scalability, as well as the general data blending functionality, is most beneficial to our core-based users."
    • "The data integration component could most likely be improved to increase enterprise scalability."

    What is our primary use case?

    The use cases range from basic EPL to predictive analytics and spatial analytics.

    How has it helped my organization?

    For example, within our functions group and our larger finance organization, we have a number of use cases where people are doing a lot of manual work, mostly in Excel. This has enabled us to move away from that, resulting in not only streamlined processes and efficiencies but also a significant increase in our ability to have confidence in that data. If the need arises, we may need to refresh data or revisit something.

    It essentially automates what would otherwise be some extremely tedious activities to rerun and re-perform.

    What is most valuable?

    I believe that the ability to leverage the gallery for scalability, as well as the general data blending functionality, is most beneficial to our core-based users. Obviously, there's a lot more to it, but these basic data prep and blending tools help us a lot.

    What needs improvement?

    In some ways, I believe it is not yet as integrated as it could be. I believe that the data integration inquiring component could be improved slightly.

    The data integration component could most likely be improved to increase enterprise scalability.

    For how long have I used the solution?

    I have been working with Alteryx for two years.

    It varies, but it will be the 2021 version.

    What do I think about the stability of the solution?

    The stability of Alteryx has been great.

    What do I think about the scalability of the solution?

    It is highly scalable for the vast majority of things you want to do. When it comes to extremely large data sets or very specific analytics that would be delivered at an extremely high scale, either really, really tremendous scale or tremendous volume may be problematic. However, those are only a small number of possible scenarios. As a result, it hasn't been a problem for us, but we've switched to another technology for those types of use cases.

    The roles are extremely varied. We have over 100, and less than 200, but that will increase in the coming months.

    We are currently at capacity in terms of licenses. So we're looking to go from the low triple digits to over 1000 in the next year, maybe a year and a half. I believe we will quadruple in the coming year.

    How are customer service and support?

    Technical support is quite powerful. I believe you must know how to take advantage of it, but I believe they have the necessary infrastructure in place to get you where you need to go. I believe it is somewhat incumbent on the organization to have someone serve as that contact, that partner. They're fine as long as you keep your end of the bargain.

    Which solution did I use previously and why did I switch?

    We switched because we wanted to. We didn't have anything that could do everything Alteryx did, in my opinion. We had some minor transformation tools and such, but nothing that could truly compete with Alteryx.

    How was the initial setup?

    The initial setup is straightforward.

    That's something we're still working on. We started with about 100 licenses and identified areas where we thought it could add value. That has been demonstrated, and we are working to scale significantly over the next year. It's been a two to four-year journey from discovery to widespread adoption.

    What about the implementation team?

    The majority of the work is done in-house. We initially worked with Alteryx, but it was primarily done in-house.

    What was our ROI?

    It has certainly paid for itself on a per-user basis. We haven't done a group ROI yet. But it more than pays for itself. Our "highlights" are quite powerful. The more prominent business cases are extremely compelling.

    What's my experience with pricing, setup cost, and licensing?

    It's not cheap, but they offer a variety of packages to help you grow in practices and programs that allow you to scale effectively while also testing how deep the use can penetrate while allowing you to really reduce the risk. They offer various bundles in which they offer free licenses as well, so you can essentially see if you're able to use them consistently. Then, the next time, you can add that number or various other programs. It's probably on the pricey side, but they provide some really useful ways to grow and test.

    If you're serious about scaling, you'll need a product manager, which is a major cost aside from the license.

    Which other solutions did I evaluate?

    We evaluated other products.

    What other advice do I have?

    Simply strike a balance between democratizing the use of data transformation and analytics and having a vision for how you might want to roll things out. I think it's not the easiest thing to strike that balance, but that's my recommendation. To try to have a plan, but also to make sure you're not putting up too many barriers.

    I would rate Alteryx an 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.
    PeerSpot user
    Buyer's Guide
    Alteryx
    June 2023
    Learn what your peers think about Alteryx. Get advice and tips from experienced pros sharing their opinions. Updated: June 2023.
    710,326 professionals have used our research since 2012.
    Anamita Anuva - PeerSpot reviewer
    Graduate Assistant at a university with 501-1,000 employees
    Real User
    Top 10
    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.
    Flag as inappropriate
    PeerSpot user
    Data Analytics Engineer at a tech services company with 11-50 employees
    MSP
    Top 20
    Easy to set up with a good interface and straightforward scalability
    Pros and Cons
    • "The scheduling feature for the automation is excellent."
    • "The technical support could have a little bit of improvement."

    What is our primary use case?

    Most of my use cases have been around just helping customers out, specifically in the financial sector. Within our company, I've been automating the reports, project reports, and using it mostly for the automation of weekly reports in our company.

    What is most valuable?

    The scheduling feature for the automation is excellent. The machine learning suite has been pretty useful in terms of building models. I've been exploring it for a while. The in-database tools are extremely useful as well.

    The interfaces are perfect.

    The solution is easy to set up.

    The stability is quite good. 

    We have found that the scalability is good and very easy to handle.

    What needs improvement?

    I still haven't had any issues with the Alteryx designer. I don't have anything to speak negatively of now, however, I'm sure there are some features that need improvement.

    The technical support could have a little bit of improvement.

    They should work to make the solution less expensive. 

    The product needs some more tools for the image processing part. That would be pretty good. There's an image processing suite, however, it could use a little bit of improvement as well as the visualization aspect. 

    They should maybe add some capabilities for more interactive dashboarding. That would be great.

    For how long have I used the solution?

    I've been using Alteryx for a while now. I'm still learning about it. I'm still exploring it, but I've been using it for a while.

    I've been using it for a little bit over six months now.

    What do I think about the stability of the solution?

    The product has been pretty stable, however, we aren't heavily utilizing the solution. It's hard to pass a fair judgment on our part, as we don't have that many users and the utilization of the server and designer haven't been very heavy so far. That said, for us, it's been extremely stable.

    What do I think about the scalability of the solution?

    The scalability is extremely easy and very straightforward on Alteryx, especially the server for the controllers. You can easily start adding nodes for workers as well. The scalability is one of the things that get our customers mostly excited about how easy it is to start scaling the server.

    In our organization, we have four Alteryx designer users and eight or nine server users.

    How are customer service and support?

    Technical support is okay and could be better. Sometimes, it takes about two to five days to hear an answer from the technical support team. That said, when they do reply, they're very helpful. The community is very helpful. However, due to the fact that there's such a wide range of issues that could be going on, you could get lost in trying to find a solution on the community.

    Which solution did I use previously and why did I switch?

    I have not personally used any different solution. 

    How was the initial setup?

    The initial setup is extremely straightforward.

    It took about 30 minutes for the designer and the server overall to be deployed. It was easy and it's really fast. 

    There isn't much maintenance needed. I handle all of the maintenance myself. 

    What about the implementation team?

    Everything was handled by the company in-house. We didn't need any help from consultants or integrators. 

    What was our ROI?

    While we have personally seen ROI so far, I wouldn't be the one to make that judgment as to how much. That's mostly due to the fact that I'm the data engineer. I don't have a look at the numbers. I just automate processes and help customers out. That said, customers are happy with their investment in this product overall. 

    What's my experience with pricing, setup cost, and licensing?

    Since we're partners, we get licenses. That said, from the feedback I hear, the price is a little bit more on the expensive side.

    We do yearly subscriptions. There are machine learning suites that do come at an extra cost as well. 

    What other advice do I have?

    We are partners with Alteryx.

    I'm using version 21, the latest version, which may be either 21.1.4 or 0.3.2.

    I would advise potential new users to go through the community to learn. They should go through the learning path for the Alteryx solution for both the designer and the server. It's good to take it slowly. New users should be able to do this within a month or two. The solution is pretty straightforward to learn.

    I'd rate the solution at an 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.
    PeerSpot user
    Associate Managing Director at a financial services firm with 10,001+ employees
    Real User
    Top 5Leaderboard
    Great visibility with drag-and-drop functionality and an active community
    Pros and Cons
    • "I like that I can merge data from different sources into one place."
    • "I'd like it to be easier to work with PDF."

    What is our primary use case?

    The biggest use case for the solution is that it allows you to it allows me to combine data from different sources and different formats to create a unified data set to answer business questions. I can take data from my general ledger and combine it with my expense report data or with external data or with different parties or different questions, and it could all be in a different format. For example, one source can be from a database, one can be an Excel file, one can be a PDF, or a CSV file. Alteryx lets me very easily put them all together and create one database. 

    What is most valuable?

    The biggest thing I like is that you need zero coding experience. I'm not a coder. I'm an accountant by trade, and I've been able to pick up the tool fairly quicker, basically.

    The tool is very drag-and-drop. The tool has very good documentation to help you understand the features.

    The community is very active and helpful.

    I like that I can merge data from different sources into one place. 

    With this solution, we can do reporting in about five minutes as opposed to day.

    Once we've vetted the data, we can get the solution to run during off-peak hours so we can out data very easily. 

    There's a lot less maintenance required.

    We like that we can make notes right on their Canvas, so it's easy to pass workflows over to other users.

    The visibility is very clear. We can show what data is being used and how it is being transformed.

    My true data is able to stay intact even though I can easily manipulate it. 

    What needs improvement?

    I'd like it to be easier to work with PDF. When you want it to read PDFs, it can be a bit difficult. That may be a PDF issue, however. 

    Maybe if I was doing more spatial or geographical tasks, I might need a bit more; however, for my purposes, I have all the features we need. 

    For how long have I used the solution?

    I've been using the solution since 2017 or 2018. I've used it for five to six years on a daily basis. 

    What do I think about the stability of the solution?

    I find that the Designer is stable since it's on my machine. Sometimes the server environment is not the most stable. I'm not sure if that's due to the fact that we don't have enough cores or whatever that might be; however, that's something that's probably a little less stable, the server at the bottom. Again, the servers will be used to run flows, not to create the flows.

    The Designer is where you create the process and your logic, and you can use a Server to run the processes at different times throughout the day.

    What do I think about the scalability of the solution?

    The scalability is fine. That said, the pricing model is not the cheapest. You have to be careful who will be using it. The pricing is the only hindrance to scaling. 

    We have around 300 to 500 licenses. It's pretty mature in our organization. 

    How are customer service and support?

    We have a great relationship with technical support. They are helpful and responsive, and they have a great community.

    Which solution did I use previously and why did I switch?

    I'm not sure if the company used something previously.

    How was the initial setup?

    In order to deploy it, you need to have Alteryx Designer. You have to have that installed on your machine. We have a yearly license and you just basically renew your license with Alteryx to keep it active. 

    In order to maintain our flows, there is very little maintenance needed. 

    What was our ROI?

    We have witnessed excellent ROI. The fact that we can schedule flows and reduce time and entry to market has been extremely positive for the company. 

    What's my experience with pricing, setup cost, and licensing?

    The pricing is reasonable; however, if you need a lot of licenses, it will get expensive. 

    What other advice do I have?

    I am not using the latest version of the solution. We're always one or two versions behind the latest, as we only do updates once or twice a year. 

    The great thing about the solution is that if you know Excel well, it translates very well into Alteryx. It's important to have an open mind; however, I'd recommend everyone give it a try. 

    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.
    Flag as inappropriate
    PeerSpot user
    Analytics Insights - Manager at a consultancy with 10,001+ employees
    Real User
    Top 5Leaderboard
    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.
    Flag as inappropriate
    PeerSpot user
    PeerSpot user
    Director at Decision Science
    Real User
    Top 5Leaderboard
    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.
    PeerSpot user
    Alberto Guisande - PeerSpot reviewer
    Alberto GuisandeDirector at Decision Science
    Top 5LeaderboardReal User

    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.

    Sharath Chander - PeerSpot reviewer
    Business Transformation specialist at a tech consulting company with 10,001+ employees
    Real User
    Top 10Leaderboard
    Fast, reliable, and low-code
    Pros and Cons
    • "The cloud deployment ensures it scales easily."
    • "The solution is improving continuously. They have, for example, just added automatic insights. If they continue to improve on their overall service offering, that would be ideal."

    What is our primary use case?

    Right now we have huge amounts of data metrics. We have a marketing team. We have sales. We have a networking team. We have door-to-door. In terms of data preparation, this solution was the primary method to get the data from many sources. It is easy for us in terms of integrating with the cloud and we can do most of the preparation. We can enable Alteryx to handle our data preparation, and sometimes you can enable it to set a pipeline and it can be stored in CCP. We mostly use it for working with Tableau. We're currently running it for multiple use cases.

    What is most valuable?

    The best thing is that the product is low-code and mostly no-code. It can be used dynamically by both customers and the internal team also. 

    In terms of speed and reliability, it is comparatively good and actually leads the pack in terms of competition.

    It is easy to set up.

    The cloud deployment ensures it scales easily.

    The solution is extremely stable.

    What needs improvement?

    The solution is improving continuously. They have, for example, just added automatic insights. If they continue to improve on their overall service offering, that would be ideal.

    For how long have I used the solution?

    I've been using the solution for quite some time - almost four years. I used it when it was being a stand-alone application and now we are using Alteryx Cloud with integration to Trifacta.

    What do I think about the stability of the solution?

    The solution has been highly stable and reliable. The cloud is very stable. There are no bugs or glitches, and it doesn't crash or freeze. 

    What do I think about the scalability of the solution?

    We have 200 to 250 people working with the product in my company.

    We faced a few issues with scalability in the past when it was a desktop application. However, after we started to use the Alteryx Analytics Cloud, this application has been really stable in terms of scalability. Initially, we started the trial with 30 people. Now we have around 200 to 250 people who currently use Alteryx Cloud. It scales quite well for us now.

    How are customer service and support?

    We have a special SME which is assigned by Alteryx to our organization. If we have any problem, we reach out to them in terms of any support. Mostly, myself and my team have never needed to connect with tech support as it is highly stable. The only thing we've had problems with is having issues around how we can automate the workflow. When we have questions like that, we just check with them.

    Which solution did I use previously and why did I switch?

    We've been testing RapidMiner for quite some time. We wanted to have another option in pipeline if there happen to be any stability issues and budget issues happening or if the cost of Alteryx becomes an issue. However, in terms of RapidMiner, we have not fully used it for multiple reasons.

    How was the initial setup?

    The initial setup is very simple and straightforward. I've used it for a long time and previously used it as a desktop application. While it was simple then, now that they've moved to the cloud, it's even easier. 

    What's my experience with pricing, setup cost, and licensing?

    The solution is now quite expensive. You need to have a budget for it. However, if you do, it is worth the cost.

    What other advice do I have?

    We're a customer and end-user.

    We are using the cloud deployment and, therefore, always on the latest version as it updates itself. 

    I'd recommend the solution to others.

    I would rate the solution nine out of ten. It's been highly useful for my organization in terms of data strategy. In terms of usability and scalability, Alteryx is the best.

    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.
    Flag as inappropriate
    PeerSpot user
    Buyer's Guide
    Download our free Alteryx Report and get advice and tips from experienced pros sharing their opinions.
    Updated: June 2023
    Buyer's Guide
    Download our free Alteryx Report and get advice and tips from experienced pros sharing their opinions.