ifexxx-dat/Nigerian-Energy-Access-Distribution-Project

A 3-page Power BI dashboard analysing Nigeria's electricity access trends from 1990–2023, state-level disparities across all 36 states, and DISCO distribution performance across 11 electricity companies. Built with Power Query, DAX, and a shared dimension data model # Nigerian Energy Access & Distribution Intelligence Dashboard A 3-page Power BI dashboard analysing Nigeria’s electricity access trends, state-level disparities, and DISCO distribution performance using World Bank, NBS, and NERC-referenced data. ## Project Overview Nigeria’s electricity crisis is one of the most documented yet underanalysed problems in Africa. With over 90 million people still without power, and distribution losses averaging 29% across all DISCOs, the data tells a story that goes beyond infrastructure — it reveals deep regional inequality and systemic inefficiency. This project was built to demonstrate end-to-end Power BI skills including data sourcing, Power Query transformation, data modelling, DAX measure writing, and professional dashboard design. ## Tools Used - Microsoft Power BI Desktop - Microsoft Excel - Power Query (M Language) - DAX (Data Analysis Expressions) ## Data Sources NGA_Electricity_Access == World Bank Open Data == % of Nigerian population with electricity access (1990–2023) NGA_Power_Consumption == World Bank Open Data == Electric power consumption in kWh per capita (1990–2023) State_Access == Structured manually from NBS/NERC published figures|State-level electricity access % including urban and rural breakdown for all 36 states + FCT DISCO_Performance == Structured manually from NERC Annual Report figures|DISCO-level allocation, metering, billing, collection, and losses data | ### Note on Data Collection The World Bank datasets were downloaded as CSV files and contained global data for all countries Nigeria’s data was extracted during the Power Query transformation stage. The State_Access and DISCO_Performance tables were manually structured from published NBS and NERC figures, a deliberate choice that allowed full control over data quality and structure. ## Data Cleaning & Transformation (Power Query) ### NGA_Electricity_Access & NGA_Power_Consumption Both World Bank files a …