Course curriculum

  • 1

    Welcome

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

    • What to Expect In This Course

    • Learner Survey
  • 2

    Getting Started

    • Prerequisites

    • Concept Review

    • Download the Practice Data
  • 3

    Results Window

    • Meet the Results Window

    • Understanding the Results Messages

    • Challenge: Workflow Results Window

    • Challenge: Tool Results Window
  • 4

    The Humble Browse Tool

    • Browsing Our Data

    • Challenge: Browse Tool
  • 5

    You Try: Browse Data

    • Practical Introduction

    • Browse Data Practical

    • Browse Data Quiz

    • Browse Data Practical Solution
  • 6

    Three Tools for Headers & Footers

    • Introduction to Headers & Footers in Excel

    • Start Import on Line X

    • Select Records Tool

    • Sample Tool
  • 7

    You Try: Handling Headers & Footers

    • Headers & Footers Practical

    • Headers & Footers Quiz

    • Headers & Footers Practical Solution
  • 8

    What are Data Types?

    • Introduction to Data Types

    • Understanding Data Types
  • 9

    Changing Data Types

    • Select Tool with Data Types

    • Data Cleansing

    • Automatically Setting Types

    • Parsing Data Fields

    • Considerations for Data Types
  • 10

    You Try: Setting the Right Data Types

    • Data Type Practical

    • Data Type Quiz

    • Data Types Practical Solution
  • 11

    A Deeper Look at the Formula Tool

    • Introduction to the Formula Tool

    • Mathematical Functions

    • Trimming Characters from Strings

    • GetWord & Replace

    • 0-Based Indices

    • FindString & Change Case

    • Substring & Left/Right

    • Pad & Concatenate
  • 12

    You Try: Enriching Your Data

    • Functions Practical

    • Functions Quiz

    • Functions Practical Solution
  • 13

    Additional Useful Functions

    • Conditional Functions

    • Valid Conditional Expressions

    • DateTime Functions

    • Specifiers for DateTime Functions
  • 14

    Filtering Messy Data - A Common Problem

    • Introduction to Messy Data

    • Filtering Records

    • Filter Reviewing Statements
  • 15

    Removing Duplicates

    • Identifying or Removing Duplicates
  • 16

    Parsing Concatenated Data

    • Text to Columns
  • 17

    You Try: Rescuing Messy Data

    • Messy Data Practical

    • Messy Data Quiz

    • Messy Data Practical Solution
  • 18

    Reviewing Joins & Unions (aka: Merging Data)

    • Introduction to a Merging Data

    • A Deeper Look at Unions

    • Reviewing Joins

    • Duplicate Values and Joins

    • Count Records Tool
  • 19

    Find Replace Tool

    • Flexible Joins with Find Replace Tool

    • Finding & Replacing Values
  • 20

    You Try: Merging Data Sets

    • Merging Data Practical

    • Merging Data Quiz

    • Merging Data Practical Solution
  • 21

    Calculating Outliers

    • Introduction to Finding Outliers
  • 22

    Creating Summaries

    • Creating Numeric Summaries

    • Creating String Summaries
  • 23

    Select Top N

    • Find the Top N
  • 24

    Flagging Outliers

    • Append Summary Values
  • 25

    You Try: Summarizing & Finding Outliers

    • Summarize & Find Outlier Practical

    • Summarize & Find Outlier Quiz

    • Summarize & Find Outlier Practical Solution
  • 26

    Pivoting Data for Analytics

    • Introduction to Pivoting Data
  • 27

    Reshaping Data

    • The Transpose Tool

    • The Cross Tab Tool

    • Pivoting Data Sets
  • 28

    Writing Back to Excel

    • Writing to Locations within Excel Files
  • 29

    Multi-Row Magic

    • Multi-Row Formulas
  • 30

    You Try: Fix that Excel File

    • Fixing Excel Practical

    • Fixing Excel Quiz

    • Fixing Excel Practical Solution
  • 31

    Streamlining Multiple Inputs

    • Introduction to Streamlining Multiple Inputs
  • 32

    Wildcards

    • Understanding Wildcards
  • 33

    Automate Multiple Excel Sheet

    • Understanding the Dynamic Input Tool
  • 34

    You Try: Streamlining Multiple Inputs

    • Streamlining Multiple Inputs Practical

    • Streamlining Multiple Inputs Quiz

    • Streamlining Multiple Inputs Practical Solution
  • 35

    Output Tool Options

    • Basic Output Tool Configuration

    • Appending Records in Excel
  • 36

    Dynamic Outputs

    • Introduction to Automating Dynamic Outputs

    • Automatic Batch Outputs

    • Dynamic Output Configuration
  • 37

    You Try: Dynamic Outputs

    • Dynamic Output Practical

    • Dynamic Output Quiz

    • Dynamic Output Practical Solution
  • 38

    Workflows, Apps, Macros - Oh My!

    • Introduction to Apps and Macros

    • What Would You Use?

    • Types of Macros

    • Which Macro Would You Use?
  • 39

    The Interface Tools

    • 11.1 Interfacing with a user

    • What is an Interface Tool?

    • The Interface Palette
  • 40

    Building an App

    • Lights...Camera...Action!

    • Testing and Using your App

    • Publishing to Server

    • Where Should Your App Go?
  • 41

    You Try: Build an App

    • Building an App Practical

    • Building an App Quiz

    • Building an App Practical Solution
  • 42

    Sharing is Caring

    • Introduction to Sharing Your Workflows
  • 43

    Sharing Your Workflows

    • Creating Packaged Workflows

    • Save Your Select Configuration

    • Meta Info Configuration
  • 44

    Documentation

    • Annotations

    • The Comment Tool

    • Tool Containers

    • Expression Comments

    • Documentation Best Practices
  • 45

    Managing File Paths

    • Adapting Workflows for Different People

    • Understanding File Paths

    • Flexible File Paths

    • Workflow Dependencies
  • 46

    You Try: Sharing Workflows

    • Share Workflow Practical

    • Share Workflow Quiz
  • 47

    Make Alteryx Your Own

    • Maximizing Efficiency

    • User Settings

    • User Constants
  • 48

    General Workflow Settings

    • Managing Workflow Settings

    • Canvas Configuration

    • Workflow Configuration

    • Runtime Configuration

    • Events Configuration
  • 49

    A Lean, Mean, Alteryx Machine

    • Keyboard Shortcuts

    • Creating Workflow Groups

    • Your Fastest Workflows Ever
  • 50

    You Try: Workflow Efficiency

    • Which File Type Is Which?

    • Workflow Efficiency Quiz
  • 51

    Final Review

    • Weekly Challenges

    • Practice Test

    • Practice the Practical Questions
  • 52

    What is Next?

    • Next Steps

    • Feedback Survey