Alteryx Designer Features

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.

With Alteryx, you're creating a workflow to alter the data, rather than altering the data directly. Because you're creating the workflow, each of the steps are easily auditable and you can swap out the source files when it changes. This is a huge bonus and time saver as data will tend to change.

Alteryx has a huge learning curve. It's hard to get started without some sort of live tutorial from someone that has been using it for a long time.

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.

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

Ease of use & speed of use. Very user friendly and intuitive. Processes massive amounts of data very quickly, even on a desktop/laptop.

With the frequent releases, there seems to be more (minor) bugs than in the past when releases weren't so frequent.

It has a simple to use drag and drop interface.

There is so much functionality, it is difficult to know everything.

This application has no limits as it relates to everything data. With Alteryx, I have been able to automate my data cleansing / loading activites within hours and now runs within SECONDS daily. Truly remarkable product, and quite frankly scares me at times how well it works.

Price for the premium packages. However, the price points are accurate and justified based on what the application can do.

I would argue that this is the number one product for data science. I have change my entire analytics department for the better with using alteryx.

No major complaints on this software, my team loves it!

Easy to use You can see data as it passes through each tool. Seamless integration with excel, database other sources Good reporting options

Lack of customer service Not able to read excel files with macro enables format correctly

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

Read more

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.

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

I heard from Admin that license is expensive

It is easy to learn and efficient to do data preparation. Can deal with big volume of data that Excel cannot.

More machine learning and prediction tools can be developed and make them user friendly to non data science people.

I have been using Alteryx for past few months and it has made my life so easy when it comes to handling multiple files. You can combine multiple excel files, CSVs, any other files, 100s of MBs in size, and within minutes it carries out the entire ETL process. 1. Ease of use - simple drag and drop 2. Input and outputs - multiple file formats are supported 3. Very easily handle GBs of data

1. A few visualization capabilities can be added to make it more comprehensive tool 2. You have to run the entire workflow again, even if you have made a slight change - having the functionality to run just a piece or small part of the entire workflow will save much more time

I love how diverse the product is. I can do a simple data pull to a demographic report to doing regression analysis for a complex model.

The only small complaint I have is that some of the error messages themselves are cryptic and convoluted.

I use this software for manipulating csv files with <10k rows and am very pleased with the flexibility and performance. Designer opens fast, is easy to build with, processes workflows fast and lets you know where your problems are. Very logical and easy to follow for your average data junkie.

Price-per-license is high, but it's really awesome software! Designer is for more for data-minded workers, but the interface is so easy to use that a non-techie could run a workflow with minimal instruction.

It is easy to use by drag and drop. All different functions can be used to prepare data. Also can analyse data in simple mathmatics.

I have to run the whole workflow when I add one more tool. Sometimes the workflow takes a lot of time.

Very well integrated with other applications to import data. Workflows can be easily automated without much knowledge of coding. Python integration helps to reach newer capabilities.

License is very costly which hinders the use of it by everyone

It provides a no. of tools for data blending, data sorting, data extraction , generating reports and emailing them. Macros in it are easier to use. User Interface is easy to understand.

Nothing much I dislike, the only thing I disliked is that we have to use visual tool to view data every time, that slows the running time of the workflow.

No pros were added to this review

No cons were added to this review

I like how it lets me peel off the database and dig through the data more efficiently myself compared to having data analyst help with the task.

There was quite a bit of learning curve before getting used to what Alteryx can do.

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.

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

Read more

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

Read more

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

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

Read more

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.