ACIOE Associates
FGN Fiscal Performance Dashboard
Fourteen years of federal fiscal data, made queryable for policy analysts.
F
The Problem
ACIOE's policy team needed to reason about Nigeria's federal revenue and expenditure trends across a 14-year span, but the underlying CBN data existed as static, disconnected figures with no way to drill into year-over-year or oil vs. non-oil dynamics.
The Approach
An interactive Power BI dashboard analyzing Federal Government of Nigeria revenue and expenditure performance from 2010-2024, covering fourteen years of CBN data with drill-down by fiscal year, quarter, and month.
- Revenue trend analysis with year-over-year growth: NGN137.88T gross revenue (NGN81.90T oil, NGN55.98T non-oil)
- Expenditure breakdown: NGN123.94T gross (NGN99.05T recurrent, NGN24.89T capital) against a NGN66.02T fiscal deficit
- Interactive drill-down by fiscal year, quarter, and month
- Built on 14 years of CBN data (2010-2024)
The Outcome
Gives ACIOE's policy analysts a production-ready tool to generate data-backed fiscal analysis and support government advisory work, replacing static spreadsheet reporting.