The ONLY Data Cleaning Framework You Need | Playbook Ep. 3

MENTORSHIP - Applications for the Winter 2025 mentorship cohort are now open! Apply here → https://theanalyticsaccelerator.com/ 🎬 We’re looking for a video editor! → https://bit.ly/46gfaJP If you (or someone you know) loves editing long-form educational YouTube content and want to work with me on videos that make a real impact, I’d love to hear from you! ABOUT THIS VIDEO Struggling to know when your data is clean enough? In this episode of the Portfolio Playbook series, I’ll show you how experienced analysts approach data cleaning on the job. You’ll learn: • The 5-step CLEAN framework I used as a lead analyst • How to handle solvable vs. unsolvable data issues • Why “perfect” data isn’t the goal — and what to do instead FREE ➡️: Download the 20K-row e-commerce dataset to follow along and practice! https://bit.ly/4epyC9p Ready to kickstart data cleaning for this project with me? Let’s go. ABOUT ME If we haven’t met yet - hi! I’m Christine, a former data director and hiring manager helping ambitious career transitioners and recent grads land their first job as a data analyst. I'll be sharing the insights and strategies that empowered over 70% of job-hunting students in the first cohort of my mentorship program landed their first data job within 6 months, in today's super-competitive job market. If you want to become a standout data analyst through applied business skills, soft skills, and strategies for every part of the job hunt process - so that you can have confidence, professional leverage, and bring real impact to work - connect below for more insights and future workshops! LINKS - Get more tips in my newsletter - https://bit.ly/3LodfYs - Apply to the next cohort - https://theanalyticsaccelerator.com/ - Follow on LinkedIn - https://linkedin.com/in/christine-jiang - Instagram - https://instagram.com/cjiaang (my photography, because why not) Timestamps: 0:00 - Introduction 0:50 - Data Cleaning Framework 1:32 - About Our Sample Company 2:41 - Conceptualize the Data 4:11 - Locate Solvable Problems 15:00 - Evaluate Unsolvable Issues 20:02 - Augment the Data 22:30 - Note and Document Video URL: https://youtu.be/y9wFFD2bXQM Music track: Jay by Lukrembo, Vibing by Pufino, River by Lukrembo, Chill Vibes by Pufino Source: https://freetouse.com/music