Available for Remote Roles

Okoli
Ifechukwu
Chinwe.

Data Analyst  ·  Lagos, Nigeria

I am a data analyst skilled in Python, SQL, Power BI and Excel, with a background in clinical pharmacy that sharpens how I think about complex data. I turn raw, scattered information into clear insights that help businesses make faster and better decisions.

I work across the full analytics pipeline cleaning and transforming data with Python and Pandas, querying databases in MySQL, and building interactive dashboards in Power BI using DAX, Power Query, Star Schema modeling and What-If analysis. In Excel I deliver clean reports using Pivot Tables, VLOOKUP, XLOOKUP and advanced functions.

My clinical training means I ask the right questions, communicate findings precisely, and focus on outputs that are actually useful to the people making decisions.

View My Work Get In Touch
10+
Projects
5
Certificates
2
Internships
BSc
Final Year Pharmacy, UNILAG
Okoli Ifechukwu Chinwe
Tools & Skills

What I Work With

Data & Querying
Python
MySQL
Pandas
SQL (DDL / DML)
CTEs & Window Functions
Jupyter Notebook
Visualisation & BI
Power BI
Excel
DAX
Power Query (M)
Star Schema
Pivot Tables
VLOOKUP / XLOOKUP
Excel Functions
Analytics Methods
Data Cleaning & ETL
Exploratory Analysis
Dashboard Design
Data Storytelling
Portfolio

Selected Projects

```
Lagos Real Estate
Featured · Python + SQL + Power BI

Lagos Real Estate Market Analysis

End-to-end pipeline on the Lagos property market. Scraped raw listings, cleaned thousands of rows with Pandas, structured data in MySQL, and built an executive Power BI dashboard surfacing pricing trends and neighborhood value across the city.

PythonPandasMySQLPower BIDAXWeb Scraping
View on GitHub →
Hospital Readmission
MySQL · Clinical Data · ETL

Hospital Readmission Analysis & Clinical Risk Drivers

SQL-based ETL and clinical analysis identifying key drivers of 30-day hospital readmissions. Covers diagnosis groups, discharge disposition, average LOS, medication adherence and readmission rates across patient cohorts.

MySQLETLCTEsClinical DataWindow Functions
View on GitHub →
Maternal Health Dashboard
Power BI · Public Health · Nigeria

Nigerian Maternal & Child Health Analysis (2013–2023)

Two-page Power BI dashboard tracking maternal mortality and child health outcomes across Nigeria's 37 states over a decade. Covers U-5 mortality trends, vaccination coverage, skilled birth attendance and geopolitical zone comparisons against WHO targets.

Power BIDAXPublic Health DataState-Level AnalysisWHO Benchmarks
View on GitHub →
Finance Intelligence Hub
Power BI · DAX · Star Schema

Finance Intelligence Hub

Executive dashboard with What-If scenario modeling, YoY/MoM time intelligence, and AI Decomposition Tree. Identified a 349% YoY revenue spike and showed a 5% cost cut could add $1.2M in net profit.

Power BIDAXPower QueryStar SchemaWhat-If Analysis
View on GitHub →
Supply Chain Dashboard
Power BI · DAX · Supply Chain

Global Supply Chain Revenue & Performance Analysis

Power BI dashboard analyzing $37M in sales across global markets from 2015 to 2018. Tracks profit margin, order volume, shipping mode performance and monthly sales trends.

Power BIDAXPower QueryMoM / YoY
View on GitHub →
Fashion Retail Dashboard
Excel · Dashboard

Fashion Retail Performance Dashboard

Interactive Excel dashboard tracking net revenue, return rates and category trends across 8 fashion brands. Built with pivot tables, dynamic charts and brand-level filtering.

ExcelPivot TablesDashboard DesignData Cleaning
View on GitHub →
Brazilian E-Commerce
MySQL · End-to-End Analysis

Brazilian E-Commerce Analysis

End-to-end SQL analysis of a large Brazilian e-commerce dataset using CTEs, window functions and aggregate queries to surface customer behavior, delivery performance and revenue trends.

MySQLCTEsWindow FunctionsEDA
View on GitHub →
Global Population Pipeline
Python · Web Scraping · ETL

Global Population Data Pipeline

Python pipeline using BeautifulSoup and Requests to scrape live world population data from the web, clean and transform it with Pandas for downstream analysis.

PythonBeautifulSoupPandasWeb ScrapingETL
View on GitHub →
```
Credentials

Certificates

AltSchool Africa
Data Analysis
View Certificate
HerTechTrail
Data Analysis Starter
View Certificate
DataCamp
Excel Fundamentals
View Certificate
In Progress
2 more certificates coming soon
Currently completing courses
Background

Experience & Education

2024
Data Analytics Intern
Excelerate — Virtual
Virtual data analytics internship focused on real-world data problems, building hands-on skills in data cleaning, exploratory analysis and reporting.
2024
Pharmacy Intern
Sirona Hospital
Clinical pharmacy internship supporting medication management, patient counseling and drug dispensing operations within a hospital setting.
2020 – Present
Pharmacy Student — Final Year
University of Lagos — Faculty of Pharmacy
Department of Clinical Pharmacy and Biopharmacy. Final-year undergraduate conducting research on the prevalence of reproductive health disorders in women with chronic metabolic conditions.

Let's Work Together

Open to remote data analyst roles. I respond quickly.