ererock/-Nigeria-Population-Map-Analysis

## Overview This project analyzes population distribution across Nigerian states using geographic mapping and comparative population data from **2006** and **2019**. The goal of the project is to identify population trends, growth rates, and the most populated states using an interactive dashboard. # Nigeria Population Map Analysis ## Overview This project analyzes population distribution across Nigerian states using geographic mapping and comparative population data from **2006** and **2019**. The goal of the project is to identify population trends, growth rates, and the most populated states using an interactive dashboard. --- ## Dataset The dataset contains population and geographic data for Nigerian states. ### Columns | Column | Description | |------|-------------| | State | Name of the Nigerian state | | Latitude | Geographic coordinate used for mapping | | Longitude | Geographic coordinate used for mapping | | Population (2006) | Population recorded in the 2006 census | | Population (2019) | Estimated population in 2019 | --- ## Key Performance Indicators (KPIs) The dashboard highlights the following metrics: - **Total Population (2006)** - **Total Population (2019)** - **State with the largest population** - **States with population decline** - **Top 5 states by population growth rate** --- ## Key Insights ### Most Populated States The analysis identified the most populated states: 1. Kano State — approximately **14 million people** 2. Lagos State — approximately **13 million people** These states have the highest population concentration in Nigeria. --- ### Population Growth Leaders Between **2006 and 2019**, the following states recorded the highest growth rates: | State | Growth Rate | |------|-------------| | Federal Capital Territory (FCT) | 92% | | Zamfara State | 62% | This indicates rapid population growth, especially around the capital region. --- ## Dashboard Features ### Map Visualization A geographic map is used to visualize population distribution across Nigerian states using **latitude and longitude coordinates**. ### Interactive Filters The dashboard includes slicers that allow users to view: - Population in **2006** - Population in **2019** - State-level comparisons --- ## Tools Used - Microsoft Excel — Da …