CollectSurveyCTO
Field officers submit through 9 offline-capable forms across all 38 counties, GPS-tagged and validated.
How it works
From the field to the dashboard, automatically
A modern data platform built on open standards (TypeScript, Postgres, dbt) and integrated with the institutional tooling Heifer already uses: SurveyCTO, Power BI, and IPMS.
IngestFastify webhook
A single endpoint validates every submission against its form definition; issues are flagged, never dropped.
TransformPostgreSQL · dbt
JSONB raw → typed staging → P4C star-schema mart, refreshed by dbt every ~15 minutes.
VisualizePower BI · IPMS
Power BI Direct Query dashboards for staff and leadership, secured by per-county row-level access.
A continuous loop: insights from the dashboards feed the next round of field collection.
TypeScript Fastify PostgreSQL Drizzle ORM dbt Core React + Vite Power BI Docker · Azure
Get started
Ready to see field reality in real time?
Log in to the console to monitor submissions, data quality, and pipeline runs, or get in touch with the MEL team.