Hybrid Workspace Utilization Analytics
This dataset provides a detailed, time-stamped record of workspace utilization in hybrid office environments, capturing occupancy, booking patterns, and employee feedback across various workspace types and locations. It enables facility managers and real estate teams to analyze space usage trends, optimize allocation, and enhance employee satisfaction in remote-friendly workplaces. The dataset supports actionable insights for dynamic space planning and workplace experience improvements.
Sample rows
preview · 8 of 120 rows · all 20 columns| workspace_idstring | workspace_typestring | occupancy_countinteger | booking_cancelledboolean | location_zonestring | workspace_namestring | location_buildingstring | location_floorstring | datedate | time_slot_startdatetime | time_slot_enddatetime | occupancy_statusstring | booking_idstring | booked_by_employee_idstring | booking_purposestring | booking_created_atdatetime | employee_count_expectedinteger | actual_usage_duration_minutesinteger | feedback_scorefloat | feedback_commentstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| D-102A | desk | 1 | blank | Zone B | Window Desk 1 | HQ-East | 2 | 2024-05-15 | 2024-05-15T09:00:00 | 2024-05-15T12:30:00 | occupied | blank | blank | blank | blank | blank | 210 | 4.5 | Desk was comfortable and quiet. |
| MR-201 | meeting_room | 5 | false | North Wing | Maple Room | Annex | 2 | 2024-05-15 | 2024-05-15T10:00:00 | 2024-05-15T11:30:00 | reserved | BK3107 | EMP1032 | team_meeting | 2024-05-13T16:04:00 | 5 | 90 | 4.8 | Room set up was perfect for the team. |
| HS-3C | huddle_space | 3 | blank | Zone A | Collab Corner | HQ-West | GF | 2024-05-16 | 2024-05-16T13:00:00 | 2024-05-16T15:00:00 | occupied | blank | blank | blank | blank | blank | 120 | blank | blank |
| PB-15 | phone_booth | 1 | false | Zone D | Phone Booth 15 | HQ-East | 1 | 2024-05-16 | 2024-05-16T11:15:00 | 2024-05-16T11:45:00 | occupied | BK2231 | EMP1209 | client_call | 2024-05-16T08:02:00 | 1 | 30 | blank | blank |
| OTH-01 | other | 0 | blank | blank | blank | HQ-West | RF | 2024-05-16 | 2024-05-16T14:00:00 | 2024-05-16T17:00:00 | vacant | blank | blank | blank | blank | blank | 0 | blank | blank |
| D-202B | desk | 1 | blank | blank | Standing Desk | HQ-West | 4 | 2024-05-17 | 2024-05-17T08:30:00 | 2024-05-17T12:00:00 | occupied | blank | blank | blank | blank | blank | 210 | 3.7 | Desk location is a bit noisy. |
| MR-305 | meeting_room | 8 | false | South Wing | Oak Room | Annex | 3 | 2024-05-17 | 2024-05-17T09:00:00 | 2024-05-17T12:00:00 | reserved | BK3154 | EMP1017 | training | 2024-05-15T13:00:00 | 8 | 180 | 5 | Great AV setup for training session. |
| HS-2A | huddle_space | 4 | blank | Zone C | blank | HQ-West | 0 | 2024-05-17 | 2024-05-17T13:30:00 | 2024-05-17T15:00:00 | occupied | blank | blank | blank | blank | blank | 90 | blank | blank |
| PB-22 | phone_booth | 0 | false | blank | Phone Booth 22 | HQ-East | 2 | 2024-05-17 | 2024-05-17T13:00:00 | 2024-05-17T13:20:00 | no_show | BK2299 | EMP1213 | client_call | 2024-05-17T09:00:00 | 1 | 0 | blank | blank |
| OTH-02 | other | 3 | false | blank | Wellness Room | HQ-West | 1 | 2024-05-18 | 2024-05-18T10:00:00 | 2024-05-18T11:45:00 | reserved | BK3208 | EMP1125 | personal | 2024-05-18T08:20:00 | 3 | 105 | 4.4 | Comfortable space for wellness session. |
| D-205C | desk | 1 | blank | blank | Corner Desk | HQ-East | 5 | 2024-05-18 | 2024-05-18T09:30:00 | 2024-05-18T11:30:00 | occupied | blank | blank | blank | blank | blank | 120 | blank | blank |
| MR-210 | meeting_room | 7 | false | Zone D | Elm Room | HQ-East | 4 | 2024-05-18 | 2024-05-18T14:00:00 | 2024-05-18T15:45:00 | reserved | BK3142 | EMP1043 | executive_briefing | 2024-05-17T10:30:00 | 7 | 105 | blank | blank |
| HS-1B | huddle_space | 4 | false | Zone F | Focus Nook | Annex | 1 | 2024-05-19 | 2024-05-19T09:00:00 | 2024-05-19T11:00:00 | reserved | BK3181 | EMP1104 | brainstorming | 2024-05-18T16:12:00 | 4 | 120 | 4.6 | Great space for brainstorming session. |
| PB-19 | phone_booth | 1 | false | blank | Phone Booth 19 | HQ-West | 2 | 2024-05-19 | 2024-05-19T15:00:00 | 2024-05-19T15:20:00 | reserved | BK2314 | EMP1237 | client_call | 2024-05-19T08:52:00 | 1 | 20 | blank | blank |
| OTH-03 | other | 2 | blank | blank | blank | HQ-West | RF | 2024-05-19 | 2024-05-19T13:00:00 | 2024-05-19T15:00:00 | occupied | blank | blank | blank | blank | blank | 120 | 4 | Nice open space for creative work. |
| D-108B | desk | 1 | blank | Zone A | blank | HQ-East | 1 | 2024-05-20 | 2024-05-20T09:30:00 | 2024-05-20T13:00:00 | occupied | blank | blank | blank | blank | blank | 210 | blank | blank |
| MR-202 | meeting_room | 12 | false | Zone E | Birch Room | HQ-East | 4 | 2024-05-20 | 2024-05-20T10:00:00 | 2024-05-20T14:00:00 | reserved | BK3128 | EMP1074 | team_meeting | 2024-05-19T15:20:00 | 12 | 240 | blank | blank |
| HS-2B | huddle_space | 5 | blank | Zone E | Team Nook | HQ-West | GF | 2024-05-20 | 2024-05-20T14:15:00 | 2024-05-20T16:30:00 | occupied | blank | blank | blank | blank | blank | 135 | 4.7 | Ideal for small team work. |
| PB-20 | phone_booth | 1 | false | Zone B | Phone Booth 20 | HQ-East | 1 | 2024-05-20 | 2024-05-20T10:30:00 | 2024-05-20T11:00:00 | occupied | BK2290 | EMP1193 | client_call | 2024-05-20T09:05:00 | 1 | 30 | blank | blank |
| OTH-04 | other | 0 | blank | blank | Makerspace | HQ-West | 1 | 2024-05-20 | 2024-05-20T11:00:00 | 2024-05-20T14:00:00 | vacant | blank | blank | blank | blank | blank | 0 | blank | blank |
What the 120 rows show
from the 120-row sampleMeeting_
- 11%booking_
cancelled = true - 1median occupancy_
count - 3location buildings
- 4occupancy statuses
- 8booking purposes
- 14location floors
Median 1, from 0 to 24.
- string 11
- integer 3
- float 1
- date 1
- datetime 3
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
workspace_id | string | Unique identifier for each workspace (desk, room, or area) | D-102A |
workspace_type | string | Type of workspace (e.g., desk, meeting_room, huddle_space, phone_booth)desk · meeting_room · huddle_space · phone_booth · other | desk |
workspace_name | string | Descriptive name or label for the workspaceoptional | Window Desk 1 |
location_building | string | Name or identifier of the building where the workspace is located3 buildings | HQ-East |
location_floor | string | Floor number or label within the building | 2 |
location_zone | string | Zone, area, or section of the floor (e.g., North Wing, Zone A)optional | Zone B |
occupancy_status | string | Occupancy status during the time slot (e.g., occupied, vacant, reserved, no_show)occupied · vacant · reserved · no_show | occupied |
booking_id | string | Unique identifier for the booking event (if applicable)optional | BK3107 |
booked_by_employee_id | string | Employee ID of the person who booked the workspace (if booked)optional | EMP1032 |
booking_purpose | string | Purpose or reason for the booking (e.g., focus_work, team_meeting, client_call)8 purposes · optional | team_meeting |
feedback_comment | string | Optional free-text feedback or comments from employeesoptional | Spacious, well-equipped. |
| Numbers 4 columns | |||
occupancy_count | integer | Number of people present in the workspace during the time slot0 or more · optional | 1 |
employee_count_expected | integer | Number of employees expected based on booking (for group spaces)0 or more · optional | 5 |
actual_usage_duration_minutes | integer | Actual duration in minutes the workspace was used during the time slot0 or more · optional | 210 |
feedback_score | float | Optional employee feedback score for the workspace (e.g., 1-5 scale)1 to 5 · optional | 4.5 |
| Dates and times 4 columns | |||
date | date | Date of the utilization record | 2024-05-15 |
time_slot_start | datetime | Start time of the utilization or booking period | 2024-05-15T09:00:00 |
time_slot_end | datetime | End time of the utilization or booking period | 2024-05-15T12:30:00 |
booking_created_at | datetime | Timestamp when the booking was createdoptional | 2024-05-13T16:04:00 |
| True or false 1 column | |||
booking_cancelled | boolean | Indicates if the booking was cancelledoptional | false |
Use it for
A real estate dashboard
The booking_
cancelled rate, occupancy_ count by workspace_ type and a breakdown of location_ zone. Excel, Power BI or Tableau. Why do the 24 meeting_
room rows have a mean occupancy_ count of 9.9? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Workspaces120MR-2015meeting_…MR-3010meeting_…OTH-1020other
A software demo
Believable workspaces with workspace_
type, workspace_ name and location_ building to fill a screen in front of a buyer.
This dataset120 rows20 columns
Yours10,000 rows20 columnslocation_building: UK only
blueprint · hybrid-workspace-utilization-analytics
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Workspace occupancy must be recorded hourly.
- Bookings are linked to employee IDs; multiple bookings per day allowed.
- Unused reservations flagged as 'no show' for analysis.
- Utilization rates calculated as percentage of total available desks.
- Workspace type (meeting room, hotdesk, quiet zone) must be specified.
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- hybrid-workspace-utilization-analytics