Alteryx Features

Alteryx

Self-service data analytics platform for business analysts

4.73/5 (69 reviews)

Alteryx Feature Summary

  • Share analytic apps within private teams or publicly
  • Prep, blend and analyze data via repeatable workflows
  • Build data models with drag-and-drop workflows
  • Create and share data insights via reports and apps
  • Visualize data blends and models with Alteryx Designer
  • Connect, access & blend business data from multiple sources
  • Use interactive visualizations to validate model results
  • 30+ drag-and-drop predictive tools based on the R language
  • Output spatial analytics to mappings & visualizations
  • Add governance and security with Alteryx Server

Competitor Feature Comparison

Active Directory Integration
Activity Dashboard
Ad hoc Analysis
Ad hoc Query
Ad hoc Reporting
Application Sharing
Authentication
Business Analysis
Configurable Workflow
Customizable Reporting
Dashboard Creation
Data Filtering
Data Visualization
Predictive Analytics
Third Party Integration
Trend Analysis
Visual Analytics
Learn moreCompare App
Active Directory Integration
Activity Dashboard
Ad hoc Analysis
Ad hoc Query
Ad hoc Reporting
Application Sharing
Authentication
Business Analysis
Configurable Workflow
Customizable Reporting
Dashboard Creation
Data Filtering
Data Visualization
Predictive Analytics
Third Party Integration
Trend Analysis
Visual Analytics
Visit WebsiteCompare App
Active Directory Integration
Activity Dashboard
Ad hoc Analysis
Ad hoc Query
Ad hoc Reporting
Application Sharing
Authentication
Business Analysis
Configurable Workflow
Customizable Reporting
Dashboard Creation
Data Filtering
Data Visualization
Predictive Analytics
Third Party Integration
Trend Analysis
Visual Analytics
Visit WebsiteCompare App

Alteryx Feature Reviews

25 reviewers had the following to say about Alteryx's features:

Anonymous
(Financial Services company, 10001+ employees)

Pretty good data analytics software

2019-02-05

Business problems like considation, analytics, dashboard and reporting can be made very convenient

Pros

Seamless integration with excel, database other sources Good reporting options

Cons

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

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Raghu Nandhan

Verified Reviewer

A simple yet powerful ETL tool

2018-08-24

Pros

Easy to use UI, just drag and drop tools and start your data modelling.

Cons

Integration with other tools are less compared to its competitor tools such as Informatica .etc.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: GetApp
Helpful?   Yes   No
Read more
Daniel De Wet, MBA (Open), CMgr, FCMI

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

2018-07-13

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

Pros

Ease of deployment in 'non-analytics' environment was a big enabler.

Cons

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

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Neil Boughey

Alteryx - Take back control of your Data.

2019-11-12

Our experience with this product is that it has transformed our ability to analyse, consume, and report on our data in a way that make sense to the business.

Pros

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.

Cons

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

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Dinesh Kumar Baskar

Great tool for Process Automating

2018-09-12

Amazing tool for process automation and integration

Pros

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

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Software Advice
Helpful?   Yes   No
Read more
Anonymous
(Financial Services company, 10001+ employees)

Tool for automating excel workflows

2019-02-20

It was nice, I have been automating excel user tools with it

Pros

It provides a no. of tools for data blending, data sorting, data extraction , generating reports and emailing them.

Cons

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.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: Less than 6 months

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Robin Kennedy

Makes data prep and predictive analysis a breeze

2016-12-05

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.

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

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Ravi Mistry

Easy to use, beautiful interface, documentation in a cinch

2017-12-05

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)

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Vikesh Bhartee

Verified Reviewer

Must have tool for analysts

2018-12-15

Pros

Ability to import data from and export data into variety of data sources 3.

Cons

Lack of (or limited) visualisation capability. 2.machine dependent licensed(it should had license key Linked to email ID, making it easier to port licensed from one system to another) 3.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: GetApp
Helpful?   Yes   No
Read more
Virginia Moench

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

2017-12-05

This software, especially the predictive analytics piece, gave me new insight into my data.

Pros

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.

Cons

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

Rating breakdown

Value for money
Ease of use
Features
Customer support

Frequency of use: Occasionally

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
ROMARIO GARCIA

An extraordinarily ETL tool

2020-04-02

I have not used the analysis and ML capabilities that it offers, but for my use case, I find it very helpful.

Pros

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.

Cons

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

Rating breakdown

Ease of use
Features

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Hospitality company, 501-1000 employees)

Top tier point-and-click analytics tool

2019-04-30

Pros

This tool's ease of use allows our non-analytical teammates to easily do basic data analysis by themselves, freeing up our analytics team for more technical questions

Cons

For those who are unfamiliar with self-serve/point-and-click analytics tools, the software can be a little overwhelming for the first few hours

Rating breakdown

Ease of use
Features

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Hospital & Health Care company, 1001-5000 employees)

Great cleaning tool.

2019-12-27

It helps clean data, and make things easier to read for once you get to the visualization stage of the data analysis process.

Pros

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.

Cons

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

Rating breakdown

Ease of use
Features

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Financial Services company, 10001+ employees)

Go With The Flow - Automation using Alteryx Designer

2019-04-07

With the power of automation, I have more time for analyzing results instead of spending a great deal of time generating reports.

Pros

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.

Cons

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.

Rating breakdown

Ease of use
Features

Time used: 6-12 months

Frequency of use: Monthly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Jaehoon Lee

A good tool for automating complicated analytics pipelines

2019-02-24

Alteryx is a good tool and well fits in our need of clinical data management and analytics pipeline optimization.

Pros

Alteryx is a great tool when need of integrating multiple or complicated analytics pipelines in one place and manage them in a systematics manner.

Cons

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.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Financial Services company, 1001-5000 employees)

Easy, Pricy but Worth it

2019-09-03

I'm a Technology Consultant, using ALteryx for ETL projects where analyse the data is a critical job and the size of the data, wouldn't allow me to use tools like excel .

Pros

Built in tool like time Formaters, filters and Joins facilitate the work of doing data cleansing and data prepping for any ETL job.

Cons

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.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Joe Root

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

2017-12-12

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.

Cons

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.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Software Advice
Helpful?   Yes   No
Read more
Yazir Paredes

Powerful and simple

2018-09-25

This is a great data handling software.

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

Rating breakdown

Value for money
Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Software Advice
Helpful?   Yes   No
Read more
Spencer Vigil

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

2015-03-20

Pros

I can do a simple data pull to a demographic report to doing regression analysis for a complex model.

Cons

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

Rating breakdown

Ease of use
Features
Customer support

Time used: 2+ years

Likelihood to recommend

10/10

Recommendations to others considering Alteryx

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.

Source: Software Advice
Helpful?   Yes   No
Read more
Anonymous
(Consumer Services company, 10001+ employees)

Alteryx Designer

2019-05-03

Alteryx is one of the fastest & easiest softwares to use for data processing, data modeling, and data visualization.

Pros

Processes massive amounts of data very quickly, even on a desktop/laptop.

Cons

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

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Electrical/Electronic Manufacturing company, 10001+ employees)

So many uses!

2019-02-12

It solved our business need plus so much more.

Pros

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

Also there are so many tools and more than one way to achieve the same thing.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Robert Weinstein

Best Tool for Mashing Data

2019-12-03

It allows me to provide analysis in a simple way, be creative in how I manipulate the data and even create automated running of the workflow.

Pros

Alteryx has a fantastic interface, using function blocks that you can drag and drop to create a workflow.

Cons

The license cost for the tool is very high, which means not everyone can use it.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Accounting company, 10001+ employees)

Review of Alteryx

2019-01-08

Pros

I loved how quickly the user is able to learn this software. The tools are in the form of images and are extremely intuitive and helpful.

Cons

It's not possible to run just a small portion of a project without loading all the data back in again.

Rating breakdown

Ease of use
Features

Time used: Less than 6 months

Frequency of use: Weekly

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Management Consulting company, 10001+ employees)

Simple and easy to use data prep, data processing and ETL tool with intuitive drag and drop visuals

2019-01-24

Pros

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

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Retail company, 201-500 employees)

Alteryx

2019-02-12

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

Pros

Because you're creating the workflow, each of the steps are easily auditable and you can swap out the source files when it changes.

Cons

It's hard to get started without some sort of live tutorial from someone that has been using it for a long time.

Rating breakdown

Value for money
Ease of use
Features

Time used: 1-2 years

Frequency of use: Occasionally

Likelihood to recommend

6/10
Source: Capterra
Helpful?   Yes   No
Read more