Alteryx Designer Advanced study plan

Build five workflows that join three or more inputs using Join, Join Multiple, and Union, and document which join type preserves unmatched records

Configure Select, Auto Field, and Multi-Field Formula tools to standardize field types and naming across a messy multi-source dataset

Construct a Find Replace and Append Fields workflow to enrich a transactional table with a lookup table, then verify row counts before and after

Write a one-page decision guide mapping data blending scenarios to the correct tool choice and its key configuration options

Apply Text to Columns, RegEx, and DateTime parsing tools to split and normalize a semi-structured text field into typed columns

Use the Formula tool to derive at least eight new fields including conditional logic, string functions, and date arithmetic

Detect and resolve duplicate records using Unique, Summarize, and grouping logic, and quantify duplicates removed

Validate parsing output against a known-good sample and record pass/fail per field

Build a workflow using the Multi-Row Formula and Running Total tools to compute sequential and cumulative metrics

Configure the Transpose and Cross Tab tools to pivot data between wide and long formats and confirm round-trip fidelity

Implement JSON Parse and XML Parse on nested sample data and flatten the results into relational columns

Combine at least four transformation tools into one pipeline and annotate each step with tool containers

Create spatial objects from latitude/longitude fields and from point, line, and polygon sources using Create Points and related tools

Perform Spatial Match with each of the intersect, contains, and within spatial relationship options and describe how results differ

Compute distance and trade area analysis using the Distance and Trade Area tools on a point dataset

Reproject spatial data between coordinate systems with the Spatial Info tool and verify area and distance changes

Prepare a modeling dataset by handling missing values, encoding categorical fields, and splitting into training and validation sets

Train and compare at least two predictive models using the relevant predictive tools, and interpret the reported accuracy metrics

Run a statistical test or regression and explain the meaning of the reported coefficients and p-values

Identify and mitigate a leakage or overfitting risk in a modeling workflow and document the mitigation

Convert a working workflow into a standard macro with control parameters and test it against two different input configurations

Build a batch macro that iterates over grouped inputs and confirm output row counts match expectations

Construct an analytic app using interface tools, including a conditional update of downstream tool configuration

Debug a macro that fails on empty input and document the root cause and fix

Profile a slow workflow and reduce runtime using caching, container disabling, and tool-order restructuring, measuring before-and-after time

Configure input and output connections for at least three source types and set correct output options such as delimiters, field types, and overwrite behavior

Use the workflow dependencies and field metadata views to diagnose a broken connection and record the resolution

Parameterize file paths using a formula-driven output so the workflow writes to a date-stamped file

Assemble a capstone workflow that ingests, parses, blends, spatially enriches, models, and outputs data end to end

Wrap the capstone as a parameterized app or macro and validate it against two distinct input scenarios

Re-run a timed practice set across all domains and review every missed item against its underlying tool behavior

Produce a personal weak-area checklist with the specific tool configurations still needing reinforcement