FC Barcelona Sierra Leone

🚀 **AI can clean your data.**

But can you tell if it cleaned it correctly?

That's becoming one of the most valuable skills in data analytics.

Today, tools like ChatGPT, Claude, and GitHub Copilot can generate Pandas code in seconds.

I use AI every day.

But here's the reality:

**AI is only as good as the person reviewing its output.**

Imagine AI gives you code to fill missing values.

Do you know:

- Should the missing values be removed or filled?
- Is the median a better choice than the mean?
- Are those duplicates actually duplicates?
- Is that outlier an error or a legitimate business event?
- Did the cleaning introduce bias into your analysis?

These are decisions AI **cannot** make for you without context.

That's why every Data Analyst needs strong data cleaning fundamentals.

Master these 10 tasks and you'll be able to:

✅ Handle missing values correctly

✅ Remove duplicate records

✅ Fix incorrect data types

✅ Standardize inconsistent text

✅ Detect outliers

✅ Validate your data

Because here's the truth:

**Garbage In = Garbage Out.**

Even the most advanced AI model can't produce reliable insights from poor-quality data.

Clean data is the foundation of accurate dashboards, trustworthy reports, and successful machine learning models.

The goal isn't to avoid AI.

The goal is to **use AI with understanding.**

When you know the fundamentals, AI becomes your assistant—not your replacement.

💬 **Which data cleaning task do you find the most challenging?**

👇 **Save this post.** It's a checklist you'll use throughout your data analytics journey.

📚 Get more free Data Analytics cheat sheets, tutorials, and career resources:

**https://everydaydatascience.com**

Follow **AI & Data With Ibrahim** for practical lessons on SQL, Python, Data Analytics, Data Engineering, Machine Learning, and AI.

**Learn • Build • Share • Inspire**

𝗔 𝗺𝗮𝗰𝗵𝗶𝗻𝗲 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗺𝗼𝗱𝗲𝗹 𝗰𝗮𝗻 𝗯𝗲 𝟵𝟱% 𝗮𝗰𝗰𝘂𝗿𝗮𝘁𝗲 𝗮𝗻𝗱 𝘀𝘁𝗶𝗹𝗹 𝗯𝗲 𝗮 𝗯𝗮𝗱 𝗺𝗼𝗱𝗲𝗹.

Imagine you’re predicting fraud.

Out of 1,000 transactions:

• 950 are legitimate
• 50 are fraudulent

Now imagine your model predicts:

“Legitimate” for every single transaction.

Its accuracy?

95%.

Looks impressive.

But it detected zero fraud cases.

That is why accuracy alone can be misleading.

Before celebrating a model, ask:

1️⃣ 𝗪𝗵𝗮𝘁 𝗶𝘀 𝘁𝗵𝗲 𝗰𝗹𝗮𝘀𝘀 𝗯𝗮𝗹𝗮𝗻𝗰𝗲?
Is one outcome much more common than the other?

2️⃣ 𝗪𝗵𝗮𝘁 𝗱𝗼𝗲𝘀 𝗽𝗿𝗲𝗰𝗶𝘀𝗶𝗼𝗻 𝘁𝗲𝗹𝗹 𝗺𝗲?
When the model predicts positive, how often is it correct?

3️⃣ 𝗪𝗵𝗮𝘁 𝗱𝗼𝗲𝘀 𝗿𝗲𝗰𝗮𝗹𝗹 𝘁𝗲𝗹𝗹 𝗺𝗲?
How many of the actual positive cases did we catch?

4️⃣ 𝗪𝗵𝗮𝘁 𝗶𝘀 𝘁𝗵𝗲 𝗰𝗼𝘀𝘁 𝗼𝗳 𝗮 𝗳𝗮𝗹𝘀𝗲 𝗽𝗼𝘀𝗶𝘁𝗶𝘃𝗲 𝗼𝗿 𝗳𝗮𝗹𝘀𝗲 𝗻𝗲𝗴𝗮𝘁𝗶𝘃𝗲?
In healthcare, fraud, lending, or cybersecurity, the consequences can be very different.

5️⃣ 𝗗𝗼𝗲𝘀 𝘁𝗵𝗲 𝗺𝗲𝘁𝗿𝗶𝗰 𝗺𝗮𝘁𝗰𝗵 𝘁𝗵𝗲 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗽𝗿𝗼𝗯𝗹𝗲𝗺?
The “best” metric depends on what decision the model supports.

🤖 𝗪𝗵𝗮𝘁 𝗮𝗯𝗼𝘂𝘁 𝗔𝗜?

AI can train the model.

AI can calculate accuracy, precision, recall, F1-score, and ROC-AUC.

AI can even recommend a model.

But you still need to decide which mistake matters most to the business.

That requires context and judgment.

𝗗𝗼𝗻’𝘁 𝗮𝘀𝗸 𝗼𝗻𝗹𝘆:

“How accurate is the model?”

Ask:

“Is the model good at the thing we actually care about?”

💬 Which metric do you look at first when evaluating a classification model?

📌 Save this for your next machine learning project.

🌐 More practical tutorials and cheat sheets:
EverydayDataScience.com

Follow AI & Data With Ibrahim for practical lessons on Python, SQL, Data Analytics, Machine Learning, Data Engineering, and AI.

Learn • Build • Share • Inspire

🚨 I’m Going Live: Healthcare Data Analytics for Beginners

I’m starting a new Healthcare Analytics Series where I’ll be learning, building, and sharing the entire process publicly.

In Episode 1, we’ll break down:

• What healthcare analytics actually means
• What healthcare claims data is
• Why claims data matters
• How patients, providers, diagnoses, procedures, payers, and costs connect
• Why SQL and data engineering are so important in healthcare
• The production-quality healthcare analytics project we’re building from scratch

This is designed for data analysts, data scientists, students, and anyone interested in breaking into healthcare analytics.

No complicated coding in Episode 1 — we’re starting with the fundamentals so everything we build afterward actually makes sense.

🎥 Join me LIVE on YouTube:
https://www.youtube.com/live/aYxw4qs6IDw?is=pjquYoabECmGtCPe

🔔 Set your reminder and come learn with me.

AI & Data With Ibrahim
Learn • Build • Share • Inspire

Healthcare Data Analytics for Beginners: What Claims Data Actually Is (Project Series Ep. 1 Every healthcare analyst job posting asks for claims data experienc...

𝗬𝗼𝘂𝗿 𝗮𝘃𝗲𝗿𝗮𝗴𝗲 𝗰𝗼𝘂𝗹𝗱 𝗯𝗲 𝗹𝘆𝗶𝗻𝗴 𝘁𝗼 𝘆𝗼𝘂.

Imagine I tell you:

“𝗧𝗵𝗲 𝗮𝘃𝗲𝗿𝗮𝗴𝗲 𝘀𝗮𝗹𝗮𝗿𝘆 𝗮𝘁 𝘁𝗵𝗶𝘀 𝗰𝗼𝗺𝗽𝗮𝗻𝘆 𝗶𝘀 $𝟵𝟬,𝟬𝟬𝟬.”

What would you assume?

Probably that a typical employee earns somewhere around $90,000.

But look closer.

Suppose:

• 9 employees earn around 𝗦$𝟱𝟱,𝟬𝟬𝟬
• 1 executive earns 𝗦$𝟰𝟬𝟱,𝟬𝟬𝟬

The average?

𝗦$𝟵𝟬,𝟬𝟬𝟬.

Yet almost nobody earns $90,000.

That is why simply calculating an average is not enough.

𝗧𝗵𝗲 𝗺𝗲𝗮𝗻 𝗶𝘀 𝘀𝗲𝗻𝘀𝗶𝘁𝗶𝘃𝗲 𝘁𝗼 𝗲𝘅𝘁𝗿𝗲𝗺𝗲 𝘃𝗮𝗹𝘂𝗲𝘀.

One unusually high or low value can pull it away from what is actually typical in your data.

As Data Scientists and Analysts, we need to go beyond:

“𝗪𝗵𝗮𝘁 𝗶𝘀 𝘁𝗵𝗲 𝗮𝘃𝗲𝗿𝗮𝗴𝗲?”

We should also ask:

🔹 𝗪𝗵𝗮𝘁 𝗶𝘀 𝘁𝗵𝗲 𝗺𝗲𝗱𝗶𝗮𝗻?
🔹 How is the data distributed?
🔹 Are there outliers influencing the result?
🔹 Is the data skewed?
🔹 Does this statistic actually represent what is typical?

This matters everywhere:

Salary data.
House prices.
Healthcare costs.
Customer spending.
Business revenue.

And this becomes even more important in the age of AI.

𝗔𝗜 𝗰𝗮𝗻 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲 𝘁𝗵𝗲 𝗺𝗲𝗮𝗻.

𝗔𝗜 𝗰𝗮𝗻 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲 𝘁𝗵𝗲 𝗺𝗲𝗱𝗶𝗮𝗻.

𝗔𝗜 𝗰𝗮𝗻 𝗱𝗲𝘁𝗲𝗰𝘁 𝗼𝘂𝘁𝗹𝗶𝗲𝗿𝘀 𝗮𝗻𝗱 𝗴𝗲𝗻𝗲𝗿𝗮𝘁𝗲 𝘃𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻𝘀.

But 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗶𝗻𝗴 𝗮 𝘀𝘁𝗮𝘁𝗶𝘀𝘁𝗶𝗰 and 𝘂𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱𝗶𝗻𝗴 𝘄𝗵𝗮𝘁 𝗶𝘁 𝗿𝗲𝗽𝗿𝗲𝘀𝗲𝗻𝘁𝘀 are two different things.

The real skill is knowing when a number deserves to be questioned.

So next time someone tells you:

“𝗧𝗵𝗲 𝗮𝘃𝗲𝗿𝗮𝗴𝗲 𝗶𝘀…”

Don’t stop there.

Ask:

“𝗗𝗼𝗲𝘀 𝘁𝗵𝗮𝘁 𝗮𝘃𝗲𝗿𝗮𝗴𝗲 𝗮𝗰𝘁𝘂𝗮𝗹𝗹𝘆 𝗿𝗲𝗽𝗿𝗲𝘀𝗲𝗻𝘁 𝘄𝗵𝗮𝘁’𝘀 𝘁𝘆𝗽𝗶𝗰𝗮𝗹?”

Numbers don’t lie.

𝗕𝘂𝘁 𝗼𝗻𝗲 𝗻𝘂𝗺𝗯𝗲𝗿 𝗿𝗮𝗿𝗲𝗹𝘆 𝘁𝗲𝗹𝗹𝘀 𝘁𝗵𝗲 𝘄𝗵𝗼𝗹𝗲 𝘀𝘁𝗼𝗿𝘆.

𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻 𝘁𝗵𝗲 𝗻𝘂𝗺𝗯𝗲𝗿𝘀. 𝗙𝗶𝗻𝗱 𝘁𝗵𝗲 𝘀𝘁𝗼𝗿𝘆.
𝗧𝗵𝗶𝗻𝗸 𝗹𝗶𝗸𝗲 𝗮 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝘁𝗶𝘀𝘁.