Alteryx lessons

Code-free ETL: the tool palette, joins, and repeatable workflows. 12 lessons across 4 tracks, each ending with a short self-check.

12lessons

66mtotal

4tracks

24checks

Environment & data

The canvas, the tool palette, and getting data in and out.

2 · 11m

The Designer interfaceCanvas, tool palette, configuration window and results — how a workflow runs.beginner5m Input and Output toolsReading files and databases, and writing results back out.beginner6m

Cleaning & preparation

Select, Formula, Filter, Data Cleansing, Sort and Sample.

3 · 16m

The Select toolRenaming, reordering, changing types and dropping fields.beginner5m The Formula toolCreating and modifying fields with expressions.beginner6m Filter and Data CleansingSplitting rows by condition, and bulk-cleaning messy data.beginner5m

Blending & structuring

Join, Union, Append, Cross Tab, Transpose and Summarize.

4 · 23m

The Join toolThree outputs, and the record count that tells you what happened.intermediate7m Union and Append FieldsStacking rows and attaching fields — and the difference from a join.beginner5m Cross Tab and TransposePivoting rows to columns and back.intermediate6m The Summarize toolGrouping and aggregating — the GROUP BY of Alteryx.beginner5m

Workflow & automation

Organising, parsing, outputs and running repeatably.

3 · 16m

Organising workflowsContainers, annotations and comments — making a workflow readable.beginner5m Parsing toolsText to Columns, RegEx and DateTime — pulling structure out of messy fields.intermediate6m Outputs and running workflowsWriting results, multiple outputs, and scheduling.intermediate5m