Alteryx

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.

Overall: As an analyst in the Finance dept of a large financial institution, my work is largely cyclical in nature. I need to produce the same output on a monthly basis and a lot of my processes require several manual steps which can take hours. With Alteryx Designer, I have been able to convert many of these processes to automated workflows which can achieve the same results in literally seconds. With the power of automation, I have more time for analyzing results instead of spending a great deal of time generating reports.

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

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

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

Overall: Very useful for automating processes and helps to save money. Also, increases the efficiency and make human error free.

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.

Overall: Overall, am a happy user, ALteryx saved time and effort on daily basis and opened many horizons for me to clean he data in a timely manner. If you work in a dynamic environment where quick steps in data cleaning and wranglning are required in no time then ALteryx is your first option.

Pros: Very useful to automate manual workflows with repetitive tasks. Python Integration helps to ease out the process. Saves a lot of cost. Integration with other servers and applications is top notch.

Cons: Costly license limits the use. Requires training for getting used to it.

Overall: Helps to increase efficiency and saves money for the company.

Pros: Let's be honest Data Science can be hard. Alteryx helps you do some of the heaving lifting. Can be used to blend, analyze , clean data and more.

Cons: Sometimes the flow diagram feel and look and be a little confusing to get used to at first. The best part about the learning curve is they have a wonderful company supper system that believes in the product

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

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

Overall: Alteryx has been great! It solved our business need plus so much more. The number of users in my company has been expanding since we first started using it.

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

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

Overall: I like Alteryx as a data mulipulation tool but it's also very diffult to learn.

Pros: - 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

Cons: - Hard to scale (Best use case is for individual projects)

- Expensive to use, high license cost

What do you like best?

What do you dislike?

Recommendations to others considering the product

What business problems are you solving with the product? What benefits have you realized?