What are Analytics?

Description of analytics.

The basic Dataviews in Timekeeping provide transactional data, such as the count of exceptions on a timecard. But sometimes the basic data is not sufficient. For example, a manager might want to review only specific types of exception, to compare departments or other location types based on their org structure, or to compare Late In exceptions by part-time workers to Late In exceptions by full-time workers.

Analytics provides a rich subset of metrics and KPIs, including targets and thresholds that can help customersbetter manage their labor force.

Over 100 standard metrics and KPIs are provided, covering the following subject areas:

• Overtime Hours & Costs (Actual, Scheduled, Projected)
• Absenteeism Hours & Costs (Actual, Scheduled, Projected)
• Exception Counts & Hours
• Productive (Worked) Costs & Hours (Actual, Scheduled, Projected)
• Non-Productive Costs & Hours (Actual, Scheduled, Projected)
• Rounding Rule Analysis

The standard metrics and KPIs are configurable in the sense that you define which pay codes count towards the defined metrics and KPIs.

Analytics also includes an administrative interface, KPI Builder, for configuring and creating metrics and Key Performance Indicators (KPIs) that can provide the detailed information that managers need.

A domain function performs the role of an Extract, Transform, and Load (ETL) procedure in that it extracts data from a data source in the Timekeeping transactional database, applies business logic to the data (that is, transforms it) to add value to it, and loads the resulting metric into the Analytics data repository.

In the following illustration, the Actual Hours domain function extracts data from the Actual Hours data source (the PAY_CODE_TOTAL table in the transactional database), and transforms the data through business logic to create the five metrics listed. Ultimately, calculations are applied to the metrics to create Key Performance Indicators.

Analytics is fully integrated into Timekeeping Information Access. Dataviews, reports, and dashboards all provide access to metrics and KPIs. Metrics and KPIs share a common set of dimensions and attributes, such as Employee, Org, and Date/Time) with Dataviews. Moreover, all Dataview functionality, including grouping, filtering, sorting, and pivoting apply to metrics and KPIs

A key feature of the KPI Framework is its ability to provide real-time updates to all metrics and KPIs, whether standard or custom. Timekeeping, Scheduling, and other product transactions will immediately trigger the system to process the data and recompute all metrics and KPIs in real-time to ensure that the data is accurate and up-to-date when it is consumed through Dataviews, reports and dashboards.