Skip to main content

Data Normalization

Categorize your data to calculate specialized indicators or activate benchmarking

Virginie Huaranca avatar
Written by Virginie Huaranca
Updated over a week ago

Introduction

Link to your Reflect account : https://app.getreflect.io

💡This guide is intended for Reflect account administrators or data managers.

Some HR indicators require a little work on your part in order to be calculated correctly by Reflect.

Exemples

Here are common scenarios where Reflect can't calculate an HR indicator without additional normalization :

  1. Absence Management : Your HRIS might have dozens of absence reasons. Reflect needs to know if these are :

    (vacation, maternity leave)

    (sick leave, accidents)

    ➡️ Without this classification, Reflect cannot calculate your company's absenteeism rate.

  2. Employment Types : Source values are not standardised for your contract types. Reflect doesn't clearly identify contracts that are permanent contracts.

  3. Recruitment Sources : In your ATS, you have numerous sources of applications, for which Reflect cannot always identify whether they correspond to :

Solution

Due to the lack of consistency across various software platforms, source values must be unified to calculate certain KPIs accurately. To solve this, Reflect has established a universal HR standard: Data Normalization.

This process involves mapping your specific source entries to Reflect’s standardized categories. By classifying your data into these shared, actionable categories, Reflect can reliably calculate critical metrics such as absenteeism, permanent headcount, gender equality indexes, and regretted attrition.

How it works?

Normalizing your data

To begin, navigate to the normalization page. You will see a table containing the source values from your software for the selected data category.

⚠️ Some data categories (like absences) may require multiple normalizations for different purposes.

You can find an explanation for each specific normalization by clicking "?" icon next to the column.

💡Use the date range selector in the top right to only view source values that appear during a specific timeframe. This is helpful to avoid worrying about legacy data from a distant period.

To modify a dimension's normalisation, click "Edit mappings" button. Mapped value column will then become editable.

Each box is then a drop-down list, and you choose a normalized value for each source value.

Select a black value.

A normalization refers to a column; you have to select the correct values for all source values that belong to the specific column.

⚠️ Once your changes are complete, don't forget to click "Save mappings" button in the top right.

Monitoring Your Data Quality

Status Indicators

On your dashboards or legal reports, you may see a specific warning symbol next to an indicator.

By clicking on it, a window opens showing various standardizations required to reliably calculate this indicator :

Click on one of the lines to open the associated normalization in the settings.

Completion Bar

Without complete normalization, Reflect cannot guarantee the reliability of some indicators.

To help you track the current status of your normalization, a completion bar is displayed on the data normalization page :

It shows what percentage of source values are normalized. It updates in real time.

Updates

Once saved, normalization is not updated immediately.

You must wait until the next data update in Reflect before the normalization is taken into account.

Once normalization is complete, your indicators will be reliable, including historical data !

However, if new source values are added to your source software, you will need to regularize the new values in Reflect.

Please don't hesitate to visit normalization page periodically.

Did this answer your question?