Real numbers. Live. From the same database staff are working in.
No nightly ETL. No stale tab. The dashboard your director opens at 8am is the same data the clerk just typed at 7:58. Every number is clickable — drill into the underlying records on the way to the next meeting.
Live, not lagged. Same database, same model.
Most "real-time dashboards" are nightly snapshots in a marketing trench coat. Ours run on the live operational database — because the platform is one product, not seven.
Operational DB
Permits, FOIA, 311, inspections — all live in the same Postgres. No warehouse round-trip.
Streaming materialized views
Aggregates refresh on write, not nightly. The 8am number is the 7:58 reality.
Click any number
Drill into the underlying records. Aggregate and source share one model — no ID translation.
Council-ready PDF + CSV
Scheduled emails for the people who want them in their inbox. Embed for the public-facing transparency page.
Three things this module is actually good at.
Three core capabilities — director dashboards, ad-hoc reports, scheduled distribution. Built for the people who answer to elected officials on Tuesday nights.
The view from the corner office.
Permits issued, FOIA backlog, 311 cycle time, revenue collected. One screen, live, drillable. The numbers your director defends at council are the same numbers the clerk types into the platform.
- KPIsCross-module KPIs on one screen — permits, FOIA, 311, revenue, cycle time.
- TrendWeek-over-week, month-over-month, year-over-year with delta indicators.
- DrillClick any number → underlying records. No ID translation, no warehouse lag.
"Council asked for it Tuesday. Send it by Wednesday."
Filter, group, sort, chart. Save the configuration as a report. Schedule it to email itself. The clerk builds it without learning SQL — and the data engineer doesn't get pulled in.
- FilterCross-module filtering — permits issued by district, district by quarter.
- SaveSave as report. Re-run anytime, share with a colleague, or schedule.
- ExportPDF, CSV, embed. Council packet on the way out the door.
In their inbox before the meeting.
Schedule any report to email itself — daily, weekly, monthly. Subscribe a council member, a director, an auditor, or the public-transparency portal. Same data, different audience.
- ScheduleDaily / weekly / monthly with timezone-aware delivery.
- SubscribePer-recipient subscriptions. Add a council member without a vendor ticket.
- PublicPublic transparency embeds — a citizen-facing version of the same dashboard.
Your KPIs. Your audience. Your cadence.
Reports ship as a workbench. We configure your director dashboards, council-meeting packets, and public transparency embeds — and your staff keep configuring after we leave.