My Work

Case Studies & Projects

Real data. Real analysis. Real recommendations.

Health Analytics
Excel Dashboard

Grapevine Hospital — Clinical Performance Analysis

A comprehensive analysis of 2,000 patient records across 8 departments over a 3-year period (2022–2024). The project uncovered critical gaps in patient outcomes, financial access barriers, and departmental performance — delivering actionable recommendations for hospital management.

24.6% Cardiology mortality rate — highest in the hospital
48.4% Recovery rate — less than half of patients fully recovered
₦110.8M Out-of-pocket patient burden identified
0% Mortality in Gynaecology & Orthopaedics — best practice identified
ExcelPivot TablesDashboard Health DataPatient OutcomesKPI Analysis
Business Analytics
Insight Report

David's Stores — Sales & Customer Insight Report

A full business intelligence report on a Nigerian retail chain covering ₦319.9M in transactions, 2,951 customers, and 13,371 orders. The analysis identified revenue concentration risks, the highest-ROI marketing channel, and an under-monetised female customer segment.

₦319.9M Total revenue analysed across all transactions
83% Gross margin uncovered — strong pricing power confirmed
₦72.4M Instagram revenue — identified as #1 marketing channel
₦33M Word-of-mouth revenue with zero ad spend
ExcelPivot TablesBusiness Intelligence Retail AnalyticsCustomer InsightRevenue Analysis
Coming Soon

Case Study 3 — In Progress

A third case study is currently in development. Follow Davids Analyst on LinkedIn and Facebook for updates.

Have a dataset you want analysed?

Commission a professional insight report for your organisation.

Start a Project