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...