Hybrid Data Hub - Introduction & Data Options (Filters, Drill Down, Export)

OfficeRnD Data Hub is divided into several dashboards, giving you a detailed overview of the most important metrics. It helps you understand the usage of your desks and spaces, spot resources that are under/over utilized, and optimize your real estate to cust costs.

Knowing if the office capacity is hit or there are not enough meeting rooms will allow you to craft your strategy to boost employee collaboration and satisfaction.

You can also monitor the office presence of your employees and help them adhere to your office policy.

In this article

overview new.png

 

What data can you analyze?

Here is a short summary of what data you can analyze:

  • Track past and future bookings and the office presence of employees and teams.
  • Narrow down the results by employee and team.
  • Analyze the utilization per neighborhood.
  • Filter the utilization of desks and spaces per resource type and neighborhood.
  • Take advantage of the many utilization views (yesterday, last week, last month, weekly, and monthly).
  • See bookings by originating source and recurrence type.
  • See all occurrences of a recurring booking.

 

Dashboards

The data in each dashboard is updated every 2 hours.

You can find these useful dashboards in the Data Hub datahub mod.png module of the Admin Portal:

  • Overview - the general one, displaying a summary of key metrics for Desks, Spaces, and Employees. From this dashboard, you can see the number of bookings per employee and team. 
  • Desks – shows metrics for resources defined as Desks on the Office Maps. If you have multiple such resources, you can use filters to narrow them down to a specific resource type or resource. The dashboard is focused only on bookable resources and doesn’t include assignable resources.
  • Spaces – shows metrics for resources defined as Space on the Office Maps. If you have multiple such resources, you can use filters to narrow them down to a specific resource type or resource. The dashboard is focused only on bookable resources and doesn’t include assignable resources.
  • Employees - track desk bookings, related metrics, and Workplace Policy compliance for a particular employee.
  • Workplace Policy Compliance Overview – Track employee compliance with office-day requirements. You can narrow it down to a specific policy, team, or employee to see how/when they come to the office.
  • Workplace Policy Detailed View - track employee compliance based on presence requirements.

 

Schedule report deliveries and alerts

 

Additional Options

The following options are available in each dashboard:

 

Filters

Each dashboard has several filters in the top bar allowing you to narrow down data in the widgets. You can look into different periods of time, locations, resources, teams, and employees. Choose your filters and click Refresh ref.png to update the results.

filters2.gif

The action buttons on the right of the top bar let you refresh the widgets ref.png , show or hide the filters showhide.png , and access a menu Tile opt.png with options to download data from the entire dashboard and reset the filters:

resetf.png

 

Drill down data

You can click on specific values in the Data Hub utilization widgets to get a detailed breakdown of the data. This feature gives you deeper insights into resource usage, helping you analyze trends and performance at a granular level.

You can drill down data in the following widgets:

  • Overview Dashboard: Utilization Rate, By Resource Type; Daily Utilization Rate, By Resource Type

  • Desk Dashboard: Daily Desks Utilization; Weekly/Monthly Desks Utilization Rates; Neighborhood Utilization Rates

  • Spaces Dashboard: Daily/Weekly/Monthly Spaces Utilization Rates

Hybrid Data Hub–Drill Down data.gif

 

Download Data From The Entire Dashboard

Data from the dashboard can be exported in PDF or CSV format. PDF export lets you choose the document properties - paper size, show all rows, and arrange tiles in a single column.

download all.png

 

Download Data From a Single Widget

Click on the Tile Actions button Tile opt.png to the right of any widget and choose Download data from the menu. The Download Data dialog opens with several options to format the exported data according to your needs:

download util.png

The following file formats are offered:

  • TXT (tab-separated values)
  • Excel Spreadsheet (Excel 2007 or later)
  • CSV
  • JSON
  • HTML
  • Markdown
  • PNG (Image of visualization)

You can also specify a custom range of rows and columns from which to export data. Up to 5000 rows can be downloaded.

numberofrows.png

 

Select and Zoom

Click and drag inside a widget to zoom in on a particular part of the chart. Click on the Reset Zoom button to restore the original view.

zoom.gif

 

Expanded View

Each widget can be opened in Expanded View. Click on the Tile Actions button Tile opt.png and select View>Expanded.

expanded.gif

 

Was this article helpful?
3 out of 4 found this helpful
Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.