The Deputy Analytics reports are built on datasets. When building custom reports you use these same datasets as the building blocks of the report to add elements such as tables and graphs.
This article gives a brief overview of the kind of data contained in each dataset.
- Where do I find the Deputy datasets?
- Deputy datasets
- How do I find out exactly what data is in each column in each dataset?
Where do I find the Deputy datasets?
When you add a data element to a customised report you will need to select a data source for the data.
1. Click on Add element.
2. Select the data element you wish to add such as a table, chart or pivot table. You will then have the opportunity to select a data source.
Click on Tables and Datasets.
3. The Deputy Datasets are listed.
The below sections in the help article discuss the data contained in each dataset and you can also preview the dataset to see exactly what columns of data are contained in each dataset.
Deputy Datasets
Current number of employees
| What do the single rows of data represent? | Your business in Deputy |
| What do the columns of data represent? | The total number of employed employees in your business |
| Deputy reports that use this dataset as a source: |
Employee audit
| What do the single rows of data represent? | A single audit log change related to the aspects of the employee profile |
| What do the columns of data represent? |
Data related to the team member profile information and the user modifying the profile |
| Deputy reports that use this dataset as a source: |
Employees
| What do the single rows of data represent? | A single team member in the business |
| What do the columns of data represent? |
Data related to the team member including their:
|
| Deputy reports that use this dataset as a source: |
Journals
| What do the single rows of data represent? | A single journal entry |
| What do the columns of data represent? | Data related to a journal entry, who created the entry and the related team member |
| Deputy reports that use this dataset as a source: |
Leave balance summary
| What do the single rows of data represent? | The leave balance and upcoming leave for each team member, aggregated per leave type in hours and days |
| What do the columns of data represent? |
Data related to a team member's leave policy, along with their:
|
| Deputy reports that use this dataset as a source: |
Leave requests
| What do the single rows of data represent? | A single component of a Leave requests (ie. Pay Lines such as a half day of Sick leave and half day of Annual Leave) from a leave request and its corresponding Leave Timesheet |
| What do the columns of data represent? |
Data related to the leave request, along with:
|
| Deputy reports that use this dataset as a source: |
Leave timesheets
| What do the single rows of data represent? | A single leave timesheet for a team member |
| What do the columns of data represent? |
Data related to the leave timesheet, along with:
|
| Deputy reports that use this dataset as a source: |
Shift audit
| What do the single rows of data represent? | A single audit log change in relation to a shift |
| What do the columns of data represent? |
Data related to the shift and the user modifying the shift, along with:
|
| Deputy reports that use this dataset as a source: |
Shifts
| What do the single rows of data represent? | A single shift in Deputy |
| What do the columns of data represent? | Data related to the shift, along with:
|
| Deputy reports that use this dataset as a source: |
Shift, timesheets & sales
| What do the single rows of data represent? | Represents hours & costs related to shifts & timesheets alongside sales data, aggregated to a daily level. |
| What do the columns of data represent? | Data related to shifts, timesheets, sales and costs |
| Deputy reports that use this dataset as a source: |
Tasks
| What do the single rows of data represent? | A single task |
| What do the columns of data represent? | Data related to individual tasks and group tasks along with task completion actions |
| Deputy reports that use this dataset as a source: |
Timesheet audit
| What do the single rows of data represent? | A single audit log change in relation to a timesheet |
| What do the columns of data represent? |
Data related to the timesheet and the user modifying the shift, along with:
|
| Deputy reports that use this dataset as a source: |
Timesheet geolocation audit
| What do the single rows of data represent? |
Represents a single event at either:
|
| What do the columns of data represent? |
Data related to the team member, timesheet and geolocation information, along with:
|
| Deputy reports that use this dataset as a source: |
Timesheet geolocation map
| What do the single rows of data represent? |
Represents a single event at either:
|
| What do the columns of data represent? | Geolocation details of Locations, Areas, Timesheets |
| Deputy reports that use this dataset as a source: |
Timesheets
| What do the single rows of data represent? | A single timesheet in Deputy |
| What do the columns of data represent? | Data related to the timesheet, along with:
|
| Deputy reports that use this dataset as a source: |
Training modules
| What do the single rows of data represent? | A single training module in a business |
| What do the columns of data represent? | Data related to training modules and the areas they are assigned to |
| Deputy reports that use this dataset as a source: |
Training records
| What do the single rows of data represent? | A single training record that a team member has completed, including expiry information. |
| What do the columns of data represent? | Data related to training modules, training records and team member information |
| Deputy reports that use this dataset as a source: |
How do I find out exactly what data is in each column in each dataset?
Some of the datasets have so many columns that it would be unwieldy to list them all in this article. The easiest way to find a list of the data in each column in a data set is to open a blank custom report.
1. From the left-hand side menu click the + icon.
2. Give your report a name, click on Blank template and click Create report.
3. Add a data element such as a Table. When selecting the source for the table you will be presented with the list of datasets and you can click Preview to view the data in each dataset.