kenobech/HumanitarianFunding

This repository analyses NGO funding to Kenya # HumanitarianFunding ## License and Contributions This project is licensed under the MIT License. Contributions are welcome! See the Contributions section for details. ## Table of Contents 1. Introduction 2. Datasets 3. SQL Analyses 4. Features 5. Getting Started - Prerequisites - Setup 6. Git Workflow 7. Examples 8. Observations and Insights 9. Contributions 10. License ## Introduction Welcome to the Humanitarian Funding Analysis repository! This project focuses on analyzing NGO funding data for Kenya, including funding requirements, allocations, Covid funding, organizations funded, donors, gaps across various sectors and years, etc. By leveraging SQL and visualization tools, users can gain insights into funding trends, gaps, and donor contributions. ## Datasets The project utilizes publicly available datasets related to humanitarian funding in Kenya. These datasets include: - **fts_requirements_funding_cluster_ken.csv**: Funding requirements and allocations by cluster. - **fts_requirements_funding_globalcluster_ken.csv**: Global cluster-level funding data. - **fts_requirements_funding_covid_ken.csv**: COVID-19-related funding data. - **fts_incoming_funding_ken.csv**: Incoming funding contributions. - **fts_requirements_funding_ken.csv**: Allocations per sector in Kenya ## SQL Analyses This project includes a variety of SQL queries to analyze the funding data. Below are some key analyses performed: 1. **Funding Trends**: - Analyze total funding by year. - Identify funding gaps across clusters and sectors. 2. **Donor Contributions**: - Identify top donors and their contributions. - Analyze funding by donor organization types. 3. **COVID-19 Funding**: - Calculate the percentage of funding allocated to COVID-19-related efforts. - Compare COVID-19 funding to overall funding. 4. **Sectoral Analysis**: - Analyze funding distribution across sectors like health, education, and food security. ## Features - **Joins**: Combine data from multiple tables for comprehensiv …