Analytics, Business Intelligence & AI Copilot Platform
The intelligence layer of NexusOne: executive and module dashboards, a KPI framework, rule-based alerting, and a report builder are Basic tier. Gemini-powered predictive analytics and the conversational AI Copilot are Elite tier, following the platform's "AI features are Elite" rule.
Implementation note: dashboards aggregate directly from each module's existing collections (DailyAttendance, ReportCard, StudentFeeAccount, AdmissionLead, Payroll, Asset, MaintenanceTicket, CompetencyRecord, Course, Notice, DriverTrip, etc.) rather than a separate data warehouse. The AI Copilot and Predictive Analytics controllers use their own Gemini helper (utils/geminiHelper.js) so the existing aiInsightController.js from earlier chapters is left untouched. Cross-school benchmarking and full Data Governance / Data Quality tooling (BRD §22.53-54) are scoped out of this pass as fast-follow items.
Features
Executive & Module Dashboards
- Executive dashboard: composite School Health Score (0-100) across academics, attendance, admissions, finance, engagement and operations pillars
- Ten module dashboards: Academic, Attendance, Finance, Admissions, HR, Facilities, Growth Passport, LMS, Communication, Transport
- All aggregations computed live from existing MongoDB collections (no separate data warehouse) via getSchoolFilter-scoped pipelines
- Web UI: /dashboard/admin/analytics and its module sub-pages
KPI Framework
- Seven categories: academic, financial, operational, admissions, engagement, workforce, development
- Target, warning threshold, critical threshold per KPI, with automatic status computation (on_target / warning / critical)
- Web UI: /dashboard/admin/analytics/kpis
Alert Management
- Rule-based (non-AI) nightly scan across attendance, academic, fee and operational risk categories
- De-duplicated per ongoing condition, routed to admins via the existing NotificationService
- Acknowledge / resolve workflow with full audit trail on the Alert record itself
- Web UI: /dashboard/admin/alerts
Report Builder
- On-demand export to PDF, Excel or CSV for any supported module
- Optional recurring schedule (daily/weekly/monthly/quarterly) with email delivery via the existing email service
- Report creation and every export is written to AuditLog
- Web UI: /dashboard/admin/reports
Predictive Analytics Engine
- Six forecasting domains: academic risk, attendance risk, financial (fee defaulters), admissions forecast, workforce attrition, facility replacement
- Gemini-generated risk narrative and recommendations over real aggregated data, with a statistical fallback when the AI service is unavailable
- Web UI: /dashboard/admin/analytics/predictions
AI Copilot
- Conversational natural-language queries over a role-scoped data snapshot (financial data excluded for teacher/student/parent roles)
- Every query logged to CopilotQueryLog for audit, including which data categories were accessed
- One shared chat UI reused across admin, teacher, parent and student portals — web and mobile
- Web UI: /dashboard/admin/copilot (and the teacher/parent/student equivalents)
API Reference — Chapter 22
Dashboards & Benchmarking (Basic)
/api/analytics/dashboard/executiveSchool Health Score, KPI summary, active alerts
/api/analytics/dashboard/:moduleacademic | attendance | finance | admissions | hr | facilities | growth-passport | lms | communication | transport
/api/analytics/drill-downSchool → grade → section → student attendance drill-down
/api/analytics/benchmarksCompare by term, academic year or campus
/api/analytics/my/performanceStudent self-service performance view
/api/analytics/my/child/:studentIdParent view of a linked child's performance
KPIs, Alerts & Reports (Basic)
/api/analytics/kpisKPI framework CRUD
/api/analytics/alertsList alerts, filterable by status/category/priority
/api/analytics/alerts/:alertId/acknowledgeAcknowledge an alert
/api/analytics/alerts/:alertId/resolveResolve an alert
/api/analytics/reportsReport Builder definitions
/api/analytics/reports/:reportId/export?format=pdf|excel|csv on-demand export
Predictions & AI Copilot (Elite)
/api/analytics/predictions/at-riskAcademic risk prediction
/api/analytics/predictions/attendance-riskChronic absenteeism / dropout risk
/api/analytics/predictions/fee-defaultersFinancial / fee collection prediction
/api/analytics/predictions/enrollmentAdmissions forecast
/api/analytics/predictions/workforceWorkforce attrition & hiring forecast
/api/analytics/predictions/facilityAsset replacement & maintenance demand forecast
/api/analytics/copilot/queryNatural-language query, role-scoped data snapshot
/api/analytics/copilot/historyAudit log of past Copilot queries
Frontend Pages
| Path | Role | Description | Tier |
|---|---|---|---|
| /dashboard/admin/analytics | Admin / Super Admin | Executive dashboard | Basic |
| /dashboard/admin/analytics/{module} | Varies by module | Academic, attendance, finance, admissions, HR, facilities, growth-passport, LMS, communication, transport | Basic |
| /dashboard/admin/analytics/benchmarks | Admin / Super Admin | Term / year / campus comparison | Basic |
| /dashboard/admin/analytics/kpis | Admin / Super Admin | KPI framework management | Basic |
| /dashboard/admin/alerts | Admin, Teacher, HR, Facilities, Accountant | Alert center | Basic |
| /dashboard/admin/reports | Admin / Super Admin | Report builder | Basic |
| /dashboard/admin/analytics/predictions | Admin / Super Admin | Predictive analytics | Elite |
| /dashboard/admin/copilot | Admin / Super Admin | AI Copilot chat | Elite |
| /dashboard/teacher/copilot, /dashboard/parent/copilot, /dashboard/student/copilot | Teacher / Parent / Student | Role-scoped AI Copilot chat | Elite |
Mobile
Under app/(admin)/:analytics.tsx (executive summary),alerts.tsx (alert center with acknowledge/resolve), and ai-copilot.tsx(Elite). The same Copilot screen is reused under app/(teacher)/,app/(parent)/ andapp/(student)/ via a sharedcomponents/analytics/CopilotChat.tsxcomponent, following the same requiresElite sentinel pattern used by the existing AI Parent Assistant.