goodnessO2/nigeria-energy-infrastructure-analysis

Analysis of electricity infrastructure, generation capacity, and electricity access across Nigerian states using SQL and Power BI # nigeria-energy-infrastructure-analysis ## Dashboard Preview ## Project Overview Analysis of electricity infrastructure, generation capacity, and electricity access across Nigerian states using SQL and Power BI ## Tools Used * **MySQL:** Data cleaning, standardization, and view creation. * **Power BI:** Data visualization, interactive dashboard design, and DAX modeling. * **Excel:** Initial data retrieval and null value handling. ## Datasets * **State Electricity Access Dataset:** Contains the electricity access rate (%) for rural and urban areas across Nigerian states over a 5-year period (2018–2023). * **Grid Infrastructure Dataset:** Details state-allocated infrastructure, including grid type, plant type, voltage capacity (real and apparent power), transmission length, year commissioned, and functional status. * **Nigeria Energy Analysis Dataset:** A merged, analytical dataset combining access and infrastructure records via SQL joins on the state level to uncover deep distribution trends. ## Data Cleaning Process * **State Electricity Access Dataset:** Contains the electricity access rate (%) for rural and urban areas across Nigerian states over a 5-year period (2018–2023). * **Grid Infrastructure Dataset:** Details state-allocated infrastructure, including grid type, plant type, voltage capacity (real and apparent power), transmission length, year commissioned, and functional status. * **Nigeria Energy Analysis Dataset:** A merged, analytical dataset combining access and infrastructure records via SQL joins on the state level to uncover deep distribution trends. ## Key Insights * **Capacity Leadership:** Lagos State significantly dominates the national power generation capacity. * **The Energy Mix:** Gas-powered plants make up the overwhelming majority of the current energy infrastructure. * The Infrastructure Disconnect:** Higher infrastructure allocation in a state does not inherently guarantee a proportionally higher electricity access rate for its po …