Alteryx Designer Erfahrungen

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

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.

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.

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.

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.

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

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.

The ease of use is great. We can teach people how to data analyst very quickly. The functions they continue to add have been great.

We have issues at times with it hanging or shutting down but customer support is quick to respond and resolve issues.

Alteryx offers great capabilities for data prep, blending and processing intuitively. It's possible to connect to a wide variety of data sources. Also, It offers visual and table data to help you visualize the results and profile the data you're using. Furthermore, flows are very easy to understand what's going on and are exportable to formats such as direct SQL queries.

There's a learning curve to understand all the components that Alteryx offers. However, there's great documentation out there to learn.

Alteryx is incredibly powerful. I used it on a daily basis for 3~ years, and I still only scratched the surface of its total functionality. Its GUI is beyond easy to use because it's so intuitive. Alteryx is a great solution for handling the tasks Excel was never built for.

Contacting customer support is hard; the software's very expensive, but you have to pay extra to talk to someone on the phone.

- Great for data prep and processing. Very light weight ETL tool.
- Ability to enhance the data by applying statistical models, available public data, etc.
- UI interface is very intuitive with drag and drop components

- Hard to scale (Best use case is for individual projects)
- Expensive to use, high license cost

I like how many different ways I can get data into Alteryx, and all the easy manipulation that you can do both with and without SQL coding experience. It is very easy to use, and easy to learn on your own. They also have great customer support, and training videos.

I would like to see the Period Table of Alteryx with more detail, or a decision tree on inputs and outputs and uses to help figure out the best tools to use.

The software allows data prep options for just about any scenario imaginable. If you need to omit rows, add columns,

The layout involves a flowchart and the user assigns cleanup steps based on a flowchart scheme he so desires.

The user with a SQL background will have a better understanding and capabilities of the back-end processes.

Does require a bit of practice to get used to the layout and customizable features. Would recommend taking an online or in person course. There is a learning curve, especially for individuals like myself without a data background.

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

Between the great customer service, easy UI, online tutorials and sample files, it is a very easy product to use.

There are so many uses it is sometimes hard to know you have the best environment for the software, because different features require different needs.

Alteryx is a practical tool and very easy to learn even if you are a beginner in the computer field

Nothing too serious I don't use it too often

I love the easy of drag and drop data scrubbing. Whether a contributor is using advanced coding or a more visually inclined, this product unites data users from across the technical spectrum to collaborate in a common intuitive way.

Setting up connection is not always straight forward and dependent on data environment of one's workplace. However, this only needs to be done once for a given connection.

A feature I hope to see in the future is the ability to sequence specific segments of a workflow.

I love the icons. I am very visual and enjoy knowing what I am doing by simply looking at the icons. This software can be as technical and as user friendly as you make it. The drag and drop of request allows users to play around with the files, data and request without being afraid of braking a formula like in Excel.

I don't like whenever I get a "null" error and it does not allow me to correct it. I manipulate the data, remove filters and the null remains visible. Perhaps having a pop up to show where the error lies in your work.

This software greatly simplifies the process of dealing with large data sets, taking tasks that previously might require knowledge of SQL, Hadoop, and other database items, and allowing you to do it all in an intuitive manner within the Alteryx package.

Software sometimes runs slowly - mostly due to the size of the data sets, but also potentially due to insufficient optimizations for lower level calculations. Also expensive compared to competitors.