Turning distributed government data into one public data channel.

The dashboard was shaped around the needs of government leaders, from heads of provincial departments (dinas) to the Governor of West Java. Alongside its public-facing role, it was intended to give leadership a clearer view of indicators across sectors and support data-informed policy discussions.

Department leaders need to understand the picture within their area of responsibility. At the provincial level, the governor needs a broader view across departments. Bringing those inputs together helps create a shared basis for reviewing conditions, discussing priorities, and coordinating next steps.

My contribution was on the backend: integrating data from multiple government sources and preparing consistent datasets for those views. That connected the pipeline work to its purpose—making fragmented records easier for decision-makers to understand and use.

Government data comes from many owners and systems, each with its own schema, conventions, update cadence, and level of completeness. That creates a gap between the source of a record and the public-facing view of it.

If every dashboard endpoint needs to rediscover where data lives, reshape it, and resolve the same joins at request time, the product becomes difficult to maintain and increasingly expensive to query as data grows. My responsibility was to help close that gap with a central data flow.

The result had to be understandable for teams publishing information and reliable enough that public visualisations could be backed by a consistent source of truth.