Training

We are refining our curriculum to be tailored for 2019 data experts. Once courses are live you will have the ability to add training courses at an additional cost to your registration.

Alteryx is offering 2 days of intensive and highly sought-after platform training and certification exams. The instructors for these courses represent the best-of-the-best that Alteryx has to offer, and ensure specific, actionable training that creates game-changing solutions for our customers!

 

PT

 


PLATFORM Training Course Offerings

This year’s training offerings will include expanded topics and a greater number of session rooms. Mix and match to build your perfect training experience. This will be first come, first serve, so act quick once courses are announced.

  • Full Day Platform Training Courses (6+ hours)
  • Elective Platform Training Courses (2 hours)

See all Platform Trainings

 

CT
 

Alteryx Certification

Prove what you learned at Inspire with an Alteryx Certification Exam. We will continue to offer certification exams at the start and finish of the conference, allowing attendees to retake exams if necessary.

  • Certification for the Core and Advanced exam is FREE
  • We will also be offering the Expert Certification Exam - only available at Inspire or Inspire Europe!

See all Certification Exams

 

BC

 


Alteryx Core Boot Camp

In 2019, we are proud to present our first ever customer Boot Camp at Inspire! In this session, we will be accepting registrations from those who are just getting started in Designer, or never used Designer. Across a rigorous multi-day curriculum, we present everything you need to be successful with Alteryx, the core skill sets of working with data, and achieve core certification status! The high-level schedule for the boot camp will be as follows:

  • Monday, June 10 10:00 am-5:30 pm: Classroom training and labs
  • Tuesday, June 11 8:00 am-5:00 pm: Classroom training, labs, office hours
  • Wednesday, June 12 8:00 am-12:00 pm: Classroom training, labs, cert prep
  • Wednesday, June 12 1:00 pm-5:00 pm: Core Certification Exam, follow-up exam review
    • If you passed, you’ve graduated. If not, we got you! We’ll identify gaps and give it another try!
  • Thursday, June 13 8:00 am – 12:00 pm: Knowledge gap coverage, and concept reinforcement
  • Friday, June 14 8:00 am - 10:00 am: Core Certification Exam re-attempt, follow-up exam review

See all Core Boot Camp Sessions

Note that this boot camp truly is intended to be rigorous and will be running the duration of conference. In our time schedule, we have built in time periods to ensure you have access to all the wonderful keynote sessions we have planned!

To review all tools and concepts covered in this session, please click here.

Reasons to attend:

  • Higher instructor to student ratio than other sessions (8:1)
  • Small, intimate classroom setting
  • One continuous course learning path
  • Personalized feedback and help from office hours
  • Develop a tight network with other attendees
  • Review exam performance and get suggested key areas of study

Sign up now, room is limited. This session is expected to sell out!
 

Offerings Pre Event
Product Training - Elective Courses (2 Hours) $125
Product Training - Full Day Courses (Full Day) $375
Boot Camp $1495
Certification (Expert, Spatial Master, Automation Master) $150
Certification Exam (Core and Advanced) FREE

 

Training Agenda

Filter

Monday , Jun 10 2019

10:00am - 12:00pm (2 Hrs)

PT

Deploying a Single Node Server

Mon, Jun 10: 10:00am - 12:00pm (2 Hrs) | Canal A,B

If you are looking to deploy your server, or understand how your single node server is deployed, this session will run through the architecture, behaviors, permission and dig into many of the Alteryx System settings. In this session we will have a machine available to you to deploy your server on!

You Should Take This Class If: 
Interested in standing up your server? No Designer expertise needed!

Concepts We Cover:

  • Architecture
  • Identifying people and requirements for your server
  • Configuration pre-requisites
  • A breakdown of deployment options

Tools Used in Training: 
N/A

Training Track

Platform Training

Level

0-3 Getting Started
PT

Sold out: See the Future - Time Series Analysis

Mon, Jun 10: 10:00am - 12:00pm (2 Hrs) | Governor's Ballroom A,E

Have a rich history of data based in time? Use your data to help create future projections and impress your organization using your crystal ball, Alteryx.

You Should Take This Class If:
If you're interested into getting into forecasting and willing to deal with moderatly difficult to grasp concepts we recommend this session. If you are a seasoned forecaster, you may find this session a little too easy. The predictive install (FREE) will be required for this class.

Concepts We Cover:

  • Trends
  • Seasonality
  • Cyclical Patterns
  • Investigation
  • ARIMA Models
  • Forecasting


Tools Used in Training:

  • TS Plot
  • TS Filler
  • ARIMA
  • TS Compare
  • TS Forecast

Training Track

Platform Training

Level

5-6 Challenging

10:00am - 3:00pm (Half Day)

PT

Sold out: Deep Learning with Alteryx

Mon, Jun 10: 10:00am - 3:00pm (Half Day) | Bayou A,B

In this session, we will be using the Python Code tool and other Alteryx tools to perform deep learning in Alteryx.  Students will leave being able to perform analysis of their data using deep learning techniques and have a set of example workflows and data to reference later.

You Should Take This Class If: 
You have Beginner to intermediate Python programming knowledge. Knowledge of machine learning and predictive modeling will be useful, but not required. Alteryx Designer 2018.3 or later will be required. 

Concepts We Cover:

  • PyTorch
  • Training models
  • Defining models 
  • Evaluating 
  • Deploying models

Tools Used in Training: 

  • The Python Tool 

Training Track

Platform Training

Level

7-8 Demanding
PT

Sold out: Introduction to Reporting in Alteryx

Mon, Jun 10: 10:00am - 3:00pm (Half Day) | Bayou C,D

Looking to do in-line visualytics, output a batch report, or maybe an Analytic Insight? In this half-day session, learn to do it all! We’ll walk you through static reporting, but systematic and batched, then wrap with a view into some interactive dashboards.

You Should Take This Class If:
If you have an understanding of blending, although in this session very few tools outside of 'reporting' tools are used.

Concepts We Cover:

  • Understanding reporting snippets
  • Combining snippets
  • Outputting a report to PDF
  • Outputting 100s of PDFs with one reporting workflow
  • Interactive Dashboards


Tools Used in Training:

  • Interactive Chart
  • Insights
  • Text
  • Map
  • Basic Table
  • Layout
  • Join
  • Union
  • Render

Training Track

Platform Training

Level

5-6 Challenging
PT

Sold out: Web Scraping

Mon, Jun 10: 10:00am - 3:00pm (Half Day) | Bayou C,D

Web scraping, the process of extracting raw data or information from webpages, is an extremely useful approach to gather web-hosted data that isn’t supplied via APIs. With the wealth of data available on the web to contextualize your analyses, have you ever thought to yourself, "If I could just combine all this data from the Internet into my Alteryx workflow, I COULD RULE THE WORLD!!!" ?  Well then this course might be for you!  (Plans for global domination not included).

You Should Take This Class If: 

You have a basic understandings of 

  • String operations, 
  • Regular Expressions
  • Download Tool
  • Cross Tab
  • Transpose
  • Formula
  • Summarize

Concepts We Cover:

  • Far Too Brief History of the Markup Languages
  • XML / HTML / JSON Crash  Course
  • Designer Parsing Tools Overview
  • Iterating through an API’s pagination
  • Demonstrations / Exercises

Tools Used in Training: 

  • Download
  • RegEx
  • Text To Columns
  • JSON Parse
  • XML Parse (I actually find it useful)
  • Transpose
  • Cross Tab
  • Multi-Row Formula 

Training Track

Platform Training

Level

5-6 Challenging

10:00am - 5:30pm (Full Day)

PT

Sold out: Designer 101: Core Concepts

Mon, Jun 10: 10:00am - 5:30pm (Full Day) | Governor's Ballroom B

Are you new to the Alteryx Designer or have limited experience with the Designer? Kick-start Inspire with this class about developing basic workflows in the Designer with the full gamut of Favorites tools in no time!

You Should Take This Class If:
If you have little to no knowledge of the Alteryx Designer

Concepts We Cover:

  • Tour of the Designer layout
  • Inputting and outputting data
  • Understanding and Changing Data Types
  • Data Preparation
  • Blending Basics
  • Calculations
  • Parsing strings via Formulas
  • Ranking Data


Tools Used in Training:

  • Input
  • Output
  • Dynamic Input
  • Select
  • Auto Field
  • Filter
  • Union
  • Join
  • Append
  • Summarize
  • Formula
  • Sort
  • Sample
  • Multi-Row Formula
  • Multi-Field Formula

Training Track

Platform Training

Level

0-3 Getting Started
PT

Sold out: Introductory Advanced Analytics

Mon, Jun 10: 10:00am - 5:30pm (Full Day) | Governor's Ballroom C,D

Looking for your first foray into advanced analytics? In this class we will overview the lifecycle of predictive analysis, steps to sanitizing your data, creating your first predictive workflow, and overview other tool categories like predictive grouping and time series

You Should Take This Class If:
This session is geared towards the highly analytical mind that has not built advanced and predictive workflows. While this session is not geared towards a total understanding of each model, we will give a high-level overview and show you how it can be built in Designer. If you are a data scientist already building python or R scripts to accomplish your modeling, this session will likely be too easy for you.

Concepts We Cover:

  • Understanding the advanced analytic lifecycle
  • Data Understanding
  • Data Preparation
  • Modeling
  • Evaluation
  • Deployment


Tools Used in Training:

  • Field Summary
  • Plot of Means
  • Scatter Plot
  • Frequency Table
  • Pearson Correlation
  • Association Analysis
  • Linear Regression
  • Score
  • Stepwise
  • Decision Tree
  • Forest Model
  • Stepwise
  • Lift
  • ETS
  • ARIMA
  • TS Plot
  • TS Compare
  • TS Forecast

Training Track

Platform Training

Level

7-8 Demanding

1:00pm - 3:00pm (2 Hrs)

PT

Sold out: Prescriptive Optimization

Mon, Jun 10: 1:00pm - 3:00pm (2 Hrs) | Governor's Ballroom A,E

Looking to maximize profit? Or minimize the cost of staffing on Monday? In this very basic introduction to the Optimization Tool, learn about how a single tool, in conjunction with data preparation, can find the best outcomes for your business problems.

You Should Take This Class If:

This course is intended for those with the ability to understand basic preparation and high-school-level linear algebra.

Concepts We Cover:

  • Understanding objectives, limits, and constraints
  • Preparing data for optimization
  • Inputting a file for optimization
  • Manually configuring an Optimization Tool

Tools Used in Training:

  • Optimization

Training Track

Platform Training

Level

5-6 Challenging

3:30pm - 5:30pm (2 Hrs)

PT

Sold out: Building a HTML Interface for Macros

Mon, Jun 10: 3:30pm - 5:30pm (2 Hrs) | Canal C,D

Want to make the user interfaces for your macros prettier and more interactive? Meet the HTML GUI SDK. By the end of this course you will know how to layer a custom web page atop an Alteryx macro. Basic knowledge of HTML/CSS/JavaScript is recommended.

You Should Take This Class If: 

  • Fundamental Knowledge of (or willingness to learn) HTML Basics
  • Fundamental Knowledge of (or willingness to learn) JavaScript Basics
  • Basic Alteryx Macros

Concepts We Cover:

Tools Used in Training: 

  • Alteryx Designer 2019.1+
  • Basic code editor (e.g., Notepad++, VS Code, etc.)

Training Track

Platform Training

Level

7-8 Demanding
PT

Sold out: CREW Macros - Tools You Didn't Know Existed

Mon, Jun 10: 3:30pm - 5:30pm (2 Hrs) | Bayou C,D

There is a designated set of tools that many Alteryx employees use that is not officially supported by the product: the CREW macros. Presented by the owner of the CReW macros himself, learn about all the additional tools you can download that can help resolve tricky development tasks.

You Should Take This Class If:
In this class, we will be demonstrating workflows with issues and how these tools resolve the issues. Experience with the favorites tools is reccomended.

Concepts We Cover:

  • Show you what you might have been doing, and how the CReW macros can solve your problems!
  • Understanding and meeting the Community of solvers that are improving your analytical life.


Tools Used in Training:

  • Only Unique
  • Blocking Test
  • Parallel Block Until Done
  • Expect Equal
  • Add Totals
  • Wildcard Input
  • Dynamic Formula
  • And More!

Training Track

Platform Training

Level

3-4 Moderate
PT

Sold out: Dive into In-Database Workflows

Mon, Jun 10: 3:30pm - 5:30pm (2 Hrs) | Bayou A,B

Pulling data from a large database? Large tables can quickly slow down data being brought into Designer. Why not just leave the data in the database? In this class, shift the compute context off of your machine and into a database by learning about the in-DB tool palette.

You Should Take This Class If:
If you know how to use all the tools mentioned minus 'In-DB' suffix you'll find it not too diffuclt to take this session. You'll learn the decisions and behaviors to be aware of when moving your workflow In-DB.

Concepts We Cover:

  • Shifting compute context
  • DB System Eligibility
  • Simple OLEDB connection example
  • In memory vs in-DB performance decisions
  • How In-DB tools compare to their more mainstream ‘in-memory’ peers


Tools Used in Training:

  • Connect In-DB
  • Save In-DB
  • Data Stream In
  • Data Stream Out
  • Formula In-DB
  • Select In-DB
  • Summarize In-DB
  • Filter In-DB
  • Join In-DB
  • Sample In-DB
  • Dynamic Output In-DB

Training Track

Platform Training

Level

5-6 Challenging
PT

Sold out: Fuzzy Matching

Mon, Jun 10: 3:30pm - 5:30pm (2 Hrs) | Canal A,B

Have two separate data sources that you need to blend, but the source systems aren't consistent enough for clean joins? Join this class to understand not just the fuzzy matching tool, but the methodology and requisite knowledge to successfully match the most records possible.

You Should Take This Class If:
If you are comfortable with exploring your data. Fuzzy match can be difficult in the sense that there is never a 'right' answer, but the session value is to help you understand what matching style is right for you!

Concepts We Cover:

  • Merging vs purging
  • Data Preparation
  • Fuzzy Matching as a process
  • Key generation
  • Matching functions


Tools Used in Training:

  • Record ID
  • Union
  • Fuzzy Match
  • Unique
  • Union
  • Join

Training Track

Platform Training

Level

5-6 Challenging

Tuesday , Jun 11 2019

8:00am - 10:00am (2 Hrs)

PT

Sold out: Administering Alteryx Gallery

Tue, Jun 11: 8:00am - 10:00am (2 Hrs) | Canal A,B

In this class, learn about how the Alteryx Gallery can be an integral component of your organization's use of the Alteryx platform. You'll learn more about the roles and permissions of Gallery users, how to manage Gallery use and maintain a seamless integration with Designer users.

You Should Take This Class If:

  • If you are a Beginner to the Gallery who has just deployed, or want to deploy your own server.


Concepts We Cover:

  • Understanding Gallery components
  • Discussing Gallery structures based on needs
  • Permissions users to the Gallery
  • Permissioning Schedules/Insights
  • Setting worker/data access via Gallery
  • Usage reporting

Training Track

Platform Training

Level

5-6 Challenging
PT

Dynamic Workflows

Tue, Jun 11: 8:00am - 10:00am (2 Hrs) | Tennessee Ballroom C

Ever build a workflow, but feel like you have to continually revisit to accommodate shifting changes in your data or logic or perhaps your scheduled workflow keeps breaking? This class will focus on all the tools, and methods to use to get your workflow to that ‘set it and forget it’ end state!

You Should Take This Class If:
If you know how to use all the tools mentioned minus 'In-DB' suffix, you'll find it not too difficult to take this session. You'll learn the decisions and behaviors to be aware of when moving your workflow In-DB.

Concepts We Cover:

  • Dynamic Inputs
  • Dynamic Outputs
  • Dynamic Datatypes
  • Dynamic Parsing
  • Dynamic Aggregation


Tools Used in Training:

  • Input
  • Output
  • Dynamic Input
  • Directory
  • DateTimeNow
  • Select
  • Dynamic Select
  • Autofield
  • Crosstab
  • Transpose
  • Text to Columns

Training Track

Platform Training

Level

3-4 Moderate
PT

Sold out: Introduction to Regular Expressions (RegEx)

Tue, Jun 11: 8:00am - 10:00am (2 Hrs) | Tennessee Ballroom A

Having troubles getting that stubborn data to parse? It's time to get serious with regular expressions. In this class, learn about the basics of constructing a regular expression, how to increase or decrease the expression flexibly, and the tools in which it can be implemented.

You Should Take This Class If: 
Designed for anyone with a need to pull information from raw, semi-structured text.  Concepts are simple, but can you harness the power?

Concepts We Cover:

  • RegEx Crash Course
  • Literal Characthers
  • Meta-Characters
  • Character Classes
  • Capture Groups
  • Back-References
  • Parsing With Regx
  • Exercises
  • Designer Use-Cases

Tools Used in Training: 

  • RegEx

Training Track

Platform Training

Level

3-4 Moderate
PT

Introduction to Spatial Analytics

Tue, Jun 11: 8:00am - 10:00am (2 Hrs) | Presidential Ballroom B

How close are competing locations to my customers? Does my trade area overlap with a competitor's? In this session, answer seemingly complex questions like these using tools from the Spatial tool palette.

You Should Take This Class If:
If you have no spatial background. This session requires simple input/blending knowledge.

Concepts We Cover:

  • What is Spatial Analysis?
  • Lines, Points, and Shapes
  • Creating points
  • Finding points nearest to each other
  • Calculating distance
  • Building trade areas
  • Spatial Matching


Tools Used in Training:

  • Create Points
  • Find Nearest
  • Distance
  • Trade Area
  • Spatial Match

Training Track

Platform Training

Level

3-4 Moderate
PT

Sold out: PRE-PREDICTIVE: Data Investigation Fundamentals

Tue, Jun 11: 8:00am - 10:00am (2 Hrs) | Presidential Ballroom A

All too often, we talk about Data Investigation for predictive tools. However, the reality is that every user seeks to understand their data at the next level! In this class, learn about the state of your data and its needs for the most effective analysis.

You Should Take This Class If:
If you're analytically minded, understand the basic favorites tools, and really want to take your understanding of data to the next level.

Concepts We Cover:

  • Understand when to perform DI
  • Why DI is critical
  • Tools that you should use for certain questions
  • See DI in action!


Tools Used in Training:

  • Basic parsing tools
  • Browse
  • Field Summary
  • Contingency Table
  • Frequency Table
  • Association Analysis
  • Scatter Plot
  • Plot of Means

Training Track

Platform Training

Level

3-4 Moderate
PT

Sold out: See the Future - Time Series Analysis

Tue, Jun 11: 8:00am - 10:00am (2 Hrs) | Tennessee Ballroom B

Have a rich history of data based in time? Use your data to help create future projections and impress your organization using your crystal ball, Alteryx.

You Should Take This Class If:
If you're interested into getting into forecasting and willing to deal with moderatly difficult to grasp concepts we recommend this session. If you are a seasoned forecaster, you may find this session a little too easy. The predictive install (FREE) will be required for this class.

Concepts We Cover:

  • Trends
  • Seasonality
  • Cyclical Patterns
  • Investigation
  • ARIMA Models
  • Forecasting


Tools Used in Training:

  • TS Plot
  • TS Filler
  • ARIMA
  • TS Compare
  • TS Forecast

Training Track

Platform Training

Level

5-6 Challenging

Product

Alteryx Platform

8:00am - 12:30pm (Half Day)

PT

Sold out: Introduction to Reporting in Alteryx

Tue, Jun 11: 8:00am - 12:30pm (Half Day) | Governor's Ballroom A,E

Looking to do in-line visualytics, output a batch report, or maybe an Analytic Insights? In this half-day session, learn to do it all! We’ll walk you through static reporting, but systematic and batched, then wrap with a view into some interactive dashboards.

You Should Take This Class If:
If you have an understanding of blending, although in this session very few tools outside of 'reporting' tools are used.

Concepts We Cover:

  • Understanding reporting snippets
  • Combining snippets
  • Outputting a report to PDF
  • Outputting 100s of PDFs with one reporting workflow
  • Interactive Dashboards


Tools Used in Training:

  • Interactive Chart
  • Insights
  • Text
  • Map
  • Basic Table
  • Layout
  • Join
  • Union
  • Render

Training Track

Platform Training

Level

5-6 Challenging

8:00am - 4:00pm (Full Day)

PT

Sold out: Building Analytics Applications in Alteryx

Tue, Jun 11: 8:00am - 4:00pm (Full Day) | Tennessee Ballroom D, E

If you've been working with .yxmds for a while, step it up to .yxwzs! In this course, students will learn how to create a user interface for an analytic app, implement best practices for app development and deploy/share apps to a wider audience.

You Should Take This Class If:
If you have no app experience

Concepts We Cover:

  • Why Apps?
  • Categorizing Interface Tools
  • Updating Values
  • Testing
  • Debugging
  • Deploying
  • Sharing


Tools Used in Training:

  • Text Box
  • Numeric Up-Down
  • Dropdown
  • Error Message
  • Checkbox
  • Action

Training Track

Platform Training

Level

5-6 Challenging
PT

Sold out: Designer 101: Core Concepts

Tue, Jun 11: 8:00am - 4:00pm (Full Day) | Governor's Ballroom B

Are you new to the Alteryx Designer or have limited experience with the Designer? Kick-start Inspire with this class about developing basic workflows in the Designer with the full gamut of Favorites tools in no time!

You Should Take This Class If:
If you have little to no knowledge of the Alteryx Designer

Concepts We Cover:

  • Tour of the Designer layout
  • Inputting and outputting data
  • Understanding and Changing Data Types
  • Data Preparation
  • Blending Basics
  • Calculations
  • Parsing strings via Formulas
  • Ranking Data


Tools Used in Training:

  • Input
  • Output
  • Dynamic Input
  • Select
  • Auto Field
  • Filter
  • Union
  • Join
  • Append
  • Summarize
  • Formula
  • Sort
  • Sample
  • Multi-Row Formula
  • Multi-Field Formula

Training Track

Platform Training

Level

0-3 Getting Started
PT

Sold out: Introductory Advanced Analytics

Tue, Jun 11: 8:00am - 4:00pm (Full Day) | Tennessee Ballroom B

Looking for your first foray into advanced analytics? In this class we will overview the lifecycle of predictive analysis, steps to sanitizing your data, creating your first predictive workflow, and overview other tool categories like predictive grouping and time series

You Should Take This Class If:
This session is geared towards the highly analytical mind that has not built advanced and predictive workflows. While this session is not geared towards a total understanding of each model, we will give a high-level overview and show you how it can be built in Designer. If you are a data scientist already building python or R scripts to accomplish your modeling, this session will likely be too easy for you.

Concepts We Cover:

  • Understanding the advanced analytic lifecycle
  • Data Understanding
  • Data Preparation
  • Modeling
  • Evaluation
  • Deployment


Tools Used in Training:

  • Field Summary
  • Plot of Means
  • Scatter Plot
  • Frequency Table
  • Pearson Correlation
  • Association Analysis
  • Linear Regression
  • Score
  • Stepwise
  • Decision Tree
  • Forest Model
  • Stepwise
  • Lift
  • ETS
  • ARIMA
  • TS Plot
  • TS Compare
  • TS Forecast

Training Track

Platform Training

Level

7-8 Demanding
PT

Sold out: Macros for Advanced Users

Tue, Jun 11: 8:00am - 4:00pm (Full Day) | Bayou A,B

Feel like you’re in a macro rut? Always approaching the same problem in the same way? In this session, we walk through some nuances to building macros you may not have considered before. To support this, we have a collection of standard, iterative, and batch macros with nuanced behaviors that might make you think twice the next time you build a macro!

You Should Take This Class If:

If you have been building basic macros, this class will add a level of complexity. This class is not recommended for first-time macro builders.

Concepts We Cover:

  • Fully embed a macro tool into your Designer experience
  • Macro messaging
  • Workflow ordering
  • Macros in macros
  • Data-less batch macros
  • Accommodating different/changing schemas
  • Data types
  • Interface design

Tools Used in Training:

  • Macro Input
  • Macro Output
  • Action
  • Control Parameter
  • Numeric Up-Down
  • Message
  • Drop Down
  • Check Box
  • File Browse
  • List Box

Training Track

Platform Training

Level

7-8 Demanding
PT

Sold out: Macros for Beginners

Tue, Jun 11: 8:00am - 4:00pm (Full Day) | Bayou C,D

If you've been working with .yxmds for a while, step it up to .yxmcs! In this course, students will learn how to parameterize a workflow for production, implement best practices for macro development and create a variety of simple macros that can help cut down on repetitive processes.

You Should Take This Class If:
If you a very comfortable building workflows with any tools from the categories In/Out, Preparation, Join, Parse, and Transform, but have not used any tools from the Interface category.

Concepts We Cover:

  • What is a macro?
  • Identify when a macro is needed
  • Understand 3 basic macro types
  • Build a simple version of each macro
  • Interface design
  • Testing
  • Deployment


Tools Used in Training:

  • Macro Input
  • Macro Output
  • List Box
  • Text Box
  • Action
  • Control Parameter
     

Training Track

Platform Training

Level

5-6 Challenging
PT

Macros for Beginners

Tue, Jun 11: 8:00am - 4:00pm (Full Day) | Presidential Ballroom C,E

If you've been working with .yxmds for a while, step it up to .yxmcs! In this course, students will learn how to parameterize a workflow for production, implement best practices for macro development and create a variety of simple macros that can help cut down on repetitive processes.

You Should Take This Class If:
If you a very comfortable building workflows with any tools from the categories In/Out, Preparation, Join, Parse, and Transform, but have not used any tools from the Interface category.

Concepts We Cover:

  • What is a macro?
  • Identify when a macro is needed
  • Understand 3 basic macro types
  • Build a simple version of each macro
  • Interface design
  • Testing
  • Deployment


Tools Used in Training:

  • Macro Input
  • Macro Output
  • List Box
  • Text Box
  • Action
  • Control Parameter
     

Training Track

Platform Training

Level

5-6 Challenging

10:30am - 12:30pm (2 Hrs)

PT

Advanced Spatial Analytics

Tue, Jun 11: 10:30am - 12:30pm (2 Hrs) | Presidential Ballroom B

Ready to take your skills in spatial analytics up a notch? Learn to apply spatial processes to data, geocode data, and display your findings with a map.

You Should Take This Class If:
If you are working with simple points and lines, but really need to level-up your skills with shapes.

Concepts We Cover:

  • Splitting and building spatial object
  • Altering spatial objects
  • Processing spatial objects
  • Relating spatial objects


Tools Used in Training:

  • Poly-build
  • Poly-split
  • Buffer
  • Spatial Process
  • Spatial Match
  • Spatial Info

Training Track

Platform Training

Level

5-6 Challenging
PT

Sold out: Dynamic Workflows

Tue, Jun 11: 10:30am - 12:30pm (2 Hrs) | Presidential Ballroom A

Ever build a workflow, but feel like you have to continually revisit to accommodate shifting changes in your data or logic or perhaps your scheduled workflow keeps breaking? This class will focus on all the tools, and methods to use to get your workflow to that ‘set it and forget it’ end state!

You Should Take This Class If:
If you know how to use all the tools mentioned minus 'In-DB' suffix, you'll find it not too difficult to take this session. You'll learn the decisions and behaviors to be aware of when moving your workflow In-DB.

Concepts We Cover:

  • Dynamic Inputs
  • Dynamic Outputs
  • Dynamic Datatypes
  • Dynamic Parsing
  • Dynamic Aggregation


Tools Used in Training:

  • Input
  • Output
  • Dynamic Input
  • Directory
  • DateTimeNow
  • Select
  • Dynamic Select
  • Autofield
  • Crosstab
  • Transpose
  • Text to Columns

Training Track

Platform Training

Level

3-4 Moderate
PT

Sold out: Fuzzy Matching

Tue, Jun 11: 10:30am - 12:30pm (2 Hrs) | Tennessee Ballroom A

Have two separate data sources that you need to blend, but the source systems aren't consistent enough for clean joins? Join this class to understand not just the fuzzy matching tool, but the methodology and requisite knowledge to successfully match the most records possible.

You Should Take This Class If:
If you are comfortable with exploring your data. Fuzzy match can be difficult in the sense that there is never a 'right' answer, but the session value is to help you understand what matching style is right for you!

Concepts We Cover:

  • Merging vs purging
  • Data Preparation
  • Fuzzy Matching as a process
  • Key generation
  • Matching functions


Tools Used in Training:

  • Record ID
  • Union
  • Fuzzy Match
  • Unique
  • Union
  • Join

Training Track

Platform Training

Level

5-6 Challenging
PT

Sold out: Parsing Fundamentals

Tue, Jun 11: 10:30am - 12:30pm (2 Hrs) | Tennessee Ballroom B

Many of us have lost count of how many times we have received data in the form of a giant singular string. Learn some of the most popular methods of turning the nonsensical into beautifully columnized datasets.

You Should Take This Class If:
If you have a beginner working knowledge of the Alteryx Designer favorite tools. This is a fast-moving session. Strap in and hold on!

Concepts We Cover:

  • Parsing structured, semi-structured data
  • Envisioning your result
  • Seeing patterns


Tools Used in Training:

  • Text to Columns
  • DateTime
  • RegEx
  • Dynamic Rename

Training Track

Platform Training

Level

5-6 Challenging
PT

Server Scaling

Tue, Jun 11: 10:30am - 12:30pm (2 Hrs) | Canal A,B

In this session, we have a single node server deployed. But how do we scale our server, when do we scale, and why? Also see some sample benchmark decisions you can use to drive and justify your scaling needs.

You Should Take This Class If:
If you are a beginner user to the Server who has just deployed, or feel that you might need to scale the server with heavier usage.

Concepts We Cover:

  • Points of Scalability
  • Scaling by symptom
  • Tuning your scaling
  • How to scale your workers
  • Discussion scaling DB/Gallery nodes


Tools Used in Training:
N/A

Training Track

Platform Training

Level

3-4 Moderate

2:00pm - 4:00pm (2 Hrs)

PT

CREW Macros - Tools You Didn't Know Existed

Tue, Jun 11: 2:00pm - 4:00pm (2 Hrs) | Tennessee Ballroom A

There is a designated set of tools that many Alteryx employees use that is not officially supported by the product: the CREW macros. Presented by the owner of the CReW macros himself, learn about all the additional tools you can download that can help resolve tricky development tasks.

You Should Take This Class If:
In this class, we will be demonstrating workflows with issues and how these tools resolve the issues. Experience with the favorites tools is reccomended.

Concepts We Cover:

  • Show you what you might have been doing, and how the CReW macros can solve your problems!
  • Understanding and meeting the Community of solvers that are improving your analytical life.


Tools Used in Training:

  • Only Unique
  • Blocking Test
  • Parallel Block Until Done
  • Expect Equal
  • Add Totals
  • Wildcard Input
  • Dynamic Formula
  • And More!

Training Track

Platform Training

Level

3-4 Moderate
PT

Introduction to Regular Expressions (RegEx)

Tue, Jun 11: 2:00pm - 4:00pm (2 Hrs) | Tennessee Ballroom C

Having troubles getting that stubborn data to parse? It's time to get serious with regular expressions. In this class, learn about the basics of constructing a regular expression, how to increase or decrease the expression flexibly, and the tools in which it can be implemented.

You Should Take This Class If: 
Designed for anyone with a need to pull information from raw, semi-structured text.  Concepts are simple, but can you harness the power?

Concepts We Cover:

  • RegEx Crash Course
  • Literal Characthers
  • Meta-Characters
  • Character Classes
  • Capture Groups
  • Back-References
  • Parsing With Regx
  • Exercises
  • Designer Use-Cases

Tools Used in Training: 

  • RegEx

Training Track

Platform Training

Level

3-4 Moderate
PT

Sold out: Supporting the Alteryx Server

Tue, Jun 11: 2:00pm - 4:00pm (2 Hrs) | Canal A,B

In this session, we cover settings and configuration, logging, and diagnostics.

You Should Take This Class If:
If you are currently managing your own server, supporting Alteryx Servers, or just deployed your Server recently

Concepts We Cover:

  • Tools needed to support your Server
  • Brief Server architecture overview
  • Basic Command Line options
  • Diagnostic Process
  • Log reading
  • Testing fixes
  • Common troubleshooting scenarios
  • Startup


Tools Used in Training:
N/A

Training Track

Platform Training

Level

7-8 Demanding