Roadmap
Day 5 · Cleaning 50 min 40 XP
🧹Cleaning messy data
Real data is messy: stray spaces, odd capitals, duplicates and dates stored as text. Analysts spend a large part of their time cleaning, and it decides whether the answer can be trusted.
What you'll learn
- Remove duplicates safely
- Fix spaces and capitals with TRIM and PROPER
- Convert text dates into real dates
A peek inside
Never clean the original
The rest of Day 5 is a Pro lesson
You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).
- 3 deep-dive lessons
- A copy-paste worked example
- 3 hands-on practice tasks
- Studio task: Clean a messy contact list
- 3-question quiz, up to 45 XP
- 4 quick-glance glossary cards
- 40 XP + streak tracking
Already Pro? Sign in