My team has been running Tableau reports for clinicians, researchers, and leadership in our organization. As we have developed more reports we had strong needs of managing data pipelines in a systematic way. In many cases, ETL processes were managed individually by data developers and analysts and there were issues of report ownership, data consistency, and management issues. We adopted Alteryx and automated two types of processes: ETL processes and Tableau data extract creation. Alteryx provided values in terms of systemized pipeline management and query performance.,Alteryx provides an integrated workflow management environment for data blending, analytics, and reporting. It is also very extensible to be connected to a variety of data connections including major databases (Oracle, etc.), analytics tools (R), and visualization tools such as Tableau through its plugins. Our department used Oracle and Tableau already and it was well integrated with Alteryx. The workflow authoring environment in Desktop is easy to use so that most of the users (if they are a bit skilled data developers or analysts) may not need the training to use its basic functions. Drag and drop interface and icons are intuitive to understand. When running Alteryx workflows, it is easy to monitor and track what's the progress by seeing percentages. It is helpful to balance and manage bandwidths of database servers, especially when to populate large data sets.,Sometimes the desktop version of authoring tool crashes! It's been unstable in the previous versions but gets better. Even if it doesn't crash, it used to be slow or not responding. When running several version of database drivers in local machine or server, it is tricky to set up database connections. Often you have to figure out it by googling the problem and solution. There are not many knowledge bases from Alteryx. Alteryx project file creates .bak file automatically. It is useful to prevent for the purpose of back up, sometimes it's not necessary. But it is not changeable for some reason. By default, it always creates backups.,8,,8,6,Tableau Desktop, Tableau Server, IBM Cognos, Cerner HealtheIntentAlteryx use began in the marketing department to help automate data prep pre-Tableau from data sourced from Salesforce. It is now also being used by the IT department to help join multiple data sources to automate data munging for some standard report generation. The primary business problem Alteryx helps our team with is helping analyst move much more quickly by building data workflows visually instead of creating hundreds to thousands of lines of code to move and prep the same data.,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.,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.,10,Jitterbit,10,10,Tableau Online, Tableau Desktop, Google Analytics, Salesforce Analytics Cloud, PostgreSQL, Marketo

Alteryx Analytics Reviews

Score 8.7 out of 10

Vendors can't alter or remove reviews. Here's why.

April 30, 2018

Alteryx Analytics Review: "Alteryx is a good tool for analytics productivity"

Verified User

Project Manager in Research & Development

Hospital & Health Care Company, 10,001+ employees

Score 8 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Pros and Cons

Alteryx provides an integrated workflow management environment for data blending, analytics, and reporting. It is also very extensible to be connected to a variety of data connections including major databases (Oracle, etc.), analytics tools (R), and visualization tools such as Tableau through its plugins. Our department used Oracle and Tableau already and it was well integrated with Alteryx.
The workflow authoring environment in Desktop is easy to use so that most of the users (if they are a bit skilled data developers or analysts) may not need the training to use its basic functions. Drag and drop interface and icons are intuitive to understand.
When running Alteryx workflows, it is easy to monitor and track what's the progress by seeing percentages. It is helpful to balance and manage bandwidths of database servers, especially when to populate large data sets.

Sometimes the desktop version of authoring tool crashes! It's been unstable in the previous versions but gets better. Even if it doesn't crash, it used to be slow or not responding.
When running several version of database drivers in local machine or server, it is tricky to set up database connections. Often you have to figure out it by googling the problem and solution. There are not many knowledge bases from Alteryx.
Alteryx project file creates .bak file automatically. It is useful to prevent for the purpose of back up, sometimes it's not necessary. But it is not changeable for some reason. By default, it always creates backups.

Likelihood to Recommend

Well suited: if an organization already has a lot of running ETLs or pipelines but need to systemize them, Alteryx is a good choice. It would be good to figure out how well Alteryx would be harmonized with the existing components, but in a general sense, it may be well harmonized.

Less appropriate: Alteryx is good for "automation", but some data developers and analysts may prefer to remain and keep using SQL tools. One should be careful of not just adding "one more layer or tool" into the existing pipeline and make it more complicated to manage.

Read this authenticated review

December 05, 2017

Alteryx Analytics Review: "Alteryx: One Tool, Unlimited Applications"

Cameron Tubbs

Senior Predictive Analyst

BuxtonMarket Research, 51-200 employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx is predominantly used by our predictive analytics department, but some use is spreading out to our data teams given the user-friendly interface and its ability to handle "big data". We also use it for some internal tools that allow other departments, who may not be as familiar with the product, to run reports and gather data specific to our processes that allow them to more easily do their internal reporting. Alteryx is used for a wide range of things, from data cleansing to general data manipulation that helps answers a client's day-to-day questions, all the way to report automation and "wizarding" that provides clients with their solution(s).

Pros and Cons

User-friendly interface - the tool structure and general workspace are very easy to pick up on. Short learning curve from "no experience" to "beginner user".
Standardization - modules/wizards allow a single tool to generate results for multiple clients, all through the use of a few actions/inputs.
Analytics - wide range of statistical analytics tools makes it easy for a user to look at data and provide simple summary statistics, while also having the ability to build advanced regression models.

Excel reporting - reports in PDF are fairly straightforward, but trying to output results in Excel can prove to be tricky/ugly.
Chart creation - current chart tool is very basic; needs to be a way to customize the look/feel of a chart more, as well as an easier way to incorporate "big" data that can be easily reported on/viewed.

Likelihood to Recommend

More often than not, Alteryx can handle any situation or scenario thrown at it. Some may take a little more "trickery" along the way, but for the most part it is fairly easy to get from point A (data) to point B (results/report). And the nice thing is is that there is more than one way to produce the same result - two people with two different mindsets can ultimately create the same thing, but do so in a way that is better suited for their skill level.

Read Cameron Tubbs's full review

December 05, 2017

Alteryx Analytics Review: "Alteryx - powerful and easy to use"

Sanket Bharaswadkar

Process Analyst

HoneywellWarehousing, 10,001+ employees

Score 8 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

We used Alteryx for analyzing pre-sales data. We had a proposal management system which generated a lot of numbers. My job as a process analyst was to use Alteryx to get insights into making the process efficient. It helped us in identifying bottle necks and focusing on problem areas.

The solution engineers were able to better design the proposals which resulted in client satisfaction and savings for the company.

Pros and Cons

Cleaning datasets
Preparing data for analyzing
Customer data analytics
Transforming data from one format to other

Poor documentation
Costly
Overkill for simple tasks
Not many options for data visualization

Likelihood to Recommend

It is very well suited for mid-sized data operations. One person working on a project is ideal. I have not used Alteryx in a collaborative project, so can't say for sure. It is quite powerful and compares well with the competitors. If you have data from disparate sources, it helps to have a tool like Alteryx.

Read Sanket Bharaswadkar's full review

November 22, 2017

Alteryx Analytics Review: "A fantastic ETL, data munging, data prep, and data processing tool"

Joe Root

Marketing Technology & Intelligence Program Manager

Cradlepoint, Inc.Computer Networking, 501-1000 employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx use began in the marketing department to help automate data prep pre-Tableau from data sourced from Salesforce. It is now also being used by the IT department to help join multiple data sources to automate data munging for some standard report generation. The primary business problem Alteryx helps our team with is helping analyst move much more quickly by building data workflows visually instead of creating hundreds to thousands of lines of code to move and prep the same data.

Pros and Cons

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.

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.

Likelihood to Recommend

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.

Read Joe Root's full review

December 06, 2017

Alteryx Analytics Review: "Alteryx: a pocket BI solution"

Verified User

Consultant in Information Technology

Retail Company, 10,001+ employees

Score 8 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx is the primary ETL/analytics tool being used by our BI users. Alteryx is particularly popular because of its ability to create a Tableau data extract and thus provides a meaningful alternative to Tableau's missing data blending capabilities. Alteryx offers a range of tools that can be used to clean/prepare your data for analytics along with ETL capabilities. Alteryx has some amazing analytics capabilities including but not limited to spatial, behavioral, predictive etc.

Pros and Cons

The ability to create a TDE(Tableau data extract)
The ability to use geo spatial data for spatial analysis
The range of tools that can be used to clean/prepare your data

Alteryx lacks good visualization capabilities
Alteryx does not run on Mac(IOS)
Alteryx is not as stable as some of the enterprise-grade tools like DataStage

Likelihood to Recommend

Alteryx analytics is particularly well suited for situations where a BI user needs to quickly prepare the data for analysis
Alteryx sells tom-tom maps and these maps are extremely useful for spatial analysis and help real estate or SCM teams plot routes and spatial charts
Alteryx makes predictive modeling easy
Alteryx lacks the capability to produce good visualization hence one should never try to achieve an end to end BI solution using only Alteryx.
If you prefer using a MacBook then you need to use a Windows VM to run alt Alteryx

Read this authenticated review

December 05, 2017

Alteryx Analytics Review: "Simple, efficient yet powerful Alteryx"

Verified User

Professional in Professional Services

Education Management Company, 10,001+ employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx is being used into its full potential to collect data, bend and prepare, analyze/summarize as well as create automation workflows, what-if analysis toolkits, and to do statistical modeling of data. It has simplified the way analytics used to be done as well as taken the same to the masses.

Pros and Cons

Quick data blending.
Wide range of analytical coverage - ETL, Descriptive and Predictive analytics.
Ease of learning for new users.

Iterations/ looping/ interactive user interface creation is cumbersome for new users.
Missing prescriptive analytics modules.

Likelihood to Recommend

Most suited: Teams involved in BI and reporting can do data analysis, blending and analysis really quickly as well as do the statistical analysis and expand the horizon of analytics into the organization with ease.

Less appropriate: Organizations that have low analytics adoption and more of visual report consumption culture would find it difficult to resonate with the value proposition of Alteryx.

Read this authenticated review

March 27, 2017

Alteryx Analytics Review: "Alteryx: Making life easier!!"

Verified User

Engineer in Information Technology

Information Services Company, 1001-5000 employees

Score 9 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx Analytics was being used by a team I was working with that wanted to check different Analytical software available in the market to see which one would be the best suited for our purpose. We wanted to be able to repeatedly analyze the same kind of data from different sources. Alteryx made our life easier by making it really easy to blend data from different kinds of sources.

Pros and Cons

It's great at blending data from different sources. I loved how easy it was.
There is a huge variety of visualizations that are available as well.
A lot of drag and drop options available for different workflows.
Open APIs available are a great help.

I would love better training videos on their website.
Trying to automate the workflow is at an additional cost.
If we happen to skip a few versions of Alteryx then it gets difficult to get accustomed to newer versions.

Likelihood to Recommend

I know I have stated this already, but it really is very helpful for blending data from different sources. [It's] great where the people using it do not know coding. Love the drag and drop options. Makes life really easy. Could be a hassle trying to learn it for the first time due to the quality of training videos. It is improving a lot day by day and I love the way they are going with the product.

Read this authenticated review

March 22, 2017

Alteryx Analytics Review: "Alteryx - One tool for All"

Verified User

Engineer in Information Technology

Retail Company, 10,001+ employees

Score 9 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

My department is using Alteryx extensively and it is a great tool to perform ETL operations. We use Alteryx for various purposes and to implement many complex operations and automations.

Pros and Cons

Alteryx can publish to Tableau server which can be used as an extract and data source for Tableau.
Scheduling on Alteryx server is a great functionality which helps to schedule the workflows automatically on the server without manual intervention.
Analyzing the data is great - we can export the data in Excel, CSV; browse the data and so on.

Alteryx should provide Tableau Data Extracts (TDE) as an input option, it would be really helpful. It's more to do on Tableau side though.
We should be able to filter and manipulate the browse thing in Alteryx so that we can analyze even better.

Likelihood to Recommend

Alteryx is great at doing complex manipulations like filtering out the data and summarizing, without writing a single line of code. Also, publishing on Tableau Server is a great feature where we can use it as a source in Tableau.

Read this authenticated review

October 10, 2016

Alteryx Analytics Review: "Alteryx for many things"

Rana Banerji

General Manager

Tridant Pty LtdInformation Technology and Services, 51-200 employees

Score 9 out of 10

Vetted Review

Reseller

Use Cases and Deployment Scope

We use Alteryx for data cleansing, prep and analytics across sales and marketing functions, i.e. blending CRM, Excel and MailChimp data.

Pros and Cons

Breadth of data sources available (Excel to Big Data)
Easy to learn and use
Makes applying predictive analytics simpler
Alteryx community is a great place to learn and share workflows
Alteryx Gallery is a great platform to share apps

Alteryx Gallery needs a fresher UI
Automating workflows that blend Excel would greatly improve productivity

Likelihood to Recommend

Alteryx is suited for many, many use cases and scenarios - too many to mention.

Read Rana Banerji's full review

December 16, 2016

Alteryx Analytics Review: "Alteryx: Making life easier!"

Verified User

Engineer in Research & Development

Education Management Company, 11-50 employees

Score 9 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

I used Alteryx Analytics individually for some research that I was doing for one of the data projects that I had. It has an intuitive workflow for data blending and analytics. It makes all the processes much faster compared to what it was before.

Pros and Cons

It can independently generate required analytics instead of having to require specialists.
The ability to read and write in a multitude of formats: from Excel, Access tables, Tableau and Teradata to MapInfo, ESRI, Google Earth, etc.
Single drag and drop workflow instead of multiple tools.

The visualization that Alteryx provides can be improved much more than where it stands tonight.
It doesn't seem to be able to process Big Data as efficiently as I would have liked.
There are a lot of things that you need to learn.

Likelihood to Recommend

It is well suited where the user likes to write some code from time to time and also in cases where machine learning is required. Alteryx uses R for its machine learning which makes it life easier. Scenarios where maps need to be created for visualization are the examples. It lags a lot compared to other similar softwares for visualization but is very friendly for data analysis.

Read this authenticated review

December 20, 2016

Alteryx Analytics Review: "Alteryx: Faster and Easier."

Verified User

Engineer in Information Technology

Education Management Company, 11-50 employees

Score 9 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx Analytics has been used by my organization on a very small scale as of now. It is being used by only me for now. It can be used to blend data easily without any hassles and to remove the complexity for predictive analysis for people without detailed knowledge about those things.

Pros and Cons

Blends data beautifully.
Easily interacts with most databases.
Great integration with R.

Reading tableau data.
The price seems to be really expensive.
Support for special characters isn't the best.

Likelihood to Recommend

The ability to abstract processing and to modularize is a useful software development model made more efficient by the clean, modular approach of the software. This lets users leverage prior modules and workflows effectively and somewhat transparently. It seamlessly uses R for its machine learning side.

Read this authenticated review

September 11, 2015

Alteryx Analytics Review: "Organization made easy."

Darrell Haley Jr.

Associate Program Manager

IDM, Inc.Marketing and Advertising, 51-200 employees

Score 9 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

We specifically use Alteryx for data blending. Due to our multi-sourced approach, we receive multiple data sources in aggregate and find value in combining them into a database. It helps us gain intelligence on specific client-related asks in a simple, easy to use format. It really allows us to stay agile and manipulate data at a fast pace, something that is lacking in Excel alone.

Pros and Cons

Blend multiple sources of data
Append or update existing data
Allows for powerful insights for non-technical users

Improve work flow in modules, sometimes buggy when dealing with multiple files
On-screen wizard could help demonstrate common best practices
Add more tools that could benefit the user without them having to create macros

Likelihood to Recommend

It is great for dealing with mass quantities of data, not so good if you're trying to analyze. If you're dealing with 50k+ records, then it probably is considerably faster to deep-dive into the data with Alteryx. However, for anything under that, Excel is the better program for visually finding patterns and trends in data, at least for someone who has a limited tech background.

Read Darrell Haley Jr.'s full review

September 01, 2015

Alteryx Analytics Review: "Tired of processing a bunch of Excel files, let's give a try to Alteryx."

Tran Huynh

Research Analyst and IT Support

Salesify, Inc.Information Technology and Services, 201-500 employees

Score 8 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Salesify’s products arm data-driven marketers and sales professionals with critical B2B Customer and Business Intelligence. We provide millions of high quality, relevant companies and contacts at the tip of your fingers with the help of our customer data analysis. All the data team is using Alteryx now to process tons of raw data to filter, cleanse and append relevant information based on customer requests. Its super fast processing performance helps us reduce considerable times of running big queries, opening large files and combining different sources.

Pros and Cons

Automation macros
Query simultaneously across instances
Process big files
Output multiple file types

More options for each tool
Not compatible when running at high DPI
Should have an account page online to manage license

Likelihood to Recommend

Ask about documentation, maintenance and support.

Read Tran Huynh's full review

June 03, 2015

Alteryx Analytics Review: "Incredibly Fast and Flexible"

Dan Chapman

Manager, Market & Competitive Insights

Office DepotBusiness Supplies and Equipment, 10,001+ employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

I am the sole user of Alteryx at Office Depot and it has become critical to just about everything that I do. In a nutshell, tasks and projects that would take the use of sometimes several programs (GIS, Access, Teradata, PowerPoint, Excel, etc.) and many hours, if not days to complete, can now be done in many cases using just one program and in a fraction of the time. Alteryx has made me incredibily more productive and efficient at my job. Though I have the only license in the company, there is definitely a huge opportunity for it to be used across the organization.

Pros and Cons

Spatial analysis in breakneck speed when compared against GIS. Add to that some pretty comprehensive mapping capabilities. My MapInfo Professional GIS is used less and less.
The incredible speed at which it reads and processes data (spatial and otherwise).
The ability to read and write in a multitude of formats: from Excel, Access tables, Tableau and Teradata to MapInfo, ESRI, Google Earth, etc. The flexibility is awesome.
Fantastic customer service with a live expert that answers everytime.

Creating maps can be a challenge sometimes as the process can be time consuming, and depending on the complexity of the map, it can take learning some nuances about the program.

Likelihood to Recommend

Great for working with huge sets of data (and small sets too). Very well suited for geographic and data analysis. Fantastic for combining data from multiple sources into one and writing data and reports out to Excel, PowerPoint, Access, text files and even several GIS platforms. It is easy to write out data to multiple files/slides/databases (and I'm talking thousands of files if necessary). Can produce great looking maps when the time is put in. This program would not be appropriate for companies with only small datasets. The program can be expensive but I understand that they recently tiered their products at different price levels.

Read Dan Chapman's full review

November 10, 2014

Alteryx Analytics Review: "Alteryx: One man's opinion backed by years of experience."

Mark Frisch

Director, Technology Services

ExperianInformation Technology and Services, 5001-10,000 employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx is used within Development, Analytics and Client Services organizations within our company to handle a variety of business problems. It contributes to our data product development, business intelligence and ETL processes necessary to server our Marketing Service customers. It provides ease of use in both experienced developers hands as well as to analysts with limited data processing education. Data aggregation, model development, spatial analysis and business intelligence all fall within the sweet spots of Alteryx processing.

Pros and Cons

Alteryx democratizes data and quickly allows analysts the ability to turn data into intelligence. Data exploration can take new depths as users are capable of interrogating larger sets of data in reduced timeframes. Processes timeframes are reduced to fractions of their legacy counterparts.
Innovation has been accelerated by using Alteryx to develop quick prototypes that can rapidly be deployed for production use. Similarly, we have used Alteryx to replatform legacy systems. The transition to Alteryx not only reduces the infrastructure requirements, but also places the application/product into a new paradigm for processing, allowing innovative enhancements that were once limited by the legacy system(s).
Alteryx is a viral application. We've used Alteryx course training, in-house training, webinars and videos and our user community continues to grow. Alteryx is feature rich and each version of software builds reliably on prior versions. New users quickly come to speed on Alteryx and supoprt requirements for new users is minimal.

Alteryx seeks feedback from the user community. We regularly provide Alteryx with detailed requirements for supporting our data processing needs and Alteryx consistently delivers required functionality in their software updates.
Alteryx is rapidly expanding support for advanced analytics and delivery of consumable analytic tools. Alteryx can call other applications if necessary, but can also run R natively. Alteryx has been working both on expanding their delivered modeling toolset as well as enhancing their software to improve the performance of R.
While parallel processing is performed, there are times that I'd like to see more of it. Alteryx makes it easy to browse data within modules, but the browse output (tabular) is not readily filterable/sortable. Improvements to the user interface would be welcomed.
Alteryx allows users to schedule individual jobs for execution, but doesn't provide advanced scheduling tools to establish workflows where jobs executions have outside dependencies.

Likelihood to Recommend

I am admittedly a Customer Evangalist for Alteryx and believe that Alteryx should be considered as a solution enabler in most cases. Alteryx allows for connection to data of many types and sources. If Alteryx complicates or lengthens the execution time of a process because of the need to move data from one point to another, I'd likely rearchitect the solution.

Call Alteryx and see how quickly they respond to your needs. Client Services is available most hours either by phone, email or chat. You can post to their community boards. They are very responsive and seek high customer satisfaction. They are very accessible and if you want to talk to their Chief Customer Officer, she'll get on the phone with you.

Read Mark Frisch's full review

November 05, 2014

Alteryx Analytics Review: "Awe Inspiring Omniscient‎ Alteryx"

Spencer Vigil

Predictive Analyst

BuxtonMarket Research, 51-200 employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Buxton utilizes Alteryx to automate our processes for building regression models. It is used from everything from variable generation to building models using R and then to implement the final product to our customers. It is used by multiple departments to complete these tasks. It is able to stream line the processes that we do on a daily basis in order to shorten our projected delivery time.

Pros and Cons

Alteryx is a very versatile program to use. Whether you are formatting data or running complex models it can be efficient and helpful.
Alteryx interface is very easy to follow. There is code behind all of the tools but the visual appearance of the tools and process flow allow the user to visually see exactly what is going on behind the scenes.
Alteryx can be used by a variety of skill levels. Beginners can benefit greatly from already built modules. Experts can be innovative and provide company wide solutions that will streamline processes and make results more consistent.

Some error messages seem too ambiguous. Granted user error is a major cause of problems, it could still be beneficial to have the error point more closely to the area that is malfunctioning.
Reporting tools are difficult at times to get formats exactly fine tuned to the desired output.

Likelihood to Recommend

When working with a lot of data where processes will be repeated in a similar fashion it is a must have. It cuts down on re work and gives the user the option to re-use past work in order to focus on more important theoretical aspects of the project. For one off formatting or similar tasks it might still be better to utilize other tools. PS SQL and R are two good programs to have a working knowledge of while working in Alteryx.

Read Spencer Vigil's full review

September 12, 2014

Alteryx Analytics Review: "Data blending made easy!"

Shaun Beckett

Data Analyst & Creative Integration

LS Direct MarketingMarketing and Advertising, 11-50 employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

I use Alteryx for 99% of my data work at my company. The main reasons are: its incredible speed; user friendly interface; dynamic functionality; and above all its seamless integration with outside data sources and reporting engines. I highly recommend Alteryx for any company that is serious about data.

Pros and Cons

Speed
Usability
Integration
Functionality
Predictive Modeling
Blending
Spatial

Just keep making it faster and easier to use!

Likelihood to Recommend

I wouldn't use Alteryx to do a lot of reporting, but thanks to its integration with Tableau, that is covered. Still the best BI data blending software out there.

Read Shaun Beckett's full review

March 31, 2014

Alteryx Analytics: "Alteryx the leading provider of strategic analytical solutions"

Nick Lensing

Data Engineer

Virtual DBSMarketing and Advertising, 51-200 employees

Score 9 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx is the tool of choice for data manipulation. It is being used in departments that have a need to solve complex and custom data processing problems. It solves all problems for the direct mail industry.

Pros and Cons

Alteryx handles metadata really well. The tools are intuitive in their use.
For analytics Alteryx it is a great platform.
There are barely any software bugs in the product.
The error messages are actually helpful to debug modules.
If a load-balancing application is internally developed on top of Alteryx processing nationwide universes can be really fast.

Speed is somewhat lacking.
It isn't optimally geared for ETL.
Intellisense would be a nice feature
There is no version control.
The tools could use some more features.
More pre-built macros would be nice

Likelihood to Recommend

It is a great departmental solution.

Read Nick Lensing's full review

March 26, 2014

Alteryx Analytics Review: "Great One-Stop Shop for Analysis"

Adrian Harvey, MBA

Vice President of Analytics

BuxtonMarket Research, 51-200 employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

We use Alteryx in a multitude of ways. We use it to generate geo-spatial variables for regression models as well as reporting. We also use Alteryx for internal analysis and data manipulation.

Pros and Cons

Alteryx is very easy to learn. It's really good at handling very large datasets and allows users the flexibility to manipulate data in many ways.
The user support is very helpful for Alteryx. The client services reps are very nice and always helpful when you have questions.
The analytic tools have made the software more well rounded as an end to end solution.

The R tools, although a very nice addition, are not easily modifiable so they can be somewhat limited in flexibility.
The mapping and graph/charting tools continue to be a drawback for Alteryx. We'd love to use Alteryx as the all in one stop shop solution for analysis, mapping, and reporting but it's maps and charts can't hold a candle to Excel Charts or Mapinfo/ESRI maps.
Processing speed is hit or miss depending on the size of what you're running through it. Generally, Alteryx is great at this but in cases where you're needing to process large data on the fly, things can take hours or days to run. This may not be easily resolvable but in much of our investigations, it seems like how Alteryx maybe could handle processing and optimizing the machine it's run on better. For example, a Quad-Core processor machine with 16GB of Ram may only use a quarter of it's threads to run Alteryx processes so we don't realize noticeable speed gains when run large jobs on our power boxes compared to smaller machines.

Likelihood to Recommend

Alteryx is best suited for analytical departments, mapping/GIS teams, and data teams that need to manipulate data. It is less equipped to be the all around solution if you're looking to make very impressive reports with very customizable maps. But generally speaking, it's very useful and expected to continue to capture a larger audience over time.

Read Adrian Harvey, MBA's full review

March 28, 2014

Alteryx Analytics Review: "give it a chance."

sudhir mohanraj

Software Engineer

Cerner CorporationInformation Technology and Services, 51-200 employees

Score 8 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

It was used by a department. To see the mobile area coverage across an area.

Pros and Cons

Reads in large amounts of data pretty efficiently; provided it has enough power. Pretty much takes in any format of data and gives the output in the format needed.
Easy to learn.Tools are named logically and hence easier to understand.
Integrates with SQL pretty well.
Helpful Online sites.
Good Onsite support.
Supports processing of large amounts of data pretty efficiently; again provided machine has enough power.

Variety of Maps provided are not always what the customer wants; so customizable maps would be nice.

Likelihood to Recommend

It is well suited if you have a use case of huge amounts of data needing to be mapped out or performing analytics on it.

Read sudhir mohanraj's full review

February 04, 2015

Alteryx Analytics Review: "The pros and cons of Alteryx"

Verified User

Analyst in Other

Marketing and Advertising Company, 1001-5000 employees

Score 8 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx is currently used for geospatial data processing an analysis by a team of five within the company. Alteryx allows us to easily address drive time analysis, demographic analysis, and our analyses with geospatial components.

Pros and Cons

The drag and drop interface is very intuitive allowing users to hit the ground running on this product.
Alteryx allows input and output of various data types (.csv, .tab, .shp, .png, .xlsx, .yxdb, etc.)
The user is able to "browse' the data along the way unlike some data processing programs.

The map visualization is terrible. If you're planning on outputting presentation worthy maps, Alteryx is not the software for it!
The program has glitches - sometimes everything will be created perfectly (data joining as it should, appropriate fields selected, etc), but the program will fail to read in or "update" the workstream and cause errors
Though Alteryx is touted as "Big Data" friendly, we have seen those limits reached (billions of records) and been disappointed with run times.

Likelihood to Recommend

Alteryx is particularly well-suited for demographic analysis and drive time analysis. Anything at the block group level seems to run quickly and without a hitch. Below though things get bogged down and slow. I would never suggest Alteryx as a map visualization software as this function is not user friendly and does not create presentation-quality results. While the software was originally known for its geospatial function and integration, it seems the company is moving its focus away from this - nice in some ways as R functionality and others have been added, but disappointing as I don't expect improvement in the existing geospatial tools.

Read this authenticated review

September 18, 2014

Alteryx Analytics Review: "Amazing tool for data analysis"

Verified User

Analyst in Marketing

Telecommunications Company, 201-500 employees

Score 9 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

We used Alteryx to analyze and project numbers for multiple markets at once. Alteryx allowed us to create workflows that would have taken hours to complete in other software.

Pros and Cons

Data blending: It makes SQL, Excel and Access look ancient.
User-Friendly: The workflow logos are aesthetically pleasing and easy to understand.
Efficiency: The apps take a of the leg work out of the process.

There is a steep learning curve, but nothing they can do about that.
It needs to be available on the OS platform!
It can become very expensive.

Likelihood to Recommend

Alteryx handles large projects well. Some small data analysis projects can be done just as easily in Excel.

Read this authenticated review

April 05, 2014

Alteryx Analytics Review: "Excellent Data Analysis Tool for Business Decisions"

Verified User

Strategist in Marketing

Information Technology and Services Company, 11-50 employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

I used Alteryx, as part of a consulting team, to conduct demographic assessment for best ROI on potential new market advertising. We imported existing market penetration data (our customer address data), we assessed the customer demographics based on geocoding and found like demographic markets without market penetration to invest in advertising the product. It was a very successful endeavor. The ROI on these marketing dollars far exceeded other investments.

Pros and Cons

Alteryx handles data imports very well and give great feedback on the import process.
Alteryx is incredibly feature rich. I never found myself unable to manipulate data in the way I had hoped.
Alteryx provides great formats for export as well.

You cannot as a novice just play around and get started. The learning curve is very steep, rewarding, but steep. I can't help but wonder if the product would not benefit from a "light" version for less data-mining accustomed business managers.

Likelihood to Recommend

My experience with Alteryx was very specific. We had a targeted goal and knew the precise data we wanted to work with. Alteryx is a fantastic tool if you already have data, want additional data to merge with for ultimately taking action or making assessments.

In other words, Alteryx is a fantastic data scientist tool to make data-based business decisions. But to be most effective, first you need to know what data you have, what data you want to find/incorporate and what the goal of the exercise is.

Read this authenticated review

April 05, 2014

Alteryx Analytics Review: "Analytical and geo-spatial tool in one package"

Verified User

Analyst in Other

Retail Company, 10,001+ employees

Score 10 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx is being used within a department helping us streamline various analysis cutting the processing time significantly. It works very smoothly with various data formats giving us the opportunity to process millions of data records in a short time. Alteryx does not require programming skills like other similar applications do. Therefore, there is no need to hire programmers to write complex codes in order to get majority of your business reporting solved.

Pros and Cons

Processing speed; capable of analyzing millions of records in a short time.
Data connectivity; capable of connecting various databases/formats.
Many pre-built sample modules available for your use that require little of additional time to customize them to your needs.

The reporting capabilities do not have many options for customization. It would be great to have some additional functions for graphing, charting similar to Power Point or Excel.
Alteryx geospatial capabilities are great, but are in some way limited. The quality of geospatial reports could have been improved; specifically the mapping part. Having more options to customize the maps and /or add some more of GIS capabilities would be very beneficial.
Currently the user has to start Allocate (the demographic part of Alteryx) separately from the Designer part in order to create custom variables. Having an option to build custom variables within the configuration/properties window in the Allocate Append tool (Demographics) would be very helpful.

Likelihood to Recommend

Alteryx is well suited where a spatial data analysis is needed.

Read this authenticated review

March 31, 2014

Alteryx Analytics Review: "Powerful. Easy to learn and use."

Verified User

Technician in Information Technology

Marketing and Advertising Company, 51-200 employees

Score 8 out of 10

Vetted Review

Verified User

Use Cases and Deployment Scope

Alteryx is a strong ETL tool that can be used to manipulate. In the past, I've used the tool to prepare data for custom production teams as well as a member of a custom productions team to meet customer needs. The standardization and geospatial tools are particularly useful.

Pros and Cons

The geospatial utilities are exceptional for mapping and plotting coordinates for data selection and market campaign planning.
It makes data manipulation easy. The easy-to-use interface makes ETL simple, while maintaining the power of the most recognized tools.
It's dozens of tools in one package. You'll no longer need to jump from tool to tool, changing layouts and spending time setting up the next process. Instead, you can set it up all at once, in one powerful tool.

Managing input of fixed-width files is a difficulty. The ability to type out the layout, instead of having to manually select column specifications, would be much easier.

Likelihood to Recommend

I've used it on large projects and small. It's best for handling data, as opposed to project management. It can handle input and output of delimited, Excel, and fixed-width files, as well as several database formats.

Read this authenticated review

BI Standard Reporting

Pixel Perfect reports (1)

Customizable dashboards (8)

5.9

Report Formatting Templates (1)

Ad-hoc Reporting

Drill-down analysis (12)

8.7

Formatting capabilities (13)

8.1

Integration with R or other statistical packages (12)

9.8

Report sharing and collaboration (12)

8.5

Report Output and Scheduling

Publish to Web (12)

8.0

Publish to PDF (11)

8.9

Report Versioning (1)

Report Delivery Scheduling (11)

9.2

Data Discovery and Visualization

Pre-built visualization formats (heatmaps, scatter plots etc.) (1)

Location Analytics / Geographic Visualization (11)

8.5

Predictive Analytics (12)

9.2

Access Control and Security

Multi-User Support (named login) (1)

Role-Based Security Model (1)

Multiple Access Permission Levels (Create, Read, Delete) (1)

Mobile Capabilities

Responsive Design for Web Access (1)

About Alteryx Analytics

Alteryx Analytics is a business intelligence and predictive analytics solution. The vendor's value proposition is that their solution provides analysts with the unique ability to easily prep, blend, and analyze all of their data using a repeatable workflow, then deploy and share analytics at scale for deeper insights in hours, not weeks. According to the vendor, analysts love the Alteryx Analytics platform because they can connect to and cleanse data from data warehouses, cloud applications, spreadsheets, and other sources; easily join this data together, then perform analytics – predictive, statistical, and spatial – using the same intuitive user interface, without writing any code. Additionally, the vendor says thousands of companies and data analysts worldwide rely on Alteryx daily.

Categories: , , , ,

Alteryx Analytics Features

BI Platform Features

Administration via Windows App

Administration via MacOS App

Administration via Web Interface

Live Connection to External Data

Snapshot of External Data

In-memory data model

OLAP (Pre-processed cube representation)

ROLAP (SQL-layer querying)

Multi-Data Source Reporting (Blending)

Data warehouse / dictionary layer

ETL Capability

ETL Scheduler

Supported Data Sources Features

MS Excel Workbooks

Text Files (CSV, etc)

Oracle

MS SQL Server

IBM DB2

Postgres

MySQL

ODBC

Cloudera Hadoop

Hortonworks Hadoop

EMC Greenplum

IBM Netezza

HP Vertica

ParAccel

SAP Hana

Teradata

Sage 500

Salesforce

SAP

Google Analytics

BI Standard Reporting Features

Pixel Perfect reports

Customizable dashboards

Report Formatting Templates

Ad-hoc Reporting Features

Drill-down analysis

Formatting capabilities

Predictive modeling

Integration with R or other statistical packages

Report sharing and collaboration

Report Output and Scheduling Features

Publish to Web

Publish to PDF

Output Raw Supporting Data

Report Versioning

Report Delivery Scheduling

Delivery to Remote Servers

Data Discovery and Visualization Features

Pre-built visualization formats (heatmaps, scatter plots etc.)

Location Analytics / Geographic Visualization

Predictive Analytics

Support for Machine Learning models

Pattern Recognition and Data Mining

Integration with R or other statistical packages

Access Control and Security Features

Multi-User Support (named login)

Role-Based Security Model

Multiple Access Permission Levels (Create, Read, Delete)

Report-Level Access Control

Table-Level Access Control (BI-layer)

Field-Level Access Control (BI-layer)

Single Sign-On (SSO)

Mobile Capabilities Features

Responsive Design for Web Access

Dedicated iOS Application

Dedicated Android Application

Dashboard / Report / Visualization Interactivity on Mobile

Application Program Interfaces (APIs) / Embedding Features

REST API

Javascript API

iFrames

Java API

Themeable User Interface (UI)

Customizable Platform (Open Source)

Show unsupported features

Alteryx Analytics Screenshots

Alteryx Analytics Integrations

Tableau Desktop, Tableau Public, Tableau Server, Qlik Sense, QlikView, Microsoft BI

Alteryx Analytics Competitors

Lavastorm Analytics Engine, RapidMiner Studio, IBM SPSS

Pricing

Free Trial Available?Yes

Free or Freemium Version Available?No

Premium Consulting/Integration Services Available?Yes

Entry-level set up fee?No

On-premise Edition	Pricing Details	Terms
Alteryx Designer	3,995	per user, per year
Alteryx Designer with Spatial	12,995	per user, per year
Alteryx Designer with Data	29,995	per user, per year
Alteryx Server	45,000	per server, per year

SaaS Edition	Pricing Details	Terms
Alteryx Analytics Gallery	1,500	per user, per year

The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.

Alteryx Analytics Support Options

	Free Version	Paid Version
Phone
Email
Forum/Community
Social Media
Video Tutorials / Webinar
Training

Alteryx Analytics Technical Details

Deployment Types:	On-premise, SaaS
Operating Systems:	Windows
Mobile Application:	No
Supported Languages:	English, French, German, Brazilian Portuguese

Alteryx Analytics Reviews

Alteryx Analytics Scorecard Summary

Feature Scorecard Summary

About Alteryx Analytics

Alteryx Analytics Features

Alteryx Analytics Screenshots

Alteryx Analytics Integrations

Alteryx Analytics Competitors

Pricing

Alteryx Analytics Support Options

Alteryx Analytics Technical Details