Alteryx Designer Reviews

Ease of implementation, fantastic product support. Great assistance from Altyrex - committed resources at no cost to help implement, train etc. A lot of willingness to help us 'prove' the business case - i.e. make a success of the pilot project. Workshops ran in business helped getting a number of other business functions exposed and on board in support of the product. Willingness to negotiate on price as well as providing trial licences to other functions for a period of time to enable usage uptake. Willingness to understand business problem assisted greatly in successful deployment. Ease of deployment in 'non-analytics' environment was a big enabler. What is great is that it is process flow based and no extensive coding experience is required. Now busy with further business case projects in other parts of the business.

The cost initially seems exorbitant - especially as there are alternatives such as KNIME & Rapid Miner. Value delivered however overcame this barrier.

1. Variety in built processes which helps to transform raw data into more readable formats.
2. Best option for the visual analysts as it provides in depth analysis.
3. Having very easy installation process
4. Powerful analytics product available in market which takes the raw input files and allows analysts to apply multiple processes on it which helps the analysts to prepare valuable information from raw data.

1. Cost of this application is too high as compared to the other alternative projects.
2. Integration with other tools sometimes a big challenge.
3. Dashboard needs an improvement as compared to other products.
4. Consumes more memory and CPU
5. Enhancement required in order to smoothen the integration of python.

Its ability tto blend multiple data sources and build data pipeline for cleaning and preparation for reporting and analysis.

I fell in love with this software, it is super easy to use and efficient. Nothing to dislike.

Alteryx seems to have ever-expanding capabilities.

Some of the error messages can be quite vague and help very little in troubleshooting.

I appreciate how Alteryx helps me to get a lot of solutions especially with regards to complex data transformation, which previously required us a lot of effort to check and document it. I love the fact that there are so many tools built into Alteryx that enable us to customize fields in a faster way. The dashboard provides an overview of the data being tracked so that all team members at all levels can get a fuller understanding of all the processes and analytics, and the unique presentation of the data helps So, it makes everyone on the same path while monitoring the transmission of data at all stages.

Not many negatives, as Alteryx is generally easy to use, and team members only need to get clarifications about performing some functions. It should also be given more flexibility that enables us to convert data into PDF files easily, as well as work on improving reports and graphs so that they become More modern.

Alteryx is an incredible powerful analytics tool that allows users to input source data, manipulate, clean and transpose that data, then output into a Datawarehouse or other database. Despite the complexity of this product it has a great user interface and this makes it easier to learn and you are able to get up and running in a very short amount of time.

Still lacks some basic functionality, like an in-built tool for creating SQL views or a tool that can run multiple workflows in sequence (like Crew macro).

The most i like is the Easy drag and drop function that the application has. The design and how visual it is to keep the Information flow, makes Alteryx a great app for data analysis, formatting and design. Built in tool like time Formaters, filters and Joins facilitate the work of doing data cleansing and data prepping for any ETL job. Another great area is how flexible it is input and output formats. It lets you join CSV files with XLS or even TXT.

The least I like is the price and the latency when loading the data. Because is a strong and powerful Tool, it is a bit pricey in one hand, is not a tool for one day job, is more for enterprise and daily jobs. When loading the data, depending where is located the document, it will take longer than usual.

Very user friendly and feature rich for data shaping and manipulation. It is the best ETL tool for non technical users to be able to build very complex data manipulation and blending workflows.

I wish they had a pay per use pricing model vs. fixed fee for desktop licenses. It would also help if it could run in the cloud so it could efficiently access large amounts of data in S3 or Blob storage. It also

Easy to use UI, just drag and drop tools and start your data modelling.
Geo spatial data for spatial analysis
Blending data from different sources is quite easy.
Create and schedule data models and it will run automatically.

Integration with other tools are less compared to its competitor tools such as Informatica .etc.
Reporting option could be improved.

Easiness to make a pipeline with a variety of data sources. The data source was from a text file to a cloud database.
Also it has good integration with python, which enable to writing the script to filter data very quickly and easily

The cost is on very high side. It would be good if its cost can be reduced

Probably Alteryx's best selling point is accessibility. I personally learnt how to use Alteryx quite comprehensively in a matter of days without any training resources whatsoever. The intuitive UI makes it easy to construct even incredibly complex ETL processes.

Alteryx's feature-set is also extremely powerful. It is really greater than the sum of its parts. With the wide range of modules it provides as well as the ability to construct many types of macros yourself, Alteryx allows you to do things with the product that may not have even been intended by the developers.

The community is well fleshed out and there are a number of macros out there (shout-out to the CReW macros) that pick up the slack where some native functionality is missing (eg. triggering workflows from other workflows). However, some of this reliance on external macros/connectors can be problematic for software updates when some can be broken.

We'd love to have our team all using Alteryx, but the heavy price-tag limits us to only justifying the purchase of a couple licenses at a time. There are a number of features that are attractive to us about Alteryx Server too, but the jump in price to that product is too high to justify.

Things can get awkward when it comes to automating workflows. In order to trigger workflows on demand outside of the designer, you are required to pay even more for a Desktop Scheduling license. That license only grants you access to the engine via the command line, which can be awkward in some scenarios (eg. if the workflow accesses network shares that require domain access, a user with sufficient rights must be the one to run the engine via command line).

While Alteryx can provide significant throughput of data, there does seem to be some issues when capturing large SQL datasets sometimes. I and others in the community have witnessed significant performance degradation when not using the "TOP" SQL clause in SQL statements. It's an odd issue, but it is one that slowed down our organisation's ETL processes significantly (some large workflows ran for 24 hours) in the past before identifying the "TOP" clause workaround.

Data ingestion: Alteryx is capable of connecting with a multitude of data sources from SQL databases to cloud-hosted solutions like Salesforce, Tableau, or Google Analytics. Also supports OleDB & ODBC connections.

Dynamic data munging: Alteryx has a great variety of processing tools to clean and prep data including: dedupe, formulas, joins, union, sort... Performing these functions really quickly on even moderately equipped laptops or desktops. It's dynamic in that it can easily handle changes in data by allowing extra columns to flow through.

Macros: have a process that you are consistently running in separate workflows? Build a MACRO, be it a batch or iterative, Alteryx can do it. I've built 40-50 macros and use at least 4+ in every workflow I design so data is handled the same way in every workflow for consistency and cutting down on copy/pastes.

I've had issues with the scheduler tool getting frozen or stuck in previous versions. For about the last 2-3 months the latest software version has been much more reliable. Previously I had to restart the Alteryx service on my machine at least once a week, which meant my workflows weren't running while the service had been stuck and data wasn't moving.

Some of the connectors, like the Tableau Online connector, should become supported by Alteryx. The online community is fantastic and has created a ton of useful macros and it would be great if Alteryx would adopt, support, and enhance some of the most widely used and useful.

I love how simple it is to cleanse data in Alteryx. You can build linear workflows using their myriad of icons. I love how each icon has a built-in tutorial example that will show you how to use the function. I also really love how you someone with limited SQL knowledge (my colleagues) could use Alteryx to import and refine data to get the exact results they desire. It really is a very intuitive software--well-documented. Oh, and their support is FANTASTIC! I received an email offer to work with an expert from the company and was immediately paired up with a few company trainers who offered their own customized expertise for the specific problems I was working to try to solve. The online portal is excellent as well; there's a whole community ready and willing to assist and help you get better at using Alteryx. Very impressive software.

The parts I found most difficult to use were the neural networking/forecasting & macro/automation widgets & tools. The forecasting/neural networking wasn't very straightforward and seemed to really be more of an art than a science. I would have expected there to be more tutorials on how to effectively use these tools, but I think you would need to have a degree in these arts to really master them. We are probably still too early into this new science. The macro & automation functions really blew my mind and I never learned how to use them--for example, to loop through processes. I would have liked to, but I just didn't have the patience to figure it out on my own and it wasn't high enough of a priority.

It has a lot of out-of-the-box integrations with pretty much any data source you can imagine. It connects flawlessly with on-prem and SaaS sources as well.

The designer UI is very easy to work with. Drag and drop functionality makes it convenient for non-programmer/business users, while scripting support allows for powerful transformations and data processing.

Additionally, data prepping/cleaning, ETL operations, visualization, etc. are super easy to learn and implement. Also, there is a big user community that makes finding help and support easy.

This is an expensive product. Even at the enterprise level, it's a significant cost, so you need to think about the trade-offs before committing to it.

It can be slow sometimes if other users are running resource-intensive tasks. You may have to wait for others to complete their tasks or add more resources, which again can be costly.

Storage options are also lacking especially cloud-based ones. Although, the vendor is considering support for this in the future releases.

Alteryx Designer is a very intuitive way to map out a process in a step by step visual workflow which can be then executed with the click of a button. Tedious manual tasks can be automated with ease. Traditionally, programming required drawing out ones algorithm in a flowchart and then having to translate that into computer code. With Alteryx, the flowchart itself is the code. It features a vast array of icons called tools, each of which has a specific function such as importing data, filtering based on criteria, summarizing, merging information and so forth. You simply drag and drop each tool into the work area for each step in your process and then click the play button. It's like having a robot to whom you can describe your work and then have it do it for you in a fraction of the time.

Alteryx Designer is excellent for data mining/wrangling for eventual output to be used for reporting but it's internal report generation and presentation tools are not as robust as others when it comes to publishing a polished presentation. I prefer to use Designer to produce my final data result set and export to Excel where I can then take advantage of Microsoft Office formatting and presentation options.

You can do so much with Alteryx! We acquired the software for one specific project but I find myself using it for so many other things, from day to day data work to other large projects. It has great features like fuzzy matching, data normalization, and join capabilities. It is great for working with large data sets that can't be easily managed in excel or access and for allowing multiple data sources to interact with each other.

There is a bit of a learning curve. However, once you understand how it all works its easy. Also there are so many tools and more than one way to achieve the same thing. It can be hard to know how to approach new projects.

Alteryx has a fantastic interface, using function blocks that you can drag and drop to create a workflow. This makes it simple to use and provides the ability to create complex workflows.

The license cost for the tool is very high, which means not everyone can use it. I find very little other cons with the program.

Alteryx has a lot of Data Connections and Toolkits already built in which helps speed up the Data Processing and ETL for IT as well as Business people. With little to no knowledge of programming language and SQL one can easily build a pipeline for data transformation. The speed and ease of development is the main pros of the software.

There has to be more AI ML features on this software. The visualization and data exploration capabilities need to be enhanced.

It does not require coding skills like python i.e, easier to get started with and do basic data analysis in matter of minutes

Once a workflow is created, it cannot be viewed or executed by anyone who does not posses a copy of alteryx software which is expensive to buy just for execution of workflows. However, there is a separate product which is called alteryx server where workflows can be executed free of cost. The biggest problem is that behaviour of workflows on designer and server is different. Many tools do not work on server and there is no way of showing intermediate results on server. As these are two different products, one can't even file a ticket of improvement on designer's customer support. In complex workflows things get even more frustrating when server is unable to do what alteryx workflow suppose to do.

Easiness to use,PLug and play,For non technical poeple this is amazing tool.Time Saver.

I heard from Admin that license is expensive

Alteryx has the full package starting with excellent customer service and continuing with an straightforward drag-and-drop interface. An abundance of available nodes make it simple to pull in data from many different sources, merge, union, filter, sort, and even perform statistical or predictive analysis on your data, and then disseminate it to the proper stakeholders. The visual nature of the product makes it accessible, even for beginners with no programming background, so they can start building queries right away. What I love most is how it makes the part of my job that used to be the most tedious--data prep and cleansing--fast and effortless and even fun. There are also many online training videos and community group to help build your knowledge of the product and its full range of capabilities.

Alteryx may be better suited to fields other than education; however, I can still find good use cases for it in my job.

Not so steep learning curve, Alteryx is built around the human common sense. The fact that you can (View/Process) the data as a branch at any stage of the processing is really useful, and the way the software designed allows you to go backward and see what happened.

The limitation of some tools and the high barrier to developing new functionality.

Alteryx is an incredibly easy to use tool that creates and automates data workflows with a click and drag toolbox. Passed R, Python and JSON code through the workflow so you can get technical tasks done without a developer.

Alteryx support could be a bit better in terms of follow up with very specific and technical questions. However, the community is a great resource to get answers to high level questions!

1. Drag and drop based UI interface
2. Ability to import data from and export data into variety of data sources
3. Re-usuability of workflows
4. Full feature trial license

1. Lack of (or limited) visualisation capability.
2.machine dependent licensed(it should had license key Linked to email ID, making it easier to port licensed from one system to another)
3. Expensive license

Multiple data sources support - A plethora of data sources are supported making the tool very versatile
Analysis - Data preparation, blending, analysing of different types of files is possible
Intuitive interface workflow - The workflow interface is quite convenient to use
No code required - QUite simple working without any code
Transformation functionalities - data cleansing, filtering, data ingestion, standardisation possible
Customization - macros

Interactive dashboard sharing - there should be a convenient method to share the reports with users outside the development environment, or with new clients
Workflow scheduling functionality improvement