Case Study 02
Analysis of classroom capacity, enrollment, attendance, and occupancy patterns to identify underused space, attendance gaps, and scheduling opportunities.
Academic and operations teams needed a clearer way to understand how classrooms were being used across the scheduled day.
Capacity, enrollment, bookings, and attendance were not easy to compare side by side, making it difficult to separate space issues from attendance behavior.
Which rooms and time slots are underutilized?
When does occupancy peak during the day?
How large is the gap between enrolled and attending students?
Is low utilization driven by capacity, scheduling, or attendance behavior?
One of the requirements was to make the report easier for new users to understand without separate training. I added a built-in Help Guide that explains each KPI, chart, and metric in context, and the carousel shows both the final dashboard view and the guided overlay designed to support user adoption.
52% booking rate showed moderate use of available operating hours.
44% occupancy rate indicated that less than half of available room capacity was being used.
29 enrolled versus 17 attending highlighted a consistent attendance gap across scheduled sessions.
Improved visibility into when classroom space was being used and where utilization was low.
Separated capacity from attendance so teams could avoid treating every utilization issue as a space shortage.
Supported scheduling decisions with a repeatable view of room, day, and hour-level utilization.
Requirements Gathering
Data Modeling
DAX Development
Dashboard UX Design
Power Query Prep
Stakeholder Reporting