Heifer International — Kenya

Field data to dashboards in under 24 hours.

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.

625K target households
9 counties served
4 value chains
What this platform does

Replacing a 2–3 week manual cycle with a 24-hour pipeline

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.

Real-time ingestion

SurveyCTO field submissions stream into a generic webhook the moment they hit the network — no polling, no batch lag.

Schema-on-read

Raw payloads are stored as JSONB. dbt extracts typed staging tables and shapes a star-schema mart. New forms add zero server code.

Indicator-aligned mart

A reporting mart aligned to the P4C results framework — five result areas, GI + PSI indicators, mapped to SDG codes.

Decision-grade dashboards

Power BI Direct Query, role-based access by county, embedded in IPMS Insights for program managers and senior leadership.

Program scope

Nine counties. Four value chains. One source of truth.

Operating across Western, Rift Valley, and parts of Northern and Southern Kenya — supporting smallholder producer organizations, FOABs, and the households they serve.

Counties served

  • Bungoma
  • Busia
  • Isiolo
  • Kajiado
  • Kakamega
  • Nakuru
  • Nandi
  • Trans-Nzoia
  • Uasin Gishu

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.

Value chains

  • Beef
  • Dairy
  • Poultry
  • Horticulture

Five P4C result areas drive measurement: producer-org sustainability, household nutrition, income, environmental sustainability, and inclusive value chains.

Scale & performance

What the platform measures

Targets set during Heifer Kenya's program design, with the platform engineered to support reporting at the indicator and household level.

625K target households across the program
9 data collection forms on SurveyCTO Collect
5 P4C result areas mapped to SDGs
4 agricultural value chains beef, dairy, poultry, horticulture
< 24h field-to-dashboard latency down from 2–3 weeks
≥ 95% first-pass validation target on submission
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.

  1. 01

    Collect SurveyCTO

    Field officers and enumerators submit through 9 offline-capable forms across all 9 counties. GPS-tagged, validated, ready to sync.

  2. 02

    Ingest Fastify webhook

    A single generic endpoint receives every submission. Payloads are validated against form definitions, never rejected — issues are flagged and stored alongside the data.

  3. 03

    Transform PostgreSQL · dbt

    JSONB raw → typed staging → P4C star-schema mart. dbt runs every ~15 minutes. New forms only need a staging model — zero server changes.

  4. 04

    Visualize Power BI · IPMS

    Direct Query dashboards for program managers, MEL staff, and leadership — embedded in IPMS Insights, secured by row-level access per county.

TypeScript Fastify PostgreSQL Drizzle ORM dbt Core React + Vite Power BI Docker · Azure