DPSN Dashboard

The problem

Operational data was arriving continuously but was only readable by people who could query it directly. Different roles needed different slices of the same data, and 'export a CSV and email it' does not survive contact with a growing team.

What I built

1. 01Streaming ingestion into PostgreSQL with aggregation done server-side, so the browser renders prepared series rather than raw event volume
2. 02Role-based access control enforced at the API layer, not the UI — the query itself is scoped, so a role cannot request data it should not see
3. 03Visualisation layer built for dense, multi-series data with the read path optimised separately from ingestion
4. 04Deployed on AWS alongside the ingestion workers

Outcome

In production as the operational view of the network — each role opens the dashboard and sees exactly the slice they are entitled to, live.

Streaming

Ingestion

Server-side

Aggregation

Enforced in the query

Access control