Global Health & Economic Outcomes

This project examined how economic conditions and public healthcare investment relate to health outcomes around the world. Using data from Our World in Data, I analyzed GDP per capita, public health expenditure, life expectancy, child mortality, and population across 52 countries from 2000 to 2022. I created interactive dashboards in Tableau and Excel to explore regional differences, long-term trends, and relationships between economic and health indicators.

I completed the full data workflow, beginning with multiple source datasets that required cleaning and preparation before they could be analyzed together. I used Python to standardize columns, align year ranges, reconcile country and region data, and merge the datasets. I then performed the analysis and designed interactive dashboards in both Tableau and Excel.

The source data was distributed across multiple datasets with different structures and levels of coverage. Public health expenditure had the smallest country coverage, so I needed to establish a consistent set of countries and years before merging the data.

I built a consistent analysis dataset in Python by standardizing fields, filtering all sources to 2000–2022, and merging records by country and year. I then used regional groupings, interactive filters, maps, time-series charts, scatter plots, and summary statistics to make relationships in the data easier to explore across Tableau and Excel.