Alteryx Reviews

• 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

We provided the whole consulting delivery on a single tool with reporting and automated PowerPoint presentations.

• 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.

We have been using this solution since 2014.

There were no deployment issues, and it went pretty fast. You sometimes need a license file if you are behind a firewall.

When the workflows are huge and complex, it may take some time to refresh it.

There were no issues with scalability.

Customer service is pretty responsive, based on the UK and US time zones.

Technical support is pretty responsive and knowledgeable. The community support is exceptional, too. It is a very crowded community with lots of practical solutions.

• 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
  

The setup was simple. It was pretty much "next, next, and next".

We did the implementation in-house.

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.

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.

• 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.

This solution has a very bold vision.

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.

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.

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.

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.

I have been using Alteryx for around 10 months. 

It never crashed in the last 10 months.

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.

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.

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.

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.

Alteryx has made us more agile and increased the speed and effectiveness of decision making.

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.

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.

We have been using Alteryx for four years.

It is fairly stable and we have had no major issues.

With respect to scalability, it is rather good at handling large data sets.

Grazitti Interactive is very responsive and very helpful.

We did not use another solution prior to this one.

The initial setup is very easy.

We used Grazitti Interative. They are excellent!

We did not calculate a specific ROI.

The server pricing is high.

We did not evaluate other options before choosing Alteryx.

I use this solution for KPIs and trending.

All of the data science features in terms of unioning and joining data together are valuable. The formula tools are good, and it provides an easy way to summarize data. 

It has some really good, solid, basic reporting functions. 

It's not as robust as a lot of the dynamic interactive tools, but it certainly gets into the more static reporting very effectively.

The only weakness I would say is on the visualization side of having that dynamic incapability.

I know that it is dependent upon having the on-premise and cloud server environments, but even there, the product functionality is somewhat limited.

This would reduce the need to integrate it with other products.

I have been using Alteryx for a couple of years.

I am not using the latest version. I am one version out, and I am in the process of having it updated to the latest.

I generally stay up to date with each release. 

I am using the desktop version.

I don't think that there any more issues with stability than would be expected for a product of this type. Those occasional things happen, but it's nothing that is significant.

Alteryx is easy to scale. 

We have three people who are using this solution in our organization.

Technical support is very good. They get high marks.

I would rate them a ten out of ten.

We had used JMP, which is a product by SAS, and it really didn't have any capability of doing the automation that Aletryx has, other than some really bespoke programming language. It is a type of script language. 

It is very awkward to learn and use it.

The initial setup is definitely straightforward.

I would definitely advise others to give it a fair look. It's a great product.

It is not marketed as a solution to all different types of aspects of analytics. I'm not going to downgrade it just because that's not within the scope of what they're marketing the product for.

Based on what it has been marketed for, I would rate Alteryx a ten out of ten.

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.

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.

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. 

I've been working with the product for 1.5 years. My team has been working with it for 3+ years. 

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.

Scalability is excellent, five-star. 

Technical support is very forthcoming in helping people out.

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

The initial setup is straightforward. 

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. 

I use the solution to build an ETL workflow.

The ease of use is the solution's most valuable feature. It doesn't require coding for usage. I only have to drop and drag the available options to perform complicated functions.

They should make the solution user-friendly for nontechnical people by giving specific names to the options. That will be helpful for them to understand.

I have been using the solution for six months.

I rate the solution's stability as a ten.

It is a scalable solution. We are two users who created a workflow using it. We use it once a month or two.

I rate the solution's pricing as a ten, as it is highly priced.

I rate the solution as a nine.

I'm a contractor who works on different teams. Right now, I'm working on three different projects. 

Alteryx has cut down on time spent cleaning and transforming the data. It improved productivity. Transitioning from PoC to other users was seamless. The users upskilled quickly, so they could take ownership without a steep learning curve.

Alteryx effectively visualizes the flow of data and what happens at each stage. I also like that it's a no-code solution. I also like that you can troubleshoot certain parts of the workflow by putting them in a sandbox.

I have been using Alteryx off and on since 2020. 

Alteryx is stable.

Alteryx customer service was great. They gave me a trial version, and the client company bought licenses. The technical support and the sales guys were all helpful and supportive.

I use Excel and Power Query. I don't use Alteryx personally because I don't have the funds for an enterprise solution.

Setting up Alteryx was straightforward. The drag-and-drop menus are fantastic, and the icons are great. There isn't a steep learning curve. You become familiar with it quickly.

Alteryx wasn't deployed in the previous project. It was somewhat irregular. We ultimately did the dashboard in Power BI, but nobody was using Power BI as a data cleaning and transformation tool, so we used Alteryx as a proof of concept, We also deployed the cleaned data to use in a dashboard, and the dashboard was delivered to the client.

I rate Alteryx seven out of 10. I recommend using the 14-day trial version to learn how it works. You can use some of their in-house data to try real information or run a parallel. The trial version is super helpful for making a decision and understanding the capabilities. That's what kind of sold me.

The solution is used for data ETL.

The most valuable feature of Alteryx is its performance. It is a powerful solution.

The gallery could improve in Alteryx. Additionally, if there was a Conditional Join feature it would be beneficial. Since I do not have this feature I have to use Python scripts.

I have been using Alteryx for approximately four years.

I rate the stability of Alteryx a ten out of ten.

We have three people using the solution in my organization. We plan to increase our usage, we only will have to purchase more licenses.

I rate the scalability of Alteryx a nine out of ten.

I have not used the support. There is a helpful online community where we can search for answers to our questions.

I previously used other solutions but they were not as good as Alteryx. We switched because of the scalability, ease of use, community, and workflow.

The initial setup of Alteryx is not difficult.

I rate the initial setup of Alteryx a nine out of ten.

The license price of the solution is expensive.

I rate the price of Alteryx a nine out of ten.

This is one of the best tools for ETL. It has a lot of capabilities. I would advise others to explore the solution. There is a free certification that is offered.

I rate Alteryx a nine out of ten.

The solution is good for data transformation from the web and office.