What is nigerian-energy-access-distribution-project?

This is a three page Power BI dashboard that analyses Nigeria's electricity access and distribution performance using data spanning 1990 to 2023. Power BI is a data visualization tool that turns raw numbers into interactive charts and reports. The project explores how much of Nigeria's population has electricity, how that figure has changed over 30 years, how access varies across all 36 states and the FCT, and how well the 11 electricity distribution companies, called DISCOs, are performing. The dashboard draws on World Bank open data for national level access rates and per capita power consumption, supplemented by state level figures and DISCO performance data manually structured from published NBS and NERC reports. The raw World Bank files came in a wide format with one column per year, so they were reshaped using Power Query, Microsoft's built in data preparation tool, into a long format that Power BI can work with for time based visuals. Because multiple tables all need a time dimension, the model uses a central Year table as a shared reference point rather than linking the fact tables directly to each other. Calculated measures written in DAX, the formula language built into Power BI, compute things like year over year access change, the north south regional gap, worst and best performing DISCOs by loss percentage, and collection efficiency rates. The first page covers national trends and shows that access grew from 27 percent in 1990 to 61 percent in 2023, though over 90 million Nigerians remain without power. The second page breaks down access by state, with Lagos leading at 87 percent and Yobe at 22 percent, using a color graded matrix to highlight the gap. A third page looks at DISCO level distribution performance, comparing losses, metering, billing, and collection efficiency across companies. The full README is longer than what was shown.