Power BI · Data Analysis · Excel

Nigeria Presidential
Election Analysis

Elections Covered 2019 & 2023
Parties Analysed Top 4 per Election
Tool Power BI + Excel
Author Kehinde Odewabi
422M Total Population
177.5M Registered Voters
160M PVCs Collected
50M Top 4 Votes Cast
APC 2023 Winner

Understanding how Nigeria votes and what changed between 2019 and 2023

Nigeria is Africa's most populous country and one of its most complex democracies. Presidential elections here are not just contests between candidates, they are reflections of ethnic geography, regional loyalty, voter mobilisation, and shifting political winds across 36 states and the FCT.

This project analyses two consecutive presidential elections (2019 and 2023) using official data from INEC, population projections from the National Bureau of Statistics (NBS), and voter registration records. The focus is on the top 4 parties per election — the only parties for whom complete, verifiable state-level data is available.

The central questions: How did voter participation change? Who won where, and why? And what do the patterns suggest about 2027?

Where the data came from

This analysis draws from four primary official sources, supplemented with publicly available candidate biographies:

Note on party scope: This analysis covers the top 4 parties only — APC, PDP, PCP, ADC in 2019; and APC, PDP, LP, NNPP in 2023. Vote totals for other parties were either unavailable or incomplete at the state level and have been excluded to preserve analytical integrity.

Cleaning, structuring, and modelling the data

Raw election and demographic data was collected from multiple sources and required significant cleaning and restructuring before it could be loaded into Power BI. All preparation was done in Microsoft Excel and shaped further using Power Query (M language) within Power BI Desktop.

Data Model Overview

Main Table
🔑 Year, State, Zone
📊 Population, Registration
📊 PVC Collected/Uncollected
📊 APC, PDP, LP, NNPP votes
📊 Winner, Accredited Votes
Party Votes Table
🔑 Year, State, Party
📊 Votes
🔗 Joined from Main Table
Dim Party
🔑 Party
📊 Year, Full Name
📊 Candidate, Logo URL
Dim Year
🔑 Year (2019, 2023)
🔗 Filter table
Age
📊 Year
📊 Young Adults (18–50)
📊 Elderly (51–70)
📊 Old (70+)
Biography
📊 Party, Year, Candidate
📊 Biography text
📊 Image URLs

Key DAX Measures

The following are some of the DAX measures written to power the dashboard visuals and KPI cards:

DAX
-- Dynamically identifies the winning party per state/year
Winning Party =
VAR APCVotes = SUM('Main Table'[APC])
VAR PDPVotes = SUM('Main Table'[PDP])
VAR LPVotes  = SUM('Main Table'[LP])
VAR NNPPVotes = SUM('Main Table'[NNPP])
VAR MaxVotes = MAXX({APCVotes, PDPVotes, LPVotes, NNPPVotes}, [Value])
RETURN
SWITCH(TRUE(),
    APCVotes = MaxVotes, "APC",
    PDPVotes = MaxVotes, "PDP",
    LPVotes  = MaxVotes, "LP",
    NNPPVotes = MaxVotes, "NNPP"
)
DAX
-- Calculates the winning margin between top 2 parties
Winning Margin =
VAR PartyTable = ADDCOLUMNS(VALUES('Party Votes Table'[Party]),
    "TotalVotes", CALCULATE(SUM('Party Votes Table'[Votes])))
VAR TopTwo = TOPN(2, PartyTable, [TotalVotes], DESC)
VAR WinnerVotes   = MAXX(TopTwo, [TotalVotes])
VAR RunnerUpVotes = MINX(TopTwo, [TotalVotes])
RETURN
IF(COUNTROWS(TopTwo) < 2, BLANK(), WinnerVotes - RunnerUpVotes)
DAX
-- Uncollected PVC percentage
Uncollected PVC % =
DIVIDE(
    SUM('Main Table'[PVC Uncollected]),
    SUM('Main Table'[Total Reg.])
)

How the dashboard works

The Power BI dashboard is built across four pages — Overview, Participation, Party Analysis, and Demographics. Each page shares the same slicer panel, allowing you to slice the entire report by year, state, or zone simultaneously.

Slicers Available

Slicer 1
Year
Toggle between 2019 and 2023. Every visual, KPI card, and chart on the page updates instantly to reflect the selected election year.
2019 2023
Slicer 2
State
Filter all visuals down to a single state — or multi-select to compare groups. Available on Participation and Overview pages. Useful for drilling into a state's registration rate, party performance, and PVC collection.
37 options (36 states + FCT)
Slicer 3
Zone
Filter by Nigeria's six geopolitical zones. Selecting a zone narrows all visuals to only the states within it — revealing regional patterns in votes, registration, and PVC collection that state-level views might obscure.
N. West N. East N. Central S. West S. South S. East
Slicer 4 — Party Analysis Page
Party
On the Party Analysis page, selecting a party loads that candidate's biography, photo, total votes, states won, strongest state, and strongest zone — all dynamically. Works in combination with the Year slicer.
APC PDP LP NNPP
Cross-filtering is active: All slicers interact with each other. For example, selecting "South East" zone + "2023" year will filter every visual — votes per party, PVC collection, population vs registrants, candidate performance to show only South East states in 2023.

APC wins a fragmented election

The 2023 presidential election was the most competitive in Nigeria's recent democratic history. For the first time, a third-party candidate (Peter Obi of LP) won multiple states, and no party crossed 50% of the total votes cast across the top 4 parties.

8.8M
APC Total Votes

Bola Tinubu won with 8.8M votes, down significantly from Buhari's 15.2M in 2019, reflecting a more fragmented electorate.

47.95%
APC Share (Top 4)

APC held under 48% of the top-4-party vote share. The ruling party won, but without a dominant mandate.

1.8M
Winning Margin

APC beat PDP by approximately 1.8 million votes, smaller than the 2019 margin of 3.9M over PDP.

11.8%
Votes-to-Population Ratio

Only 11.8% of Nigeria's total population actually cast a vote, a stark illustration of the participation gap from registration to ballot.

2023 Vote Share (Top 4 Parties)

Percentages below are calculated as a share of the top 4 parties' combined votes (23.4M).

APC
47.95% — 8.8M
PDP
36.46% — 7.0M
LP
26.08% — 6.1M
NNPP
6.40% — 1.5M

2019 Vote Share (Top 4 Parties)

Percentages below are calculated as a share of the top 4 parties' combined votes (26.7M). The 2019 race was essentially a two-party contest as APC and PDP together held over 99% of the top 4 vote. PCP and ADC were included as the only other parties with complete verified state-level data, but their share was negligible.

APC
56.98% — 15.2M
PDP
42.25% — 11.3M
PCP
0.40% — 107K
ADC
0.37% — 98K
Note on PCP & ADC: Their combined share of just 0.77% of the top 4 vote confirms they had no meaningful impact on the 2019 outcome. They are included for completeness — these were the only other parties with full, verified state-level data. In 2023, they were replaced by LP and NNPP as credible third and fourth parties.

2019 Candidates at a Glance

Muhammadu Buhari
APC — Winner ✓
15.2M
Votes
56.98%
Top 4 Share
North West
Strongest Zone
Atiku Abubakar
PDP — 2nd Place
11.3M
Votes
42.25%
Top 4 Share
North East
Strongest Zone
Felix Nicolas
PCP — 3rd Place
107,286
Votes
0.40%
Top 4 Share
South West
Strongest Zone
Obadiah Mailafia
ADC — 4th Place
97,874
Votes
0.37%
Top 4 Share
South West
Strongest Zone

2023 Candidates at a Glance

Bola Tinubu
APC — Winner ✓
8.8M
Votes
12
States Won
South West
Strongest Zone
Atiku Abubakar
PDP — 2nd Place
7.0M
Votes
12
States Won
North East
Strongest Zone
Peter Obi
LP — 3rd Place
6.1M
Votes
12
States Won
South East
Strongest Zone
Rabiu Kwankwaso
NNPP — 4th Place
1.5M
Votes
1
State Won
North West
Strongest Zone

Geography still shapes voting patterns

The zonal vote data reveals how deeply regional the 2023 outcome was. North West delivered the most total votes. South East was almost entirely captured by LP. South West went to APC's home territory.

North West — 6.6M votes

APC2.65M (40%)
PDP2.33M (35%)
NNPP1.27M (19%)
🏆 APC — Most contested zone

North Central — 4.4M votes

APC1.76M (40%)
LP1.42M (32%)
PDP1.16M (26%)
🏆 APC — LP strongly competitive

South West — 4.1M votes

APC2.28M (56%)
PDP0.94M (23%)
LP0.85M (21%)
🏆 APC — Tinubu's home territory

North East — 3.4M votes

PDP1.74M (52%)
APC1.19M (35%)
LP0.32M (10%)
🏆 PDP — Atiku's stronghold

South South — 2.75M votes

LP1.21M (44%)
APC0.80M (29%)
PDP0.72M (26%)
🏆 LP — Peter Obi's wider reach

South East — 2.19M votes

LP1.96M (90%)
PDP0.09M (4%)
APC0.13M (6%)
🏆 LP — Near-complete sweep

The electorate shifted, so did the parties

Between 2019 and 2023, Nigeria's registered voter base grew substantially, yet total votes cast actually fell. This paradox tells an unignorable story about participation, trust, and the fragmentation of the political landscape.

Metric 2019 2023 Change
Registered Voters 84.0M 93.5M +11.3%
Total Votes Cast (Top 4) 26.7M 23.4M −12.4%
Winning Party APC (Buhari) APC (Tinubu) —
Winner's Votes 15.2M 8.8M −42%
Winner's Vote Share 56.9% 47.9% −9pp
2nd Place Party PDP — 11.3M PDP — 7.0M −38%
New Entrant — LP (6.1M) / NNPP (1.5M) 🆕 Significant
Young Adults Share of Registrants 81.1% 75.4% −5.7pp (absolute growth)
PVC Collection Rate (National) ~90.1% ~90.1% Stable
Key shift: 2023 was the first election where a third party candidate (Peter Obi, LP) matched the established parties in states won. LP claimed 12 states, equal to both APC and PDP — an unprecedented performance for a party outside the traditional duopoly.

Registration is rising. Turnout is not.

One of the most striking findings of this analysis is the persistent gap between how many Nigerians are registered to vote and how many actually do. Across both elections, only a fraction of eligible citizens translated registration into a ballot.

9.85%
Uncollected PVCs (National)

Nearly 1 in 10 registered voters did not collect their Permanent Voter Card in 2023 — a direct barrier to participation.

52.66%
Male Registrants

Men make up the slight majority of registered voters. Female registration (47.34%) has been growing election-over-election.

North West
Most Populous & Highest Voting Zone

North West dominates both population and total votes cast, driven largely by Kano State, Nigeria's most populous state.

75.4%
Young Adults (18–50) Share of Registrants

In 2023, three-quarters of all registered voters were young adults, confirming that youth demographic holds the democratic key to Nigeria's future.


What the data suggests about 2027

2027 Election Projection

Based on the trends observed across 2019 and 2023, and factoring in current political developments in Nigeria, the following patterns are likely to shape the 2027 contest:

🟢

APC remains the incumbent advantage, but Tinubu's government faces significant pressure from economic hardship, fuel subsidy removal fallout, and currency depreciation. A weakened APC could lose its North West stronghold if NNPP or PDP consolidates. His recent primary election win margin speaks volume though.

🔴

Labour Party Peter Obi's trajectory is uncertain. LP's 2023 performance (6.1M votes, 12 states) was remarkable for a party that barely existed nationally four years prior. If Peter Obi runs again or LP builds a national structure, it could become a genuine second-place force. Without that consolidation, the movement may fragment.

🔵

PDP must confront internal reform. Two consecutive presidential losses with the same candidate (Atiku Abubakar) and declining vote totals — signal that the party's traditional coalition is eroding. A new, younger candidate from the South could reinvigorate the party's competitiveness. Reports are suggesting Goodluck Jonathan may run, but nothing official yet

👥

Youth mobilisation is the wildcard. With 75%+ of registrants under 50 years old, whoever successfully energises the youth vote, as the Obidient movement showed is possible, will have a decisive advantage. BVAS improvements and IREV transparency are expected to increase voter confidence.

📍

South East remains the battleground to watch. LP's near-total sweep of the South East in 2023 (90%+ in the zone) was unprecedented. Whether this becomes a permanent political realignment or a one-election phenomenon depends heavily on Nigeria's federal resource distribution policy over the next 4 years. With Tinubu, Atiku, Kwankwaso, Obi, and Makinde all in the picture, the big question remains: will Nigeria witness another multi-way split in votes at the next election, or will some of the parties undergo coalition to weave a stronger force?

Prediction is based on observed data trends and publicly reported political developments. It represents analytical inference, not a definitive forecast.

Explore the full analysis

Access the interactive dashboard, download the dataset, or explore the source files below.

NOTE: The Live Interactive Dashboard can only be accessed by PowerBi service users (those who have an active PowerBi service account). Additionally, the interactive visuals can also be accessed by opening the PowerBi file (pbix) with Microsoft Power BI desktop app. Consequentially, a static dashboard/visual can be accessed by clicking on the latter link (Dashboard Export)-in PDF format.

More from this portfolio

Coffee Sales Performance Analysis
Power BI · Data Analysis · Kaggle Dataset
Power BI View →
BMW Used Cars
Exploratory Analysis; Price Anomalies • Depreciation • Transmission Trends • Ownership Cost
SQL View →
2025 Global Population
Data Cleaning and Exploratory Analysis
Excel View →

← Back to all projects