webmastrick/food-security-benin-dashboard

Interactive Power BI dashboard monitoring food insecurity across 12 departments in Benin (2020-2023) — built for NGOs and development agencies. # 🌾 Food Security Monitoring Dashboard — Benin (2020–2023) > An interactive Power BI dashboard tracking food insecurity, malnutrition, and agricultural production across the 12 departments of Benin — built to support evidence-based decision-making for NGOs, public health organizations, and development agencies. --- ## 📊 Dashboard Preview --- ## 🎯 Project Objective Food insecurity remains a critical challenge in West Africa. This project provides a **clear, visual, and interactive monitoring tool** that allows decision-makers to: - Track food insecurity rates by department and season - Compare the North (more vulnerable) vs. South/Centre regions - Analyze the relationship between agricultural production and food insecurity - Monitor malnutrition trends from 2020 to 2023 --- ## 🔍 Key Findings | Indicator | Value | |---|---| | Average food insecurity rate | **~27%** | | Average malnutrition rate | **~16%** | | Total households surveyed | **~3 million** | | Most affected region | **North (Atacora, Alibori, Donga)** | | Trend | North remains stable at ~36% — urgent intervention needed | **Main insight:** Departments with higher agricultural production (>1,400 kt) consistently show lower food insecurity rates — confirming that supporting local agriculture directly reduces vulnerability. --- ## 🛠️ Tools & Methodology | Step | Tool | |---|---| | Data simulation | Python (random, csv) | | Data cleaning & transformation | Power Query (Power BI) | | Data modeling | DAX measures | | Visualization | Power BI Desktop | **Data source:** Simulated dataset modeled after FAO/WFP methodology for food security assessments in West Africa. Dataset structure mirrors real-world IPC (Integrated Food Security Phase Classification) surveys. --- ## 📁 Repository Structure ``` ├── securite_alimentaire_benin.csv # Dataset (96 rows, 9 variables) ├── dashboard_preview.png # Dashboard screenshot └── README.md # Project documentation ``` - …