faithchuwang/urban-vs-rural-africa-analysis

Power BI dashboard analyzing income, expenditure, savings behavior, and financial stress across urban and rural African households. # Cost of Living & Financial Resilience: Urban vs Rural Africa ## Table of Contents - Project Overview - Project Objectives - Dataset Summary - Tools & Technologies - Data Cleaning Process - Dashboard Features - Key Insights - Dashboard Preview - Project Outcome - Author --- ## Project Overview This project explores household income, expenditure, savings behavior, and financial stress across urban and rural African communities using Power BI. The analysis was conducted as part of the Dataverse Africa Healthcare Data Analytics Internship icebreaker project. The goal was to uncover financial patterns, compare urban and rural households, and examine how digital financial access may influence savings behavior. --- ## Project Objectives - Compare average income and expenditure between urban and rural households - Analyze household spending patterns - Examine the relationship between mobile money access and savings behavior - Explore financial stress levels across households - Build an interactive Power BI dashboard for storytelling and insight communication --- ## Dataset Summary The dataset contains information from **5,786 households** across multiple African communities. ### Features Included #### Demographics - Country - Household Size - Age - Gender - Education - Occupation #### Financial Indicators - Monthly Income - Food Expenditure - Rent Expenditure - Transport Expenditure - Utilities - Savings Rate - Monthly Savings #### Access Indicators - Mobile Money Access - Healthcare Access - School Access #### Derived Metrics - Percent Income Spent on Essentials - Financial Stress Index --- ## Tools & Technologies - Power BI - Power Query - DAX - CSV Dataset --- ## Data Cleaning Process The dataset was cleaned and transformed in Power BI using Power Query. ### Cleaning Steps - Checked and corrected data types - Removed missing or invalid values - Validated savings and stress index ranges - Reviewed outliers and logical inconsistencies - Standardized num …