IT Central Station is now PeerSpot: Here's why

Alteryx OverviewUNIXBusinessApplication

Alteryx is #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 out of 10. Alteryx is most commonly compared to KNIME: Alteryx vs KNIME. Alteryx is popular among the large enterprise segment, accounting for 69% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a computer software company, accounting for 23% of all views.
Alteryx Buyer's Guide

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

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

Archived Alteryx Reviews (more than two years old)

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
Director at a non-tech company with 11-50 employees
Real User
Stable and very fast with good scalability options
Pros and Cons
  • "The product is very stable and super fast, five-star. It's significantly more stable than it's nearest competitor."
  • "The only area where the product lags is documentation and videos on the analytical app and the batch macro."

What is our primary use case?

Our clients buy the product license and then ask us to configure and set it up for them. We also provide training on product use and act as troubleshooters if customers have problems. The company has a 15-member team that provides training and consulting on multiple technologies. We have clients who are from tax, audit, and automation. They also use Automation Anywhere and Robotic Process Automation Application. There are three primary use cases for this product.  Firstly, we have a case study that involved lot of buy and sell transactions in Dubai (real estate). We wanted to create a model that takes up all the data sets that are frequently upgraded, and then be able to extract a ballpark transaction value based on multiple parameters. A big task was to sanitize the data including how to handle incomplete data sets. Secondly, it is used to automate reconciliation of tax related system entries. For example, or for tax reconciliation such as a client in India where there is something similar to VAT called GST, a requirement to reconcile different transactions and make sure both party's accounting books match. Finally, there is a case where you have your own accounting software such as SAP and it has to talk to another software application, which is not SAP compatible so we use Alteryx.

What is most valuable?

There's no single feature I can think of that stands out as being the most valuable, but we've worked on multiple areas such as analytical apps, especially to connect with Facebook, LinkedIn, and multiple other online data APIs. We also use batch macros to automate and repeat steps many times over. These two features help us a lot. They are slightly more advanced, so it's not for a regular user, but these are the areas where people ask for assistance.

What needs improvement?

I think the only area where the product lags is documentation and videos on the analytical app and the batch macro. We have learned the hard way, but I see people struggling there. Secondly, the tools for data science are not as user-friendly as KNIME. Additional features that could be included would be improved documentation, more user-friendly data science, and the pricing should be more competitive. 

For how long have I used the solution?

I've been working with the product for 1.5 years. My team has been working with it for 3+ years. 
Buyer's Guide
Alteryx
June 2022
Learn what your peers think about Alteryx. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
607,127 professionals have used our research since 2012.

What do I think about the stability of the solution?

The product is very stable and super fast, also five-star. In fact, the reason people use Alteryx is that it's fast. It's significantly more stable than the nearest competitor.

What do I think about the scalability of the solution?

Scalability is excellent, five-star. 

How are customer service and support?

Technical support is very forthcoming in helping people out.

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

We use several solutions for our clients. The two main ones are Alteryx and KNIME. Probably 90% use Alteryx and 10% KNIME. 

How was the initial setup?

The initial setup is straightforward. 

What other advice do I have?

I would suggest that the decision to purchase the product should be based on a company's level of deployment. If it's for a process for a pharma company, which is a smaller enterprise. then I recommend starting with KNIME. As the data gets bigger, switch to Alteryx.  I think they should have a student version just like Tableau does. Not all the tools, but the basic top 10 or 15 tools. The reason I suggest this is because there's a huge need for Alteryx users, but because of its 14-day trial period, a lot of students cannot get a handle on it so a scaled-down light version would be good. I would rate this product an 9 out of 10. 
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
Real User
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.
Buyer's Guide
Alteryx
June 2022
Learn what your peers think about Alteryx. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
607,127 professionals have used our research since 2012.
Technology Sales & Cybersecurity Professional at a computer software company with 51-200 employees
MSP
End-users can complete analysis projects without knowing the code but there should be both cloud and on-premises options
Pros and Cons
  • "The ease-of-use allows non-technical business users to directly create their own solutions without the use of additional development resources."
  • "There is currently no cloud solution and this would be valuable for many clients."

What is our primary use case?

The team uses Alteryx for many things because they code various algorithms to create different dashboards. These are used as solutions for various things from sales to customer experience to whatever else the customer needs. So there are many areas where the team is using the product. There is not one, but as of now, there are some 30 different use cases that we have.  

How has it helped my organization?

The ease-of-use has allowed our business users to directly create their own solutions without the use of additional development resources.  

What is most valuable?

I think the most valuable feature is the ease of use for my business scientists. They do not need to be experts in R and Python coding, and they can do their complete analysis projects without knowing the code. I think that one of the biggest reasons we are depending on Alteryx.  

What needs improvement?

I'm sure there is always development happening with the product, but I think there should be both cloud and on-premises options. We have not seen a cloud deployment and have not heard they will be making one available. I think if there is the cloud deployment available, it would definitely be more convenient for some users to engage with and use while lowering the implementation costs.  

Cloud deployment would be easier for us and our clients because a lot of services that we push to the clients are through the cloud only. It is expensive to buy additional licensing, and it is time and resource consuming to install onto our own hardware — which itself requires maintenance and administrative attention. On-premises can raise the cost of deployment over just using a cloud enrollment option.  

For how long have I used the solution?

We are one of the main solution providers in the region and we have been using this solution for almost two years.  

What do I think about the stability of the solution?

The solution is stable. We experience no bugs, glitches or crashes.  

What do I think about the scalability of the solution?

We can scale usage of the product as much as we want and we do that depending on the instructions that we have from the client. It is quite scalable in that regard.  

We have more than 50 users who are using this solution within our company. They are a mix of data scientists, administration and business users as well.  

Alteryx is used quite extensively in our organization and we are planning to increase the usage in the short term.  

How are customer service and technical support?

We are sometimes in touch with Alteryx technical support. If I had to evaluate them, the waiting times are not long, the response, in general, is pretty good. So we are satisfied with their support work.  

How was the initial setup?

I would say the initial setup is straightforward. It takes the technical team just a few days to deploy this solution. It is deployed in days, not months or weeks.  

In terms of deployment, you only really need one person to complete it and that is good enough. You might use two technicians depending on the skill set, the scale of the deployment and the business areas the client focuses on. The maintenance is pretty cheap. The same people that do the deployment manage it for us.  

What about the implementation team?

We do not use an integrator, seller or consultant for the deployment as our team has training and they do these things.  

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

We have a yearly cost that we pay for the licensing. We do not pay any costs in addition to the licensing fees. The technical support is included as part of the fees that we pay.  

Which other solutions did I evaluate?

Before we choose Alteryx, we did weigh other options from different vendors. In fact, we still use other technologies. We cannot properly service client needs by just using Alteryx as the only solution we offer. Because client needs differ, we are using other products that we evaluated and determined were also serviceable technologies to deliver for client use.  

What other advice do I have?

Advice that I would give to people considering Alteryx as a solution depends on the real needs from business to business and in accord with what use cases they have. I think Alteryx definitely takes away the potential problem of having to have a lot of technical expertise. Any business user can use Alteryx to develop their business case and use the program's options much quicker without having the technical knowledge and programming know-how. It really depends on the skills and resources of the individuals in the company. They should use Alteryx if they want users to be able to walk through the process and deploy their own use cases without having a deeper technical knowledge and skills that other products may require.  

What we have learned from using the product is that it is definitely a great advantage for the business users to not need to have great technical skills and programming knowledge to complete their analysis. The business users can build their own analytical use case, visualize what they want to do more easily and quickly, and revise it without any dependencies on other staff and additional communications.  

On a scale from one to ten where one is the worst and ten is the best, I would rate this product as a seven-out-of-ten.  

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
AmitJain - PeerSpot reviewer
Deputy Manager at Keppel
Real User
Does a good job of end-to-end integration as well as accessing data from multiple sources or email modes
Pros and Cons
  • "This is a drag-and-drop tool which is easy-to-use and yet can be customized by creating your own components."
  • "The GUI interface functions but it could stand to be updated to a more modern look and feel."

What is our primary use case?

I am using the product for making machine learning models for particular uses that we have to focus on analytics.  

What is most valuable?

I didn't like the data analysis features at first, but they were actually quite good. The built-in machine-learning models that they have are quite extensive and useful. There are a few models that are normally not found in any other drag-and-drop interface platforms. For example, when I was using and testing other tools, I could not find vector autoregression models. I also could not find the rather complicated tentative models and other model types that I find very useful. Those are built-in to Alteryx as cubes. On top of that, the capability of writing Python commands and creating our own tools and our own models for machine learning make the solution customizable and quite interesting.  

What needs improvement?

There are a few ways the solution could be made better. The graphical user interface could be made more friendly. I mean from the GUI point of view, it is a little dated. But from a functionality point of view, I think even for people who do not know the coding part and who are more business users than programmers, they would not have a very hard time using  Alteryx for creating machine learning models. It is quite good and quite useful already without improvement to the GUI. It could just stand to be more modern-looking. 

I would like if they could make some type of free license for the product. Not a free full license but a limited edition or limited capability free version. The limited-time version is a little restrictive. A free, open-term desktop version like Power BI and Tableau and KNIME might help users more with discovery and utility.

For how long have I used the solution?

I've used this solution for about five or six months.  

What do I think about the stability of the solution?

We were using Alteryx from a development point of view. We did not use it to test it to its breakage point. So it handled our demands and was quite stable.  

The response time was quite good. Even running on a laptop, it was like using it on my desktop. The response is consistent, fast and stable.  

What do I think about the scalability of the solution?

From my experience and from my point of view, the solution is quite scalable. We did not use it for the production system yet, but from my experience of using it on a laptop more recently, it runs with a few hundred thousand rows and columns without a problem.  

The other good side of the scalability is the number of connectors available for data sources. They have more than 200 connectors, which allows access to well more sources than anything I have needed.  

How are customer service and technical support?

I did not contact the technical support at Alteryx directly. When we initially got the license, they had us talk to the local support here in Singapore. We went to them for a small issue to see what exactly the product can do and then we did not need any support from their support at all. We are quite adept with this solution and modeling. We called up the Alteryx local support to show us how to do that one thing but it was very easy. Once we saw it, we did not have additional reasons to contact them again.  

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

Before Alteryx we tried of KNIME. The learning curve for KNIME is steeper than Alteryx. Alteryx is much more user-friendly than KNIME, at least from our experience on both products. Also, KNIME functionality is limited for the free version so it was harder to explore the full capabilities. When we tried the free license for Alteryx, we got the full use of the client license for 14 days and then we were able to get an extension to explore our testing of it for some time. But we did use KNIME before that for long enough to be familiar with the differences. My impression of Alteryx is that it is more user-friendly than KNIME and the built-in modeling in Alteryx is much better than KNIME.  

How was the initial setup?

The initial setup was very straightforward. I was able to install it and get it running up and running quickly and the process was very simple.  

When I started doing a machine-learning model in a project writing my own code, it took me in-all about three or four days to complete it. For my initial experimentation, I decided to replicate that model in Alteryx. As someone who understood models but did not know the program at all, it took me two hours or less than that to complete the test. Once you learn how to drag-and-drop things in the interface, it is very easy to start on development as long as you know what you want to do.  

What about the implementation team?

We did not use any help as far as an integrator, reseller or consultant. We did the deployment ourselves.  

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

Our approximate cost as we understand from the company is that the total is $5,000 per user per year for the desktop production license. So, for us and the ten licenses we need, that means the production license would be around $50,000 per year. That might not be the exact number, but I think it is close enough to be correct. With that, there are not any additional costs. Probably you can pay for support and for training if you want something like a dedicated workshop. That might cost more as an add-on but there is no additional cost for using the tool itself.  

What other advice do I have?

I have a really good impression of Alteryx at this point in time. So I would suggest to people who are considering this type of solution to go ahead and try it. If you are looking for a self-service data analytics tool, Alteryx is a good solution. It does a good job of end-to-end integration as well as accessing data from multiple sources or email modes. Then you can push data out to Tableau and Power BI or tools like that if you need other capabilities. So, 'go ahead and try it' would be my recommendation.  

On a scale from one to ten where ten is the best and one it the worst, I would rate Alteryx as easily a solid eight. From my use case and considering the point that I'm not seeing and using everything, I can't give it more or less. But from our use case and what we have in our company, it is pretty good for several purposes.  

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.
ArqumKhalid - PeerSpot reviewer
Business Intelligence & Data Analyst at a non-tech company with 501-1,000 employees
Real User
Excellent predicting power, good accuracy, and easy to set up
Pros and Cons
  • "The solution offers excellent predicting power. The accuracy and confidence have been great."
  • "The solution could work on the BI side of the tool to make it a bit better."

What is our primary use case?

We primarily use the solution for basic data analysis and forecasting.

What is most valuable?

The giga size is very good. 

The solution offers excellent predicting power. The accuracy and confidence have been great.

You don't have to be tech-savvy or technical to use the solution. There's a lot of drag-and-drop functionality.

What needs improvement?

The visualization could be improved, as could the BID bots.

The solution could work on the BI side of the tool to make it a bit better.

For how long have I used the solution?

I've been working with the solution for five or six months.

What do I think about the stability of the solution?

I've liked working with Alteryx so far.

What do I think about the scalability of the solution?

The solution is totally scalable. Users can work with the data at all levels and determine if you want to scale it. You just have to choose the product model with the larger amount of data.

How are customer service and technical support?

The technical support is very good.

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

I've worked with other solutions such as Knime, among others, however, in a corporate environment, I've only worked with Alteryx.

How was the initial setup?

The initial setup is very straightforward. You just need to go through the manual. Reading it makes everything easy.

Each deployment is different. Some jobs seem easy, but then the back end is complex. Other times it can be deployed in practically one click. It all depends on the customer requirements.

What other advice do I have?

We're Alteryx partners. We handle various deployment models, depending on the client's needs.

I've worked with other solutions such as Knime, among other tools for data science and data prep. It's great that this solution is just drag and drop and easy.

I'd recommend the solution. I'd rate it 9.5 out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Data Analytics Consultant at a tech vendor with 11-50 employees
Consultant
Advanced solution that checks the quality of my data
Pros and Cons
  • "Alteryx is so advanced. It's just drag and drop."
  • "It would be great if Alteryx could take third party tools and incorporate them."

What is our primary use case?

My company uses Alteryx differently for each of our clients' individual cases.

How has it helped my organization?

It has helped across my organization.

Let's say we have a client that has been mostly using Excel for their data preparation, data casing, etc. By using Alteryx, they now spend most of their time in the data prep and then just go to reporting. It saves a lot of time.

What is most valuable?

I actually like all of their features. But the feature I have found most valuable is the data profiling. I can check the quality of my data and everything else. 

What needs improvement?

Alteryx is very good - I don't see any room for improvement. I can't think of any downside to Alteryx.

I use a lot of third-party tools with Alteryx. It would be great if Alteryx could take third party tools and incorporate them.

For how long have I used the solution?

I have been working with Alteryx around two years.

What do I think about the stability of the solution?

In terms of stability, Alteryx is stable.

What do I think about the scalability of the solution?

It is scalable. We currently have all of our almost 20 employees using Alteryx with plans to expand.

How are customer service and technical support?

Their technical support is good.

How was the initial setup?

The initial setup was straightforward. Depending on your machine it usually takes less than 20 minutes.

What other advice do I have?

Alteryx is very good. You can do literately anything on Alteryx. Alteryx is so advanced. It's just drag and drop. You don't need to know any coding or other technical stuff to use Alteryx.

On a scale from 1 to 10, where 1 is the worst and 10 is the best, I would rate Alteryx a 10. No doubt, a 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Sebastien Peyron - PeerSpot reviewer
Technical director, BGFi Data & Analytics - Asia Pacific at Positive Thinking Company
Real User
Good data preparation features help to provide flexible and accurate analytics

What is our primary use case?

We use this solution for self-service data preparation from data warehouses and data marts.

How has it helped my organization?

It gives the power back to the end-users. It brings flexibility and accuracy to our new analytics.

What is most valuable?

The most valuable feature of this solution is data preparation.

Alteryx Connect (data catalog) is also really important for us.

What needs improvement?

The event handling, such that the file system watcher, is in need of improvement.

For how long have I used the solution?

We have been using this solution for one year.
Disclosure: My company has a business relationship with this vendor other than being a customer: We are one of the principal partners and trainers of Alteryx in Singapore
Tableau Developer at Borrego Health
Real User
We use it for data blending and complex data manipulation and augmentation.

What is our primary use case?

Data blending and complex data manipulation and augmentation.

How has it helped my organization?

  • Fast return on investment
  • Increased data analytics productivity.

What is most valuable?

Workflows and a large number of tools were a quick QA methodology and rapid prototype creation tool.

What needs improvement?

More emphasis on extensible R and data augmentation interface design.

For how long have I used the solution?

One to three years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
User at KPMG
Real User
Fast data processing and cleaning features have improved my organization

What is our primary use case?

ETL.

How has it helped my organization?

Fast data processing and cleaning.

What is most valuable?

Crosstab and transpose.

What needs improvement?

Add inbuilt interactive visualization in Alteryx.

For how long have I used the solution?

One to three years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Director at a consultancy with 1-10 employees
Real User
It collects data, manipulation and some Geo-spacial mapping.
Pros and Cons
  • "The tools are built-in. You just plug and play, drag and drop, once you understand how to use the tools, it is easy."
  • "I think better visualization would be helpful to this solution."
  • "It is a little bit pricey."
  • "It seems to me that it is not always user friendly."

What is our primary use case?

It collects data and manipulation and some Geo-spacial mapping.

How has it helped my organization?

It provides opportunities to do some pretty complex tasks easily, without having to worry about the Java. The tools are built-in. You just plug and play, drag and drop, once you understand how to use the tools, it is easy.

What needs improvement?

I think better visualization would be helpful. In terms of data extraction, during the sequel queries of servers as an example, you can structure your sequel query and it's fine, very readable, but once you run it, it crashes into one complex single line, and makes it very difficult. Then you you almost have to go back to management studio, and run it through management studio and put it through restructuring, and it just seems to me that that's not very user friendly.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

It is a very stable solution.

What do I think about the scalability of the solution?

For our purposes, the scalability is fine. But, I think that scaling it for a big enterprise would probably be an expensive endeavor.

How is customer service and technical support?

I would rate the tech support a 7.5 out of 10.  They do not necessarily provide lots of hands on support themselves, instead they farm it out to partners and forums. 

How was the initial setup?

The learning curve for implementation was a bit steep. You pretty much have to teach yourself as you are setting up the solution. Once you do that, you are OK.

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

It is a little bit pricey. The desktop version is cheaper, it is on a one year license. And, if you want to do anything on an enterprise name it is quite expensive. The current pricing model may get to be too much in three to four years time.

Which other solutions did I evaluate?

We also considered DataBricks.

What other advice do I have?

I would advise that you should ask yourself what you need and want, and do a one-month trial.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Consultant at The Information Lab
User
Helps clean messy data and provides spatial analysis

What is our primary use case?

I implemented Alteryx for a logistics company. 

It helps clean messy data and provides spatial analysis.

How has it helped my organization?

We create workflows to automate central reporting and visualize data directly in Tableau. 

We use Alteryx everyday. Using the product, we earn a lot of time, which is used to do other tasks.

What is most valuable?

Multicategories exist in Alteryx: These categories are flexible and answer a lot of controlling rules.

What needs improvement?

  • Alteryx could be improved in the area of analytics and central governance. 
  • The next feature release should include easier reporting. 
  • Improvement in the coexistence of In-Database, Python and R tools.

For how long have I used the solution?

One to three years.
Disclosure: My company has a business relationship with this vendor other than being a customer: We are a partner of Alteryx.
Abdellah Benaoussar - PeerSpot reviewer
Professor Adjunct at a university with 5,001-10,000 employees
Real User
It saves time on a lot projects

What is our primary use case?

  • Data integration
  • Automation
  • Data analytics

How has it helped my organization?

It saves time on a lot projects.

What is most valuable?

The analytics are easy.

What needs improvement?

In the database, it should be more functional and connect to more big data, especially using IPI.

For how long have I used the solution?

More than five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Insights Analyst at a consultancy with 1,001-5,000 employees
Real User
Geo features have made spatial mapping large retail universes possible
Pros and Cons
  • "It allows for manipulation and automation, which has greatly reduced the amount of time required per project."
  • "Geo features have made spatial mapping large retail universes possible."
  • "A feature which allows the user to be able to click on an output (in a file browser) and see the creation of the module would be fantastic."
  • "When a process completes there is a notification, but the notification does not include the process's name."

What is our primary use case?

It handles multiple large data sources, and prepping/manipulating the feed to the Live dashboards for internal and external distribution.

How has it helped my organization?

It allows for manipulation and automation, which has greatly reduced the amount of time required per project.

What is most valuable?

Geo features have made spatial mapping large retail universes possible. The basic package of manipulation tools are the tools that my team use the most. It makes lengthy Excel processes seamless and lighting quick in comparison.

What needs improvement?

A feature which allows the user to be able to click on an output (in a file browser) and see the creation of the module would be fantastic. Also, when a process completes there is a notification, but the notification does not include the process's name.

For how long have I used the solution?

Three to five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Global People Analytics & Metrics Analyst at a manufacturing company with 10,001+ employees
Real User
Provides a single source of truth to help us see the bigger picture
Pros and Cons
  • "The value add of Alteryx is the agility for making changes, and speed of deployment."
  • "The learning curve is long, and there is lack of e-learning; the tool is not user-friendly to a non-technical user."

How has it helped my organization?

We can now provide a single source of truth and build a bigger picture.

What is most valuable?

The data preparation. We have high reporting needs and the data is stored in many different tools. We are moving to predictive analysis too. Still, we need an easy to deploy solution until the IT department finds a better solution to connect all data sources.

What needs improvement?

The learning curve is long, and there is lack of e-learning; the tool is not user-friendly to a non-technical user.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

No stability issues.

What do I think about the scalability of the solution?

No scalability issues, if it is accompanied with centralization or the organization has a strong top-down culture.

How are customer service and technical support?

I would rate tech support five out of five. The team is willing to work with you and help with any difficulties.

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

We were using Oracle BI, and we are still using it. The value add of Alteryx is the agility for making changes, and speed of deployment.

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

The seat is too expensive.

What other advice do I have?

I am using the desktop version. The only issue is it supports only a 64-bit system so I have to use an earlier version.

My advice to regarding this product is to keep learning and not rely too much on the support team.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user570999 - PeerSpot reviewer
Billigence VP for Europe at a tech services company with 51-200 employees
Consultant
Has predictive models, which are easy to use, and help a lot with fast design and deployment​
Pros and Cons
  • "Predictive models, which are easy to use, and help a lot with fast design and deployment​."

    How has it helped my organization?

    • Faster delivery of projects
    • Quick preparation of data for analysis
    • Direct output to Tableau extract for visualization
    • Significant productivity improvement

    What is most valuable?

    • Data blending
    • Calculations
    • Predictive models, which are easy to use, and help a lot with fast design and deployment.

    What needs improvement?

    Visualization.

    For how long have I used the solution?

    One to three years.

    What do I think about the stability of the solution?

    No issues.

    What do I think about the scalability of the solution?

    Not really.

    How are customer service and technical support?

    • There is a very good and supported community. 
    • Reasonable reaction time for the support.

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

    Different ETL tools (SSIS, Talend). We switched for ease of use and a wide range of features.

    How was the initial setup?

    Easy to install and intuitive to use.

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

    Very transparent.

    Which other solutions did I evaluate?

    We worked with other ETL tools for a long time, Alteryx was chosen based on ease of use and value add.

    What other advice do I have?

    Start small and prove the value for specific use cases.

    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
    AltanAtabarut - PeerSpot reviewer
    Founding Partner at Altdata Analytics
    Real User
    Top 20
    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:

    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.
    Ed Dallal - PeerSpot reviewer
    Founder, CEO, & President at Krystal Sekurity
    Consultant
    Intuitive and you don’t need to know how to write code to use it.

    What is most valuable?

    Data Blending and Predictive Analytics: Alteryx is very intuitive and you don’t need to know how to write code to use Alteryx.

    How has it helped my organization?

    It helped us reduce time blending data from multiple sources into one file. Our analyst’s time was cut from two days to one hour of data blending and the output was amazing! And we could map out file-run predictive analytics in the same tool.

    What needs improvement?

    Visualization: There is room to improve here.

    For how long have I used the solution?

    I have used it for two years; this is our third year using Alteryx Designer.

    What do I think about the stability of the solution?

    I did not encounter any stability issues.

    What do I think about the scalability of the solution?

    I did not encounter any scalability issues.

    How are customer service and technical support?

    I haven’t had to call tech support.

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

    I did not previously use a different solution. I used to copy and paste and convert data.

    How was the initial setup?

    Initial setup was straightforward.

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

    Buy a single desktop license, and if more is needed, you can expand. Initially I would advise clients to start with the 14-day trial license.

    Which other solutions did I evaluate?

    I did not evaluate other options.

    What other advice do I have?

    Try the free trial.

    As a multiple data source blending tool and predictive analytics tool, Alteryx stands out from an ease-of-use and flexibility perspective.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    it_user416430 - PeerSpot reviewer
    Business Intelligence Consultant at a computer software company with 51-200 employees
    Vendor
    Its drag and drop workflow creation capability is like drawing a flow chart.

    What is most valuable?

    The drag-and-drop capability to create a workflow works like drawing a flow chart. Each icon represents an action. You drag the action on the canvas and connect it to the data source, make configurations on the action, then run the workflow. When data goes through the process, the action will execute and you get what you want afterwards. The actions are intuitive and you can design you own way to do the same thing.

    How has it helped my organization?

    Alteryx automated some manual standard processes and the workflow is easy to maintain. Staff do not need to wait for IT to prepare data once a data warehouse is set up. The output can be shared within the company which other teams can make use of to reduce rework. Advanced analytics such customer response prediction, time series demand forecast can be done without a PhD.

    What needs improvement?

    I would like to see the field tracks along the workflow show the route of selected field. That would be easier to do checking or modification when designing a complex workflow.

    Also, data profiling would be helpful if audit/compliance requires the info of data transformation. That would be easier to trace the data along the whole process.

    For how long have I used the solution?

    I have used it for one year.

    What do I think about the stability of the solution?

    I did not encounter any stability issues, at all. This tool is designed for big-data analysis, so basically there are no input/output issues. It can process more than 10 million records in 10 minutes on a normal laptop.

    What do I think about the scalability of the solution?

    I did not encounter any scalability issues, at all. As long as the server is set up, it can share the workload by the load balancer. It depends on how complex the problems you want to solve are or how many people you want to access them simultaneously.

    How are customer service and technical support?

    Technical support is 8/10:

    • Active community
    • Quick response from client service
    • International partners to help in person, on site

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

    We previously used Informatica. The position of Alteryx is not only ETL, and we need to do more than just ETL, so we switched.

    How was the initial setup?

    Initial setup was very straightforward. You can also download a comprehensive guide from the official website.

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

    It is not cheap. So I would suggest you start with a trial and then evaluate how many licenses you need for your analysts. Basically, I do believe each analyst – regardless of whether they are in the sales operation, data analytics, or planning – requires one license. When they acquire the skills of how to use it, the ROI will be much larger than you can imagine.

    Which other solutions did I evaluate?

    We did not evaluate other options before choosing this product.

    What other advice do I have?

    It would be great to find a local partner to do some training and use the consultation service at the beginning. It would help you and your staff to learn fast.

    It is a very user-friendly product that doesn’t require a strong technical background; you can build something within an hour. It encourages self-service, has good capacity and supports a variety of data sources.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Associate Solutions Analyst at a healthcare company with 501-1,000 employees
    Vendor
    I can pipe external data onto a server in a temporary table. This frees my machine up while the server does all the heavy lifting.

    What is most valuable?

    One of the most valuable features to me is its ability to take millions of rows of data, blend them with more millions of rows of data, then output the data set to a Tableau Data Extract (*.tde), which I would then use to build a dashboard in Tableau.

    Another of its most valuable features gives me the ability to pipe external data onto a server in a temporary table. This frees my 16GB machine up while the server does all the heavy lifting. Blending data this way is faster, as a simple blend of a couple of million rows can take a minute or two. Also, because Alteryx can output to a *.tde, we are able to use it hand-in-hand with Tableau Server to develop data access solutions for our users.

    How has it helped my organization?

    Non-computer-savvy business users used to require periodic and ad-hoc reports to spot trends or so they could work with our customers on spend allocation. Some of these reports took days or weeks to compile. Alteryx allowed us to access all the data, blend it, and output it as a dashboard for the user to access any time they needed it. It took the strain off the reporting team and it gave the user a simple interface from which to work.

    What needs improvement?

    The company is constantly pushing updates and making the product more user friendly and faster. Although I have about seven months’ experience using it, I don’t feel like I’ve even scratched the surface on its capabilities. I haven’t used its spatial, data investigation, predictive/predictive grouping, market basket analysis, time series, demographic analysis, behavior analysis, or macro-building features.

    If there's one thing that I would like improved, it's the in-database tools to function the same way as outside-database tools. For instance, if there is data that is being blended outside database with a join, there are nodes that you can select so you can see the data that didn't get joined. As you can see with the purple join

    For how long have I used the solution?

    I started using Alteryx in the beginning of January, 2016.

    What do I think about the stability of the solution?

    I did not you encounter any stability issues.

    What do I think about the scalability of the solution?

    I did not you encounter any scalability issues.

    How are customer service and technical support?

    I haven’t had to use technical support, as far as actually speaking to people, but I have used Alteryx Community to find solutions to some of the challenges I faced. Alteryx Community has a great selection of training videos and documentation, and its users are posting more and more, which offers other users solutions without having to reach out to Alteryx representatives.

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

    I did not previously use a different solution.

    How was the initial setup?

    The initial setup was straightforward. Another user in my department decided he wasn’t going to use Alteryx, so he transferred the license key to me. I downloaded the program and started using it.

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

    It’s quite pricey for an Alteryx Designer license (~$5200 for a one-year subscription), but once you use the product, you won’t want to go back to whatever you were using before.

    Which other solutions did I evaluate?

    I did not evaluate other options.

    What other advice do I have?

    Before you download the 14-day trial, compile a list of processes that you want to improve. Once you start improving processes, you won’t want the trial to run out.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.