Chundi21/Nigeria-2026-Federal-Budget-Dashboard

# Nigeria 2026 Federal Budget Dashboard This is an interactive 4-page Power BI report analyzing ₦51.59 trillion in Nigeria's 2026 federal budget allocations across 56 Ministries, Departments, and Agencies (MDAs), with drill-down by sector, ministry, and individual budget line item. ## Overview Nigeria's federal budget is public data, but in its raw form, it is a document most citizens, journalists, and policymakers struggle to interrogate meaningfully. This project transforms the 2026 appropriation data into a navigable Power BI dashboard that makes sector priorities, ministry-level allocations, and line item breakdowns immediately legible. The analysis covers three critical sectors in depth: the Security, Healthcare, and Education sectors, alongside a general overview of the full ₦51.59 trillion envelope. ## Objectives - Source and structure Nigeria's 2026 federal budget appropriation data - Build a 4-page Power BI report with consistent navigation and drill-down across MDAs - Surface allocation priorities, sector shares, and capital vs recurrent breakdowns - Produce a dashboard that a policy analyst, journalist, or civil servant could navigate without training ## Tech Stack | Microsoft Power BI | Dashboard development | | Power Query (M) | Data cleaning and transformation | | DAX | Measures and calculated columns | | Excel / CSV | Source data preparation | ## Data - **Source:** Nigeria 2026 Federal Appropriation Bill (publicly available) - **Total Budget:** ₦51.59 trillion - **Coverage:** 56 MDAs - **Sectors analyzed:** Security, Healthcare, Education, General Overview ## Dashboard Structure **Page 1 — General Overview** - Total budget: ₦51.59 trillion - Recurrent vs Capital expenditure split - Top 10 MDAs by allocation - Sector share of total budget **Page 2 — Security Sector** - Total security allocation and share of the national budget - Breakdown across defence, police, intelligence, and paramilitary MDAs - Capital vs recurrent split within securit …