Skip to main content
Millennial Business Academy

Free Data Cleaning Lab

Clean dirty data like the job actually requires

Cleaning messy data is most of the analyst job, so this is the hands-on drill: download a genuinely dirty dataset, clean it in the required tool (Excel or SQL), and answer scored questions while the stakeholder reacts. Two Excel scenarios, two SQL scenarios, 20 questions. No hand-holding: the full answer key, with the formula or query for each and a note that other approaches work too, appears at the end.

4

Scenarios

20

Questions

Excel + SQL

Tools

Downloadable

Datasets

Every dataset is genuinely messy, the way real exports arrive: duplicates, placeholder nulls, mixed formats, text stored as numbers, orphaned records, and impossible values. Every answer is checkable from the file you download, and every wrong option is the exact number you get when you skip a cleaning step.

Ready to clean real client data with a mentor watching?

The bootcamp drills data cleaning on larger, messier datasets and turns it into a portfolio, live, with feedback.