Frita123/Forecasting-Financial-Inclusion-in-Ethiopia

Ethiopia Financial Inclusion Analytics Dashboard Tasks 1–5 | Data Engineering, Analysis, Forecasting & Visualization 📌 Project Overview This project analyzes financial inclusion trends in Ethiopia, focusing on account ownership and digital payment adoption. Using historical data, event annotations, and forecasting models, the project delivers an interactive dashboard that enables stakeholders to: Explore historical trends Understand policy and market event impacts Compare scenarios and forecasts Track progress toward a 60% financial inclusion target The project is structured and implemented across five progressive tasks, from data preparation to dashboard deployment. ✅ Task 1: Data Collection & Preparation Objective Collect, clean, and unify financial inclusion datasets into a single, analysis-ready format. Key Activities Imported raw datasets on: Account ownership Digital payments / mobile money usage Standardized column names and formats Converted fiscal year formats (e.g., FY2022/23 → 2022) Created numeric indicator values Saved unified dataset to: data/processed/ethiopia_fi_unified_data.csv Output ✔ Clean, structured dataset suitable for analysis and forecasting 📊 Task 2: Exploratory Data Analysis (EDA) & Event Impact Objective Explore trends and understand how major policy, telecom, and financial events influenced financial inclusion. Key Activities Time-series analysis of: Account ownership Digital payment usage Event annotation (e.g., mobile money expansion, telecom competition) Correlation analysis between indicators Visual identification of growth accelerations Key Insight Digital payment adoption has grown faster than account ownership, indicating that usage growth outpaces access expansion. 🔮 Task 3: Forecasting & Scenario Analysis Objective Forecast financial inclusion trends under multiple future scenarios. Models Used Trend-based forecasting (baseline) Scenario adjustments: Optimistic Base Pessimistic Forecast H …