Course curriculum

  • 1

    Introduction

    • Welcome From Chad Martin, Founder & CEO of Data Prep U

    • What Is Alteryx?

    • Download the Practice Data
  • 2

    Installing Alteryx Designer

    • Download Designer

    • Installing Alteryx Designer

    • License Activation
  • 3

    A Tour of Alteryx Designer

    • A Guided Tour

    • Alteryx Designer In Detail

    • Anatomy of a Workflow

    • Test Your Knowledge
  • 4

    Input Data and Browse

    • The Input Data Tool

    • Input Tool for XLSX Configuration

    • Input Tool for CSV Configuration

    • Bringing in an Excel File
  • 5

    Handling Data Fields

    • The Select Tool

    • Configuring the Select Tool: Part I
  • 6

    Viewing Your Data

    • The Browse Tool

    • Configuring the Browse Tool
  • 7

    Let's Try Connecting to Data!

    • The Use Case

    • Practical: Your Turn to Connect to Data

    • Check Your Understanding

    • Connecting to Data Practical Solution
  • 8

    Stacking Two Data Files

    • Visualizing a Union

    • The Union Tool

    • Configuring the Union Tool
  • 9

    Joining Two Data Files

    • What is a Join?

    • The Join Tool

    • Configuring the Join Tool
  • 10

    Let's Try Blending Data!

    • The Use Case

    • Practical: Your Turn to Blend Data

    • Check Your Understanding

    • Blending Data Practical Solution
  • 11

    Setting Data Types

    • What are Data Types?

    • Data Types and the Select Tool
  • 12

    Enriching Your Data

    • The Formula Tool

    • Configuring the Formula Tool
  • 13

    Filtering Data

    • The Filter Tool

    • Configuring the Filter Tool

    • QUIZ - Reviewing Filter Statements
  • 14

    Let's Try Prepping Data!

    • The Use Case

    • Practical: Your Turn to Prep Data

    • Check Your Understanding

    • Prepping Data Practical Solution
  • 15

    Data Output

    • The Output Data Tool

    • The Last Use Case

    • Practical: Your Turn to Write Outputs

    • Writing Data Practical Solution
  • 16

    Alteryx Resources

    • Alteryx Designer Search Bar

    • The Alteryx Community

    • Starter Kits

    • Alteryx Documentation
  • 17

    Wrap-Up

    • Test Your Understanding

    • Weekly Challenges

    • Alteryx Rapid Launch - Feedback Survey

    • Thank you!