Four end-to-end analyses showing the full workflow: data collection, cleaning and quality checks, analysis and reporting of findings.
Youth Skills & Enterprise Programme
Illustrative training programme for 300 young people in three Kenyan sub-counties: a proposal and workplan, a logframe and indicators with planned targets, and an interactive dashboard reporting results against those targets.
Programme designLogframe & indicatorsResults reportingExcel · Logframe & Indicators · Interactive Dashboard
Household Socioeconomic Survey Analysis
Illustrative survey of 9,420 households taken from questionnaire design in KoboToolbox to PostgreSQL analysis, a Power BI dashboard with DAX, and a findings report with recommendations.
Survey designQuantitative analysisData visualisationKoboToolbox · PostgreSQL · Power BI · DAX
HealthAccess: Hospital Visits Analysis
Python analysis of about 84,000 synthetic hospital visits: data cleaning, exploratory analysis, correlation analysis (Spearman, partial) and hypothesis testing (Chi-square, Mann-Whitney U, Kruskal-Wallis), with effect sizes reported alongside p-values.
Statistical analysisData quality assurancePython · Pandas · Descriptive & Inferential Statistics · Hypothesis Testing
East African Retail Sales Analysis
Power BI analysis of 999 synthetic supermarket transactions across three East African markets, covering data cleaning in Power Query, DAX time-intelligence measures and a four-section dashboard.
Data visualisationData quality assurancePower BI · Power Query · Github


