Betnel/Kenya-Fiscal-Debt-Sustainability-Analysis

# 🇰🇪 Kenya Public Debt & Fiscal Sustainability Analytics Dashboard ## 📌 Project Overview This project delivers a comprehensive fiscal sustainability and sovereign debt analytics solution built using Python and Power BI. The analysis leverages historical fiscal datasets from the Central Bank of Kenya (CBK) to evaluate Kenya’s public debt trends, debt sustainability, revenue performance, expenditure structure, and fiscal risk exposure. The dashboard transforms raw fiscal data into executive-level insights capable of supporting: * Fiscal policy evaluation * Debt sustainability monitoring * Sovereign risk assessment * Public finance analysis * Treasury-style reporting --- # 🎯 Project Objectives The main objective of this project was to build an institutional-grade analytics dashboard capable of answering key fiscal questions such as: * How has Kenya’s public debt evolved over time? * What is the relationship between debt and government revenue? * Is debt growth accelerating faster than revenue growth? * How sustainable are Kenya’s fiscal operations? * What proportion of debt is domestic versus external? * How much revenue is consumed by interest payments? * What are the major expenditure components? * What fiscal risks are emerging over time? --- # 📂 Dataset Sources The project uses historical fiscal datasets sourced from the Central Bank of Kenya (CBK), including: * Public Debt Data * Domestic Debt Composition Data * Revenue & Expenditure Data The datasets contain: * Domestic debt * External debt * Treasury bills * Treasury bonds * Government stocks * Revenue and grants * Interest payments * Expenditure categories * Fiscal balances * Debt servicing indicators --- # 🛠️ Tools & Technologies Used | Tool | Purpose | | ---------------- | -------------------------------------- | | Python | Data cleaning & transformation | | Pandas | Data wrangling | | NumPy …