Capstone projects
8 end-to-end cases built on fictional business data. Each one gives you several messy source files, a source dictionary, known anomalies and two to four graded deliverables. Your queries are checked on the visible files, on a refreshed pack and on held-out packs you never see.
One project is free to try without an account; the others are part of Pro. Every brief is public, so you can see the scope before you start.
Monthly sales consolidation
FreeLarkspur Outdoor Supply
Combine a folder of monthly till exports whose columns drift from month to month, then build the monthly revenue summary by region.
intermediate · ~50 min · 2 deliverables · 5 files
Finance expense cleanup
ProHalden & Pike Consulting
Turn a messy UK expense export with resubmitted claims and three currencies into one clean claim per row in pounds, then report approved spend by department.
intermediate · ~60 min · 2 deliverables · 3 files
Inventory supplier merge
ProQuarry Lane Hardware
Consolidate a multi-sheet stock count workbook, compare it with the reorder policy and pick the best supplier for everything that needs ordering.
advanced · ~70 min · 2 deliverables · 3 files
CRM deduplication
ProBrightwater Events
Bring web sign-ups and event badge scans together, respect deletion requests, and build one golden record per person.
advanced · ~65 min · 2 deliverables · 3 files
HR roster normalization
ProPemberton Freight
Rebuild a clean staff table from a printed roster report with title rows, department blocks and subtotals, apply the leavers list and report headcount by department.
intermediate · ~55 min · 2 deliverables · 3 files
Nested ecommerce JSON flattening
ProFernhill Ceramics
Flatten paged order exports from a shop API (customers, line items, discount lists, optional shipping) into a line table and an order summary.
advanced · ~70 min · 2 deliverables · 3 files
Support-ticket operations reporting
ProTidewater Telecom
Clean a helpdesk export, measure resolution time against priority-based SLA targets and build a weekly SLA report per team.
intermediate · ~60 min · 2 deliverables · 3 files
Refresh-resilient multi-file analyst case
ProOstrander Cold Chain
Standardise depot files with drifting layouts from a column map and settings file, separate valid shipments from data-quality problems, resolve resends, and build a status matrix that grows with new statuses.
advanced · ~90 min · 4 deliverables · 6 files