Data Analysis & Reporting

Group Class Occupancy & Trainer Performance Report

Overview:

A reporting tool to monitor class attendance, trainer workload, and utilisation rates. Supporting operational decisions through data. Designed with data accuracy, integrity and role-based access in mind.

Problem Solved:

Managers lacked reliable, centralised insight into class demand and trainer distribution. This tool aggregates key metrics securely, enabling informed decisions while ensuring sensitive data is handled responsibly.

Key Features:

Attendance & Utilisation Reports - Visualise capacity trends over time

Trainer Metrics - Track performance, load balance and consistency

Peak Hour Analysis - Identify time slots for scaling or reallocation

Data Integrity Measures - Protected input sheets and locked formulas

Controlled Access - Workbook sections secured by role (admin vs. staff)

Tools & Techniques:

Excel · Pivot Tables · Conditional Formatting · Access Control · Secure File Structuring