A Power BI dashboard that brings soil, weather and yield forecasts together for Ghanaian farmers and the people who support them.
Cocoa, cashew and coffee farmers in Ghana make planting and harvest decisions with little soil, weather or yield data, and the organisations that support them can’t easily see who they are reaching. What would one dashboard for both groups look like?
I modelled farmers, plots, soil readings, weather and harvests in Excel and built a Power BI dashboard on top. It has four views: farmer distribution and engagement, soil and weather conditions, predicted versus actual yield, and regional comparisons.
It is designed around USSD requests, so farmers can get their information on any basic phone.
A working prototype on simulated data that shows how one dashboard can serve farmers and their support agencies at once. The Power BI file and dataset are on GitHub.