breechirchir/east-africa-infrastructure-tracker

Power BI dashboard analysing private infrastructure investment across East Africa using World Bank PPI data (2000-2024) # East Africa Infrastructure Investment Tracker Power BI dashboard analysing private infrastructure investment across East Africa using World Bank PPI data (2000-2024) ## Overview A 3-page Power BI dashboard analysing private participation in infrastructure investment across Kenya, Ethiopia, Rwanda, Uganda, and Tanzania from 2000 to 2024. ## Data Sources - World Bank PPI Database (ppi.worldbank.org) - World Bank World Development Indicators (databank.worldbank.org) ## Tools Used - Microsoft Power BI Desktop - Microsoft Excel - DAX - Power Query (data cleaning and transformation) ## Dashboard Pages 1. Executive Summary - portfolio overview, KPIs, trends 2. Country Deep Dive - country-level analysis with interactive filtering 3. Sector Analysis - Energy vs Transport comparison with heat map matrix ## Key Insights → Energy dominates private infrastructure investment across the region - Transport lags significantly behind despite being the sector with the most visible public need → Distressed projects are not evenly distributed - some countries carry significantly more investment risk than others ## Live Dashboard app.powerbi.com ## Author Brenda Chirchir