Every census in the country had ended the same way: a bound PDF report, a press conference, and a year of silence until the next one. Decisions made between cycles ran on instinct, not data — because the data wasn't accessible.
From PDFs to Power BI
We built a streaming pipeline that ingests enumerator submissions in real time, validates them against historical baselines, and surfaces anomalies to district supervisors within minutes. The same pipeline feeds a public dashboard built on Power BI Embedded — citizens can now query the same numbers their government uses.
The unexpected hardest part
Not the technology. Trust. Convincing departments that publishing data wouldn't be used against them politically took longer than the entire build. We solved it by giving every department editorial control over how their own slice was presented — annotations, caveats, methodology notes — without touching the underlying numbers.
