Ifedolapo Joseph

Data Analyst | Exploring insights through data 📊 | Just completed my first project in Excel & still learning every day!

[Ifedolapo Joseph @Ifedolapojoe]

I am delighted to be enrolled as a Data Analyst in the
@TDataImmersed Community Sapphire Cohort 2025. This is my first assignment for Week One!

@jacob_ajala
@DabereNnamani
@msexcel
#TDI

[Ifedolapo Joseph @Ifedolapojoe]

@Maggiewitdsauce @jon_d_doee This is the only authentic and realistic advise I have seen so far.

It was the same thing I would have said. Nothing more , nothing less.

End.

[Ifedolapo Joseph @Ifedolapojoe]

📊 Chivita Sales & Distribution Performance Review.

A full sales analytics deep-dive, from raw data to dashboard to written report

https://t.co/yeY4vBgeih

#SQL #DataAnalytics #PortfolioProject

[Ifedolapo Joseph @Ifedolapojoe]

Sharing 2 recent projects from my portfolio 👇

🏥 MediCare Plus: a fully normalised SQL Server healthcare database (3NF, stored procs, views, triggers, RBAC, a data warehouse + ETL, and a 93% query speed-up via indexing)

https://t.co/qATpMN2H6T

[Ifedolapo Joseph @Ifedolapojoe]

@therealmakuthu @ScholarshipfPhd Is it free?

[Ifedolapo Joseph @Ifedolapojoe]

@The_Adire_girll You use draw io for this right?

[Ifedolapo Joseph @Ifedolapojoe]

@Adedamolaartt @Ifyyodunze @treazyblaq 300 billion dollars for you my man...

[Ifedolapo Joseph @Ifedolapojoe]

@taiwo_junzi This is what we call wisdom 101.

The foundation for having a long lasting relationship.

Thank you for this.

[Ifedolapo Joseph @Ifedolapojoe]

@chisomholic @guzu_p Lol

You are very wicked 😂

[Ifedolapo Joseph @Ifedolapojoe]

Full breakdown here 👇
[https://t.co/eSZHp2Qamn]

[Ifedolapo Joseph @Ifedolapojoe]

I analyzed a logistics dataset with PowerBi and found why deliveries get delayed 👇

At first glance, everything looked fine.
Shipments were moving. Deliveries were happening. But the data told a different story.

[Ifedolapo Joseph @Ifedolapojoe]

Then turned it into actionable recommendations:
Reduce Lagos congestion
Improve last-mile delivery
Rebalance transport usage

This project changed how I think about logistics. It’s not about movement. It’s about coordination.

[Ifedolapo Joseph @Ifedolapojoe]

These steps helped transform raw operational data into structured insights that can support better supply chain decision-making.

#TheDataImmersed
@TDataImmersed
@DabereNnamani
@ThePSF

[Ifedolapo Joseph @Ifedolapojoe]

Week 7 of my Python data analytics journey focused on data cleaning and feature engineering using Pandas.

I worked with a supply chain dataset to handle missing values, convert data types, and clean messy text fields to ensure consistency.

[Ifedolapo Joseph @Ifedolapojoe]

Beyond cleaning, I built additional analytical features like delivery speed categories, order age, and comparisons between order costs and product category averages.

[Ifedolapo Joseph @Ifedolapojoe]

Also explored pivot tables and supplier performance metrics to uncover supply chain insights.
Excited to keep building stronger data analysis skills.

#TheDataImmersed
@TDataImmersed
@DabereNnamani
@ThePSF

[Ifedolapo Joseph @Ifedolapojoe]

Week 6 of my Python Data Analysis journey focused on Pandas for data exploration and transformation.

I practiced loading datasets, filtering records, indexing data, creating calculated columns, merging tables, and performing group analysis.

[Ifedolapo Joseph @Ifedolapojoe]

. Applied 5% shipping markup and ran full statistical analysis
. Identified above-average cost products and outliers
. Compared suppliers’ performance & modeled profit with different margins
#TheDataImmersed
@TDataImmersed
@DabereNnamani
@ThePSF

[Ifedolapo Joseph @Ifedolapojoe]

Week 5: NumPy for Supply Chain Analytics
This week, I used NumPy to analyze a cleaned supply chain dataset:
. Extracted costs, quantities & lead times into arrays
. Calculated total revenue, average order value, min/max costs & lead time range