Workflow Challenges
Lessons teach the tools. Workflow Challenges ask you to use them.
Choose any brief. Each uses small synthetic datasets and runs independently. Time estimates are loose guidance.
Consistent product names
Prepare consistent product labels for a catalogue handoff.
Table Clean labelsOpen brief
Prices that can be used
Separate usable café prices from records that need repair, retaining the original text as evidence.
Table Usable & repair listsOpen brief
An attendance handoff
Produce a chronological attendance table with identifiable learners and valid dates.
Table Attendance handoffOpen brief
Repeated order exports
Remove repeated uploads while retaining legitimate repeat purchases.
Table Deduplicated ordersOpen brief
Calculate a useful total
Prepare usable sales lines and their monetary totals.
Table Sales totalsOpen brief
Fill only what is justified
Prepare net order amounts under the billing team’s explicit missing-value policy.
Table Net amountsOpen brief
Connect records to a lookup
Attach depot managers without losing deliveries that have no matching assignment.
Tables Assigned & unassignedOpen brief
Combine two batches
Combine two compatible delivery exports into one handoff.
Tables Combined handoffOpen brief
Make repeated measurements usable
Prepare an activity extract that keeps each value connected to its measurement and unit.
Table Long measurementsOpen brief
Prepare a clean handoff
Prepare a compact café billing extract while preserving the incoming evidence.
Table Billing handoffOpen brief