Post-Covid-Healthcare-Expenditure
Post-COVID Healthcare Expenditure Analysis: A Global Perspective
📊 Interactive Dashboard
Click to View Full Dashboard ►
📘 Overview
Healthcare expenditure significantly impacts both national economies and public health. This analysis investigates how countries allocated healthcare funds between 2019 and 2022, with a spotlight on shifts induced by the COVID-19 pandemic. From economic resilience to life expectancy, our research connects spending to outcomes that shape lives.
🔍 Key Research Questions
- How has healthcare expenditure as a % of GDP changed since 2019?
- What’s the relationship between healthcare spending and GDP per capita?
- How does healthcare expenditure vary geographically?
- Is there a correlation between spending and life expectancy?
- What are the overall expenditure trends post-COVID?
👥 Audience & Stakeholder Value
Policymakers — Budget allocation insight for underfunded regions
Healthcare Administrators — Performance tuning based on resource impact
Public Health Researchers — Correlations between spending and health outcomes
📂 Dataset Overview
- Source: World Development Indicators (2019–2022)
- Format: 239 rows x 6 columns
- Indicators: GDP, life expectancy, health expenditure, mortality, etc.
⚖️ Methodology
- Power Query Unpivoting — Reshaped wide format to long for better analysis.
- Pivoting Indicators — Created separate columns for each metric.
- Clean Wrangling — Final dataset included year-wise values per country with 13 core indicators.
📊 Visualization Tools Used
| Tool | Purpose | |—————–|———————————-| | Line Chart | Trends over time | | Scatter Plot | Correlation analysis | | Map View | Geographic comparison | | Heatmap | Year-on-year change detection |
📈 Key Visual Analyses
A. Healthcare Expenditure (% of GDP, 2019–2022)
B. Expenditure per Capita vs. GDP per Capita
C. Magnified View (Lower GDP Nations)
D. Map View: Spending % of GDP
E. Latest Year Snapshot (2022)
F. Expenditure per Capita vs. Life Expectancy
G. Heatmap: 2019–2022 Trends
💡 Key Insights
- Disparity in Funding Capacity — Wealthier countries rapidly increased budgets; poorer nations struggled.
- Spending vs. Life Expectancy — Correlation exists, but not perfectly linear due to system inefficiencies.
- Geographic Inequality — Clear divide in per capita and GDP-based spending.
- Economic Capacity Isn’t Everything — Policy priorities matter. E.g., Brazil’s public care model.
📅 Recommendations
1. 🌍 Boost International Aid for Low-Income Countries
- Mobilize multilateral health grants
- Build resilient healthcare infrastructure
- Expand support beyond pandemic periods
2. 🔧 Improve Efficiency in High-Income Nations
- Prioritize preventive care over reactive
- Integrate digital health systems
- Link provider pay to patient outcomes
- Cut waste via streamlined insurance systems
3. 🛡 Strengthen Global Health Crisis Preparedness
- Setup emergency health funds
- Maintain PPE/vaccine reserves
- Train scalable health response teams
- Support global early warning systems
🔗 Further Reading
📄 Conclusion
Post-COVID healthcare spending has amplified both economic resilience and vulnerability. High-income nations leveraged their budgets for swift action, while many low-income countries continue to rely on aid and long-term support. The global community must address these imbalances for a more equitable, sustainable health future.
“Investment in health is not a cost — it is a prerequisite for prosperity and peace.”
— WHO Director-General
Author: Ramanav Bezborah
Project Repository: View on GitHub