Admin Dashboard & KPIs

Coordinators and administrators currently spend significant time manually aggregating data from Word forms and Excel sheets to understand the performance of their peer mentor networks. A real-time KPI dashboard eliminates this manual effort and provides immediate visibility into activity levels, reimbursement backlogs, and engagement trends. For organization leaders, the dashboard is a strategic tool for demonstrating impact to stakeholders and Bufdir, while for coordinators it is an operational tool for identifying which peer mentors need outreach or support. This directly addresses the core value proposition of the platform: making invisible volunteer work visible and measurable.

Dashboard data is served via dedicated summary endpoints (/api/v1/admin/dashboard) that execute optimized aggregate SQL queries against PostgreSQL. Queries are parameterized by organization_id and date range and return pre-aggregated counts to avoid N+1 issues. The Next.js admin panel renders charts using a lightweight library (e.g., Recharts or Chart.js) with server-side data fetching for initial load and client-side polling or SWR-based revalidation for freshness. Role-based scoping is enforced at the API layer — coordinators receive only their local_association_id scope, while org admins receive all associations under their organization. KPI widgets are componentized for reuse and future extensibility. Response data is typed with Zod schemas on the API boundary.