Learning & Curriculum Analytics Dashboard
Excel · dashboard design · utilization · portfolio strategy
A portfolio-safe Excel reconstruction of learning and curriculum analytics methods using fully synthetic data. The workbook demonstrates how row-level engagement data, organization mapping, product-level performance, and curriculum lifecycle signals can be combined into an executive-facing decision-support dashboard.
No employer, client, member, learner, faculty, revenue, or proprietary program data are included.
Dashboard snapshot
UNIQUE LEARNERS
80
ORGANIZATIONS
12
REGISTRATIONS
331
ATTENDANCE
85.5%
COMPLETION
80.6%
REFRESH CANDIDATES
3
Quarterly activity
Q1 — 80
Q2 — 84
Q3 — 98
Q4 — 69
All values shown are synthetic demonstration data generated for this portfolio workbook.
What the workbook demonstrates
- Executive dashboard: KPI cards, quarterly activity, topic demand, format footprint, and development signals.
- Activity-level data model: participant, organization, event, topic, format, delivery mode, job family, seniority, registration, attendance, and completion fields.
- Curriculum portfolio model: lifecycle stage, launch and refresh dates, registrations, attendance, completion, satisfaction, utilization score, refresh age, and development priority.
- Reference enrichment: synthetic organization-to-industry and subsector mapping.
- Formula-driven analysis: SUMIFS, COUNTIF, UNIQUE, INDEX/MATCH, ranking, conversion formulas, weighted utilization scoring, refresh logic, and development-priority rules.
- Visual QA: charts, conditional formatting, data bars, freeze panes, tables, date/percentage formatting, and a dedicated data dictionary.
Workbook tabs
Dashboard · Activity Data · Curriculum Portfolio · Reference Mapping · Data Dictionary · Portfolio Guide