YAP Data Analytics Internship : Module 2 | Data Management & Cleaning (SQL)

Things I Learned Cleaning Data(dummy)

Data Analysis isn't just making pretty charts. It’s 80% Janitor work.

I thought Data Analytics was mostly about visualizing trends and finding the magic insight. The Reality? You can't find the magic if the data is noisy.

What I learned about Noise: Real-world data is messy. It has duplicates, missing timestamps, and status codes that don't make sense.

If you just run SELECT *, you get a table.
But if you don't filter for Data Quality first, you get wrong answers.

I learned that a NULL value isn't just an empty cell, it's a potential broken business process. A duplicate ID isn't just a typo it's a system glitch.

Excited to have added SQL Data Cleaning to my toolkit. It’s the unglamorous skill that makes the glamorous insights possible.

3 comments

Global Early Careers

skool.com/global-early-careers

Helping Early-Stage Professionals Launch Careers. Fast - With A Track Record To Prove It.

Leaderboard (30-day)