Data Visualization
National Fertilizer Dashboard for Ministry Partners
Subsidy debates were gridlocked by incompatible spreadsheets. We built a single source of truth with explicit lineage from customs declarations to farm-gate price monitors.
Challenge
Fragmented administrative data made it difficult to align subsidy rules with soil health goals and fiscal ceilings.
Solution
Harmonized customs, retail, and farm survey microdata into a reproducible pipeline with scenario tools for policy teams.
Result
Quarterly briefings adopted by ministry technical units and transparent assumptions for donor coordination.
Overview
Subsidy debates were gridlocked by incompatible spreadsheets. We built a single source of truth with explicit lineage from customs declarations to farm-gate price monitors.
Methodology
- Entity resolution across dealer registries; documented ETL with signed-off business rules; scenario sliders for subsidy rate and fiscal cap.
- User testing cycles with directorate staff who would refresh the dashboard each quarter.
Outcomes
- Production dashboard with role-based views for treasury vs agronomy units.
- Donor coordination memo referencing shared scenario assumptions.
Partners
- IFDC FERARI
- Ministry of Food and Agriculture (Ghana)