₦airaland Forum

The goal was not just to build dashboards, but to simplify complex electricity sector data into something decision-makers, businesses, and everyday Nigerians can understand.

Tool: MS Power BI

My background

I'm a Power BI Data Analyst with proficiency in using Power BI's Power Query, DAX, Data modeling capabilities to transform complex business data to uncover meaningful and actionable insights to support data-driven decision-making

METERING OPERATIONS

- The South West recorded the largest customer base and strongest metering performance.
- Ibadan had the largest customer base overall but less than half of customers were metered.
- Yola recorded the weakest metering rate at 15.5%.
- Millions of customers still depend on estimated billing.

Key recommendations
- Expand prepaid and smart meter rollout.
- Reduce dependence on estimated billing practices.

ENERGY OPERATIONS

- DisCos received 197,960 GWh of electricity between 2017 and 2023.
- Only 154,512 GWh was successfully billed to customers, resulting in a billing efficiency of 78.1%.
- About 21.9% of energy was lost through technical and commercial inefficiencies.
- The data also shows that higher electricity offtake does not always result in stronger billing performance.

Key recommendations
- Upgrade aging distribution infrastructure.
- Improve transformer maintenance and feeder monitoring.
- Strengthen meter reading accuracy and billing systems.

REVENUE & COLLECTIONS

- Nigerian DisCos billed about ₦6.6 trillion between 2017 and 2023 but collected only ₦4.5 trillion.
- About ₦2.1 trillion remained uncollected across the industry.
- Ikeja, Eko, and Abuja recorded the highest collection efficiencies, while Kaduna, Jos, and Yola recorded the weakest performance.
- The South West region generated nearly half of total electricity market revenue in Nigeria.

Key recommendations
- Improve digital payment adoption and customer payment systems.
- Reduce estimated billing disputes through mass metering.
- Improve energy accounting and operational transparency across DisCos.

Here are some key findings from the reports.
OVERVIEW
- Nigeria’s average ATC&C loss stood at 46.8% between 2017 and 2023.
- Ikeja and Eko recorded the strongest operational performance with ATC&C losses of 23.6% and 27.0%, while Kaduna and Yola recorded the weakest performance above 70%.
- Total electricity customers stood at 12.12 million, but over 6.3 million customers still remained unmetered.
- Ikeja recorded the highest metering rate at 80.6%, followed by Port Harcourt, Eko, and Abuja.

Nigeria’s Electricity Gap and Where the Burden Falls

These reports clearly highlight Nigeria’s electricity gap and where the burden truly falls across electricity distribution companies, regions, and consumers.

Before I continue, let me quickly mention this.

Over the past few months, I’ve been building strong expertise in data analysis with Microsoft Power BI as part of the Power BI Data Analyst Program at Data Science Nigeria in partnership with Microsoft through the Elevate AI Developers Program.

Interestingly, my original plan was to focus mainly on Excel. But one thing led to another, and I found myself diving deep into Power BI, data storytelling, dashboard design, DAX, Power Query, and business intelligence reporting.

This capstone project became an opportunity to use data to understand one of Nigeria’s biggest economic and social challenges: electricity distribution.

Now back to the story.
Nigeria generates far less electricity than it actually needs, but one major question remains:

Is Nigeria’s electricity problem mainly a generation problem, a distribution problem, or both?

The data tells an interesting story.

My analysis focused on the operational performance of Nigerian Electricity Distribution Companies (DisCos) using publicly available NERC data from 2017 to 2023.

Why DisCos?
Because they sit at one of the most critical points in the electricity value chain. They are responsible for distributing electricity to homes and businesses, billing customers, collecting revenue, and managing energy losses.

The findings reveal that the electricity burden is not shared equally across regions or DisCos.

Some DisCos consistently perform better in billing efficiency, metering, revenue collection, and ATC&C loss reduction, while others struggle heavily with commercial losses, energy theft, poor metering coverage, and weak revenue recovery.

One important lesson from the analysis is this:
- Higher electricity supply alone does not automatically translate into better performance.
- Some DisCos receive large volumes of electricity but still fail to bill or recover enough revenue from it efficiently.

That means the problem is not only about generating electricity. Distribution efficiency, metering infrastructure, revenue assurance, and energy accountability also play a major role.

If I were presenting this dashboard to policymakers, the first visual I would lead with is the ATC&C Loss analysis by DisCo.

Why?
Because it combines technical loss, commercial loss, and collection inefficiency into one metric. It gives the clearest picture of operational performance and financial leakages across the sector.

The dashboard does not only show problems. It also highlights progress.

For example, Ikeja and Eko DisCos consistently recorded stronger billing efficiency, metering rates, collection efficiency, and lower ATC&C losses compared to several others. This shows that improvement is possible when operational systems are stronger.

#dataanalytics #data #dataanalysis #PowerBI

Xion57:
Please how do I get to Ican Amuwo center from Ikorodu?

Find your way to Oshodi, then enter mile 2 bus from Oshodi and alight at 2nd Rainbow, take keke/bike to Ago palance Road, and tell the bike to stop you by ICAN

joshkke:
I want someone that can do simple AI generated phone graphics from descriptions I will provide. Quote me if you are interested.

How do we get started?

I've sent a WhatsApp message to the number on your profile l.

I've also sent an email request via Nairaland

Kindly check.

I did 1, 3, 5, 7 & 9

3 & 9 looks similar though.

The hardest for me were 1, 3/9 & 5

Leelo190:
Please I need directions from yaba to Km 18, Lekki-Epe Expressway, Before Chevron Roundabout, Lekki, Lagos

1. Take a bus to Obalende
2. Enter a second bus that's going to Ajah from Obalende
3. Tell the driver/conductor to stop you/you're stopping at Chevron B/Stop, Lekki

Hmm

ONWARD BIG = Olu Na Witch After Reading Devil's Book In Ghana.

Update: In respect to my previous post on knowing someone that you can reach out to for a student loan...

Kindly note that such platform is no longer available please. You can keep searching until you find your breakthrough.

Kind regards!

MaineHomes:
Hello guys, kindly advise me. I have a Toyota RAV4 2004 and I want to use it for Bolt. Is the car ok for the business? Has anyone used it and what's the experience?

It's okay for Uber and the likes. One of the requirements for any car to be used for such business is that it must be 2003 models upwards.

You will also undergo their inspection. Your car AC must be working fine too

Learn any tech skills! I repeat, Learn any Tech skills!

Tech skills like Data Analytics, Data Science, Cyber Security, Software Engineering, Product Designer/Manager/Owner, Project Manager, UI/UX Designer, DevOps etc.

Shalom

Dear Nairalanders,

As a necessary prerequisite to completing an 8-week intensive program with ALX to specifically train me to become a Virtual Assistant;

I invite you to request tasks from me, I will accept any tasks that can be done and completed under 1hr and remotely. You can submit multiple tasks and I will complete them for you free.
kindly submit your task requests via the link below...

Kindly check go to my profile to get the link and my WhatsApp number to submit your requests, since nairaland won't allow it posted here.

I look to receiving your task requests. Thank you

The Itunu Residential, Site and Service Plots - Itunu, Lekki Epe Expressway

Now Selling!!!

Welcome to the land of Comfort, a place where the simplicity of nature and the thrill of technology meets.

A safe haven where you can rediscover the tranquility of a perfect space.

An evergreen land that sits at Aiyetoro, Ibeju-Lekki LGA, facing the Lekki-Epe Expressway.

This is a residential space with a natural appeal, perfect for holiday get-aways and a sweet escape from the hustle and bustle of Lagos.

*Residential Plot Sizes available in 300sqm and 500sqm*

*Title: Government Allocated CofO
*Prices:
300sqm - N11.5m
500sqm - N16m
All inclusive of Other Statutory Charges

Flexible payment plan available for up to 12 months.

*ESATEE FEATURES*

- Good road network
- 24/7 Security
- Family entertainment center
- Good Drainages
- Portable Water
- Landscapes
- Electricity

*NEIGHBOURHOOD*

- Alaro City
- Lekki Airport
- Dangote Refinery
- Lekki Free Trade Zone
- Epe Resort & Spa
- Jubillee Resort Epe
- Eleganza Industrial City

For more details & inspection/bookings call/WhatsApp 09060720721

New Price Update!!!

THE LAGOON FRONT ESTATE, ALARO CITY, EPE.

The Lagoon front estate, Alaro City is set on the North side of the Lekki Lagoon located along Lekki-Epe expressway, Alaro City, Epe.

It is situated in a serene environment with a touch of nature and class.
It is also pocket- friendly and gives real value for money.

Location: Opposite Alaro City, Epe.

Title :Government Allocation /C of O

*Plot Sizes : (300 sqms & 500 sqms)

NEW PRICE FROM APRIL 16th
500sqm: ₦15M
300sqm: ₦9M

Initial deposit: ₦1m

Neighbourhood
- Lekki free trade zone
- Alaro city
- Epe resort
- Proposed International Airport.
- Seaport.
- Lekki phase 1.
- Ajah.

Highlights
- Perimeter fencing.
- Electricity.
- Estate gate house.
- Motorable and Accessible

Water front properties are the most expensive with Promising ROI.

The iIkoyi, Banana island are Clear Evidences��
You need to own a water front property

For Enquiries/ Site Visits:
Call/WhatsApp 09060720721

JEWEL GARDENS, ELEKO, IBEJU LEKKI

NOW SELLING FAST

Jewel Gardens is a beautiful, well laid out enclave in a serene and developed neighborhood of Eleko town in Ibeju lekki. The property is situated along the Lekki Coastal road that links Ibeju Lekki to Victoria Island surrounded by the breathtaking view of the ocean side, with its good land title and complete documents you can be rest assured that you are owning more than just a land you will be owning a treasure.

Neighborhood

- Lekki Free Trade Zone
- Eleko Beach
- Debojo Beach and Resort
- Shares boundary with Amen estate Phase 2

Proposed Features

- Security
- Electricity
- Good road
- Perimeter fencing of the entire estate and gate house
- Properly designed layout plan
- Water
- Drainage system
- Recreational and green area
- Commercial building

Land Title: Approved Government Excision

Land Size: 600 sqm

Actual Price: 3.5M


TAKE ADVANTAGE OF THIS OFFER TODAY
Call\Whatsapp 09060720721

New Price update coming up soon

THE LAGOON FRONT ESTATE, ALARO CITY, EPE.

PRICE GOES UP APRIL 1st‼️‼️�

The Lagoon front estate, Alaro City is set on the North side of the Lekki Lagoon located along Lekki-Epe expressway, Alaro City, Epe.

It is situated in a serene environment with a touch of nature and class.
It is also pocket- friendly and gives real value for money.

*Location: Opposite Alaro City, Epe.

*Title: Government Allocation /C of O

*Plot Sizes: (300 sqms & 500 sqms)

Outright Payment (0-3months)
500 sqms- 12.5M
300sqm- 7.5M

Initial deposit: 1m

Neighbourhood
- Lekki free trade zone
- Alaro city
- Epe resort
- Proposed International Airport.
- Seaport.
- Lekki phase 1.
- Ajah.

Highlights
- Perimeter fencing.
- Electricity.
- Estate gate house.
- Motorable and Accessible

Water front properties are the most expensive with Promising ROI...

The Ikoyi, Banana island are Clear Evidences��
You need to own a water front property

For Enquiries/ Site Visits:
Call/WhatsApp 09060720721

Price goes up soon! April 1st

DE CASTLE, AWOYAYA LEKKI-AJAH

De Castle is an Affordable Luxury Empire Designed mainly for kings and Queens who value Royal magnificent homes.

De castle is luxury Redefined sitting structurally on a large expanse of land specially designed to turn home into a place of comfort.

De Castle Awoyaya consist of both Semi-Detached Bungalows and Fully- Detached Bungalows.

Location: Oribanwa Bustop Awoyaya , 2min from Mayfair Gardens

Title: Gazette

HOUSE TYPES & PRICES:

3bedroom Semi-Detached Bungalow Castle

*LOutright Payment (0-6 months)

Classic Finish @25Million

Royal Finish @28Million

Initial Deposit: #10,000,000

Installmental Payment Plans Available

Outright Payment (0-6months)

3 Bedroom Fully Detached Castle Bungalow + BQ

Classic Finish @32million

Royal Finish @37million

Initial Deposit :#10,000,000

INFRASTRUCTURES
- Perimeter fencing.
- Estate Gate and Gate House.
- Road connectivity.So
- Electricity and Street Light.
- Off-street parking spot.
- High tech Security system.
- Visitors park and Green area.
- Guaranteed Maximum Security.
- Recreational centres.

NEIGHBORHOOD:
- Adiva Plainfield
- Lakowe Golf
- Mayfair gardens
- Corona school
- Greenspring schools
- Lufasi Nature Park
- Omu resort
- Fara park
- Novare mall Shoprite
- Peak Bungalows

De-Castle: The Signature of Affordable Luxury✍�

For further enquires!
Call/WhatsApp: 09060720721

OfficialR:
Thank you so much for the answers

You are welcome sir

OfficialR:
A compound G on heating gives a cracking sound, reddish brown fumes H, a gas J which rekindle/relight a glowing splint and a residue K. The residue K is reddish brown when hot and yellow when cold
i) Identify G, H, J and K
ii) What is the name given to the cracking sound?

Please answer urgently needed. Thank you.

G = Lead Nitrate, Pb(NO3)2

H = Nitrogen (IV) Oxide gas, NO2

J = Oxygen gas, O2

K = Lead Oxide, PbO

The cracking sound is called Decrepitation

Equation of reaction;
2Pb(NO3)2 + heat ==> 2PbO + 4NO2 + O2