Alteryx Designer

Vorteile

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.

Nachteile

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.

Vorteile

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

Nachteile

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.

Vorteile

Alteryx seems to have ever-expanding capabilities.

Nachteile

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

Vorteile

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.

Nachteile

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.

In Betracht gezogene Alternativen

Warum Alteryx Designer gewählt wurde

Zuvor genutzte Software

Gründe für den Wechsel zu Alteryx Designer

Vorteile

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.

Nachteile

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

In Betracht gezogene Alternativen

Warum Alteryx Designer gewählt wurde

Zuvor genutzte Software

Gründe für den Wechsel zu Alteryx Designer

Vorteile

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.

Nachteile

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.

Vorteile

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.

Nachteile

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

In Betracht gezogene Alternativen

Gründe für den Wechsel zu Alteryx Designer

Vorteile

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

Nachteile

Probably cost is the biggest challenge for Alteryx being widely used

Vorteile

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.

Nachteile

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.

Vorteile

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

Nachteile

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

Vorteile

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

Nachteile

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

Vorteile

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.

Nachteile

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.

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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.

Vorteile

Friendly graphic interface. The drag and drop workflows are fun to create

Nachteile

The tool is a bit pricy. However it is worth the spending when you need it

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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

Vorteile

It has a simple to use drag and drop interface.

Nachteile

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

Vorteile

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

Nachteile

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

Vorteile

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

Nachteile

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

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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.

Vorteile

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

Nachteile

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

Vorteile

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.

Nachteile

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

Vorteile

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)

Nachteile

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

Vorteile

Really like the community which sits behind the tool, makes problem solving much easier and less reliance on support team

Nachteile

I personally struggle with the UI online but know that others generally don’t

Vorteile

Alteryx est très facile d'utilisation.Le logiciel est assez intuitif pour les débutants et les leçons en ligne aident à monter rapidement en compétence !Je recommande ce logiciel à ceux voulant traiter de grandes bases de données et les transformer.

Nachteile

L'un des inconvénients pourrait être que la compréhension de ce logiciel est assez spécifique. Je ne connais pas d'autres logiciels ressemblant à Alteryx et utilisant le systèmes de bulles afin de tranformer les données.

Vorteile

Easy to use and understand the drag and drop flow layout is really nice

Nachteile

The cost of this software is prohibitive for using more broadly

Vorteile

It is a very powerful tool with close to limiteless possibilities.The user interface is colorful and user friendly.The very useful community forums are very easily accessible directly from the search function integrated to the tool.

Nachteile

Such a powerful can't be mastered within a few minutes or hours. It requests to be trained by someone who has a good knowledge of the tool. It is not always easy to understand what is going wrong with the "code" that we are creating.There is a lot of information and buttons and the meaning of some of them is not straight-forward.

Vorteile

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.

Nachteile

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.

Vorteile

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.

Nachteile

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.

Vorteile

Alteryx is very easy to use, you have a repository of tools and what is true is that the sky really is the limit. This tool will be as simple or as complex/powerful as you want or need.

Nachteile

Okay, here's a personal gripe: there's not a lot of learning available online for Alteryx and the "trainings" in the website are actually somewhat lackluster. What is available on Udemy is not as specialized as one might hope.

Vorteile

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

Nachteile

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

Vorteile

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.

Nachteile

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.

Vorteile

Alteryx is a tool that you can easily learn and use.Its saves you time.

Nachteile

At the point when different users access the same workflow on a server it may become unstable.

Vorteile

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.

Nachteile

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.

Vorteile

Alteryx execution of Workflows.
Alteryx recording and execute feature

Nachteile

Automation testing is very tough with other desktop tools like AutoIt, UIPath and Winappdriver.

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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!

Vorteile

Alteryx is a great tool when need of integrating multiple or complicated analytics pipelines in one place and manage them in a systematics manner. It provides a variety of data connections to common relational database product and web resources. It also provides plugins to add other product such as Tableau, etc.

Nachteile

The desktop application used to crash (not responding) in case of loading large sized data. It also gets very slow when moving or drag-dropping objects in the authoring environment.

Vorteile

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

Nachteile

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.

Vorteile

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.

Nachteile

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

Vorteile

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.

Nachteile

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.

Vorteile

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

Nachteile

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

Vorteile

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.

Nachteile

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.

Vorteile

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

Nachteile

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

Vorteile

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

Nachteile

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

Vorteile

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

Nachteile

I heard from Admin that license is expensive