Welcome to ONLC Training Centers

Alteryx Training Classes, Courses & Alteryx Certification

Learn to use Alteryx Designer effectively and efficiently with live, hands-on certification classes from ONLC Training Centers!

Alteryx Designer streamlines the process of prepping, blending, and analyzing data by delivering a repeatable workflow for self-service data analytics, leading to deeper insights in just hours. Alteryx makes analytics simple and powerful for everyone. With little or no coding you can create advanced models.

Alteryx Designer empowers data analysts by combining data preparation, data blending, automate reporting and more through the intuitive user interface.

Designer lets you bring multiple types of disparate data sources together to effectively build and publish analytic models to answer questions.

ONLC’s Alteryx Designer certification training courses are led by seasoned instructors with real-world Alteryx experience. Training is immersive with hands-on exercises thoughout class to make sure you are effectively learning and applying the software. Maximize all that Alteryx Designer can do with our training at ONLC. Our classes can also be used to help prep for Alteryx Designer certification which can add value to your professional status.

 

Instructor-led Training (ILT)

Click for FAQs about remote instructor-led training

ILT classes are live and hands-on training with an online instructor. Attend ILT classes from any of ONLC's hundreds of training centers or from your own location with very easy setup. Training is fully interactive.

Alteryx Designer Certification

Certification

Many of these courses can be used as a prep for Alteryx authorized exams. Alteryx Certification gives you the opportunity to build your skills, prove your expertise, and differentiate yourself in the marketplace. See Alteryx Designer certifications.

Savings Options

Save on training at ONLC

Get maximum buying power and flexibility with ONLC Learning Credits . They're a great way to prepay for training and secure a substantial volume discount on end-user and technical courses!

Alteryx Training Class Schedule

Alteryx Concepts - Level 1

Overview
This two-day instructor-led course is designed to give students a hands-on introduction to Alteryx Designer, an all-in-one self-service Business Intelligence solution for acquiring, transforming, visualizing and interacting with data. The course doesn’t assume any previous experience with Alteryx or any other Business Intelligence technology. By the end of the course, students will have had the opportunity to work with Alteryx designer and will have learned the fundamentals of using it to analyze business data through a series of lab exercises using several different sample datasets.

Audience Profile
The primary audience for this course is BI professionals and other technically proficient business users who want to analyze data using Alteryx Designer.

Prerequisites
The primary prerequisite for this course is simply that students should be familiar with the data they want to analyze and have some sense of the kinds of analysis they want to do. Beyond that, students should have basic computer skills and knowledge of getting around in the Microsoft Windows operating system. Some familiarity with Microsoft Excel is helpful but by no means necessary.

Course Outline

Module 1: Introduction to Alteryx
This module provides the opportunity to get familiar with Alteryx Designer and its functionality. Topics include:
· The Alteryx Analytics Platform
· Alteryx Designer licensing
· Obtaining and installing Alteryx Designer
· A brief tour of Alteryx Designer

Module 2: Basic Operations
This module covers some of the most common and fundamental operations that all analysts will need to perform in Alteryx Designer. Topics include:
· Acquiring data
· Viewing data
· Outputting data
· Annotating your solution
· Filtering and sorting data
· Creating custom calculations
· Combining and summarizing data
· Pivoting and unpivoting

Module 3: Cleaning and Transforming Data
Often, business data will contain errors, non-printable characters, codes that must be replaced or eliminated, and other features that make the data in its original form unsuitable for use in an analytic solution. Module 3 addresses the need to “clean”
data, that is, to remove or alter undesirable elements in preparation for analysis. Topics include:
· Handling nulls
· Multi-field and multi-row formulas
· Creating ad hoc data
· Data cleansing

Module 4: More Transforming Operations
Module 4 continues the discussion from previous modules, addressing more of the tools and techniques that Alteryx Designer provides. Topics include:
· Appending fields
· Automatically setting data types
· Working with date & time values
· Working with directories

Module 5: Combining & Shaping Data
After data has been cleaned, it is often still organized in a way that makes analysis difficult. This module covers some of the techniques an analyst can use to change the “shape” of the data. Topics include:
· Using demographic data
· Find and replace
· Complex joins
· Text to columns
· Random sampling
· Parsing XML

Module 6: Visualizing Data
Once data has been cleaned and organized, it’s time to present it. Module 6 covers some of the primary tools that Alteryx Designer provides for visualizing data.
· Charting
· Working with spatial data
· Working with report layouts
· Adding tables
· Adding images
· Sharing reports through e-mail

Module 7: Advanced Data Manipulation
If the previous techniques don’t work, Alteryx Designer has more sophisticated tools for cleaning, transforming, and shaping data. Topics covered in Module 7 include:
· Fuzzy matching
· Record Ids
· Using regular expressions
· Removing duplicates

Module 8: Creating Forms for User Interaction
Along with the ability to transform, shape, and visualize data, Alteryx Designer also provides the ability to create applications that allow users to interact with the data. Topics covered in this module include:
· Actions
· Conditions
· Control parameters
· Input controls

Dates Times Location Price
3/13/24 - 3/14/24 Live Online from our site or yours. $1,195

4/15/24 - 4/16/24 Live Online from our site or yours. $1,195

5/22/24 - 5/23/24 Live Online from our site or yours. $1,195

6/26/24 - 6/27/24 Live Online from our site or yours. $1,195

More Dates    Quote

Alteryx Concepts - Level 2

Overview
This one-day instructor-led course is designed to give students who are already familiar with Alteryx Designer a more in-depth look at its capabilities. This course picks up where the level 1 class leaves off and focuses on the features of the product that allow more in-depth data extraction, transformation, and loading with the Alteryx's In-DB tools as well as offering demonstrations of the products procedural programming capabilities.

Audience Profile
The primary audience for this course is BI professionals and other technically proficient business users who want to analyze data using Alteryx Designer.

Prerequisites
This course assumes that students will have completed the Alteryx Concepts: Level 1 class or have familiarity equivalent to the material covered in that course:
Alteryx Concepts: Level 1

COURSE OUTLINE

Review of Alteryx Designer Basics
This module provides a brief, high-level review of Alteryx Designer and the process of creating a basic solution:
The Alteryx Analytics Platform
Acquiring Data
Shaping and Transforming Data
Creating and distributing a report

In-DB Tools
This module explores a series of tools that allow interaction with a live relational database. Topics include:
Browse In-DB
Connect In-DB
Data Stream In/Out
Filter In-DB
Join In-DB
Macro Input/Output In-DB
Select In-DB
Summarize In-DB
Union In-DB
Write Data In-DB
Sample In-DB

Integrating with Other Systems
Alteryx has a number of tools and connectors that make it easy to connect to external services. Topics include:
The Download tool

Procedural Programming
Although Alteryx is designed to make acquiring and transforming data simple, it also includes powerful, flexible programming tools for building more complex solutions. This module offers short demonstrations of the programming capabilities of Alteryx.

Dates Times Location Price
3/15/24 Live Online from our site or yours. $595

4/17/24 Live Online from our site or yours. $595

5/24/24 Live Online from our site or yours. $595

6/28/24 Live Online from our site or yours. $595

More Dates    Quote

 

Added Value When You Train with ONLC

Along with outstanding training, attendees in our public, live instructor-led classes have these bonuses:

  • Satisfaction Guarantee
    There is no better way for you to experience the quality of our live, instructor-led training than to take a class. Those not familiar with ONLC can take a public, instructor-led class risk-free knowing we offer a money-back satisfaction guarantee. See satisfaction guarantee details

  • Optional Class Retake
    Need a second look at a public, instructor-led ILT course you already attended with ONLC? Our optional refresher course lets you repeat the same course one time (1x) for free. Some restrictions apply and not available for any self-study On-Demand courses. See Retake class details

Alteryx Designer Certifications

Prep for Alteryx certification at ONLCThere are three Alteryx Designer certifications and they must be achieved in order:

Scroll down to view the learning path for each of these certifications.

spacer

Alteryx Designer Core Certification

Alteryx Designer Core is a first-level certification. It is a prerequisite for advanced level Alteryx exams/certifications. Whether you are just beginning your journey in analytics or are a seasoned professional, this certification proves your skills in Alteryx. The 'core' toolset is the most commonly used tools in Alteryx Designer in addition to understanding basic UI/operational elements.

Instructor-led Alteryx Training Course
(click course title for outline & dates)

Alteryx Concepts: Level 1
This online, instructor-led training (ILT) is live and hands-on.

Certification Exam
Alteryx Core Designer Exam
The exam is on-demand and free from Alteryx Community .

Review the Alteryx Designer Core Study Guide before attempting the certification exam.

Alteryx Recertification
Alteryx certifications expire two (2) years after the date the certification is earned. The earned date is based on the most recent, highest-level exam passed. If you do not recertify by the required date, your certification will expire and you will lose the right to use the certification logo or represent yourself as holding that certification credential.

spacer

Alteryx Designer Advanced Certification

Alteryx Designer Advanced certification is for users who have already demonstrated their proficiency on core Designer abilities. This exam may be attempted only after you have passed the Alteryx Designer Core exam.

The Alteryx Advanced exam is the next stepping stone in the Platform Certification journey, allowing users to demonstrate their higher-level abilities with the Alteryx Designer. It builds on concepts, configurations and tools that are included in the Core exam, and also requires users to be able to understand a wider breadth of tool functionality and apply their knowledge to more complex applications.

Prerequisite (required)
Alteryx Core Certification

Instructor-led Alteryx Training Course
(click course title for outline & dates)

Alteryx Concepts: Level 2
This online, instructor-led training (ILT) is live and hands-on.

Certification Exam
Alteryx Designer Advanced
The exam is on-demand and free from Alteryx Community .

Review the Alteryx Designer Advanced Study Guide before attempting the certification exam.

Alteryx Recertification
Alteryx certifications expire two (2) years after the date the certification is earned. The earned date is based on the most recent, highest-level exam passed. If you do not recertify by the required date, your certification will expire and you will lose the right to use the certification logo or represent yourself as holding that certification credential.

spacer

Alteryx Designer Expert Certification

Alteryx Designer Expert certification is intended for users who have demonstrated proficiency in both the Alteryx Designer Core and Alteryx Designer advanced exams. You must have passed the Core and Advanced exams in order to qualify for registration of the Alteryx Designer Expert Exam.

The Alteryx Designer Expert credential is the top level certification in Alteryx Designer. The Designer Expert exam builds on concepts in the Core and the Advanced exam, and, additionally, expands knowledge coverage to all areas and facets of the Alteryx Designer. Though it's only a handful of questions, the Expert exam is comprehensive and will test your ability to work with any part of the Alteryx Designer.

Prerequisite (required)
Alteryx Core Certification and Alteryx Designer Advanced Certification

Alteryx Certification Exam

Alteryx Designer Expert Exam
There is a fee for this exam. Registration for the exam can be made via the Alteryx Community .

Alteryx Recertification
Certifications expire two (2) years after the date the certification is earned. The earned date is based on the most recent, highest-level exam passed. If you do not recertify by the required date, your certification will expire and you will lose the right to use the certification logo or represent yourself as holding that certification credential.

News & Offers

ONLC Training Centers has locations coast to coast

Training Locations Coast to Coast
ONLC provides live, hands-on classes with an online instructor at our hundreds of training centers coast to coast. Our centers are fully equipped and provide an interruption-free environment to focus on learning. Find ONLC centers near me click link.

 

Call our Education Advisors for certification and course selection assistance

Education Advisors to Help You
Our advisors can assist you with questions about our classes, vendor certifications and discount options plus help you select training that is right for you. For assistance, contact our Education Advisors toll free in the USA at 1-800-288-8221 (weekdays).

 


Group training available from ONLC

Group Training Option
ONLC offers complete learning solutions so training coordinators can quickly and successfully upskill their teams while maintaining their budget. Training can be via our public class schedule or private sessions delivered virtually or onsite. We can also customize content to meet the client's specific needs and technologies. To discuss our group training options and to receive a price quote complete our quick Group Training Request form or call 1.800.288.8221 (weekdays).

 

ONLC Learning Credits with savings up to 35%

Volume Discounts with ONLC Learning Credits
Get maximum buying power, flexibility and savings with ONLC Learning Credits. They're a great way to prepay for training and secure a substantial volume discount on end-user and technical-level courses. Credits can be used on live, instructor-led & self-study, On-Demand learning formats, and are good for up to a year! Details & pricing .

For More Information

To register for class or to learn more about Alteryx Designer training contact an ONLC Education Advisor weekdays via chat or by phone at:

1.800.288.8221
(weekdays)

 

 

ONLC TRAINING CENTERS
800-288-8221
www.onlc.com