lu-sketch/South-African-Agriculture-Exports---Trends-over-the-last-30-years

Excel dashboard depicting agricultural export trends over the last 30 years # 🇿🇦 **South African Agriculture Exports: Trends Over the Last 30 Years** --- --- ## 📁 Project Overview This project presents an **interactive Excel dashboard** analysing South Africa's major **agricultural crop exports** over a 30-year period, based on data sourced from the **FAO Data Bank**. 🔗 **View the dashboard:** 📈 Excel Dashboard 📝 **Read the full report:** 📄 Project Report --- ## 🔧 Process & Tools Used The data preparation and analysis were carried out in **Microsoft Excel**, with the following steps: - 🧹 **Data Cleaning** using functions such as `TRIM`, `TEXT`, `IF`, and `AND` - 📊 **Pivot Tables** for: - Export volumes per crop - Export value (ZAR) per crop - Export trends over time --- ## 🎯 Outcomes & Use Cases This dashboard offers valuable insights for: - 🌱 **Farmers** – to guide decisions on what crops to cultivate based on export demand - 🏭 **Agri-business stakeholders** – for economic and trade planning - 📈 Understanding long-term export trends by crop and value --- ## ✨ Highlights - 30 years of historical export data - Visual trends and comparisons - Clean, user-friendly dashboard design - Practical for **decision-making** in the agriculture value chain --- ### 👩‍💻 Created by: **Lucille Jordaan** | 2025 ---