tebogosocks88-ui/Botswana-Macroeconomic-Dashboard

An automated Python data-cleaning pipeline and interactive Plotly dashboard analyzing Botswana's government expenditure, inflation metrics, interest rates, and exchange rate trends from 2014 to 2026 using official Bank of Botswana data registries. Botswana Macroeconomic Dashboard Overview This project analyzes key macroeconomic indicators for Botswana using official data from the Bank of Botswana Economic and Financial Statistics (May 2026). The dashboard focuses on government expenditure, inflation, interest rates, and exchange rates to provide insights into Botswana’s fiscal and monetary environment. Indicators Analyzed - Government Expenditure (Table 1.1) - Inflation Rate (Table 2.3) - Bank Rate / Interest Rates (Table 4.1) - Exchange Rates (Table 6.10) Features - Data cleaning and preprocessing of official Bank of Botswana datasets - Trend analysis of macroeconomic indicators - Professional visualizations using Matplotlib - Summary statistics and economic insights Tools Used - Python - Pandas - Matplotlib - Jupyter Notebook - Visual Studio Code Data Source Bank of Botswana – Economic and Financial Statistics (May 2026) Author Tebogo Socks Finance & Banking Student | Data Analytics with Python ## Project Visualizations