The Work Gym

Courses / Data and analytics tools

Alteryx Designer

Build workflows, reconcile files and deliver checked analyst reports.

Start lesson 1 Practice interview Take the assessmentPractice the first unit of every course. No account needed.

49lessons

286checked exercises

14projects, cases and exams

Prepares you for Analyst roles and Core-style practice

Projects, case studies and mock exams

Case study · BeginnerStaffing intake case

Prepare a staffing extract and identify the hours available by team.

5 steps · 14 min Project · IntermediateWorkforce export merge

Deliver a cleaned worker/payroll comparison with signed hour differences.

6 steps · 30 min Case study · IntermediateSales reporting case

Separate open sales and rank each team by its net reported amount.

5 steps · 14 min Project · IntermediateMonthly sales reconciliation

Clean a monthly sales file and compare matched invoices with the ledger.

6 steps · 30 min Case study · AdvancedCapacity review case

Trace workload changes and compare each team peak with its net change.

5 steps · 14 min Project · AdvancedCustomer contact deduplication

Deliver one contact per normalized email with a traceable handoff order.

6 steps · 30 min Project · AdvancedCoverage calendar project

Generate an inclusive staffing calendar with daily and cumulative coverage hours.

6 steps · 30 min Case study · ExpertPayroll discrepancy case

Build evidence for matched worker differences without hiding source exceptions.

5 steps · 14 min Project · ExpertReusable department preparation

Build a local macro-based preparation flow with a clear output contract.

6 steps · 30 min Case study · ExpertFailed refresh case

Recover a changed invoice export using its current fields and business meaning.

6 steps · 14 min Mock exam · ExpertDesigner Core-style practice mock

Complete 24 original decisions and workflow tasks within a 45-minute practice clock.

24 questions · 45 min

Practice Alteryx Designer in a working browser simulator with a tool palette, connected canvas, Configuration window and Results data, metadata and messages. Start with input files, preparation and formulas, then combine exports, reshape reports and audit exceptions. The course uses original fictional records for workforce, sales and customer work. Continuing projects build a payroll comparison, a monthly sales reconciliation, a deduplicated contact list and reusable preparation workflows. Later units cover calculations across records, generated rows, basic macros and Interface controls. Original interview sets and a timed Core-style practice mock test the same skills. This course is independent training and does not grant a vendor certification.

Beginner

Workflow foundations

Read sources, connect anchors and inspect output data and metadata.

4 lessons

1Canvas, anchors and ResultsConnect a source to a tool and inspect the records that actually ran.4 exercises · 14 minFree

2Inputs, Browse and outputsChoose a source, inspect its stream and prepare an output dataset.4 exercises · 14 minFree

3Select fields and typesControl the names, types and column order in an output schema.4 exercises · 14 minFree

Practice setFoundations practicePrepare new intake records and inspect their schema.Free

Row preparation

Filter records and create cleaned, typed calculations.

4 lessons

5Filter True and FalseRoute records by a condition and select the correct result anchor.4 exercises · 14 minWith a plan

6Formula fields and nullsCreate typed calculations without confusing missing values with zero.4 exercises · 14 minWith a plan

7Text cleanup and cleansingClean selected text fields while preserving meaningful blanks and nulls.4 exercises · 14 minWith a plan

Practice setPreparation practiceClean and classify a fresh service extract.With a plan

Order and identity

Sort, sample and distinguish duplicate business keys from row identifiers.

4 lessons

9Sort and SampleControl record order before selecting a sample.4 exercises · 14 minWith a plan

10Unique records and Record IDDistinguish a business key from a generated row number.4 exercises · 14 minWith a plan

Case studyStaffing intake casePrepare a staffing extract and identify the hours available by team.With a plan

Practice setIdentity practiceAudit duplicates and establish a repeatable record order.With a plan

Intermediate

Combining files

Match HR records and stack files with explicit field alignment.

4 lessons

13Join matches and exceptionsUse Join J for matched pairs and preserve L and R exceptions.4 exercises · 14 minWith a plan

14Union field alignmentStack files using a deliberate name or position mapping.4 exercises · 14 minWith a plan

ProjectWorkforce export mergeDeliver a cleaned worker/payroll comparison with signed hour differences.With a plan

Practice setCombining practiceMatch staffing extracts and stack files without losing their meaning.With a plan

Reporting shapes

Summarize at the intended grain and reshape report measures.

4 lessons

17Summarize at the right grainChoose grouping fields and measures that answer the business question.4 exercises · 14 minWith a plan

18Cross Tab and TransposeMove between wide reporting columns and long measure records.4 exercises · 14 minWith a plan

Case studySales reporting caseSeparate open sales and rank each team by its net reported amount.With a plan

Practice setReporting practiceBuild fresh grouped and reshaped operational summaries.With a plan

Parsing and dates

Parse text and dates and reconcile monthly sales against a ledger.

4 lessons

21Text to Columns and RegExSplit delimited fields and choose the correct regular-expression output.4 exercises · 14 minWith a plan

22Date parsing and elapsed timeParse dates with a mask and calculate calendar changes explicitly.4 exercises · 14 minWith a plan

ProjectMonthly sales reconciliationClean a monthly sales file and compare matched invoices with the ledger.With a plan

Practice setParsing practicePrepare shipment tags, references and reporting dates.With a plan

Advanced

State across records

Calculate neighboring values, running totals and record tiles.

4 lessons

25Multi-Row and Multi-Field FormulaCalculate from neighboring records and repeat a rule across chosen fields.4 exercises · 14 minWith a plan

26Running Total and TileAccumulate measures by group and divide a stream into record tiles.4 exercises · 14 minWith a plan

Case studyCapacity review caseTrace workload changes and compare each team peak with its net change.With a plan

Practice setState calculations practiceTrace team movements and repeat field rules on a fresh period.With a plan

Matching and enrichment

Combine multiple sources, apply lookups and prepare customer contacts.

4 lessons

29Join Multiple inputsMatch three streams at the same business key and inspect missing sources.4 exercises · 14 minWith a plan

30Lookup replacement and parametersReplace a controlled code and attach a small parameter stream.4 exercises · 14 minWith a plan

ProjectCustomer contact deduplicationDeliver one contact per normalized email with a traceable handoff order.With a plan

Practice setEnrichment practiceApply lookup rules without multiplying or losing business records.With a plan

Generation and expressions

Generate bounded sequences and build a staffing coverage calendar.

4 lessons

33Generate Rows safelySet an initial value, a stopping condition and a changing loop expression.4 exercises · 14 minWith a plan

34Conditional formulas and conversionsWrite explicit branch order and use the appropriate text or numeric function.4 exercises · 14 minWith a plan

ProjectCoverage calendar projectGenerate an inclusive staffing calendar with daily and cumulative coverage hours.With a plan

Practice setGeneration practiceCreate bounded sequences and classify records with explicit rules.With a plan

Expert

Reliable handoff

Audit source populations and deliver an explicit output contract.

4 lessons

37Validation and audit branchesUse exception records and counts to explain a report before handoff.4 exercises · 14 minWith a plan

38Output data contractsDeliver the fields, names and types the receiving report expects.4 exercises · 14 minWith a plan

Case studyPayroll discrepancy caseBuild evidence for matched worker differences without hiding source exceptions.With a plan

Practice setHandoff practiceAudit a fresh report and deliver its stated schema.With a plan

Reuse and recovery

Package preparation and recover a report from a named schema change.

4 lessons

41Macros and Interface basicsReuse a small workflow and distinguish a parameter from its configuration action.4 exercises · 14 minWith a plan

ProjectReusable department preparationBuild a local macro-based preparation flow with a clear output contract.With a plan

Case studyFailed refresh caseRecover a changed invoice export using its current fields and business meaning.With a plan

Practice setReuse and recovery practiceReuse preparation while keeping source and output contracts visible.With a plan

Interviews and practice mock

Explain workflow decisions and complete a timed original mixed assessment.

5 lessons

Interview setEasyExplain sources, anchors and common preparation choices.With a plan

Interview setMediumReason about join grain, alignment and reshaping traps.With a plan

Interview setHardDefend a repeatable workflow under changing inputs and audit constraints.With a plan

Mock examDesigner Core-style practice mockComplete 24 original decisions and workflow tasks within a 45-minute practice clock.With a plan

Practice setAssessment practiceTransfer the complete preparation and reporting toolkit to a fresh extract.With a plan