dez-data/ghana-agriculture-analysis

Power BI dashboards and Python statistical analysis of Ghana's agricultural sector, demonstrating data visualization, correlation and regression modelling, and policy research skills developed during Amalitech Ghana internship. # Ghana Agriculture Sector Analysis ### Power BI Dashboards + Python Statistical Validation | Amalitech Ghana Internship **63 years of agricultural data (1961-2023)** analyzed for government policy recommendations during Data Analytics Internship at Amalitech Ghana. --- ## Live Power BI Reports Access the interactive dashboards online: | Dashboard | Description | Live Report Link | |-----------|-------------|------------------| | **Production & Area Trends** | Production volumes, area harvested, yield analysis across 4 crops | View Report | | **Export Trends** | Cocoa export volumes, revenue, and price trends (1991-2023) | View Report | | **GDP Contribution** | Agriculture and cocoa contribution to Ghana's GDP (2006-2024) | View Report | --- ## Dashboard Screenshots ### Dashboard 1: Production & Area Trends *Live Report* #### Page 1: Production Volumes Production trends for Cocoa, Maize, Rice, and Yam (1961-2023) #### Page 2: Area Harvested Land allocation trends showing cocoa stagnation vs. food crop expansion #### Page 3: Yield Per Hectare Productivity improvements across all four crops over 63 years #### Page 4: Production vs Area vs Yield Comparison Three-panel comparative analysis showing relationships between metrics **Key Visual Findings:** | Finding | Implication | |---------|-------------| | Maize, Rice, Yam show dramatic upward production trends | Food security crops expanding rapidly | | Cocoa production more volatile and slower growing | Export crop facing structural challenges | | **Cocoa area harvested virtually flat (r=0.16)** | **Cannot grow production through land expansion** | | Maize, Rice, Yam area expanding dramatically (r>0.85) | Land allocation shifting toward food crops | --- ### Dashboard 2: Export Trends *Live Report* #### Page 1: Export Volume, Revenue & Price Trends Year-over-year analysis with interactive year slicer (1991-2023) #### Page 2: Expor …