Alteryx Designer Reviews

I use the solution to build pipelines, schedule them, and do some data transformations and data cleaning.

The solution's ability to hold a huge amount of data in its memory is significant.

We use the solution for our ETL process, which involves moving data between source and reporting servers. 

The tool's most valuable feature is its API connections. Its predictive analytics feature has helped us pass some ETL processes to analysts rather than developers.

With Alteryx, we mostly fetch data from SQL, SQL server databases, and SharePoint. Some team members were doing the task using Excel for a long time with Macros and Excel functions like VLOOKUP, and these things become quite easy when you are using Alteryx as a solution.

We have automated the processes and scheduled the workflow so that users don't have to sit in front of the system to do the same tasks every day. So, the system will trigger the workflow, and it will send the output file to the concerned team. We are mainly using this solution for data blending and preparation. 

Alteryx is quite easy to use, learn, and understand as a product. Any user can understand what's going on by looking into the designer's workflow. But in Excel, there are so many formulas that are very difficult to understand. But in the case of Alteryx, it's quite easy to understand the transformations happening in a step-by-step manner. 

I have used Alteryx Designer to perform predictive analytics that helps in predicting the selling of products, particularly in banking and financial areas.

The main valuable aspect is the simplicity of use across all features. Additionally, I have developed some functionality to integrate Alteryx Designer with other connectors, including some Alteryx plugins for various software, which proves useful.

We use Alteryx Designer for data manipulation.

The product is intuitive and easy to use. It helps in faster data processing for gigabytes of files. It provides accessible data summarizing in terms of applying formulas across columns.

I use it for data preparation, mainly cleaning raw data.

When you open a raw Excel file, it can be hard to look at everything in detail. Alteryx makes it much easier to go through the data, summarize it, and use different tools for analysis. So, Alteryx Designer have significantly reduced the time I spend on data analysis tasks.

Moreover, the drag-and-drop interface of Alteryx Designer improved our overall workflow.

We use Alteryx Designer to enable business users to automate their workflows so they don't have to spend time in Excel doing things like pivot tables, VLOOKUPS, or HLOOKUPS. Instead, they can spend more time on analysis than being a spreadsheet slinger.

At my last company, our national account team would need to go to a system to get information on various accounts. They would then need to compile it with the information we have in our system. They would download information that we had in our system into an Excel workbook and the information from the external system into a workbook. They needed to combine each client to find all the information for a single client. That manual manipulation used to take six hours of one person's week, and then that person would need to compile it and send a summary of activities from both systems for our clients. They would then need to publish it for our management to consume. Now, what they're able to do is Alteryx was able to use the API from the external system that they needed information for. They were able to connect that to our system to create one single workbook. In Alteryx, they could do all of the data cleansing preparation and transformation they needed. They were also able to set up an automatic email that was sent out. This ended up saving across the organizations about 2,000 hours a year. With Alteryx, they could find a single source of truth for the clients and could download everything automatically. They could pivot it out and summarize it at the level it needed for our executives to consume.

We use Alteryx Designer to construct workflows, encompassing data extraction from various platforms such as SQL Server and in-database sources. Subsequently, we automate these workflows and push the filtered data to Tableau for dashboard creation. This process forms our daily routine, streamlining tasks efficiently.

Alteryx Designer offers a drag-and-drop interface, making it highly user-friendly. Unlike Python and Apache Airflow, which require coding, Alteryx allows users to accomplish tasks without any programming knowledge. Its simplicity makes it accessible to anyone, even those without coding experience, and this ease of use is one of Alteryx's key advantages.