EstherMunachimso/Nigeria-HDI-Dashboard

The dashboard aims to answer how human development has evolved over a 64-year span (1960-2023) in Nigeria and what dimensions drove this change # HUMAN DEVELOPMENT IN NIGERIA ## INTRODUCTION The Human Development Index (HDI) is a composite statistical measure developed by the United Nations Development Programme to evaluate and compare countries' overall levels of human development. Unlike purely economic indicators, HDI captures development as a multidimensional concept, focusing on the extent to which people can live long, knowledgeable, and economically secure lives. ## PROBLEM STATEMENT An interactive dashboard was developed to review the stakeholder question: how has Nigeria’s human development changed over time, and which economic or social indicators explain the most significant improvements or constraints? The dashboard was created to enable stakeholders: - Monitor development trends over time. - Find key drivers for HDI growth. - Evaluate trade-offs between population, income, and welfare. - Support evidence-based policy and strategic decision-making. The analysis generates data-driven insights into long-term development patterns, key drivers of human development, and structural challenges affecting progress. ## DATA GATHERING The data source is a time series spanning 64 years (1960–2023) with 200+ development indicators, sourced from the World Bank and the United Nations Development Programme. The dataset consists of a wide range of economic indicators, Health indicators, Education metrics, and Infrastructure and welfare variables. ## DATA CLEANING To ensure analytical accuracy and usability, the dataset was processed using Excel Power Query. - Conducted data profiling to assess data types, missing values and column consistency. - I checked for duplicate entries, blank/null values to ensure consistency across indicators. ## DATA TRANSFORMATION The original format was in Wide format (years as columns) - Unpivoted columns into long format to enable time-series analysis and for easier visualization and measures on Power BI - To avoid dashboard clutter and improve analytical clarity, key …