This article covers only one of the available Dashboards. To find out more about general Dashboard use and what else is out there, visit the Dashboards Hub page.
Overview
The desk booking dashboard depicts historic desk booking data in various graphs and tables using different filters (e.g., date range, location, etc.).
In essence this dashboard shows you:
- What quantity of desks are made available to staff across locations, floors, zones;
- How many of those desks are booked by staff; and
- How many of those desks are not booked.
This intelligence is depicted by two types of measures:
- Distinct number of workspaces booked per a time period.
The time period is hourly or daily and will be averaged over the reporting periods of the graphs (i.e., quarterly, monthly or weekly). - Peak number of workspaces booked during a reporting period.
This maximum number is derived during the reporting periods of the graphs (e.g., the peak number booked in a quarter, month or week).
Available sheets
The dashboard contains 6 different sheets:
1. KPI booked - contains an overview of current vs. last monthly and current vs. last quarter comparisons of average and peak number of bookings over available desk capacity. It also shows the average and peak bookings as averaged over and split to the Days of Week (Sunday to Saturday);
2 - 5. Booked by …- contains graphs and tables of the measures reported over quarters, months and weeks, and Days of Weeks for the selected value (i.e., Office Locations, Floors, Zones, Workspace Types);
6. What If Analysis - extends the KPI booked sheet with the opportunity to adjust the available number of desks to a "WHAT IF" level of desk capacity. This allows you to verify the consequences of office resizing scenarios.
Sheet details
Quick navigation
- “KPI booked” sheet graphs explained
- “Booked by location” sheet graphs and tables explained
- “Booked by floor” sheet graphs and tables
- “Booked by zone” sheet graphs and tables
- “Booked by workplace type” sheet graphs and tables
- “What if Analysis” sheet graphs and tables
“KPI booked” sheet graphs
This sheet shows the following KPI graphs:
A.1 to A.3 compares the number of desks that are booked daily as % of the available desks between current and last month and shows the change in absolute number of booked desks between those months;
A.4 to A.6 compares the same statistics for this quarter and last quarter;
B.1 to B.3 compares the peak number of desks that are booked as % of the available desks between current and last month and shows the change in absolute number of booked desk between those months;
B.4 to B.6 compares the same statistics for this quarter and last quarter;
C.1 and C.2 display the number of daily booked and not booked desks vs. the available number of desks for this month and last month respectively. The measures are averaged to the different days of the week (i.e., Sunday to Saturday);
C.3 and C.4 displays the same measures and averaging principle for this quarter and last quarter;
D.1 and D.2 display the peak number of booked and trough number of not booked desks vs. the available number of desks for this month and last month respectively. The measures are averaged to the different days of the week (i.e., Sunday to Saturday);
D.3 and D.4 displays the same measures and averaging principle for this quarter and last quarter;
E.1 and E.2 display the the number of desks that are booked daily as % of the available desks and the peak number of desks as % of the available desks respectively for the current calendar year;
E.3 and E.4 display the the number of desks that are booked and not booked daily vs. the available desks and the peak number of booked and trough number of not booked desks vs. the available number of desks respectively for the current calendar year. The measures are averaged to the different days of the week (i.e., Sunday to Saturday).
“Booked by location” sheet graphs and tables
This sheet shows the following graphs and tables:
G.1 displays the number of desks that are and are not booked daily vs. the available number of desks for the current and last quarter;
G.2 displays the peak number of desks that is booked and trough number of desks not booked vs. the available number of desks for the current and last quarter;
G.3 to G.5 displays the 5 measures of graphs G1 and G2 in tables by quarter, by month and by week respectively;
H.1 displays the average daily, peak and trough as well as the available number of desks averaged over the reporting period and split to the different day of week (i.e., Sunday to Saturday).
H.2 displays the data of graph H.1 in the form of a table;
H.3 displays the 5 measures by each day for the reporting period.
“Booked by floor” sheet graphs and tables
This sheet shows the following graphs and tables:
J.1 displays the number of desks that are booked daily vs. the available number of desks, split to the floors that are part of the controls selection for the current and last quarter;
J.2 displays the peak number of desks that are booked vs. the available number of desks, split to the floors that are part of the controls selection for the current and last quarter;
J.3 displays the number of desks that are not booked daily vs. the available number of desks, split to the floors that are part of the controls selection for the current and last quarter;
J.4 displays the trough number of desks that are not booked vs. the available number of desks, split to the floors that are part of the controls selection for the current and last quarter;
J.5 to J.7 displays the 5 measures of graphs J.1 to J.4, in tables by quarter, by month and by week respectively. The measures remain split to the floors that are part of the controls selection;
K.1 to K.4 displays respectively the average daily booked, the peak booked, the average daily not booked and the trough not booked, all split to floors that are part of the controls selection vs. the available number of desks averaged over the reporting period and split to the different day of week (i.e., Sunday to Saturday).
K.5 displays the data of graphs K.1 to K.4 in the form of a table;
K.6 displays the 5 measures by each day for the reporting period.
“Booked by zone” sheet graphs and tables
Similar to the “Booked by floors”, but the split of the data is now by zone instead of by floor:
M.1 displays the number of desks that are booked daily vs. the available number of desks, split to the zones that are part of the controls selection for the current and last quarter;
M.2 displays the peak number of desks that are booked vs. the available number of desks, split to the zones that are part of the controls selection for the current and last quarter;
M.3 displays the number of desks that are not booked daily vs. the available number of desks, split to the zones that are part of the controls selection for the current and last quarter;
M.4 displays the trough number of desks that are not booked vs. the available number of desks, split to the zones that are part of the controls selection for the current and last quarter;
M.5 to M.7 displays the 5 measures of graphs M.1 to M.4, still split to the zones that are part of the controls selection in tables by quarter, by month and by week respectively;
N.1 to N.4 displays respectively the average daily booked, the peak booked, the average daily not booked and the trough not booked, all split to zones that are part of the controls selection vs. the available number of desks averaged over the reporting period and split to the different day of week (i.e., Sunday to Saturday).
N.5 displays the data of graphs N.1 to N.4 in the form of a table;
N.6 displays the 5 measures by each day for the reporting period.
“Booked by workplace type” sheet graphs and tables
Similar to “Booked by floors/zones” ,but the split of the data is now by workplace type:
P.1 displays the number of desks that are booked daily vs. the available number of desks, split to the workplace types that are part of the controls selection for the current and last quarter;
P.2 displays the peak number of desks that are booked vs. the available number of desks, split to the workplace types that are part of the controls selection for the current and last quarter;
P.3 displays the number of desks that are not booked daily vs. the available number of desks, split to the workplace types that are part of the controls selection for the current and last quarter;
P.4 displays the trough number of desks that are not booked vs. the available number of desks, split to the workplace types that are part of the controls selection for the current and last quarter;
P.5 to P.7 displays the 5 measures of graphs P.1 to P.4, still split to the workplace types that are part of the controls selection in tables by quarter, by month and by week respectively;
Q.1 to Q.4 displays respectively the average daily booked, the peak booked, the average daily not booked and the trough not booked, all split to workplace types that are part of the controls selection vs. the available number of desks averaged over the reporting period and split to the different day of week (i.e., Sunday to Saturday).
Q.5 displays the data of graphs Q.1 to Q.4 in the form of a table;
Q.6 displays the 5 measures by each day for the reporting period.
“What if Analysis” sheet graphs and tables
This TRY OUT (or Beta-version) sheet builds upon the “KPI Booked” sheet and contains the following:
WHAT IF.1 allows you to ‘reduce’ the actual number of desks that are and historically were made available with a percentage between 0 and 50.
WHAT IF.2 displays the result of your What If scenario (i.e., the reduced amount of the current number of available desks). Note that the result might differ over the historic period, as the calculation reduces the historic value with the indicated percentage of WHAT IF.1.
S.1 to S.3 are the same graphs as A.1 to A.3 of the “KPI booked” sheet. These compare to S.7 and S.8 to derive the consequence of your selected What If scenario for this current and last month.
S.4 to S.6 are the same graphs as A.4 to A.6 of the “KPI booked” sheet. These compare to S.9 and S.10 to derive the consequence of your selected What If scenario for this current and last quarter.
T.1 to T.3 are the same graphs as B.1 to B.3 of the “KPI booked” sheet. These compare to T.7 and T.8 to derive the consequence of your selected What If scenario for this current and last month.
T.4 to T.6 are the same graphs as B.4 to B.6 of the “KPI booked” sheet. These compare to T.9 and T.10 to derive the consequence of your selected What If scenario for this current and last quarter.
U.1 and U.5 display the number of desks that are booked daily as % of the available desks and the What If number of available desks respectively averaged for the current year;
U.2 and U.6 display the peak number of desks that are booked as % of the available desks and the What If number of available desks respectively averaged for the current year;
U.3 displays the number of daily booked and not booked desks vs. the available number of desks for the current year. The measures are averaged to the different days of the week (i.e., Sunday to Saturday).
U.7 displays the What If equivalent without the not booked measure.
U.4 displays the peak number of booked and trough number of not booked desks vs. the available number of desks for the current year. The measures are averaged to the different days of the week (i.e., Sunday to Saturday).
U.8 displays the What If equivalent without the trough not booked measure.