kingalphie/Nigeria-Population-Growth-and-Forecasting-Analysis-Using-PostgreSQL

This project analyzes population growth trends, growth rates, and the forecasting of Nigeria’s 2033 population using 2006 and 2023 population data across Nigerian states. # Nigeria-Population-Growth-and-Forecasting-Analysis-Using-PostgreSQL This project analyzes population growth trends, growth rates, and the forecasting of Nigeria’s 2033 population using 2006 and 2023 population data across Nigerian states. ## Introduction The Nigeria Population Growth and Forecasting Analysis project was developed using PostgreSQL to analyze population trends across Nigerian states between 2006 and 2023. The project focuses on understanding population growth patterns, comparing state level population changes, and forecasting future population estimates for the next 10 years(2033) using Compound Annual Growth Rate (CAGR) analysis. The analysis was performed using SQL queries for data aggregation, filtering, growth calculations, forecasting, and reporting. The project demonstrates practical data analysis and predictive analytics skills using PostgreSQL. ## Importance of the Project This project is important because population analysis plays a major role in national planning, economic development, and policy formulation. The project helps to: - Understand population growth trends across Nigerian states - Identify highly populated and rapidly growing states - Support government planning for healthcare, education, housing, and infrastructure - Assist in resource allocation and development planning - Demonstrate practical SQL analysis and forecasting skills - Provide data driven insights for decision making and policy evaluation Dataset Details #### Dataset Name - Nigeria Population Dataset #### Number of Rows 37 rows Explanation: 36 Nigerian states & Federal Capital Territory (FCT) #### Number of Columns 4 columns Description of Each Column Column Name Description - States: Stores the name of each Nigerian state and the Federal Capital Territory - population_2006: Represents the population recorded during the 2006 population census - population_2023: Represents the estimated population for each state in 2023 …