Cohort signals across 52 students
Real-time aggregates from the live Postgres backend. RIASEC profiles, aptitude distributions, career-fit by family, and recent counselling activity.
Holland Code averages
Mean scores across all 52 students, 6 dimensions.
cohort lean → Enterprising (61)
Where students gravitate
Family of each student's #1 ranked career match.
Finance dominates (38% of students)
DAT V battery averages
6 aptitude dimensions, scored 0–100.
strongest → Speed/Accuracy
Most-matched careers (top match)
Recent reports
Five §5 metrics, computed in one Postgres query each
Each card maps to a single SELECT … GROUP BY on students, reports, or career_matches. No materialised views, no caching layer.
Server passes raw counts + buckets to Tera; Chart.js draws bar / pie / horizontal-bar in the browser. No build step, no bundler.
Each chart is interactive: clicking a segment links to /discovery? with the right filter chips pre-applied — counsellor lands on the underlying records.
Page is fully server-rendered. Reload = re-query. In prod we add Postgres NOTIFY + SSE push for live updates.