Ayodeji-Analyst/-economic-development-Analysis

Interactive Power BI dashboard analyzing World Development Indicators (2015–2024) across selected Sub-Saharan African countries using Power Query and DAX. # -economic-development-Analysis Interactive Power BI dashboard analyzing World Development Indicators (2015–2024) across selected Sub-Saharan African countries using Power Query and DAX. 🌍 World Development Indicators Dashboard 📖 Overview This project is an interactive Power BI dashboard developed using the World Development Indicators (WDI) dataset from the World Bank. The dashboard provides insights into economic, social, and environmental development trends across selected Sub-Saharan African countries** between 2015 and 2024. 🎯 Project Objectives - 📈 Analyze GDP trends over time. - 💰 Compare GDP per Capita across countries. - ❤️ Evaluate Life Expectancy. - 🌐 Explore Internet Usage Growth. - ⚡ Compare Access to Electricity. - 🌱 Analyze Carbon Dioxide (CO₂) Emissions. - 📊 Monitor Inflation trends. 📊 Dashboard Features ✅ KPI Cards - 💰 Total GDP - 💵 GDP per Capita - ❤️ Average Life Expectancy - 🌐 Average Internet Users - 📈 Average Inflation 📈 Visualizations - 📉 GDP Trend by Year - 📊 GDP per Capita by Country - ❤️ Life Expectancy Trend - 🌐 Internet Users Growth - ⚡ Electricity Access by Country - 🌱 CO₂ Emissions by Country - 🗺️ Population Map - 🎛️ Interactive Year & Country Filters 🛠️ Data Preparation The dataset was transformed using Power Query by: - ✅ Filtering selected countries - ✅ Filtering years (2015–2025) - ✅ Selecting relevant indicators - ✅ Unpivoting yearly columns - ✅ Changing data types - ✅ Renaming columns - ✅ Creating DAX measures 🧰 Tools Used - 📊 Microsoft Power BI - ⚙️ Power Query - 📐 DAX - 📄 Microsoft Excel 📂 Dataset **Source:** World Bank – World Development Indicators (WDI) Indicators Used - 💰 GDP (Current US$) - 💵 GDP per Capita - ❤️ Life Expectancy - 🌐 Internet Users - 📈 Inflation - ⚡ Access to Electricity - 🌱 CO₂ Emissions 🔍 Key Insights - 📈 GDP trends vary across the selected countries. - 💵 Ghana records a higher GDP per Capita than Nigeria. - ❤️ Life Expectancy improved throughout the analysis period. - 🌐 Intern …