October challenge board
Dirty Data Lab™ · Challenge 06
Medium-Hard
Monday, October 19 · 20–25 minutesOrder Export Maze
The same order can have multiple lines, so order_id alone is not a duplicate key. You need the right composite key before the math works.
The assignment
Cleanup rules
There is one finished state. Use the rules to get the board there.
- Normalize order_id, line_id and SKU; use lowercase SKUs.
- Normalize dates to YYYY-MM-DD.
- Convert qty to whole numbers, unit_price to decimals, and discount_pct to whole-number percentages.
- Remove duplicates using the composite key order_id + line_id.
- Keep the seven original columns and sort by order_id then line_id.
- Calculate net revenue as qty × unit_price × (1 - discount_pct / 100).
Loading the puzzle board…
Loading your Lab profile…
Pass the puzzle
Send this one to a friend.
The friend link carries Dirty Data Lab™ referral attribution, so referred signups can be measured separately from newsletter and ad traffic.
Take the habit into Google Sheets
Practice here. Preflight real sheets with CTS Guard.
Clean That Sheet Guard checks the active Google Sheet for duplicates, missing data, formatting issues and other handoff problems before you share or import it.