Alteryx Analytics

Product Training

Alteryx offers a variety of ways to learn and develop your skills with both the Designer Desktop and Server. Users can choose from a variety of ways to familiarize yourself with the Alteryx technology via traditional classroom training, Virtual training classes and On demand Videos designed to quickly provide a business analyst with the tools to solve business challenges in hours and minutes versus days and weeks.

On Demand Videos and Exercises (Free)

Get the most out of Alteryx Designer Desktop by taking advantage of our free on-demand training videos. This library features free recordings of our training webinars, each focusing on a specific task or functionality. Each session is available as a streamed video or a download, allowing you to enhance your Alteryx skills where and when you choose.

Virtual Training (Free)

Users can participate in instructor lead courses that cover a variety to topics from getting started with Alteryx to advanced predictive analytics. The courses will focus on practical use cases gear to illustrate how to use individual tools in Alteryx to construct an analytical solution.

Classroom Training

Users can attend an instructor lead training session geared to rapidly educate and acclimated new users to the Alteryx platform. In addition to tradition classroom lead training, users will also get hands on experience for solving practical business problems across the retail, telecommunication and marketing services verticals.

For those wanting a custom or onsite training delivery, we will also come to you! For $2500/day plus travel and expenses, we'll provide a trainer at your location for up to 12 trainees and will work with you to develop an agenda that best meets your needs.

Jump to:  Getting Started  |  Managing Data  |  Spatial Functionality  |  Predictive Analytics  |  Macros and Analytic Applications  |  Installation and Architecture

 

Getting Started

Learn the Alteryx Designer basics, focusing on the Favorites tool palette. Each Tutorial video corresponds to fully annotated Paint-by-Numbers sample in Alteryx Designer. To access the exercise files, in Alteryx Designer click File > Open Tutorial > Tutorial Name. Each video ends with an Analytic challenge to help you learn the tools and concepts. Download the answer file for the challenge questions here.

Watch All "Getting Started" Videos (25:16)

Tour of Alteryx Designer (3:34)
Overview of Menus, tools, Workflows, Properties, and Run time events. Learn to customize the Designer layout, find help, and get tutorials and samples.

Getting Started Preparing Data (5:12)
Input an Alteryx Database file (YXDB) that contains a list of addresses, and prepare the data for analytics. Use the Select tool to remove, rename, and reorder the fields. Basic step-by-step tutorial using the Alteryx Designer Open Tutorials. In Alteryx Designer, click File > Open Tutorials > Preparing Data.

Getting Started Filtering Data (3:50)
Find records using the Filter tool that match a basic expression ‘scores' is greater than '50', and order the results from highest to lowest with the Sort tool. Basic step-by-step tutorial using the Alteryx Designer Open Tutorials. In Alteryx Designer, click File > Open Tutorials > Filtering Data.

Getting Started Blending Data (4:44)
Use the Join tool to merge transactional data with customer information from two different data sources, XML and Excel, into a single data stream. And then, use the Summarize tool to aggregate the transactions for each 'customer segment'. Basic step-by-step tutorial using the Alteryx Designer Open Tutorials. In Alteryx Designer, click File > Open Tutorials > Blending Data.

Getting Started Analyzing Data (7:56)
Use the Tile tool to group customers by number of visits and amount spent, create a new field that categorizes them (low or high) based on the visits and spent groups using the Formula tool. Basic step-by-step tutorial using the Alteryx Designer Open Tutorials. In Alteryx Designer, click File > Open Tutorials > Analyzing Data.

^Top

 

Managing Data

This section focuses on reading and managing various types of internal and external data in the Alteryx Designer. We will also review various data blending and parsing techniques to stage data to perform advanced analytics.

I/O and Connector Functionality (8:03)
Alteryx provides a variety of mechanisms to consume relevant data into the environment to perform data blending and advanced analytics. This video reviews how users can access data via Standard Inputs, Cloud Connectors and Social Media outlets.

Data Cleansing and Parsing Tools (10:00)
Data sets can be challenging to work with based on the structure of the asset or lack thereof. Alteryx provides a series of Parsing and Data Cleansing tools to stage accessible data for analytics. This video will review how to use a series of parsing tools to structure a stream of data that originates from a web service.

Data Blending (8:44)
Alteryx provides a series of tools to blend multiple disparate data sources together. This video will highlight different ways to blend data based on common keys or on spatial proximity.

Fuzzy Matching (10:36)
Fuzzy matching is a process that either purges duplicate records from a data stream or merges disparate sources when a common identifier is not present. This video will review the fuzzy matching techniques and algorithms available in the Alteryx platform.

^Top

 

Spatial Functionality and 3rd Party Data Content

This section focuses on embedded spatial engines for geocoding data and performing drive time analysis. We will also review a series of embedded data retrieval engines to enrich data content that feeds analytical processes.

Drive Time and Geocoding Engines (9:27)
The drive time and geocoding engines embedded in the Alteryx platform add a "where" component to all analytical processes. The drive time engine physically walks the road network node by node and takes into account Z-factors to accurately calculate drive time and distance between two spatial objects. The geocoding engine will locate points based on address level detail. The engine attempts to match addresses to property parcel centroids and will leverage an interpolation method for locating points along a street segment if parcel level matches cannot be found. This video will review how to use both engines to perform a spatial analytical process.

Allocate Engine (5:23)
The Allocate engine stores 3rd party content from Experian and the US Census. The engine contains demographic and psychographic information that can be apportioned to both standard and non-standard geographies for analytics. In this video, we will review how to leverage the engine to retrieve statistics for analytical processes.

Calgary Engine (5:54)
The Calgary engine is leveraged for large scale static database files to enable rapid retrieval and integration within the Alteryx platform. Alteryx packages both the Experian Consumerview (Household) and D&B Business List files in the platform to empower users to enrich their data assets for analytics. This video will review how to access data from the Calgary engine focusing on retrieval of data from the Experian Consumerview file.

^Top

 

Predictive Analytics

This section focuses on some of the most commonly used predictive tools. The tools are built on top of the R programming language and offer a parameter driven environment for executing advance analytical algorithms. This module assumes the viewer has some basic understanding of statistical concepts.

Regression Analysis (7:21)
Alteryx has a series of tools that perform basic regression analytics to estimate relationships among variables. The tools allow users to relate a variable of interest (target variable) to one or more variables that are expected to have influence on the target (predictor variables). This video will review a simple logistical regression model for predicting probable response rate to targeted marketing campaigns.

Market Basket Analysis and AB Testing (11:17)
Alteryx offers a series of tools to perform a Market Basket analysis to aid in understanding associations between transactional items within a basket. The results can be used to influence future promotional ads, coupons and product placement in store. Alteryx also provides the ability to perform AB testing, comparing a series of test locations against a series of control locations to see if changes within the test yield positive or negative results. In this video we will review both analytical processes as well as how to interpret the results.

Clustering and Means Analysis (11:13)
Clustering creates a series of "like" groupings based on commonalities within the data. Alteryx provides a tool grouping specific to Clustering to help understand key characteristics of customers, locations or products. This video will review the various clustering algorithms within the Alteryx platform and how to determine the proper number of clusters to create logical groups that can be leveraged in additional analytical processes.

Time Series Tools (9:10)
The time series tools contained in Alteryx provide the ability to perform forecasting based on past observations within the data. This video will review two different time series forecasting models and compare the results

^Top

 

Macros and Analytic Applications

This section focuses on extending the existing functionality within Alteryx by creating Macros to perform repeatable business processes. The module will also review how to operationalize an analytical process through the creation of an Application.

Standard Macros (8:51)
A standard macro is an Alteryx module that has the flexibility to be run as a single tool within another Alteryx module. Macros are primarily used to encapsulate repeatable processes. This video will review the creation and deployment of a standard macro within an Alteryx module.

Batch Macros (7:36)
A batch macro is a special kind of macro that is typically needed to process a group of records based on a control parameter. The control parameter determines which group of records will be processed through the underlying macro logic. The macro will be run from beginning to end for each control parameter. This video will review the creation and deployment of a batch macro within an Alteryx module.

Iterative Macros (10:28)
An iterative macro will run through every record in a data stream and loop the records back through the module, repeating the process as many times as specified or until a condition is met. This video will review the creation and deployment of an iterative macro within an Alteryx module.

Location Optimization Macro (10:38)
The location optimizer macro runs multiple iterations to determine the best locations to add or remove from an existing location network. This video will review the creation and deployment of a location optimization macro within an Alteryx module.

Analytical Application (App) Development (9:49)
An Alteryx Analytical App is a self-contained program that performs a specific function for the user. The App performs a limited range of tasks, focused on optimizing user experience. This video will review the creation of an Analytical App and how to deploy it to a Gallery environment for consumption by a broader set of users.

^Top

 

Installation and Architecture

This section contains videos and documentation that review the installation process for Alteryx Desktop Designer and Server. It concludes with a brief overview of the technical architecture of each product.

Alteryx Architecture and Gallery (6:50)
This video will review basic architecture for the Alteryx Analytical Gallery.

^Top

Dates Time Course Seats Registration Link
January 5 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
January 7 9:00 - 10:00 AM Pacific Predictive Analytics - #1 – Data Prep & Investigation Open Register now
January 14 9:00 - 10:00 AM Pacific Predictive Analytics - #2 – Regression Modeling Open Register now
January 19 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
January 21 9:00 - 10:00 AM Pacific Predictive Analytics - #3 – Cluster Analysis Open Register now
January 26 3:00 - 4:00 PM Eastern Use Case (Data Parsing) Open Register now
January 28 9:00 - 10:00 AM Pacific Predictive Analytics - #4 – Times Series Open Register now
February 2 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
February 16 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
February 23 3:00 - 4:00 PM Eastern Use Case (Spatial Trade Area Development) Open Register now
March 2 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
March 16 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
March 23 3:00 - 4:00 PM Eastern Use Case (Fuzzy Matching - Best Practices) Open Register now
March 30 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now

Send an email to our training team


Alteryx Essentials

Prerequisites: None
Target audience: Beginner
Cost: Free
Duration: 1 hour webinar

Automate your data processes with the power of Alteryx. This virtual course will provide you with the necessary tools to get started building your own analytic processes with the Alteryx Designer Desktop.

You'll learn how to:

  • Build your own data processes
  • Utilize all of the commonly used tools
  • Parse and transform your data for use in visual analytic applications

Tool sets/processes covered:

  • Favorites
  • Text to Columns
  • Transpose and Crosstab

 

^Top


Alteryx Predictive Analytics

Prerequisites: Students should be comfortable building basic Alteryx workflows. Some familiarity with statistical analysis and model development is helpful.
Cost: Free
Duration: Four, 1 hour webinars

Do you know the difference between "categorical" and "continuous" variables? Are you familiar with "p-values" and why they're important? Does the term "least-squares" mean anything to you? Have you performed cluster analysis? If so, this class is for you.

See how the Alteryx Predictive Tools enable you to create powerful predictive analytics workflows without the need to write formulas or code. Perform data investigation, predictive modeling, cluster analysis and time series analysis using the simple drag and drop Alteryx interface.

This course is divided into four one hour virtual training sessions. There is one session per week over the four weeks of the course. Please register for each session you wish to attend.

Session 1: Data Prep and Investigation

Understanding your data is vital before modeling. The majority of time spent on predictive analytics is often on getting data ready and understanding its relationships. In this session you'll:

  • Learn best practices for prepping your model data
  • Analyze your data to identify key relationships

Session 2: Regression Modeling

Once your data is ready there are a variety of modeling techniques available depending on the data type. In this session you'll:

  • Create sample sets to develop and validate your models
  • Develop models using linear, logistic and decision tree analyses
  • Score you model to determine accuracy

Session 3: Cluster Analysis

Which of you customers are similar to other customers? Which of your stores have similar demographics in the surround area? In this session you'll:

  • Use Principal Components to reduce dimensionality
  • Use K-Means Clustering to determine the number of clusters and which records belong in each cluster.

Session 4: Time Series

Data that is time based (values collected over a year for example) has an order which needs to be accounted for. There are several methods available to model and forecast time series. In this session you'll:

  • Learn the difference between ARIMA and ETS modeling
  • Forecast Time Series
  • Compare Time Series Models

 

^Top


Use Cases

Prerequisites: None
Target audience: Beginner to Intermediate
Cost: Free
Duration: 1 hour webinar

In this session an Alteryx Solutions Engineer will educate users on how to build an analytical solution leveraging the Alteryx platform to solve common organizational use cases specific to data preparation and parsing, spatial analytics or predictive analytics.

^Top

Dates Time Course Location Seats Registration Link
January 6 - 7 9:00 – 4:00 Pacific Alteryx Fundamentals Irvine 12 Register now
January 8 9:00 – 4:00 Pacific Advanced Data Analysis Irvine 12 Register now
February 10-11 9:00 – 4:00 Central Alteryx Fundamentals Naperville 12 Register now
February 12 9:00 – 4:00 Central Advanced Data Analysis Naperville 12 Register now
March 10 - 11 9:00 – 4:00 Pacific Alteryx Fundamentals Irvine 12 Register now
March 12 9:00 – 4:00 Pacific Advanced Data Analysis Irvine 12 Register now

There will be a one hour break for lunch on your own and beverages are available throughout the day. Dress code is casual.

Send an email to our training team


Alteryx Fundamentals

Prerequisites: None
Target audience: Beginner
Cost: $1495
Duration: 2 days

Whether you are new to Alteryx or simply need a refresher on basic functionality, this session is for you! This 2-day course will give you the building blocks necessary to create powerful, agile business intelligence processes inside of Alteryx.

You'll learn how to:

  • Build your own data processes
  • Utilize all of the commonly used tools
  • Perform spatial processing
  • Generate customized reports
  • Automate modules for deployment throughout your organization

Tool sets/processes covered:

  • Favorites
  • Spatial analysis
  • Demographic retrieval
  • Reporting/presentation
  • Analytic Apps and Gallery

^Top


Advanced Data Analysis

Prerequisites: Basic understanding of module development/Alteryx fundamentals course
Target audience: Intermediate/Advanced users
Cost: $795
Duration: 1 day

Take your data analysis to the next level! This 1-day course will build on basic concepts and teach you how to leverage some of the advanced data processing capabilities available within Alteryx. This course is dedicated to data builders with advanced data processing needs.

You'll learn how to:

  • Dynamically affect data processes
  • Utilize regular expressions to parse data
  • Join data sets based on fuzzy methodology
  • Generate and consume list count retrieval databases for faster large-volume list count retrieval

Tool sets/processes covered:

  • Dynamic tools
  • Regular expressions
  • Multi-row and multi-field formula tools
  • Fuzzy matching
  • List count retrieval

^Top


Alteryx Predictive Analytics – Essentials lab

Prerequisites: Alteryx Fundamentals and interest in statistical analysis/model development
Target audience: Intermediate
Cost: $1495 - Book purchase is also required
Duration: 2 Days

Are you ready to take the next step in your business decisions by applying predictive analytics? Do you have data related to your business, but can't tell if it is relevant? Do you know if that data needs cleansing and if so, how to do it? If you are full of questions about how to utilize the Predictive Analytics capabilities inside of Alteryx, this class is for you. Learn how to utilize pre-packaged macros, built with R, for specific analytics such as data investigation and predictive modeling. This course is a hands-on deep dive of our virtual Predictive Essentials training course and will walk those unfamiliar with statistical and modeling concepts through the step-by-step process of incorporating these types of analyses into a simple drag and drop Alteryx workflow.

You'll learn how to:

  • Analyze your data to identify key relationships
  • Prep your model data
  • Develop models using linear, logistic, decision tree and forest analyses
  • Perform cluster analysis

Tool sets/processes covered:

  • Data Investigation
  • Data Preparation
  • Linear Regression
  • Logistic Regression
  • Decision Trees
  • Forest Model
  • Principal Components
  • K-Centroids Clustering

Required reading: A syllabus of reading assignments will be administered. All required reading will come from the book Customer and Business Analytics: Applied Data Mining for Business Decision Making Using R co-authored by Dr. Dan Putler, our Resident Data Artisan. It is available for purchase in print or Kindle format through Amazon: Customer and Business Analytics at Amazon.com


^Top

Try Alteryx Designer for Free Download Now