Projects using MySQL in Nairobi CountyProjects using MySQL in Nairobi CountyRoad Safety Analysis | Python, SQL & Power BI
Developed an end-to-end road safety analytics project to help authorities understand accident patterns, identify high-risk areas, and make informed decisions about road safety interventions.
The project involved cleaning and preparing road accident data using Python and Pandas, followed by SQL-based exploratory analysis to investigate accident trends, casualty figures, severity distributions, and geographical patterns.
Using Power BI, I transformed the findings into an interactive dashboard featuring key performance indicators and visualisations that provide an overview of accident activity, highlight trends over time, and reveal differences in accident occurrence across districts and locations.
The analysis also explored accident severity in relation to road types, weather conditions, lighting, and road surface conditions.
Tools used: Python, Pandas, SQL, Power BI.
Project deliverable: An interactive Power BI dashboard supported by data cleaning, transformation, and SQL analysis.
The objective was to turn raw accident data into clear, meaningful insights that can support evidence-based road safety planning and resource prioritisation. Business Operations Dashboard for Service Management
Built an operational dashboard that helps service businesses manage daily operations from a centralized interface.
The dashboard provides quick access to jobs, customers, vehicles, invoices, and reports, allowing teams to track work progress and manage business data efficiently.
Features include job tracking, customer records, vehicle management, invoicing, reporting tools, and operational alerts. 
