Alteryx
Three levels · taught in Alteryx Designer Foundations and Alteryx Designer Advanced
Level 1 of 3
Fundamentals
The interface and the basics
10 topics
- Alteryx Designer: set-up in the Alteryx One app, and the interface
- Your first workflow
- Input and output: Excel, CSV, databases and cloud sources
- Cleaning data: Select, Filter, Sort; nulls and duplicates
- Formula, Join and Union
- Blending and aggregating with Summarize
All 10 topicsFewer topics
- Simple reports; the predictive tools in brief
- Debugging; containers, comments and dependencies
- Working with Ask Alteryx
- Designer Core certification preparation
You build: A workflow that takes over a weekly clean, join and export job.
7 assignments and 1 end-to-end live structured project
Level 2 of 3
Advanced
Building projects
9 topics
- Complex formulas and functions
- Parsing with RegEx; handling XML and JSON
- Dynamic inputs and outputs; advanced joins
- Reporting tools: Interactive Charts, Table, Layout and Overlay
- Render and Email tools
- Spatial analytics: spatial joins, drive time and trade areas
All 9 topicsFewer topics
- Macros: standard, batch and iterative
- Performance and large datasets
- Designer Advanced certification preparation
You build: A reusable macro, and a reporting workflow that renders and emails its own output.
7 assignments and 1 end-to-end live structured project
Level 3 of 3
Expert
Integrations and advanced use
9 topics
- Publishing to Alteryx Server: schedules, permissions and sharing
- The AMP engine and workflow performance
- Parquet files and cloud warehouse connectors
- Saving workflows to an Alteryx One workspace
- Python and R inside a workflow
- APIs with the Download and Parse tools
All 9 topicsFewer topics
- Feeding Tableau and Power BI from a workflow
- AI tools in a workflow: the AI palette and the Prompt tool
- Analytic apps with interface tools
You build: A scheduled workflow on Alteryx Server that pulls from an API and feeds a Tableau dashboard.
7 assignments and 1 end-to-end live structured project




