HTML report export
Department Performance Export
A generated department-level report showing performance comparisons, sortable tables, and executive summary metrics after filtering.
KPI Data Import Pipeline
Turning a messy Excel workbook into something usable.
The source file is a print-oriented KPI workbook — pivot tables, subtotal rows, inconsistent sheet names, and student records that do not align cleanly across sheets. Getting the import right was the hard part. Drawing charts is easy once the data is trustworthy.
What the dashboard is for
Surface the college KPI picture in a form staff can search and read quickly.
Filter by department, course, and student level without fighting Excel.
Export the active filtered view into interactive HTML reports for sharing.
Step 1
working-kpi-import.js
Reads the workbook, detects shifting pivot-table layouts, flattens rows, normalises attendance and assessment values, and writes the student-level master table.
Step 2
import-area-summary.js
Aggregates the student-level data by department so leadership can read attendance, BRAG, assessment, and totals at area level.
Step 3
import-course-summary-v2.js
Builds the course-level summary layer that powers filtered drill-down views and the generated course export reports.
HTML report export
Course Performance Export
A more detailed course-level export with attendance, assessment, BRAG, and at-risk breakdowns across the filtered dataset.