Alteryx Designer Cloud Core study plan

Identify the core cleansing tools (filter, formula, data cleansing, select) and state what each one changes in a dataset

Practice writing expressions that trim whitespace, fix casing, and replace null values across several columns

Configure a Select tool to rename, reorder, change data types, and drop unneeded fields

Diagnose why a value that looks numeric is being treated as text and correct the field type

Distinguish join types (inner, left, right, outer, and union-style combines) and predict row counts for each

Build joins on single and multi-key conditions and verify output row counts against expectations

Use summarize and aggregate tools to group, count, sum, and de-duplicate records

Detect and resolve duplicate records using a unique-key strategy

Organize records with sort and sample tools and confirm ordering behavior

Reshape data with transpose and cross-tab style pivots between wide and long formats

Split and combine columns and streams using text-to-columns and union approaches

Explain when to choose a join versus a union versus an append for combining streams

Connect to at least two input source types and compare their configuration options

Configure output destinations and choose correct file formats and write settings

Set up a text or CSV input with delimiters, encoding, and header handling set explicitly

Document data-type and schema pitfalls that occur when reading flat files

Design a branching workflow using a filter tool and route each branch to a distinct output

Implement conditional logic with multi-condition expressions and nested conditionals

Use a macro or reusable container concept to avoid duplicating logic

Trace a record end-to-end through a workflow to confirm the logic path

Map the platform's workspace, project, and sharing model and describe who can see what

Configure permissions for a shared workflow and explain the effect of each role

Identify where credentials and connections are stored and how to keep them out of workflow logic

Describe how version history and scheduling work at the platform level

Build a summarized report-style output with grouped totals and formatted presentation

Add a chart or visualization step and verify the output renders as expected

Profile a slow workflow and identify the heaviest tool or step

Apply at least two optimization techniques such as early filtering or reducing data volume before joins

Assemble a capstone workflow that ingests, cleans, joins, transforms, and reports in one connected pipeline

Re-verify each domain's key skill against a personal checklist and close gaps

Write a troubleshooting log covering the errors you hit and how you resolved them

Time yourself on a set of practice tasks to confirm pacing