Sacramento County Ships Custom Apps 7x Faster With the Same Ten Analysts

Inside a Sacramento County Department of Human Assistance (DHA) lobby center, a supervisor looks at a screen that mirrors the physical lobby room layout. Every interview room, every counter window, and every staff member is mapped to a card on the dashboard. The cards change color in real time as staff start helping a customer, as a window frees up, as an interview wraps. Across five lobby center locations, each with twenty to thirty interview rooms, supervisors and staff can see at a glance which rooms are occupied and which are available.

That dashboard, along with four others currently in production at Sacramento County, was built by the County's own IT analysts, with no dedicated frontend team added.

Sacramento County is one of California's largest county governments, serving more than a million residents across agriculture, animal care, elections, public health, transportation, and the Department of Human Assistance, which administers food assistance, medical coverage, and welfare programs to residents receiving public assistance services.

Hsun Lang, a Supervising IT Analyst at Sacramento County, leads a team of ten IT analysts responsible for building dashboards and data analytics for the Department of Human Assistance. His team historically relied on Power BI for enterprise reporting. While Power BI continues to support standard tabular analytics and executive reporting across the department, specialized operational workflows required custom front-end interfaces. For applications like real-time lobby tracking, supervisors needed interactive physical floor plans, dynamic spatial color-coding, and custom web behavior that fall outside standard BI reporting templates.

To build these custom UIs without dedicated web developers, Hsun's team adopted Reflex's AI Builder, which generates production-ready Python web application code directly from prompts.

While traditional BI report development follows standard build cycles, leveraging Reflex's AI code generation allowed Hsun's Python analysts to prompt, iterate, and deploy custom full-stack web UIs at unprecedented speed.

Anything new the team introduced would have to fit the constraints of a county IT environment: deployable on premise, since cloud is not an option for sensitive constituent data, maintainable by the analysts already on staff, and approvable through County procurement.

Hsun first heard about Reflex at an AI conference in Santa Clara. A tool that let his existing analysts build complete applications, deployable on the County's own infrastructure, fit those constraints precisely.

What made the decision easy was the speed of iteration. Hsun's team could prototype dashboards quickly against anonymized sample data, refine them visually in the browser, and hand off finished code to their internal implementation team for production deployment. When edge cases appear, Reflex's team has helped debug live on calls and ship fixes the same day.

With Reflex, Sacramento County builds internal apps directly on top of its existing data:

• Connect to the County's existing databases
• Use the AI Builder to create dashboards, interactions, and application logic
• Iterate visually until the dashboard matches what DHA managers and supervisors need
• Generate code the County can own, inspect, and maintain
• Run the finished app within Sacramento County's managed environment

Five apps are currently live in production at the County:

1. Three real-time lobby dashboards that mirror the physical layout of DHA lobby centers, used continuously by managers, supervisors, and staff across five locations. The apps stay open and refresh live throughout an eight-hour service day.
2. An internal tracking app that consolidates ticketing data from multiple systems, used by eleven supervisors across the department
3. The "alchemist list," an additional internal workflow app

More applications are in final testing before release, including applications that move beyond reporting into predictive operations.

Hsun's team chose Reflex because it allowed them to:

• Keep constituent data on County servers. Every app deploys on premise, on Sacramento County's own infrastructure. Constituent data never leaves the County's data servers.
• Ship dashboards that match the physical reality of a lobby center. Real-time color states, layouts that mirror actual rooms, and interaction patterns that managers can read at a glance.
• Rapid AI-driven Python development. Leveraged Reflex's AI capabilities to generate production-ready Python web apps from prompts, allowing data analysts to ship complex, custom operational UIs without writing custom JavaScript or relying on dedicated front-end engineering.
• Parallel stack alignment. Allowed the department to maintain Power BI for standard enterprise BI reporting while establishing Reflex as the dedicated framework for AI-generated operational web applications and interactive spatial workflows.
• Build with the team they already have. The same ten analysts who own the County's data build the applications, with stakeholders in the loop: dashboards are shaped with input from managers and supervisors, then delivered as code Sacramento County owns, inspects, and maintains.

Six months in, Sacramento County has five Reflex apps live in production and more in development. The lobby dashboards alone are open and refreshing continuously across five lobby center locations for the full operational day. The internal tracking app has spread organically from one Supervising IT Analyst's pain point to eleven supervisors across the department. Hsun's expansion plan is practical: get more apps into production, continue to prove reliability with real users, and show other departments what Reflex can do and how it can expedite their dashboard production.

For Sacramento County's IT organization, Reflex has become the high-speed framework of choice for AI-generated operational web applications. By maintaining Power BI for core enterprise reporting alongside Reflex for rapid Python web app development, Hsun's team has expanded their overall delivery capacity to meet growing departmental demands.

This section is written for your technical team.