Harvest Index — Global Food Supply Volatility

Multi-table FAO dataset analysis identifying which regions face the highest food supply volatility relative to domestic production — using SQL for modelling and Tableau for geographic storytelling.

Global food supply data exists across dozens of FAO datasets but is rarely analysed in combination. This project joins crop yield, food supply, and trade dependency tables across 180+ countries using PostgreSQL, then applies time series and volatility analysis to surface which regions are most exposed to supply shocks. A Tableau dashboard with choropleth maps and trend lines translates the findings into a clear geographic narrative — answering which countries are most production-dependent versus trade-dependent for their core food supply.