Donlee000/Ada-social-impact-analysis

Data analysis project exploring ADA’s social and financial performance across African microfinance institutions (2020–2024). Includes data cleaning, exploratory analysis, 25 analytical queries (Python/R), portfolio trends, loan performance metrics, cohort retention, risk detection, and visualization-ready datasets for Power BI / Tableau. ### 📊 ADA Social Impact Analysis (2020–2024) A full data analytics project exploring social and financial performance across African microfinance institutions. #### 🌍 Project Overview This project analyzes ADA-supported microfinance institutions operating across Africa from 2020 to 2024. The goal is to evaluate both social impact and financial performance, identify patterns, and generate insights that support decision-making for development finance. The analysis includes: Social impact scoring Loan portfolio evolution Interest rate patterns Industry performance trends Risk and anomaly detection Cohort retention modeling Country-level financial behavior Year-over-year (YoY) growth and decline Power BI / Tableau–ready outputs This repository contains Python + R scripts, cleaned datasets, and documentation demonstrating strong capabilities in data wrangling, analytics, modeling, and visualization. #### 🗂️ Repository Structure ada-social-impact-analysis/ │ ├── data/ │ ├── ada_social_impact_2020_2024_clean.xlsx # Clean master dataset │ └── raw/ # Optional: original data sources ├── notebooks/ │ ├── analysis_python.ipynb # 25 analysis queries in Python │ └── analysis_rstudio.R # 25 analysis queries in R │ ├── scripts/ │ ├── data_cleaning.py # Data cleaning workflow │ ├── eda_analysis.py # Exploratory data analysis │ └── model_risk_detection.py # IsolationForest + risk scripts │ ├── outputs/ │ ├── country_monthly_loans.xlsx # Aggregated results │ ├── top_outliers.csv # Anomaly detection results │ ├── cohort_retention.csv # Cohort retention summary │ └── rolling_90_day_trends.csv # Trend data for visualization │ ├── visuals/ │ ├── loan_trends.png │ ├── yoy_country_changes.png │ └── cohort_retention_heatmap.png │ └── …