JulesInData/WHO_mncah_project

A full data pipeline built by a nutritionist learning data analytics. I pulled maternal, newborn, child and adolescent health data for Kenya directly from the WHO's live API, cleaned and loaded it into PostgreSQL, analysed it with SQL, and visualised it in Power BI. # WHO_mncah_project ## Kenya MNCAH Indicators — ETL Pipeline and Dashboard A full data pipeline built by a nutritionist learning data analytics. I pulled maternal, newborn, child and adolescent health data for Kenya directly from the WHO's live API, cleaned and loaded it into PostgreSQL, analysed it with SQL, and visualised it in Power BI. This project sits at the intersection of my clinical background and the data skills I am building. I have assessed wasted children at Kenyatta National Hospital, compiled nutrition commodity reports at NASCOP, and collected household survey data in the field for Kenya's national HIV survey. I chose these indicators because I know what they mean outside of a database. --- ## What the project covers Five MNCAH indicators for Kenya pulled from the WHO Global Health Observatory API: | Indicator | What it measures | |-----------|-----------------| | Stunting | Children under 5 whose height is too low for their age — a sign of chronic malnutrition | | Wasting | Children under 5 who are too thin for their height — a sign of acute malnutrition | | Anaemia in women | Prevalence of anaemia among women of reproductive age | | Under-5 mortality | Deaths of children under 5 per 1,000 live births | | Maternal mortality | Maternal deaths per 100,000 live births | --- ## Tools used - Python with requests, pandas, and psycopg2 in Jupyter Notebook via Anaconda - PostgreSQL hosted on Aiven, queried in DBeaver - Power BI Desktop for the dashboard --- ## The pipeline ``` WHO Global Health Observatory API | requests.get() | pandas DataFrame | data cleaning and reshaping | psycopg2 executemany() | PostgreSQL on Aiven (DBeaver) | SQL analysis | Power BI dashboard ``` --- ## Data source **WHO Global Health Observatory OData API** Base URL: `ghoapi.azureedge.net` Free and open, no registration required. Kenya data is filtered by adding `?$filter=SpatialDim eq 'KEN'` to each endpoint. --- ## Step 1: Extract I stored a …