Data Analysis Capstone Project using Power BI to evaluate agricultural waste management and circular economy opportunities across selected African countries.
# Advancing Circular Economy Practices in Agricultural Waste Management Across Selected African Countries
## Data Analysis Capstone Project
### Project Overview
This project applies data analytics and visualization techniques to evaluate agricultural waste generation, post-harvest food loss, and socioeconomic indicators across selected African countries. The objective is to identify circular economy opportunities that can promote sustainable development, green job creation, environmental sustainability, and evidence-based policymaking.
The project culminates in an interactive Power BI dashboard that transforms multiple datasets into actionable insights for policymakers, investors, researchers, and development organizations. :contentReference[oaicite:0]{index=0}
---
## Project Objectives
The project aims to:
- Quantify agricultural waste and post-harvest food loss by country and crop.
- Integrate socioeconomic indicators such as unemployment, poverty, and greenhouse gas emissions.
- Identify regions with high potential for circular economy investments.
- Present findings through an interactive Power BI dashboard for decision support. :contentReference[oaicite:1]{index=1}
---
## Geographic Coverage
### Original Study Scope
- Kenya
- Nigeria
- Cameroon
- South Africa
- Rwanda :contentReference[oaicite:2]{index=2}
### Final Dashboard Coverage
The completed dashboard was expanded to include:
- Botswana
- Cameroon
- Democratic Republic of Congo
- Ghana
- Kenya
- Nigeria
- Rwanda
- South Africa
The analysis spans **22 years** of data across these eight countries. :contentReference[oaicite:3]{index=3}
---
## Data Sources
The project integrates data from multiple reputable sources, including:
- FAOSTAT
- World Bank
- ILOSTAT
- United Nations Environment Programme (UNEP)
- National Statistical Agencies :contentReference[oaicite:4]{index=4}
---
## Tools and Technologies
- Microsoft Excel
- …