Analysis of Health Facilities in Sub-Saharan Africa
This analysis aims to understand the distribution of health facilities in Sub-Saharan Africa, extracting insights related to the distribution of health facilities at both the country and state (administrative division) levels. It also investigates types and ownership structures of healthcare facilities across the region. Subsequently, the analysis will narrow its focus to Nigeria to examine the state-level distribution of health facilities, and ownership, facility type and healthcare service tiers within the country.
Insights from Failed Orders
This project involves the analysis and exploration of failed orders of a taxi-hailing company, with a specific focus on understanding orders cancelled by the client (excluding those cancelled by the system). The goal is to uncover what, when, and where these cancellations are happening.
.jpg)
Querying Hospital DB
In this project, I retrieved relevant data from a relational hospital database containing 18 interrelated tables. The focus was on showcasing my ability to write efficient SQL queries using JOINs, subqueries, and filtering techniques. These queries simulate real-world data requests across different hospital operations such as admissions, medications, allergies, and procedures.
Electronic Product Sales Analysis
This project analyzes five years of electronic sales data with a focus on showcasing advanced SQL skills—particularly the use of window functions. Through a series of business-driven queries, the analysis answers key questions around profitability trends, customer behavior, and category performance. The goal is twofold: to demonstrate proficiency in SQL window functions and to provide the sales team with actionable insights into sales dynamics over time.
.jpg)