Introduction
  • Course Overview
  • Installing Alteryx Designer (free trial)
  • Interface Walkthrough
  • Downloading Course Resources
In/Out Tools
  • Introduction to Input Tools
  • Input Data Tool - Connect to Excel
  • Input Data Tool - Connect to CSV
  • Input Data Tool - Connect to SQL Server (demo)
  • Input Data Tool - Connect to Compressed Files
  • Text Input Tool
  • Directory Tool
  • Output Data Tool - Write to Excel
  • Output Data Tool - Write to SQL Server (demo)
  • Date Time Now Tool
  • Browse Tool
Preparation Tools
  • Select Tool
  • Data Cleansing Tool
  • Filter Tool
  • Formula Tool
  • Multi-Field Formula Tool
  • Multi-Row Formula Tool
  • Sort Tool
  • Record ID Tool
  • Unique Tool
  • Sample Tool
  • Random % Sample Tool
  • Auto Field Tool
  • Imputation Tool
  • Tile Tool
  • Generate Rows Tool
  • Select Records Tool
Join Tools
  • Join Tool
  • Join Multiple Tool
  • Union Tool
  • Append Tool
  • Find Replace Tool
  • Fuzzy Match Tool
  • Make Group Tool
Transform Tools
  • Summarize Tool
  • Running Total Tool
  • Weighted Average Tool
  • Transpose Tool
  • Cross Tab Tool
  • Arrange Tool
Parse Tools
  • DateTime Tool
  • RegEx Tool
  • Text to Columns Tool
Reporting Tools
  • Introduction to Reporting Tools
  • Table Tool
  • Interactive Chart Tool
  • Report Text Tool
  • Report Header Tool
  • Report Footer Tool
  • Report Layout Tool
  • Render Tool
In-Database Tools
  • Introduction to In-Database Tools
  • Connect In-DB Tool & Data Stream Out Tool
  • Browse In-DB Tool
  • Select In-DB Tool
  • Filter In-DB Tool
  • Formula In-DB Tool
  • Join In-DB Tool
  • Data Stream In Tool
  • Summarize In-DB tool
  • Sample In-DB tool
Documentation Tools
  • Comment Tool
  • Explorer Box Tool
  • Tool Container Tool
Macros
  • Introduction to Macros
  • Workshop - Creating a standard Macro
Predictive Tools & R Code
  • Introduction to Predictive Tools & R Code
  • Time Series Forecasting - ARIMA & Forecast Tools
  • Time Series Forecasting - ETS & Forecast Tools
  • Time Series Forecasting - TS Compare
  • Custom R Code
(EXTRA) Full workflow
  • Case Study: Order Processing
(EXTRA) Advanced: Spatial tools
  • Introduction to Spatial Tools
  • Buffer Tool
  • Create Points Tool
  • Distance Tool
  • Find Nearest
  • Generalize & Smooth Tools
  • Poly Split Tool
  • Poly Build Tool
  • Spatial Info Tool
  • Spatial Match Tool
  • Trade Area Tool