Amimu-1/nigeria-macro-intelligence-dashboard

"End-to-end macroeconomic analytics platform using CBN and NBS data — Python ETL, SQLite, Power BI, policy analysis" # Nigeria Macroeconomic Intelligence Dashboard **An end-to-end macroeconomic analytics platform built on real CBN and NBS data — engineered for policy analysis, economic research, and evidence-based decision-making.** ## Overview Nigeria's macroeconomic data is publicly available — but it is scattered, inconsistently formatted, and rarely analyzed rigorously in one place. This project builds a production-grade pipeline that ingests real Central Bank of Nigeria (CBN) and National Bureau of Statistics (NBS) data, cleans it to analysis-ready standards, structures it in a relational database, surfaces policy-relevant insights through a fully interactive Power BI dashboard, and translates those findings into a formal policy brief — the kind of end-to-end work expected at institutions like the CBN, World Bank, PenCom, and ECOWAS. This is not a toy dataset exercise. Every number in this project traces back to an official, verifiable public source. ## Dashboard Preview ### Overview ### Inflation & Prices ### Exchange Rates & Reserves ### Interest Rates & Money Supply ### Banking Sector Health ## What Makes This Different - **Real government data, not sample datasets** — sourced directly from CBN's rate exports, CBN's Statistical Bulletins, and NBS's Nigeria Data Portal - **Cross-source validation** — CBN and NBS both report inflation; this project surfaces and investigates where they diverge (e.g., a 2025 CPI rebasing to 2024=100 creates a measurable gap between sources — exactly the kind of nuance a policy analyst should catch, not smooth over) - **Transparent handling of real-world data limitations** — the exchange rate series required merging two structurally different CBN rate regimes (a historical official rate and the newer NFEM rate) at a documented transition point; MPR, money supply, and banking sector ratios are reported at annual granularity in CBN's own bulletins, and this project preserves that true resolution rather than fabricating false …