Presentation

History

The HR Dashboard was built by SBS IS in 2015 via the "HR Dashboard" Project (Code 6070). Sponsor was the SBS HTR Analytics team.

Scope

Target Audience : HR Family council, HR Leadership team.
Data Accuracy : The dashboard reflects the results of the BI HR reports (Solia HR E-services), but with a monthly and not a daily update.
Historical Scope : The dashboard contains data only for the current and previous year (Meaning between 13 and 24 months total).
No data before Jan 2014 was included due to poor quality.

Data Update

The data in the dashboard are updated monthly, every 7th of the month for main data, and 11th of the month for Learning data only.

Accessing the HR Dashboard

The dashboard can be accessed via the Qlikview Access point and then selecting the “HR Dashboard”

http://qlikview.solvay.com/index.htm

If you do not see the dashboard in the Qlikview Access point, it means you do not have access to it.

You can request the access via this online form :

https://jfe.qualtrics.com/form/SV_9MjnvJNmiv4W1BH

Confidentiality

Due to confidentiality reasons, if your selection corresponds to less than 5 active employees, some graphics will show this "Autorization Condition Unfulfilled" message.

In that case you need to change the filters to display more than 5 persons.

Access Approval

Note that since this dashboard contains confidential data, your access request will be submitted for approval to the SBS HTR Analytics team.

Dimensions Availability

Due to the data structures, some dimensions are not available for all indicators

The Month is not available for all indicators in the "Performance" Tab (PDCR is a yearly process).
The Talent Group is not available for the "Performance" Tab.
The Individual Objectives and Nature of Contribution results are available only for the "Performance" Tab.
The Learning Domain, Delivery Method, Type of Learning and Budget Type are only available for the "Training" Tab.
The Assignment Type is only available for the "International Mobility" Tab.

Filtering

If you filter on these dimensions, some indicators will be empty

Dimensions Definitions

The official HR definitions of each dimension can be found in the Solvay Core Global template :

http://teamsites.solvay.com/sites/GlobalHR/HR_Management_Public/Solvay_Core_Global_Template.doc

Dimension	Explanation	Example
Entity Grouping	Grouping of organizational Entites in GBUs and Functions	GBU Novecare / F Industrial / Solvay Business Services
Entity	Organizational Entities	SBS IS Infrastructure
Entity Type	Classification of entities	Business / Function
Cluster	Grouping of Entity Grouping	Advanced Formulations
Functional Area	Previously called Domain	Information & Knowledge
Job Family	Previously called Sub Domain	Information & Knowledge Management
Region	Geographical region of the employee Note that for expatriates, this may change depending on if you are looking at Registered or Active numbers	Europe
Country	Country of the employee Note that expatriates, this may change depending on if you are looking at Registered or Active numbers	France
Site	Site (Location) of the employee	Aubervilliers CR
Company	Legal Entities	Rhodia Operations
Employee Group	Grouping of employees	Regular / Expatriate / Trainee
Employee Type	Type of employees : Cadre, Employe, Ouvrier ...	Cadre
Mgt Level	Management Level - Grouping of Grades : Junior : S15 to S18 Middle : S19 to S22 Executive : S23 to S27	Junior
Talent Group	Definition can be found in the DPS Reference Guide	Growing HIPO
Gender	Gender of the employee	Male / Female
Nationality	Nationality of the employee	French

Time Dimension

By default the dashboard opens with the full current year selected.

You can change that selection on top bar :

Tabs & KPI Definitions

Dashboard

Dashboard KPIs

Total "Active" - Shows the total number of employees for the last month of the selected period. Can be changed from Active to Active FTE or Registered via the radio button.
Nb of Nationalities - Shows the total number of different nationalities in our employees.
% Female - Shows the % of female employees for the last month of the selected period. Can be changed from Active to Active FTE or Registered via the radio button.
% Key Positions / Cadres - Shows the percentages of cadres that are flagged as Key Positions.
Avg Nb Learning Hours - Average Number of Learning hours during the year (Note that this indicator is yearly whereas the others are monthly).
Total Turnover - Shows the monthly turnover for the last month of the selected period (See Turnover paragraph for details)

Employees by Region

Shows the number of employees by Region for the selected period.

The graph will show the number of Active, or the number of Active FTE, or the number of Registered depending on the option selected in the right menu :

It is also possible to see the detail by Country when a Region is selected.

In the case where several months are selected, the graphs shows the latest month in that period.

Employee Evolution

Shows the evolution of the number of employees and % of female by month.

The graph will show the number of Active, or the number of Active FTE, or the number of Registered depending on the option selected in the right menu :

Age Distribution

The graph shows the number of employees (Active, Registered or Active FTE) by groups of ages and gender (green for men, orange for women).

Note that the age is the current age of the employee whatever the period selected.

Ex : if we are in December 2015 and you selected period Jan 2015, the graph will show the current age distribution of all the persons that were employed in Jan 2015.

The calculation is based on the number of Active, or the number of Active FTE, or the number of Registered depending on the option selected in the right menu :

The global average age can be found in the top right corner

Distribution by Mgt Level / Employee Type / Nationality

This graph shows the distribution in numbers of employee by 3 dimensions :

Management Level (Non Cadre / Junior : S15 to S18 / Middle : S19 to S22 /Executive : S23 to S27)
Employee Type
Nationality (Only top 10 showing - but you can scroll down).

In all 3 cases the colors shows the distribution by gender.

If several months were selected, it will show the values for the latest month.

The calculation is based on the number of Active, or the number of Active FTE, or the number of Registered depending on the option selected in the right menu :

Potential

Potential KPIs

Note : The calculation for Potential KPIs is based on the number of Active. Only Employee Type = Cadre are included.

Definitions for Talent Groups and Key Position can be found in the DPS Reference Guide.

Key Positions

This shows the number of cadre employees that are identified to be in Key Positions. Number shown is the situation as in the last month of the selected period.

The second number (between parenthesis) is the % of cadres in Key Positions.

High Potential Pool

This shows the % of cadre employees that are identified as High Potential. The second number (between parenthesis) is the total number of cadres in High Potential pool.

This includes the Talent Groups : HIPO for GBU/FU, HIPO, and Growing HIPO.

% Key Positions with Successor

Shows the percentage of Key Positions which have at least one successor identified.

% Cadres with Talent Group

Shows the percentage of Cadres Active employees that have a Talent Group assigned.

Cadres By Talent Group

This graph shows the distribution in numbers of the cadre employees per Talent Group. Number shown is the situation as in the last month of the selected period.

Definitions for the Talent Group and High Potential Pool can be found in the DPS Reference Guide.

The calculation is based on the number of Active.

Note : Only Employee Type = Cadre are included.

Performance

Performance Year

Note that there is a 1 year shift in the year selection : If you select 2015, it will show the Performance for 2014 (as the assessment is always done for the previous year).

Performance KPIs

PDCR Completed : Shows the % of PDCR that were already completed this year (and previous year below).
The number in parenthesis shows the actual count.
Individual Objectives Average : Shows the average Individual Objectives score.
Nature of Contribution Avg : Shows the average Nature of Contribution score.

Scoring used is :

Individual Objective Score	Individual Objective Description
0	Not applicable --> Not taken into account in the average.
1	Unsatisfactory
2	Partially Successful Achievement
3	Successful Achievement
4	Exceeds Expectations
5	Exceptional Achievement

Nature of Contribution Score	Nature of contribution Description
0	Not applicable --> Not taken into account in the average.
1	Trails
2	Acquires
3	Master
4	Steers
5	Transforms

Individual Objectives

The bar chart shows the distribution by Individual Objective.

Nature of Contribution

The bar chart shows the distribution by Nature of Contribution.

Learning

Learning KPIs

Avg Cost per Employee : Average cost of Learning per employee (Total Cost for the year / Avg of Active Employees) for the current year (and previous year below)
Avg Learning H per Employee : Average number of hours of Learning per employee (Total Number of Hours for the year / Avg of Active Employees)
Total Learning Cost : Total Learning cost for the current year (and previous year below)

Total Training Hours / Cost

The calculation is based on the number of Active.

The pie chart shows the distribution of 2 indicators:

Total Hours (Including Web Based Trainings)
Total Cost

You can change from one to the other via the selection :

By default the distribution is by Learning Domain but it can be changed via the cyclic selection :

International Mobility

KPI Average Duration

Average Duration for expatriation for the last selected Year

Assignments by Home/Host Location

This cross table shows the number of International Assignments for the last month or selected period, by Home/Host Location.

You can switch from Region to Country or Assignment Type using the cyclic :

Map by Host Country

This Map shows the assignments by host country for the last month or selected period.

The bubble size is based on the number of impatriates (host country).

It is possible to display the name of the Country and the number of Assignments by moving the cursor on the bubbles.

HIPO Scope Mobility

This chart shows the number of assignments for High Potential pool (HIPO for GBU/FU, HIPO and Growing HIPO), for the last month or max selected period.

Assignments by Duration

This chart shows the total number of International Assignments for the last month or max selected period, by Duration in year.

Turnover

Turnover KPIs

Total number of Entries for the selected period (for the year if no month or quarter is selected)
Total number of Leavings for the selected period
Total number of Voluntary leavings for the selected period
Total number of Involuntary leavings for the selected period

Entries & Leavings

Shows the number of entries and leavings (with detail of Voluntary/Involuntary) by month :

Leavings are shown as negative bars
Entries are shown as positive bars

The numbers are based on the Registered employees.

Rolling Month Turnover

The rolling turnover is calculated as the ratio of the number of Leavings over a 12 month rolling period with the average Registered employees over the same 12 rolling months.

Turnover = Sum Leavings 12 rolling months / Avg Registered 12 rolling months.

The graph shows 3 lines :

Voluntary Turnover
Involuntary Turnover
Total Turnover = Voluntary + Involuntary Turnover

Apprentices, Trainees and Students are excluded from this indicator.

Before Jan 2015

Note that the rolling turnover value before Jan 2015 is not accurate (due to poor data quality before Jan 2014).

Page tree

HR Dashboard