Real-time ingestion
SurveyCTO field submissions stream into a generic webhook the moment they hit the network — no polling, no batch lag.
An end-to-end Monitoring, Evaluation, and Learning platform tracking Heifer's Pathways for Change (P4C) program across 9 Kenyan counties and 4 agricultural value chains — from SurveyCTO field collection to real-time Power BI dashboards.
Built for Heifer Kenya's Pathways for Change program, the platform automates monitoring, evaluation, and learning end-to-end — so MEL staff and program managers see field reality, not last month's spreadsheet.
SurveyCTO field submissions stream into a generic webhook the moment they hit the network — no polling, no batch lag.
Raw payloads are stored as JSONB. dbt extracts typed staging tables and shapes a star-schema mart. New forms add zero server code.
A reporting mart aligned to the P4C results framework — five result areas, GI + PSI indicators, mapped to SDG codes.
Power BI Direct Query, role-based access by county, embedded in IPMS Insights for program managers and senior leadership.
Operating across Western, Rift Valley, and parts of Northern and Southern Kenya — supporting smallholder producer organizations, FOABs, and the households they serve.
Coverage spans Bungoma, Busia, Kakamega, Trans-Nzoia, Uasin Gishu, and Nandi in the west; Nakuru in the Rift; Kajiado in the south; and Isiolo in the north.
Five P4C result areas drive measurement: producer-org sustainability, household nutrition, income, environmental sustainability, and inclusive value chains.
Targets set during Heifer Kenya's program design, with the platform engineered to support reporting at the indicator and household level.
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.
Field officers and enumerators submit through 9 offline-capable forms across all 9 counties. GPS-tagged, validated, ready to sync.
A single generic endpoint receives every submission. Payloads are validated against form definitions, never rejected — issues are flagged and stored alongside the data.
JSONB raw → typed staging → P4C star-schema mart. dbt runs every ~15 minutes. New forms only need a staging model — zero server changes.
Direct Query dashboards for program managers, MEL staff, and leadership — embedded in IPMS Insights, secured by row-level access per county.