Emmanuel-Nwevo/DA03-DisCo-Analysis

Nigeria Power Supply & DisCo Performance Dashboard 2025 — 3MTT NextGen Capstone Project DA-03 DA-03: Nigeria Power Supply & DisCo Performance Dashboard — 2025 3MTT NextGen Cohort | Data Analysis & Visualization Track | Capstone Project --- Project Overview This project analyses power supply and outage patterns across Nigeria's 11 electricity Distribution Companies (DisCos) using verified data from the Nigeria Electricity Regulatory Commission (NERC) 2025 quarterly reports. The analysis covers energy off-take performance, energy accounting efficiency (EAE), aggregate technical commercial and collection (ATC&C) losses, and customer complaint patterns including interruption and loadshedding complaints — providing a data-driven picture of DisCo performance across Nigeria in 2025. --- Project Brief Detail Information Brief Code DA-03 Track Data Analysis & Visualization Level Beginner Focus Analyse power-supply/outage patterns per DisCo Cohort 3MTT NextGen — Project & Portfolio Phase Author Emmanuel Orji Nwevo Location Abakaliki, Ebonyi State, Nigeria --- Deliverables Deliverable File Interactive Dashboard `DA-03.pbix` — Power BI Desktop file Cleaned Dataset 1 `01_NERC_Monthly_Energy_Performance_2025_FINAL.csv` Cleaned Dataset 2 `02_NERC_ATCC_Losses_2025_CORRECTED.csv` Cleaned Dataset 3 `03_NERC_DisCo_Complaints_Outages_2025_FINAL.csv` Demo Video Submitted via 3MTT portal README This document --- Data Sources All data is sourced directly from official NERC quarterly reports: Dataset Source URL Monthly Energy Performance NERC 2025 Quarterly Reports — Appendix II nerc.gov.ng ATC&C Losses NERC Q1–Q4 2025 Quarterly Reports nerc.gov.ng Complaints & Outages NERC Q1, Q3, Q4 2025 — Appendix XII & Table 20 nerc.gov.ng Data Limitation: Complaint category breakdown is available for Q1, Q3 and Q4 only. Q2 complaint categories are not publicly disaggregated in the NERC Q2 report. Eko and Ikeja DisCos are absent from Q3 and Q4 complaint records due to state regulatory transfer — thei …