01 / The brief

The question

The goal of this project was to transform complex global mortality data into an interactive analytics solution that helps users explore trends, compare countries, identify major causes of death, and understand long-term healthcare patterns.

This Power BI dashboard provides a comprehensive analysis of global mortality data between 1990 and 2019. The solution enables users to explore death rates across countries, investigate the leading causes of death, analyze historical trends, and compare disease impacts across different regions. The dashboard combines interactive filtering, KPI tracking, country-level comparisons, trend analysis, and disease-specific visualizations to provide meaningful healthcare insights from large-scale historical datasets.

Results & observations

  • The final dashboard provides a user-friendly interface for exploring global mortality patterns.
  • Users can quickly identify the leading causes of death, compare countries, evaluate trends over time, and gain actionable insights from historical healthcare data.

Challenges

  • Large historical dataset spanning multiple decades
  • Data cleaning and transformation requirements
  • Designing intuitive healthcare visualizations
  • Optimizing dashboard performance
  • Presenting complex mortality trends clearly

Approach

  1. The dataset was cleaned, transformed, and modeled in Power BI
  2. Relationships were established between countries, years, and causes of death.
  3. Interactive slicers were implemented for filtering by year, country, and cause of death.
  4. Multiple visualizations were designed to highlight trends, rankings, distributions, and comparative analysis.
Implementation details

Data Preparation

Cleaned and transformed raw mortality datasets.

Data Modeling

Built relationships between years, countries, and causes of death.

DAX Development

Created KPIs, calculations, and analytical measures.

Dashboard Design

Developed interactive reports and visualizations.

Optimization

Improved performance and usability.

Explore the report

Select a screenshot for a larger view.