Alteryx

Alteryx

Self-service data analytics platform for business analysts

4.8/5 (54 reviews)

Alteryx Overview

Alteryx is a data analytics platform designed as a comprehensive self-service solution for business data analysts. Spanning three integrated products, Alteryx represents an intuitive workflow for data blending from numerous sources, building predictive models and then sharing those insights. Forming an enterprise-level hub, Alteryx Server provides centralized analytics deployment and share options, securely hosted to encourage effective collaboration across teams. Whether supporting 10 users or 10,000 users, Alteryx Server boasts a scalable architecture running on-premises or within the cloud as required. Analysts can then store and distribute analytics workflows or apps in a centralized private environment, adding version controls, administration governance and extended developer capabilities with Alteryx API.

Alteryx Designer is 64-bit Windows software that speeds and eases the process of gathering, cleansing, blending and reporting data. Designer provides access to data from virtually any source spanning data warehouses, databases, ERP/cloud-based apps, Hadoop data stores, Microsoft Office files, social media services or sister analytics platforms such as SPSS/SAS. This wealth of data can then be intuitively blended using visual scripting tools, rapidly generating advanced spatial analytics and rich insight reporting within one workflow. Utilizing over 30 predictive tools based on the open source R statistical language, Alteryx Designer requires no specialized programming knowledge thanks to intuitive drag-and-drop editing.

Analytic apps specifically can then be published or collaboratively customized using the cloud-based Alteryx Analytics Gallery. Save workflows in a centralized, version-controlled repository and restrict access permissions to certain user groups. Discover best practice apps published to the Public Gallery, making organizational app consumption as easy and user-friendly as navigating familiar commercial mobile app stores.

Pricing

Starting from
US$1,500.00/year
Pricing options
Free Trial
Subscription
Value for money

Devices

Business size

S
M
L

Markets

Asia, Australia, Brazil, Canada, China and 5 others, Europe, Germany, India, Japan, Latin America

Supported Languages

Arabic, Chinese (Simplified), Chinese (Traditional), Czech, Danish and 21 others, Dutch, English, Finnish, French, German, Hebrew, Hungarian, Indonesian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Russian, Spanish, Swedish, Taiwanese, Thai, Turkish, Ukrainian

Alteryx Reviews

Overall rating
4.8/5
100% positive reviews
43
Excellent
11
Very good
0
Average
0
Poor
0
Terrible
Joe R.

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

Used Daily for 1+ year
Reviewed on 12/12/2017
Review Source: SoftwareAdvice

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.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

10.0/10

Go With The Flow - Automation using Alteryx Designer

Used Monthly for 6-12 months
Reviewed on 7/04/2019
Review Source: Capterra

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

Pros

Alteryx Designer is a very intuitive way to map out a process in a step by step visual workflow which can be then executed with the click of a button. Tedious manual tasks can be automated with ease. Traditionally, programming required drawing out ones algorithm in a flowchart and then having to translate that into computer code. With Alteryx, the flowchart itself is the code. It features a vast array of icons called tools, each of which has a specific function such as importing data, filtering based on criteria, summarizing, merging information and so forth. You simply drag and drop each tool into the work area for each step in your process and then click the play button. It's like having a robot to whom you can describe your work and then have it do it for you in a fraction of the time.

Cons

Alteryx Designer is excellent for data mining/wrangling for eventual output to be used for reporting but it's internal report generation and presentation tools are not as robust as others when it comes to publishing a polished presentation. I prefer to use Designer to produce my final data result set and export to Excel where I can then take advantage of Microsoft Office formatting and presentation options.

Rating breakdown

Ease of Use

Likelihood to recommend

10.0/10

So many uses!

Used Daily for 1+ year
Reviewed on 12/02/2019
Review Source: Capterra

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

Pros

You can do so much with Alteryx! We acquired the software for one specific project but I find myself using it for so many other things, from day to day data work to other large projects. It has great features like fuzzy matching, data normalization, and join capabilities. It is great for working with large data sets that can't be easily managed in excel or access and for allowing multiple data sources to interact with each other.

Cons

There is a bit of a learning curve. However, once you understand how it all works its easy. Also there are so many tools and more than one way to achieve the same thing. It can be hard to know how to approach new projects.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

10.0/10
Daniel D.

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

Used Weekly for 6-12 months
Reviewed on 13/07/2018
Review Source: Capterra

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.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

10.0/10
Tarandeep S.

Alteryx Means Work Done

Used Daily for 2+ years
Reviewed on 18/07/2019
Review Source: Capterra

Alteryx is a tool which can increase your productivity, at the same time providing you facility to re run again, schedule and automate easily. Best Feature is plug and play feature in statistical models too...It gives alot of feature like data profiling,quality ,scheduling and automation.

Pros

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

Cons

I heard from Admin that license is expensive

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

9.0/10

Alteryx Pricing

Starting from
US$1,500.00/year
Pricing options
Free Trial
Subscription
Value for money

FREE 14-Day Trial of Alteryx Designer on signup

Alteryx Designer: $3,995 per user, per year (3-Year Subscription), $5,194 per user, per year (1-Year Subscription)
Alteryx Server: $45,000 per server, per year (3-Year Subscription), $58,500 per server, per year (1-Year Subscription)
Alteryx Analytics Gallery: $1,500 per user, per year (3-Year Subscription), $1,950 per user, per year (1-Year Subscription)

Alteryx Features

  • Customizable Reporting
  • Data Visualization
  • Visual Analytics

  • API
  • Activity Dashboard
  • Ad hoc Reporting
  • Business Intelligence
  • Charting
  • Collaboration Tools
  • Dashboard Creation
  • Data Filtering
  • Data Import/Export
  • Drag & Drop Interface
  • Graphical Data Presentation
  • Monitoring
  • Real Time Analytics
  • Real Time Data
  • Real Time Reporting
  • Reporting & Statistics
  • Third Party Integration

Additional information for Alteryx

Key features of Alteryx

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

Benefits

  • Alteryx is a three-pronged self-service data analytics platform, spanning Alteryx Designer, Alteryx Server and Alteryx Analytics Gallery.

  • Alteryx Designer offers a drag-and-drop editor for prepping and blending data from multiple sources, creating datasets ready for analysis and visualization.

  • Leveraging repeatable workflows, create predictive analytics models using tools based on the R language – all with no programming knowledge required.

  • Access and blend location data for spatial analysis, outputting to required mapping or visualizations via support for sharing with tools including ESRI, Tableau or MapInfo.

  • Share insights with a multitude of reporting options and export formats for Microsoft Excel, Tableau, XML, ESRI, PDF and Qlik.

  • Alteryx Server is a scalable enterprise platform deployable on-site or in the cloud, supporting the centralized creation, publishing and sharing of analytic workflows.

  • Alteryx Analytics Gallery is a cloud-based platform for publishing and customizing analytics apps – aiding collaboration, agility and business decision-making.
  • Alteryx FAQs

    Below are some frequently asked questions for Alteryx.

    Q. What type of pricing plans does Alteryx offer?

    Alteryx offers the following pricing plans:

    Starting from: US$1,500.00/year

    Pricing model: Subscription

    Free Trial: Available

    FREE 14-Day Trial of Alteryx Designer on signup

    Alteryx Designer: $3,995 per user, per year (3-Year Subscription), $5,194 per user, per year (1-Year Subscription)
    Alteryx Server: $45,000 per server, per year (3-Year Subscription), $58,500 per server, per year (1-Year Subscription)
    Alteryx Analytics Gallery: $1,500 per user, per year (3-Year Subscription), $1,950 per user, per year (1-Year Subscription)

    Q. What are the main features of Alteryx?

    Alteryx offers the following features:

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

    Q. Who are the typical users of Alteryx?

    Alteryx has the following typical customers:

    Large Enterprises, Mid Size Business

    Q. What languages does Alteryx support?

    Alteryx supports the following languages:

    Arabic, Chinese (Simplified), Chinese (Traditional), Czech, Danish, Dutch, English, Finnish, French, German, Hebrew, Hungarian, Indonesian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Russian, Spanish, Swedish, Taiwanese, Thai, Turkish, Ukrainian

    Q. What type of pricing plans does Alteryx offer?

    Alteryx has the following pricing plans:

    Subscription

    Q. Does Alteryx support mobile devices?

    We do not have any information about what devices Alteryx supports

    Q. What other apps does Alteryx integrate with?

    Alteryx integrates with the following applications:

    CARTO, Kognitio Cloud, QlikView, Splunk Cloud, Tableau, Tableau, matchIT On Demand

    Q. What level of support does Alteryx offer?

    Alteryx offers the following support options:

    Forum, Knowledge Base, Online Support, Phone Support, Video Tutorials