mumocollins001-cloud/kenya-fiscal-and-debt-analysis

Fiscal sustainability and public debt analysis of Kenya using Python and Power BI. # kenya-fiscal-and-debt-analysis Fiscal sustainability and public debt analysis of Kenya using Python and Power BI. # Kenya Fiscal and Debt Analysis Dashboard ## Project Overview This project analyzes Kenya's fiscal performance and public debt trends using data from the Kenya National Bureau of Statistics (KNBS) and the World Bank. The objective was to examine the relationship between public debt, fiscal deficits, government revenue, government expenditure, and economic growth between 2019 and 2024. Python was used for data extraction, cleaning, transformation, and dataset integration, while Power BI was used to develop an executive dashboard. --- ## Data Sources ### Kenya National Bureau of Statistics (KNBS) * Chapter 5: Public Finance * Table 5.2: Analysis of Key Fiscal Ratios * Table 5.10: National Government Debt Statistics ### World Bank * GDP Growth (Annual %) * Indicator: NY.GDP.MKTP.KD.ZG --- ## Tools Used * Python * Pandas * Power BI * Excel --- ## Key Metrics * Public Debt Stock * External Debt * Domestic Debt * GDP Growth Rate * Fiscal Deficit (% GDP) * Revenue (% GDP) * Government Expenditure (% GDP) --- ## Key Findings * Kenya's public debt increased from KSh 5.14 trillion in 2019 to KSh 9.96 trillion in 2024. * Government expenditure consistently exceeded revenue, resulting in persistent fiscal deficits. * GDP growth recovered after the 2020 slowdown but debt continued to increase throughout the period. * Both domestic and external borrowing contributed to the growth of public debt. --- ## Dashboard Preview --- ## Project Structure ```text data/ python_scripts/ outputs/ dashboard/ images/ README.md ``` ## LinkedIn Post A summary of this project was shared on LinkedIn: [[LinkedIn Post URL]](linkedin.com) ## Author Joseph Mumo