Yusuf TiamiyuYusuf Tiamiyu
Lagos, Nigeria  ·  Healthcare Analytics

Yusuf
Tiamiyu

Hi there, I’m Yusuf Tiamiyu and I currently work at Cerba Lancet Nigeria where lab data connects to real patient outcomes. I’ve spent the last two years turning messy clinical numbers into decisions that actually get made.

0
Years in Data
0
Portfolio Projects
0
Tools Mastered
Scroll

Who
I Am

0
Years in healthcare data
0
Lab sites covered
0
k records/week
1
Peer-reviewed pub

I’m a data analyst at Cerba Lancet Nigeria, one of West Africa’s largest diagnostic lab networks. I hold two roles there: general data analyst and Data Protection Officer. Most days it’s a bit of both.

The work I do sits at the intersection of healthcare and numbers that carry real weight. Turnaround times on lab tests. Trends in operational data. Supply chains for reagents departments cannot run out of. Patterns in clinical data that, if you spot them early, change how care gets delivered.

I got into analytics because I always needed to understand why. Why is this process slow? Why do we keep ordering too much of one thing and running out of another? Data gives you something better than intuition. It gives you evidence. And once you have that, you stop guessing.

Outside work I’m a gamer — which probably explains why I treat every dataset like there’s something buried in it worth finding. There usually is. Co-author of a peer-reviewed paper in Hydrology Journal (2023).

Download Resume ↓ Published Research ↗

Tools & Stack

01
SQL & Databases
5 of 9 projects
MySQLMS SQL Server CTEsWindow Functions Recursive CTEsDENSE_RANK Staging TablesViews Joins
02
Excel & Spreadsheets
2 of 9 projects
ExcelPower Query SUMIFSAVERAGEIFS COUNTIFSINDEX/MATCH MAXIFSPivot Tables
03
Python & Backend
1 of 9 projects
PythonFlask PandasREST APIs MySQL ConnectorHTML/CSS/JS
04
Domain Expertise
All projects
Healthcare AnalyticsClinical Research TAT AnalysisData Cleaning EDAKPI Design Supply ChainDashboard Design
05
BI Tools & Visualisation
1 of 9 projects
TableauTableau Public Dashboard DesignGeospatial Visualisation Data JoinsCalculated Fields Chart SelectionStorytelling with Data

The Work

09 projects
01
Live & Deployed

TAT Analytics Platform

Rebuilt from the ground up: React/Supabase platform replacing an earlier MySQL/Flask version. Row-level filtering across site, department and TAT type, security hardening, and analytics (breach Pareto, shift×site heatmap) built to answer specific operational questions. In daily clinical use across 9 sites.

ReactSupabase/PostgresRow-Level SecurityFramer MotionHealthcareDeployed
Internal Deployment Full Case Study
02

Lab Operations Dashboard

Excel dashboard monitoring test volumes, TAT %, staff adequacy across sites. Dynamic filtering, auto direction arrows.

ExcelSUMIFSHealthcareAnonymised
03

Inventory Reorder Tracker

Excel system for 100+ lab supplies. Auto-flags REORDER NOW at two-month buffer. Shifted procurement from reactive to planned.

ExcelINDEX/MATCHSupply ChainAnonymised
04

COVID-19 Data Exploration

SQL deep-dive into global COVID death and vaccination data. Death rates, infection vs population, continental breakdowns, rolling totals.

MS SQL ServerCTEsWindow FunctionsViews
05

World Layoffs Data Cleaning

Four-phase MySQL pipeline. Deduplication via ROW_NUMBER, standardisation, intelligent null filling with self-joins, removal of dead rows.

MySQLROW_NUMBERSTR_TO_DATESelf-Join
06

World Layoffs EDA

Exploratory analysis on the cleaned dataset. Companies that went to zero, rankings with DENSE_RANK, rolling cumulative totals.

MySQLDENSE_RANKNested CTEsGROUP BY
07
Advanced SQL

Sales Gap Estimation

Chains 12 advanced SQL concepts in sequence. Recursive CTEs for date generation, LAG/LEAD for intelligent null filling. Started from real frustration with UNION ALL.

MySQLRecursive CTELAG/LEADCOALESCE
08

Bike Sales Dashboard

Excel dashboard on 1,000 customer records. KPI cards, five purchase-rate analyses, slicers for four dimensions. Middle-age group and 2–5 mile commuters drove the highest conversion rates.

ExcelPivot TablesNested IFSlicersSales Analytics
09
Tableau

2016 Seattle Airbnb Analysis

Tableau dashboard exploring 3,818 listings. Bedroom demand, pricing by location, monthly revenue seasonality, room type split. Joined Listings and Calendar datasets in Tableau Public.

TableauData JoiningGeospatialPrice Analysis
Showing all 9 projects View GitHub ↗

My Process

01
Get the Question Right

Every dataset is noise until you know what you are actually trying to answer. I spend real time here, not just on what is being asked, but on what decision is waiting on the other side of it.

02
Trust Nothing Raw

Duplicates, nulls, wrong data types, inconsistent formatting. I treat every raw dataset like it is lying until I can prove otherwise. Clean data first. Analysis second. Every single time.

03
Dig Until It Resists

I go in with questions and come out with more. I keep slicing by time, region, category and rank until the data stops giving me anything new. That is when the EDA is done.

04
Make It Actionable

A finding nobody can act on is not a finding. Everything I deliver has a decision attached. A reorder threshold. A staffing flag. A process that needs to change. Insight without action is just trivia.

Let’s Talk

Open to data analyst roles, clinical research projects, and anything that involves making sense of messy data. Lagos-based, remote-friendly.

✓
Message sent.
I'll get back to you shortly.
or reach me directly
Project
Resume