← All case studies Case Study 02 · Facilities

Space Utilization Analysis

Analysis of classroom capacity, enrollment, attendance, and occupancy patterns to identify underused space, attendance gaps, and scheduling opportunities.

Power BISQLDAXPower QueryUser Experience Design
Space Utilization OverviewPower BI
Space utilization dashboard with KPIs for booking rate and occupancy, daily occupancy trend, and an occupancy heatmap by day and hour
Space utilization overview — booking rate, occupancy and attendance patterns
Business Context

The challenge

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.

Key Questions

What the teams needed to know

01

Which rooms and time slots are underutilized?

02

When does occupancy peak during the day?

03

How large is the gap between enrolled and attending students?

04

Is low utilization driven by capacity, scheduling, or attendance behavior?

What I Built

Planned demand vs. actual usage

  • Executive KPI cards — used hours, booking rate, capacity, enrollment, attendance, occupancy rate
  • Daily average occupancy trend compared against room capacity
  • Occupancy heatmap by weekday and hour range
  • Attendance versus enrollment comparison by time of day
  • Room, room type, and department filters
  • Guided tutorial overlay explaining the dashboard metrics

I combined room capacity, enrollment, booking, and attendance data to compare planned demand against actual usage and reveal underused periods.

Adoption

Guided dashboard experience

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. The dashboard pairs the final analytical view with a guided overlay designed to support user adoption.

Help Guide overlayPower BI
Guided Help overlay with numbered tooltips explaining each KPI, chart and metric on the space utilization dashboard
Built-in Help Guide — numbered tooltips explain every KPI and chart in context
Key Findings

What the data revealed

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 vs 17

Enrolled versus attending highlighted a consistent attendance gap across scheduled sessions.

Business Impact

Why it mattered

My Role

What I owned

Requirements GatheringData ModelingDAX DevelopmentDashboard UX DesignPower Query PrepStakeholder Reporting