Public Health Data Dashboard for County Reporting
Riverside County's health department was generating reports manually from three disconnected systems. We built a unified real-time data platform that reduced reporting time from 14 days to 24 hours.
- Faster report generation
- 14x
- Departments integrated
- 3
- Uptime SLA achieved
- 99.9%
- Report turnaround
- 24hr
- Data freshness
- Real-time
- Analyst time reclaimed
- 40%
14 days to under 24 hours
From separate disconnected systems
Over 12 months post-launch
Down from two weeks
From weeks-old static reports
Redirected to higher-value work
The challenge
The county health department maintained three separate data systems — one for clinic operations, one for laboratory results, and one for community health programs. Generating the state-mandated monthly report required a full-time analyst and took two weeks. Leadership had no real-time visibility into key health indicators, and public-facing data was months out of date.
The solution
We designed a data architecture that connected all three source systems via a secure API layer, transforming and loading data into a centralized Supabase database. We built a React-based dashboard with role-based access — executives get high-level KPIs, analysts get drill-down capability, and the public gets a transparent open data portal with weekly updates. The monthly report is now generated automatically with a single click.
The outcome
Report generation time dropped from 14 days to under 24 hours. The department's medical director now reviews real-time metrics at their morning standup. The public data portal has received coverage in three local media outlets and improved the department's public transparency rating. The platform now supports all three departments and has been adopted as the county's standard for health data reporting.