Alteryx Software


 

Alteryx is a business intelligence platform for data analysts that offers data mining and predictive analytics. It allows users to blend data from disparate sources, including Microsoft Excel, Hadoop, and Salesforce, with built-in drag-and-drop features to prepare raw data for analytics. The software provides a multi-deployment option that includes on-premise and SaaS (Software as a Service).

Analysts can create analysis modules/sequences (a sequence of steps that determine how data will be processed or combined with other sources of data for further analysis). Results from such data modules can be shared as a report or exported to other sources, such as Microsoft Excel or data visualization software such as Tableau or QlikView. Users can download reports in multiple formats, including Excel, XML and PDF files. The solution creates the dataset for analysis or visualization using data quality, integration, and transformation tools.

Pricing is on an annual per user or per server basis.

 

Alteryx - Competition risk analysis
 
  • Alteryx - Competition risk analysis
    Competition risk analysis
  • Alteryx - Geographical analysis
    Geographical analysis
  • Alteryx - Drag-and-drop interface
    Drag-and-drop interface
  • Alteryx - Analysis module creation
    Analysis module creation
  • Alteryx - Data selection
    Data selection
  • Alteryx - Analysis module configuration
    Analysis module configuration
Supported Operating System(s):
Windows 7, Windows Vista, Windows XP, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10

31 Reviews of Alteryx

 

Start your review of Alteryx

Click to start
https://www.softwareadvice.com/bi/alteryx-review/
Software Advice Reviews (11)
More Reviews (20)

Showing 1-11 of 11

Yazir from Cochez
Specialty: Retail
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

September 2018

September 2018

Powerful and simple

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Value for Money

This is a great data handling software. Half the company runs on this.

Pros

There is basically a module for doing everything
Connectivity in both inputs and outputs is simply superb

Cons

Output to PDF to export reports might need better capabilities
Documentation of less used features might be insufficient compared to most commonly used features

Review Source
 
 

Dinesh Kumar from Lennox International Inc
Specialty: Accounting / CPA
Number of employees: 501-1,000 employees Employees number: 501-1,000 employees

September 2018

September 2018

Great tool for Process Automating

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Amazing tool for process automation and integration

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

Review Source
 
 

Joe from Cradlepoint
Specialty: Software / Technology
Number of employees: 501-1,000 employees Employees number: 501-1,000 employees

December 2017

December 2017

A fantastic ETL, data munging, data prep, and data processing tool

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Alteryx can do so much more than I use it for, so I believe the only case where Alteryx wouldn't be needed is when a department/team had a full development team to prep data pre-analysis or already has a central data store fully stood up and standardized. Alteryx works extremely well with a multitude of BI and database solutions and would be a great fit for any team trying to speed up the typical daily grind of data prep and ETL so their analytics and data team can be more agile, accurate, and automated.

Pros

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.

Cons

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.

Review Source
 
 

Adam from OIA
Specialty: Insurance
Number of employees: 11-50 employees Employees number: 11-50 employees

December 2017

December 2017

Alteryx is a great self selfservice ETL tool for non-coders

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

great customer service

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

Review Source
 
 

Allison from PHD
Specialty: Marketing Services
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

December 2016

December 2016

Alteryx Review

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

I think that Alteryx is awesome!! It has an easy layout - drag and drop. There are okay trainings through their website. I think that is where they could improve. Their customer service is AMAZING. There is an on-call chat service. They will discuss your issue with you and even do a screen-share and phone call if you need the help. I would recommend Alteryx to others who need to do data prep and predictive/advanced analytics.

 
 

Jenifer from Buxton
Specialty: Marketing Services

March 2015

March 2015

Alteryx is the most frequently used software at my office.

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Likes Best

The inputs are easy to use, the tools are easily understood and well described in the help files and they easily connect with one another. Writing neat output files is made easy regardless of file type. The ability to use R within the module has made a lot of analyses much easier.

Likes Least

The transition to newer versions of Alteryx is much too complicated when you have to skip a few of the in-between versions, which my company often does.

Recommendations

If you are looking for a clear way to visualize the steps required to carry out the steps in your analysis, if you want to be able to incorporate spatial files into the same process as you want to use R, or if you just want an easy to use program that allows a lot of flexibility with the data, this is the best out there.

 
 

Charles from Buxton
Specialty: Real Estate

March 2015

March 2015

Quite Good

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Likes Best

Alteryx seems to have ever-expanding capabilities.

Likes Least

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

Recommendations

While ArcGIS and MapInfo have been industry standards for years, the R integration and computing power of Alteryx mean it will remain a leader as quantities of data grow in the future.

 
 

Spencer from Buxton
Specialty: Other

March 2015

March 2015

Saves me hours a week and allows me to think critically more often!

Ease-of-use

Functionality

Product Quality

Customer Support

Likes Best

I love how diverse the product is. I can do a simple data pull to a demographic report to doing regression analysis for a complex model.

Likes Least

The only small complaint I have is that some of the error messages themselves are cryptic and convoluted.

Recommendations

If you have a need for automation, data compilation and data reporting, this is a very diverse tool that can revolutionize your efficiency and give your analysts more time to think critically rather than be bogged down by menial tasks.

 
 

Cameron from Buxton
Specialty: Other

March 2015

March 2015

Daily use, from quick data manipulation to full-blown wizards

Ease-of-use

Functionality

Product Quality

Customer Support

Likes Best

The best thing about this product is its ease of use! It's so easy to pick up, and so versatile that anyone can benefit from it.

Likes Least

Some of the formatting and rendering can be tedious/painful, but there is rarely anything that can't be accomplished in some way/shape/form.

Recommendations

Don't let it overwhelm you. It can seem overwhelming at times, with so many tools and different things to do, but typically the best answer is the simplest one.

 
 

Kristi from Consumer Orbit, LLC
Specialty: Consulting

March 2015

March 2015

Fast and Easy

Ease-of-use

Functionality

Product Quality

Customer Support

Likes Best

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

Likes Least

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.

Recommendations

There are a variety of tools available. Be sure to examine them all.

 
 

Stephen from Slalom
Specialty: Consulting

March 2015

March 2015

Powerful and intuitive personal ETL tool

Ease-of-use

Functionality

Product Quality

Customer Support

Likes Best

The interface is intuitive and easy to learn. Alteryx has built in capabilities to export to Tableau and Qlik.

Likes Least

Workflows can become rather large and at times slow to run.

Recommendations

This tool works great for prepping data to be used in Tableau.

 
 
 
Showing 1-20 of 20

Cristy from Wal-Mart Stores, Inc.
Number of employees: 10,000+ employees Employees number: 10,000+ employees

October 2018

October 2018

Alteryx

Ease-of-use

Functionality

Product Quality

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality

Overall, I enjoy using Alteryx and love the futurist type look it has with it's icons.

Pros

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.

Cons

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.

Review Source: Capterra
 


September 2018

September 2018

Game changer.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Postive 100%

Pros

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.

Cons

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

Review Source: Capterra
 


September 2018

September 2018

Pretty Intuitive to use

Ease-of-use

Functionality

Product Quality

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Pros

I think once you get the hang of it and learning all the tools that are available, its not that bad to use. I think for people who have less SQL/software engineering skills who want to do ETL, this is a great product. Someone who has a strong software engineering and database background it is hard for us to let go of some of our habits.

Cons

chaining/scheduling workflows is not built in
there needs to be more support for non MS SQL Server people including oracle, postgres, and redshift.

Review Source: Capterra
 

William from CRCHC
Number of employees: 51-200 employees Employees number: 51-200 employees

September 2018

September 2018

Prep like a pro

Ease-of-use

Functionality

Product Quality

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Pros

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.

Cons

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.

Review Source: Capterra
 

Lincoln from doTERRA International LLC
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

August 2018

August 2018

Alteryx simplifies and Enhances Data Preparation

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

I've loved working with Alteryx. After just 4 months of using the software, I have managed to automate over 20 daily or weekly processes that used to take all my time. I now have more time to create meaningful reports that can help management make the decisions that will keep our company moving forward.

Pros

Alteryx allows you to walk through your data preparation step by step to ensure that everything is following the exact process of orders that you want.

Cons

Occasionally, Alteryx will stop processing a workflow because of a minor error. Frequently, that minor error has a handful of different solutions, forcing you to try each solution one by one. After some experience you learn what things to look for, but when just starting out, it's a nuisance.

Review Source: Capterra
 

Raghu from Trelleborg Sealing Solutions
Number of employees: 5,001-10,000 employees Employees number: 5,001-10,000 employees

August 2018

August 2018

A simple yet powerful ETL tool

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

Easy to use UI, just drag and drop tools and start your data modelling.
Geo spatial data for spatial analysis
Blending data from different sources is quite easy.
Create and schedule data models and it will run automatically.

Cons

Integration with other tools are less compared to its competitor tools such as Informatica .etc.
Reporting option could be improved.

Review Source: GetApp
 

Carlos Alejandro from Universidad Central de Venezuela
Number of employees: 1 employee Employees number: 1 employee

August 2018

August 2018

Great Tool for non-coders

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

It very very easy to use for your analysis, you can learn quickly to use it. Also, its is very fast for process big data analysis.

Cons

It could be a little expensive and for experience the whole software you have to pay something more.

Review Source: Capterra
 

Andrew from Mars & Co.
Number of employees: 201-500 employees Employees number: 201-500 employees

August 2018

August 2018

Used in Data Analytics

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Alteryx has allowed for faster processing of large data sets, and has helped to mitigate issues that arise during the data preparation process.

Pros

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.

Cons

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.

Review Source: Capterra
 

Daniel from Tsebo Facilities Solutions
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

July 2018

July 2018

We started using Alteryx in a pilot project in November 2017, which resulted in immediate success

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Massive time saving on Analytical function as well as improvement in accuracy with data from disparate data sources

Pros

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.

Cons

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

Review Source: Capterra
 

Vishal from Alvarez & Marsal
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

June 2018

June 2018

One tool for most of your data management and preparation needs

Ease-of-use

Functionality

Product Quality

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Pros

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

Cons

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

Review Source: GetApp
 


June 2018

June 2018

My first experience with a software of data analytics, very easy to learn and useful

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

Everything is visual, you don't need to code anything. Alteryx have a big community that helps you to design, learn, and download macros.

Cons

It only gives you 14 days trial and it doesn't have a freemium version. The graphics, maps and reports are not too visually modern.

Review Source: Capterra
 

Lu from Conduent Business Services, LLC

April 2018

April 2018

I use it daily at my job

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

It is easy to use by drag and drop. All different functions can be used to prepare data. Also can analyse data in simple mathmatics.

Cons

I have to run the whole workflow when I add one more tool. Sometimes the workflow takes a lot of time.

Review Source: Capterra
 

Divya from Bain and Company

April 2018

April 2018

Powerful tool - Excel but with a better data capacity

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

1. Works with large size data - I have used 10GB files as well!
2. Easy to clean and modify data - moreover, gives you option to save workflow so that you don't have to repeat the same steps again and again

Cons

1. Whenever I run alteryx flow, numbers become string when I open them in excel. So everytime I have to remember to add one more step to change them back to numeric which is a little cumbersome
2. A few features are difficult to understand - help topics could have been more elaborate

Review Source: Capterra
 


March 2018

March 2018

Alteryx is a great software! So many uses, and really easy to learn.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

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.

Cons

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.

Review Source: Capterra
 

Emeka from Boston University College of Engineering

February 2018

February 2018

This is a great data analysis and prediction software.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

I love the easy interface and the various options for different data analysis and prediction techniques. The flexibility is top-notch.

Cons

You might have to pay extra for extra features. It's not a big deal but it's not entirely convenient.

Review Source: Capterra
 

Drew from IDM

February 2018

February 2018

Great analytics and overall tool

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

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.

Cons

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

Review Source: Capterra
 

Virginia from Winston-Salem State University
Number of employees: 501-1,000 employees Employees number: 501-1,000 employees

December 2017

December 2017

Quick and easy way to move from data exploration and blending to analysis and insight

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

This software, especially the predictive analytics piece, gave me new insight into my data. I saved time during the process of merging and cleansing data that could then be put to better use exploring, analyzing, and making decisions with the data. The work that previously required collaboration between several people to complete could be done by one person in a fraction of the time, which benefited everyone.

Pros

Alteryx has the full package starting with excellent customer service and continuing with an straightforward drag-and-drop interface. An abundance of available nodes make it simple to pull in data from many different sources, merge, union, filter, sort, and even perform statistical or predictive analysis on your data, and then disseminate it to the proper stakeholders. The visual nature of the product makes it accessible, even for beginners with no programming background, so they can start building queries right away. What I love most is how it makes the part of my job that used to be the most tedious--data prep and cleansing--fast and effortless and even fun. There are also many online training videos and community group to help build your knowledge of the product and its full range of capabilities.

Cons

Alteryx may be better suited to fields other than education; however, I can still find good use cases for it in my job.

Review Source: Capterra
 

Ravi from The Information Lab
Number of employees: 51-200 employees Employees number: 51-200 employees

December 2017

December 2017

Easy to use, beautiful interface, documentation in a cinch

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

So much time saved
Easy to share documentation without worrying about syntax, coding and verfication
Trainable to a layman analyst

Pros

Drag and drop interface, the ability to manipulate my data at any point and expand my analytics through spatial and predictive.

Cons

The Server solution could be better developed to be ready to integrate with other enterprise wide features (for example, managing users, databases, schedules)

Review Source: Capterra
 

SHiam from AUS

January 2017

January 2017

Alteryx review

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Alteryx is a data visualization software and it provides a workflow solution to analyze data.
It is a robust and requires some technical skills to use. It has a user-friendly interface and a GUI interface which provides an attractive look. The trial version is available for data analyst to try the product before making any purchase decisions.

Review Source: Capterra
 

Robin from TIL
Number of employees: 51-200 employees Employees number: 51-200 employees

December 2016

December 2016

Makes data prep and predictive analysis a breeze

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

We used to spend a lot of time in Excel and SQL queries trying to get the data right for reporting, plus if there was anything more complex involved such as forecasting or predictive model building to do, we'd have to find an R expert which really slows the process down.

Alteryx changed all that and building workflows that preps the data and spits out a clean dataset or report complete with forecasts etc. can all be done without coding and in a visual way that anyone can understand and see what's been done and where leading to the greater confidence the data is right.

Pros

Easy to use interface, extremely flexible for data analysis tasks, self-documenting, very fast on large data sets

Cons

Automating workflow is an additional cost

Review Source: Capterra