Advanced Analytics
Updated 6 months ago
by
Daniel Sjögren
Introduction
Advanced Analytics offers a set of dashboards for you to visualize and analyze your WFM-related data to see trends across your business. The dashboards are found under the Analytics tab within Quinyx:
To be able to access Advanced Analytics, you must have the Advanced Analytics module activated for your organization. If you are unable to see these dashboards, please contact your account representative.
The dashboards are broken down into three main categories:
Optimization: These dashboards are focused on core WFM metrics such as scheduling, absences, and costs.
Compliance: These dashboards will be focused on helping businesses check their compliance adherence.
Engagement: (Coming soon!) These dashboards will be focused on helping businesses understand the engagement level of their workforce.
Before anyone can see any of the dashboards, you first need to enable the permission for specific roles. See below.
Advanced Analytics Setup
By default, the dashboards will be turned off. You can decide who can access the dashboards by enabling the permission for Advanced Analytics under each Role, found under Account Settings > Role Management > Edit Role.
Note that currently, there is no difference between read and write permissions, as all data presented in Advanced Analytics is read-only.
- Go to Account settings.
- Select Role management.
- For the selected role, click Edit role.
- This will open permissions, where you’ll be able to see Advanced Analytics modules: Optimization, Compliance & Engagement (Coming Soon!).
- Select the relevant module.
Once you’ve set permissions, go to the Analytics tab, and you should have the relevant module live:
KPI Definition
Optimization
Scheduled vs. Worked hours
Scheduled hours are calculated as the difference in hours between the start of the shift and the end of the shift. Breaks are deducted from total scheduled hours if they do not count as working hours based on the agreement and settings.
Further criteria for Scheduled hours calculation:
- Based on customer agreements and schedule settings breaks are either counted or not counted.
- Notice of Interest (NOI) is not included.
- Only include productive hours.
Worked hours are calculated as the difference in hours between the start of the punch and the end of the punch. They only include hours that count as worked hours according to the settings on the connected shift.
Deviation hours are calculated as a difference in hours between Scheduled hours & Worked hours.
Overtime & Unsocial Time Hours
These hours are calculated based on time allocated to the following OT and UT codes:
OT Codes: 1030, 1031, 1032, 1033, 1034, 1090, 1091, 1092, 1093, 1094, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195
UT Codes: 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227
Absence Hours
Absence hours are calculated as the total number of absence hours from scheduled hours.
Shifts Type Hours
Total number of scheduled hours per shift type varied by customer business. For example, Store, Back Office, etc.
Labor Costs
Total labor costs from worked hours of employees, such as Monthly Salary, Overtime, Vacation, social costs, etc.
Compliance
Schedule
Number of violations: This will be a total count of violations that have been flagged
Types of violations: This is a count of the different violations types that have occurred
Using the dashboard
On the left side of the application, you can navigate between the various dashboards under each category by clicking on the blue links under the heading:
By default, the page will be loaded for the whole business, showing a visual summary of all districts and units in the widgets at the top of the page and a District and Unit overview further down the page. The data set is refreshed overnight to match what has occurred within Quinyx.
You will also find a set of contextual filters at the top of the page that will affect the entire dashboard, such as the ones below:
You can add a filter by clicking into the applicable filter box, typing to search or scrolling through the list of available options, and then ticking the checkbox beside the option you want to select. Once you add a filter, you will see a '"link" icon to highlight the fact that the selectable options in this filter option are restricted by the previous filter you have added.
You need to click the refresh icon on the far right to reload the dashboard with the selected filters:
To remove filters, click on the ellipsis icon on the right right and select Reset filters:
Inside each widget, you will see an information icon. Hovering over this icon will display a definition of the selected metric to help you understand what the data represents:
Hovering your mouse over the data inside the widget will also display a tooltip showing the details of that specific data point:
You can also click on particular data points inside relevant widgets to instantly apply a filter to the dashboard and add/remove that data point from the visualizations:
You can also drag and drop over a specific date range to update the dashboard to focus on the data in this specific timeframe:
Data is also displayed in tables, and clicking on a table heading will change the sorting order inside the table:
Downloading Reports
There are two ways to download data from Advanced Analytics. You can download an entire dashboard, or just the data in a specific tile.
Downloading an entire dashboard
To download data from an entire dashboard, click the three dots at the top right of the screen and select Download.
This will open a new window allowing you to choose your download settings.
You can choose between a PDF and CSV file type and the paper size for ease of printing.
Expand tables to show all rows will ensure all data is shown even on large tables that do not fit on the page.
Arranging dashboard tiles in a single column is also useful for ease of printing.
When you're ready to download the dashboard data, click Download. A new tab will open showing the status of the download and when ready, your file will be saved to your computer.
Downloading data from a single tile
To download data from a single title, click the three dots at the top right of the specific tile and select Download.
This will open a new window allowing you to choose your download settings.
You can choose between different file types: TXT/Excel/ CSV/JSON/HTML/Markdown/PNG.
Under 'Advanced data options' you can also select various formatting types.
When you're ready to download the dashboard data, click Download. A new tab will open showing the status of the download and when ready, your file will be saved to your computer.
Scheduled Delivery
It is possible to set a schedule for when data from these dashboards is to be delivered to a particular place such as an email address.
To do this, click the three dots on the top right of the page and select Schedule Delivery
This is open a new window with options you can set relating to the frequency of the delivery, the destination and format.
Under Filters you can decide which parts of the report to deliver.
Under Advanced options you can add a custom message and adjust the page display options.
Once you have filled out your options and are ready to activate the schedule, click save.
Alerts
Alerts can be set for specific data tiles to notify you when data thresholds are met.
To set an alert, hover over the tile on the dashboard and click the alert icon.
Note that alerts can be set only on tiles that have at least one numeric measure or table calculation in the tile’s visualization.
This will open a new window allowing you to configure options for the alert.
You can now set your conditions, options where to send the alert and the frequency.
Once you have clicked save, or if you already have scheduled deliveries setup, you will see a window similar to the one below:
Clicking on the three dots will allow you to edit or delete the existing schedule.
Clicking Send now will send the report instantly.
