Alteryx Designer Expert study plan

Build a 5-tool input pipeline that ingests CSV, Excel, and JSON sources and standardizes field names and types

Configure Auto Field and Select tools to resolve mismatched data types across two sources

Use the Data Cleansing tool to trim whitespace, remove nulls, and normalize casing on a messy dataset

Write a one-page cheat sheet mapping each data preparation tool to the problem it solves

Blend two datasets with different granularity using Join and Union tools and explain when each is correct

Apply Append Fields and Find Replace to enrich a transactional dataset with a lookup table

Implement a multi-join workflow that deduplicates records with Unique and Record ID tools

Document row-count expectations before and after each join to catch fan-out errors

Parse delimited text into columns with Text to Columns and RegEx tools

Extract structured values from unstructured strings using RegEx Replace and RegEx Parse

Build calculated fields with Formula, Multi-Row Formula, and Multi-Field Formula tools

Transpose and Cross Tab a wide dataset into a normalized long format and back again

Compare Join, Join Multiple, and Union behavior on key-matched and position-matched data

Resolve duplicate-key fan-out using Unique and Summarize tools before joining

Build a workflow that reconciles two record sets and flags unmatched rows on both sides

Explain how record order and sort state affect join and union results

Create spatial points from latitude/longitude fields and build a trade-area polygon with Trade Area tool

Perform a spatial join between customer points and territory polygons with Spatial Match

Compute distance and nearest-neighbor relationships between spatial objects

Run a predictive or clustering workflow end to end and interpret the output report

Convert a repeated sub-workflow into a Standard Macro with a macro input and output anchor

Build a Batch Macro that iterates over a control parameter and unions results

Build an Iterative Macro that loops until a condition is met

Add macro interface elements (text box, drop-down, action) and test each configuration

Profile a slow workflow and identify the top bottleneck using the Performance Profiler

Reduce data volume early with Filter and Select tools and measure runtime improvement

Configure output tools for CSV, Excel, and a database connector with correct field mapping

Build a basic report with the Reporting tools and render it to a file

Complete a timed full-length practice exam and log every missed question by domain

Re-drill weak domains by rebuilding the specific tool configurations missed

Review macro, spatial, and performance edge cases one final time

Finalize a one-page tool-selection decision guide for exam day