Course curriculum
-
1
Welcome to the Alteryx Designer Core Certification Prep Course!
-
Welcome!
-
Before we begin, please complete a 2 question survey.
-
Alteryx Core Certification Data
-
-
2
Input Data, Auto Field, & Select Tools
-
Lesson Introduction & Basic Principles
-
Input Data & Auto Field Tools
-
Select Tool & Sort Tool
-
Sample & Output Data Tool
-
Quick Quiz
-
-
3
Unions And Wildcards
-
Union Tool Deep Dive
-
Wildcards: An In-Depth Discussion
-
Quick Quiz
-
-
4
Joins And Appends
-
Joins in Alteryx
-
Join Wrap Up, Prep for Append Tool Using Union & Summarize
-
Append Wrap Up, Introduction to the Formula Tool
-
Quick Quiz
-
-
5
Formula Tool Deep Dive
-
Formula Tool Introduction and Engine Constants
-
Introduction to Functions
-
If/Then Statements & String Functions!
-
Concatenating Strings & Adding Comments
-
Length & Substrings
-
Nesting Functions
-
Quick Quiz
-
-
6
Filters, Sorts, and a Tool Container
-
Basic Filters & String Operators
-
Basic Filters & Numeric Operators, Intro to Sorting
-
Introduction to Custom Filters
-
Sort Tool Deep Dive
-
Select Records, Tool Containers, and Chapter Wrap Up
-
Quick Quiz
-
-
7
Parse And Browse
-
Date Time Tool In Depth
-
Text To Columns - Part 1
-
Text To Columns - Part 2
-
Quick Quiz
-
-
8
Cross Tabs And Other Transformations
-
Summarize And Count Records Tools
-
Summarize Tool Continued And Intro to Cross Tab
-
Cross Tab Deep Dive And A Bit of Transpose
-
Quick Quiz
-
-
9
Uniques And Find/Replace
-
Unique Tool Deep Dive
-
Find Replace In Depth
-
Quick Quiz
-
-
10
Analytic Apps And Macros
-
Introduction to Analytic Apps, Macros, and the Interface Tools
-
My First Analytic App
-
The Action Tool & How It Works
-
Debugging Your App or Macro
-
Quick Quiz
-
-
11
Workflow Tips And Tricks
-
How to Identify Data Types And Keyboard Shortcuts
-
Macro Types, User Variables, Runtime Settings, and Workflow Dependencies
-
Additional Updates
-
Quick Quiz
-
-
12
Thank You And Next steps
-
Congrats! Here's what's next...
-
More resources for you
-
Before you go...
-