Oraclejoy/Nigeria-Post-Harvest-Analysis

An Excel dashboard analyzing post-harvest losses in Nigeria. Visualizes spoilage rates, revenue loss, transport impact, environmental factors, and crop trends. Designed to uncover insights and suggest data-driven solutions for reducing food waste in the agricultural value chain. 🇳🇬 Nigerian Post-Harvest Loss (PHL) Analysis Report 📌 Executive Summary This project analyzes Post-Harvest Loss (PHL) across Nigeria using regional, environmental, storage, logistics, and market data. Average PHL: 19.3% Most affected crop: Rice Lowest loss crop: Yam Most affected regions: North East, South West, North West Lowest average PHL recorded: 2024 (indicating gradual improvement) Despite training initiatives, PHL remains high, suggesting that training alone is insufficient. Technology adoption — especially hermetic bags — significantly reduces spoilage. However, cold storage paradoxically shows higher spoilage when environmental conditions are poorly controlled. Seasonality, humidity, temperature, and transport methods strongly influence spoilage and revenue loss. 📊 Dashboard Insights 1️⃣ Production & Spoilage Average PHL: 19.3% Top loss crop: Rice Lowest loss crop: Yam High-risk regions: North East, South West, North West Training impact: No significant reduction in PHL Technology impact: Hermetic bags → Lowest PHL% No technology → Highest PHL% Seasonality: Dry season records highest PHL% and revenue loss 2️⃣ Storage Methods Storage Method Performance ✅ Crates Lowest PHL% (Best) ⚠️ Cold Storage High spoilage if poorly managed ❌ Polyethylene Bags High spoilage ❌ Open Sheds High spoilage Recommendation: Use crates as the default storage solution. Cold storage should only be used when temperature and humidity are strictly controlled. 3️⃣ Logistics & Transport ✅ Best transport method: Trucks (lowest spoilage) ❌ Worst transport method: Boats (highest spoilage) Short distances still show high spoilage due to poor handling. Proper packaging and handling matter more than distance. 4️⃣ Market & Revenue Highest revenue loss crop: Pepper Highest market price crop: Pepper Lowest market price crop: Cassava Moderate market access surprisingly shows higher revenue loss than poor access. Market access alone does not significantly reduce …