← back to projects
featured project

National Mortality Data Analytics (SDG 3)

Cleaned and analyzed 7,854 national mortality records using Excel — identified a 28.8% mortality spike in 2021 across demographic and regional categories.

project write-up

Analyzed a national mortality dataset (sourced from OpenDOSM) aligned with SDG 3: Good Health & Well-Being.

Cleaned and standardised 7,854 records ensuring accuracy across demographic and regional categories. Built an Excel dashboard to monitor mortality trends by state, gender, and ethnicity for high-level public health comparison.

  • Key outcomes:
  • 7,854 records cleaned and standardised
  • 28.8% mortality increase identified in 2021
  • Dashboard segmented by state, gender, and ethnicity
  • Urban state and demographic patterns flagged for public health planning
project info
tools used
Excel
difficulty
Beginner
8
views
1
tools
published
March 2026
← All Projects