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:  Managing Data  |  Spatial Functionality  |  Predictive Analytics  |  Macros and Analytic Applications  |  Installation and Architecture

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 Location Seats Registration Link
November 11 - 12 9:00 – 4:00 Central Alteryx Fundamentals Naperville 12 Register now
November 13 9:00 – 4:00 Central Advanced Data Analysis Naperville 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

Dates Time Course Seats Registration Link
October 27 3:00 - 4:00 PM Eastern Use Case (Parsing Data) Open Register now
November 3 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
November 17, 19, 21 3:00 - 5:00 PM Eastern Alteryx Predictive Essentials 30 Register now
November 18 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
November 24 3:00 - 4:00 PM Eastern Use Case (Spatial Trade Area Creation) Open Register now
December 1 3:00 - 4:00 PM Eastern Alteryx Essentials Open Register now
December 8, 10, 12 3:00 - 5:00 PM Eastern Alteryx Predictive Essentials 30 Register now
December 15 3:00 - 4:00 PM Eastern Use Case (Fuzzy Matching) 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 - Essentials

Prerequisites: Alteryx Fundamentals and familiarity with statistical analysis/model development
Target audience: Intermediate with statistical/modeling experience
Cost: Course free - Book purchase is required
Duration: Three, 2 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. Extend the power of predictive analytics inside of Alteryx by learning how to utilize pre-packaged macros, built with R, for specific analytics such as data investigation, predictive modeling and cluster analysis. This course will teach those familiar with statistical and modeling concepts how to translate 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 K-Centroids cluster analysis

Tool sets/processes covered:

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

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


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

Try Alteryx Designer for Free Download Now