Back to projects

ACB Application Management System

Production (State of California)

"From scattered Excel files to a unified system"

SharePointNitro StudioPower BIPower Automate

> about_

The ACB Application Management System replaced fragmented Excel-based tracking with a unified digital platform. Built on SharePoint with Nitro Studio forms for data entry, Power Automate for workflow triggers, and Power BI for executive reporting.

> features_

  • Unified intake form replacing scattered Excel files
  • Automated workflow triggers via Power Automate
  • Executive dashboard with analyst performance metrics
  • Near real-time refresh (1-2 hour cycles)

100% digitized workflow

1-2 hour refresh cycles

Real-time analyst tracking