Resource Utilisation Dashboard

The Resource Utilisation Data Dashboard is a tool designed to you keep track of your resources time, including time spent on various activities, job and driving duration, absenteeism trends, and resource allocation by job type and customer. The dashboard allows you to view data in visualisations that provide insights into how resources are spending their time, and whether they are working within their contractual hours.

With the Resource Utilisation Dashboard, you can allocate resources efficiently and effectively. By identifying absenteeism trends, you can take appropriate action to reduce absenteeism and improve productivity.

Finally, by understanding which job types and customers are taking up most of your resources’ time, you can plan and allocate resources strategically, improving efficiency and profitability.

To access the data visualisation dashboards, you will need to be granted permission. To learn how to grant or revoke access, see the article Business Intelligence Dashboards – BigChange Help Centre.

Availability from Work Hours

Visualisation: Percentage and numerical values showing the duration of Resource availability from their working hours, after excluding their absence hours.

Absence

Visualisation: Percentage and numerical values showing the duration of Resource absence, within their working hours.

Utilised in Available Hours

Visualisation: Percentage and numerical values showing the duration of Resource time spent on jobs and driving on jobs, within their working hours. This chart also shows Assistant's time spent on job.

The assistant's drive time is not recorded on BigChange, and therefore not shown on the dashboard.

Unallocated

Visualisation: Percentage and numerical values duration of Resource unallocated time (i.e. time not spent on driving, job or absence), within their working hours.

This value may be higher when assistants are involved, because assistants don't have a driving duration of their own on the job they are assisting.

Utilised Outside Available Hours

Visualisation: Numerical values showing the duration of Resource time spent on jobs and driving on jobs, outside their available working hours.

Resource Utilisation by Week

Visualisation: Stacked 100% bar chart displays hours on the Y-axis and weeks on the X-axis, based on the selected data range. Each bar represents the percentage of time spent on various activities, including time on the job, driving, absences, and unallocated time. 

This visualisation helps you understand how and where your resources have spent their time for completed weeks. It allows you to see the distribution of time (in both hours and percentages) spent by resources on jobs, driving, absences, and unallocated activities each week.

This chart only reflects utilisation within working hours, and the dates shown on the visualisation represent the week commencing date (i.e. Monday). Only completed weeks will be displayed.

By hovering your cursor over the vertical bars, the percentage split of hours (including actual hours) will be displayed.

Definition of terms

• Job Duration within working hours as a resource is the time as a resource, from when the resource selects Start Job.
• Job Duration within working hours as an assistant is the time as an assistant, from when the resource selects Start Job.
• Driving duration within working hours is the time from when the resource selects “on the way” and until they start the job.
• Absence duration is any time marked as an absence.
• Unallocated duration is the sum of remainder of all time not spent by a resource either on job or driving categories, inside of their working hours. Unallocated time = Available working hours – (job time + drive time + absence time).

Visualisation rules

• Once a job is suspended, no further time is counted until it is re-started.
• If there is no Job and or absence assigned to a resource for a specific day, such days will be excluded from the dashboard.
• If the resource has more than one job scheduled, all time spent on jobs each day will be shown within Time on job activity per day.
• If a resource’s job spans across several days, time is allocated per day. For example, if a job starts on 01/11/2024 at 13:00 and the ends at 03/11/2024 at 8:00 , the activity will be recorded as three different days.
• When a resource starts driving to a job, and then another resource gets allocated to that job, the first resource time count will be ended on that job, and new resources time count will commence . Partial driving time from the first resource will still be counted as driving time for that day.

By selecting a specific activity bar within the chart, you will be provided with a visualisation for that particular week.

By selecting a bar for a particular day/date, you can drill-down into the data, displaying a data grid containing the following data fields:

• • • Resource
    • Resource Group
    • Is Assistant
    • Contact
    • Job Reference
    • Job Type
    • Job Category
    • Date
    • Job Start At
    • Job End At
    • Assistant Start At
    • Assistant End At
    • Resource Job Duration (Hours)
    • Resource Job Duration (Within working hours)
    • Resource Job Duration (Outside working hours)
    • Driving Duration (Hours)
    • Driving Duration (Within working hours)
    • Driving Duration (Outside working hours)
    • Absence Start At
    • Absence End At
    • Absence Duration (Hours)
    • Unallocated Duration (Hours)

Job and driving duration vs available hours

You will be able to see a high-level view of the utilisation status of all resources, providing insight into the proportion of Resource time is spent either driving or at a job. It helps you understand trends in how resources spend time on jobs and driving compared to the total available hours, allowing you to evaluate whether your resources are working over or under their available hours. 

This visualisation allows you to toggle between displaying total time and average time. To switch between these metrics, select the hyperlink at the bottom of the chart.

As a parent chart, you can filter the whole dashboard view by selecting a specific data point within the line chart. The whole dashboard will display metrics and visuals pertaining to that specific data point selection.

Absenteeism trend by week

You will be able to quickly identify any absence trends over several weeks and frequency of absences logged week-by-week.

By selecting a specific bar within the chart, you will be provided with a visualisation of absences for that particular week.

By selecting a bar for a particular day/date, you can drill-down into the data, displaying a data grid containing the following data fields:

• • • Resource Group
    • Resource name
    • Absence date
    • Absence start time
    • Absence end time

Job Duration by category (top 10)

You will be able to identify the average time spent on specific job categories and determine which categories are consuming the most and least time.

Resource Allocation by Job Type (Top 10) - Job Hours

To view Driving Hours by Job Type, select the hyperlink at the bottom of the chart.

Resource Allocation by Contact (Top 10) - Job Hours

Dashboard Global Filters

Dashboard global filters work in a cascading order from top to bottom, meaning that selections made in higher filters affect the options available in the filters below. For instance, if you have a Date Filter at the top and a Parent Contact Filter below it, choosing a date range will update the Parent Contact Filter to show only parent contacts relevant to that date range. If there is another filter, such as a Contact Filter, beneath the Parent Contact Filter, it will further narrow down the options to only those contacts that match both the selected date range and the chosen parent contacts. Think of the filters as a funnel: the top filter sets the broadest criteria, and each subsequent filter narrows down the data further based on previous selections.

• Resource group – Multi selectable, defaults to all.
• Resource name – Multi selectable, defaults to all.
• Date – Custom date range that allows user to filter the dashboard by job completed date. This will include both jobs completed with completed with issues
• Date range – List of pre-existing date range options to select from.

If both date filters are populated, they work in conjunction with each other. Within the visualisations, where week commencing days are shown on X-axis, the dates will start from the Monday of the dates populated on the date filter. For example, If the last 14 days was selected, going back to a Wednesday, the dashboard would show data starting from Monday of that week.