Description:
Tableau map project analyzing meeting room utilization in a two-floor office, targeting persistent booking issues. Conducted over a 6-month period, it integrates data on booking times and actual utilization in order to understand where the overbooking problem lies, identifying the most problematic rooms and highlighting them clearly in order to decide on the new booking policy for these rooms.
Objectives:
- Identify Booking Inefficiencies: Pinpoint discrepancies between actual and booked room utilizations to understand usage patterns.
- Solve Overbooking Issues: Use data-driven insights to identify and address the most problematic overbooked meeting rooms.
- Policy Optimization: Leverage findings to adjust room booking policies, aiming to alleviate overbooking and improve room availability.
- Visual Data Representation: Employ color-coded visualization to intuitively communicate room utilization levels for easy assessment.
Detail:
Key Features
- Floor Plan Integration: Uses background image for office floor plans, with a parameter to select between floors.
- Utilization and Overbooking Dashboards: Includes two dashboards, one showing actual versus booked utilization, and another focused on overbooking, both with color-coded data for clarity.
- Calculation of Utilization Metrics: Determines utilization based on booking and attendance, and overbook percentage as the difference between booked and actual usage.
- Visual Representation: Employs color gradients to highlight rooms according to utilization levels, aiding in identifying overbooked spaces.
- Insights: Uncovers significant disparities in room utilization, with some rooms exhibiting high overbook rates, necessitating policy adjustments.