/uhc-insights

This is an analysis of Universal Healthcare Coverage globally using the UHC Index on Power BI

Universal Healthcare Insights

uhc-graphic

Introduction

This is a Power BI project to analyse the Universal Healthcare Coverage globally using the Universal healthcare service coverage index.

The SDG Target 3.8 is defined as “Achieve universal health coverage, including financial risk protection, access to quality essential health-care services and access to safe, effective, quality and affordable essential medicines and vaccines for all. Universal Healthcare Coverage Index is a measure of SDG Indicator 3.8.1 while indicator 3.8.2 focuses on health expenditures in relation to a household’s budget. The two indicators are usually monitored jointly.

The indicator is an index, ranging from 0 to 100 without any units, calculated as the geometric mean of 14 key indicators of health service coverage. These indicators are grouped into four categories of service coverage:

  1. Reproductive, maternal, newborn, and child health
  2. Infectious diseases
  3. Noncommunicable diseases
  4. Service capacity and access

Universal healthcare coverage index is a measure that assesses how well a country provides healthcare to its population.

This Power BI Project will show insights on UHC globally and how the values have changed from 2000 to 2021

Problem Statement

  1. Where do the world regions rank using the UHC index?
  2. Which countries rank highest using the UHC index?
  3. Which countries rank lowest using the UHC index?

Skills/ concepts demonstrated:

The following Power BI features were incorporated:

  • Page Navigation
  • Modelling
  • Filters
  • Reporting
  • Visualisations

Modelling:

Automatically derived images are adjusted to remove and replace unwanted relationships with the required data.

Adjusted model Auto Model
Adjusted-Model Auto-Model2

Visualisation

The report comprises 8 pages:

  1. UHC Index by Country for Year 2000
  2. UHC Index by Country for Year 2005
  3. UHC Index by Country for Year 2010
  4. UHC Index by Country for Year 2015
  5. UHC Index by Country for Year 2017
  6. UHC Index by Country for Year 2019
  7. UHC Index by Country for Year 2021
  8. UHC Index by Region for 2021

UHC Index by Country for Year 2000

country-2000

UHC Index by Country for Year 2005

country-2005

UHC Index by Country for Year 2010

country-2010

UHC Index by Country for Year 2015

country-2015

UHC Index by Country for Year 2017

country-2017

UHC Index by Country for Year 2019

country-2019

UHC Index by Country for Year 2021

country-2021

UHC Index by Region for Year 2021

UHC Index by Region