work / 2026 / In production at work
Operations dashboard
A live KPI dashboard for branch, zone and state operations at AYE Finance: React on the front, FastAPI and PostgreSQL behind it.
What it is
A dashboard that pulls from the live production database into staging tables in the data warehouse, and shows operations KPIs to people at different levels of the organisation. Frontend in React, backend in FastAPI, data in PostgreSQL.
What's in it
- Role-scoped views, so a branch sees its branch and a zone sees its zone, with drill-down from state to zone to branch.
- A comparator view and a benchmark engine that compares against area, team and overall averages.
- Funnel and lead-quality analysis.
- A "needs attention" panel that flags disbursement drops and NACH bounces.
- Personal scorecards with peer rank.
Where the time went
Most of the effort after the first version was performance and loading behaviour: fixing the queries, then reworking the UI to show numbers first and load the heavier panels in the background. The query side is in Fixing a slow dashboard without a rewrite.