PhilipKatema/Malawi-Agric-Trade-Data-Mining

This project applies a multi-technique data analytics pipeline - built entirely in KNIME Analytics Platform - to 38 years of FAOSTAT trade data (1986–2024), covering all recorded export transactions between Malawi and its global trading partners. # 🌍 Malawi Trade Intelligence ### Export Analysis · 1986-2024 · FAOSTAT > A 38-year longitudinal analysis of Malawi's agricultural export economy - covering trade concentration, partner and commodity clustering, year-over-year growth dynamics, rolling volatility, and a 5-year linear regression forecast - built end-to-end in KNIME Analytics Platform. \--- ## 📊 Live Dashboard **→ View Interactive Dashboard** Open in any browser. Includes: * Commodity \& partner concentration donut charts * Year-over-year growth line chart (1987-2024) * Tobacco export forecast through 2029 * Rolling volatility table (Belgium, 3-year window) \--- ## 🔍 Key Findings |Finding|Detail| |-|-| |**Commodity Concentration**|Unmanufactured tobacco = **67.4%** of total export value| |**Partner Concentration**|Belgium = **23.7%** of total export value| |**Peak Export Year**|2010 - tobacco exports reached \~**$875M**| |**Declining Volatility**|Belgium 3-yr std. dev. fell from $71M (2009) → $7.7M (2023)| |**2029 Forecast**|Linear regression projects tobacco exports at \~**$690M**| \--- ## 🏗️ Project Structure ``` malawi-trade-intelligence/ │ ├── README.md ← You are here │ ├── data/ │ ├── README\_data.md ← Data source info \& download instructions│ ├── workflow/ │ ├── README\_workflow.md ← KNIME workflow documentation │ └── FAO\_V2.knwf ← KNIME workflow export (place here) │ ├── outputs/ │ ├── top\_10\_products\_chart.png │ ├── top\_10\_products\_table.png │ ├── top\_10\_partners\_chart.png │ ├── top\_10\_partners\_table.png │ ├── yoy\_growth\_chart.png │ ├── yoy\_growth\_table.png │ ├── rolling\_volatility\_belgium.png │ ├── regression\_forecast\_chart.png │ └── regression\_forecast\_table.png ││ └── docs/ └── Malawi\_Trade\_Intelligence\_Case\_Study.pdf ← Full case study PDF ``` \--- ## 🛠️ Tools \& Methods |Tool / Method|Role| |-|-| |**KNIME Analytics Platform**|End-to-end pipeline: ingest …