Alteryx Designer

Pros

It's a great no-code solution that can be used both by beginners and advanced users. It's very easy to grasp the basic skills such as data cleaning (sorting, grouping, filtering etc.) without learning any additional language. At the same time it has PLENTY of advanced options such as macros, geocoding, Python tools etc. that can be used by more experienced users.

Cons

Visualizations - I know there are much better tools for this but the available maps and graphs in Alteryx look like something from 10 years ago. It would be great if the Alteryx team could improve the reporting tools and maps.

Pros

1) User-Friendly Workflow Creation
2) Extensive Range of Tools
3) Versatile Integration
4) Robust Data Preparation Capabilities
5) Scalability and Efficient Performance
6) Interactive Visualizations and Reporting
7) Automated Workflow Management
8) Active Community and Support

Cons

Although Alteryx efficiently manages large datasets, running complex workflows or handling extensive data operations can strain your computer system's resources. Ensuring optimal performance may necessitate having robust hardware in place.

Pros

Alteryx seems to have ever-expanding capabilities.

Cons

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

Pros

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.

Cons

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.

Alternatives Considered

Reasons for Choosing Alteryx Designer

Switched From

Reasons for Switching to Alteryx Designer

Pros

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.

Cons

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

Alternatives Considered

Reasons for Choosing Alteryx Designer

Switched From

Reasons for Switching to Alteryx Designer

Pros

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.

Cons

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.

Pros

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.

Cons

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

Alternatives Considered

Reasons for Switching to Alteryx Designer

Pros

Its great product which helps significantly with data analysis, data preparation and cleansing. Its very handy for ETL and has a lot of additional analysis tools embedded, especially from geospatial perspective

Cons

Probably cost is the biggest challenge for Alteryx being widely used

Pros

It is great for setting up workflows that help us organize, reformat and clean up data we use in other applications and exports.

Cons

Intimidating at first, but once you learn to use it...it's a dream!

Pros

It’s easy to use, even for people who don’t understand much in coding. All the elements in data preparation and cleaning are seen visually in icon format, which makes overall process picture easy to understand.

Cons

When process is too complicated, visual map might be a bit overwhelming, with so many steps/icons. Especially if you are looking at the workflow that was built by someone else.

Pros

- Blend large sets of data
- Faster processing
- Output is easy to understand
- Saves hours of manual work

Cons

- Initial training and set up so, non-technical person can quickly grasp

Pros

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.

Cons

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.

Pros

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.

Cons

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

Pros

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.

Cons

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

Pros

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.

Cons

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.

Pros

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.

Cons

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.

Pros

I like being able to quickly manipulate data and create new rows and columns with ease, making the data easier to read as well as adding new factors into data sets.

Cons

I dislike how it can be at time cumbersome when one creates complex workflows that take over an hour to load just once.

Pros

It has a simple to use drag and drop interface.

Cons

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

Pros

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

Cons

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

Pros

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

Cons

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

Pros

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.

Cons

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

Pros

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.

Cons

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.

Pros

no coding experience necessary, seamless integration with Tableau and SQL, great workflow icons and capabilities, great automation

Cons

pricing, but they are flexible, could make a cloud product that is easier to scale out to more people

Pros

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.

Cons

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

Pros

Easy drag and drop interface for creating workflows.
Easy to debug (easy to track and monitor the workflows while it is running)
Can Integrate "R" code with Alteryx
Alteryx provides variety of features for text data cleaning (including fuzzy matching, regular expressions and table joins)
Without much coding alteryx provides machine learning for predictive analytics (drag and drop features)

Cons

At times Alteryx is slow in responding
Expensive tool
Not good for data visualization
Very few training videos