Okafor Kenechukwu Kingsley

“Future Data Analyst | Excel • SQL • Power BI • Python | Sharing my learning journey, projects & insights publicly | Solving problems one dataset at a time”

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Today’s 3MTT NextGen class reminded me that the “basics” in Excel are more important than they look 😅

Workbook structure, formatting, data types, organizing datasets properly… small things, but they can completely affect your analysis if ignored.

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Started my 3MTT NextGen Data Analysis journey today 🚀
Learned: – What data & data analysis really mean
– Types of analysis (descriptive, predictive, etc.)
– Key steps in analysis
Biggest takeaway:
👉 Clean data = accurate insights
#3MTT #NextGen #JeefAfrica #DataAnalytics

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Got a scholarship to learn Data Analysis with @nithub_lag × @DataCamp 🙏🏽
Grateful for the opportunity.
Time to learn, build, and grow.
#DataAnalytics #Scholarship #BuildInPublic #LearningJourney

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Excel shortcuts that will save you time 👇
Ctrl + T → Create table
Ctrl + Shift + L → Filter
Ctrl + Arrow → Jump fast
Alt + = → AutoSum
Small tricks. Big difference.
#ExcelTips #DataAnalytics #Productivity

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Was trying to subtract birth_date from survey_date in Excel Power Query…
The option was inactive 😤
Tried everything… nothing worked.
Turns out I also selected patient name 😅
Deselected it → it worked instantly.
Small mistakes will humble you 😂
#ExcelTips #powerquery #excel

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Excel tip:
If your numbers aren’t working properly, check this 👇
They might be stored as TEXT, not numbers.
That’s why formulas, sorting, or charts fail.
Fix it → everything works.
#DataAnalytics #ExcelTips

[Okafor Kenechukwu Kingsley @kingsleyleo7]

@Mrbankstips @Bigmos553 Never stop learning, building, and growing

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Cleaned the dataset ✅
What looked simple at first? Not even close 😅
Duplicates, missing values, wrong formats…
Took time, made mistakes, learned a lot.
Clean data >>> everything.
#DataAnalytics #BuildInPublic

[Okafor Kenechukwu Kingsley @kingsleyleo7]

@DmitryVladyko Thank you so much 😊

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Need help 👇
I’ve cleaned almost everything in this dataset, but the date column is a mess 😅
Mixed formats (DD/MM, MM/DD, etc.) and I’m struggling to standardize it properly in Excel.
Any tips or functions I should use?
#DataAnalytics #BuildInPublic #Excel

[Okafor Kenechukwu Kingsley @kingsleyleo7]

@BestofDem_szn @silverpenydr Hello

[Okafor Kenechukwu Kingsley @kingsleyleo7]

@jasper_yy Okay thank you 😊

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Spent hours trying to clean a dataset today…
Got frustrated.
Stayed up late.
Still couldn’t fix everything.
Not every day is a win.
But I understand it better than yesterday… and that counts.
#DataAnalytics #BuildInPublic

[Okafor Kenechukwu Kingsley @kingsleyleo7]

@Anthonytapias_ It makes your work easier

[Okafor Kenechukwu Kingsley @kingsleyleo7]

Day 2 🚀
Started the Data Cleaning Challenge and the dataset is messy 😅
Inconsistent text, mixed dates, missing values, wrong totals…
Realizing again: clean data > fancy dashboards
Time to fix everything step by step 💻
#DataAnalytics #BuildInPublic #TechWithEuniceChallenge

[Okafor Kenechukwu Kingsley @kingsleyleo7]

@RONiNmedia000 Yeah, for real… this part of the journey doesn’t get talked about enough.
It’s a market sales dataset from a data cleaning challenge — full of inconsistencies, mixed formats, missing values, wrong totals… the kind that looks simple
Still figuring it out step by step though.

[Okafor Kenechukwu Kingsley @kingsleyleo7]

This is the dataset I’m working on for Day 2👇
Looks normal at first… until you notice: inconsistent text, mixed dates, missing values, duplicates 😅
Real reminder: clean data > fancy dashboards
Time to fix it 💻
#DataAnalytics #BuildInPublic #TechWithEuniceChallenge

[Okafor Kenechukwu Kingsley @kingsleyleo7]

@Anthonytapias_ What’s the interesting point