PatienceKeter/Macroeconomic-Intelligence-Dashboard-on-Africa-s-Frontier-Economies-2021-2025-
Domain:
socioeconomicCreator:
Pat
Host:
A macroeconomic dashboard analyzing growth dynamics, monetary policy stance, and external vulnerability across selected African frontier economies using World Bank and IMF data.
# Macroeconomic-Intelligence-Dashboard-on-Africa-s-Frontier-Economies-2021-2025
## Overview
This is an interactive macroeconomic dashboard analyzing six African frontier economies — Kenya, Egypt, Ethiopia, Nigeria, Rwanda, and South Africa.
Using World Bank and IMF data, the dashboard evaluates growth performance, monetary policy credibility, external sector stability, and debt sustainability. The objective is to assess macroeconomic resilience through an integrated analytical framework rather than isolated indicators.
---
## Key Performance Indicators (KPIs)
The dashboard tracks and computes the following KPIs using DAX measures:
- Real Gross Domestic Product (GDP)
- GDP Growth Rate
- GDP Per Capita
- Population Growth Rate
- Unemployment Rate
- Real Exchange Rate
- Trade Balance
- Exports (% of GDP)
- Imports (% of GDP)
- Inflation Rate
- Real Interest Rate
- Money Supply (% of GDP)
- Monetary Policy Stance
- Monetary Policy Effectiveness Ratio
- Inflation Volatility
- Current Account Balance
- Foreign Exchange Reserves (Import Cover)
- Public Debt (% of GDP)
---
## Dimensional Analysis
The data model follows a structured star schema approach to ensure clean aggregation and scalable analytics:
- **Fact Table:** Macroeconomic indicators
- **Dimension Tables:** Country, Year, Indicator
Dynamic filtering is enabled across:
- Country
- Year
- Indicator Category
- Macroeconomic Themes (Growth, Monetary, External, Debt)
This structure ensures accurate DAX-driven KPI calculations and reliable cross-country comparisons.
---
## Key Insights
- Growth performance varies significantly across economies, with external imbalances constraining sustainability in some cases.
- Persistent trade deficits and exchange rate depreciation amplify inflationary pressures.
- Real interest rates provide a more accurate signal of monetary stance than nominal rates.
- Inflation volatility reveals differences in policy credibility.
- Rising public debt combined with low reserve b …