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 : This dashboard is aimed at the HR Directors of each GBU/Function as well as the GBU Presidents and Functions Directors.
- Data Accuracy : The dashboard reflects exactly the results of the BI HR reports (Solia HR E-services Reports).
- Organisational Scope : The dashboard reflects exactly the scope of the BI HR reports (Solia HR E-services Reports).
- 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 qualtity.
Data update
The data in the dashboard is updated every 11th of the month.
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 | ||
| Region | Geographical region of the employee. Note that 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. Note that expatriates, this may change depending on if you are looking at Registered or Active numbers. | Aubervillier CR |
| Cluster | Grouping of Entity Grouping | Advanced Formulations |
| Entity Type | Classification of entities | Business / Comex |
| Functional Area | Previously called Domain | Information & Knowledge |
| Job Family | Previously called Sub Domain | Accounting |
| Employee Group | Grouping of employees | Expatriate / Trainee |
| Employee Type | Type of employees : Cadre, Ouvrier ... | Cadre |
| Mgt Level | Management Level - Grouping of Grades :
| Junior |
| Talent Group | Definition can be found in the DPS Reference Guide | Growing HIPO |
| Gender | Gender of the employee | Male |
| Nationality | Nationality of the employee | French |
Time dimensions
By default the dashboard opens with the full current year selected.
You can change that selection on top bar :
Tabs & KPI definitions
Dashboard
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 :
Region can also be replaced by Country via the cyclic.
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 :
Dashboard - Right side indicators
- 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.
- Total Turnover - Shows the monthly turnover for the last month of the selected period (See Turnover paragraph for details)
- % 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 / Cadre - Shows the percentages of cadres that are flagged as Key Positions.
- Nb of Nationalities - Shows the total number of different nationalities in our employees.
Diversity
Gender Balance
Shows the % distribution of employees by Gender for the last month in the selected period
Ex : If you selected 2015 Q1, it will show the distribution of 03.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 :
Note : Not Assigned means that the gender was not correctly set in the HR systems.
Age Distribution
The graph shows the number of employees (active, registered or Active FTE) by groups of ages and gender (Blue for men, red 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 / Type / Nationality
This graph shows the distribution in numbers of employee by 3 dimensions :
- Management Level
- 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
High Potential Pool
This shows the %of cadre employees that are identified as a High Potential in the last month of the selected period.
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.
The calculation is based on the number of Active.
Definitions for the Talent Group and High Potential Pool can be found in the DPS Reference Guide.
Note : Only Employee Type = Cadre are included.
Key Positions
This shows the percent 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 total number of cadres in Key Positions.
The calculation is based on the number of Active.
Definitions for the Key Position can be found in the DPS Reference Guide.
Note : Only Employee Type = Cadre are included.
% Key Positions with Successor
Shows the percentage of Key Positions which have at least one successor planned.
The calculation is based on the number of Active.
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).
Individual Objectives
The bar chart shows the number of employees by Average Individual Objective.
Nature of Contribution
The bar chart shows the number of employees by Nature of Contribution.
Performance - Right sides 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.
- Natrue 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 |
Learning
Learning Top KPIs
- Avg Cost per Employee : Average cost of training per employee (Total Cost / Nb of Employee) for the current year (and previous year below).
- Avg Cost per Training Hour : Average cost of 1 training hour. This excludes Web Based Trainings (As the cost is always zero)
- Avg Training H per Employee : Average number of hours of training per employee (Total Number of Hours / Number of Employees)
Avg Hours / Avg Cost per Employee
The calculation is based on the number of Active.
The bar chart shows 2 indicators :
- Avg Hours : Average number of training hours per employee = Total Hours / Nb of active Employee
- Avg Cost : Average cost (Euro) per employee = Total Cost / Number of Active Employee
You can switch from one to the other with the selection :
By default each bar represents one Management Level, but it can be changed to Gender via the cyclic selection :
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 :
Turnover
Entries & Leavings
Shows the number of entries and leavings (with detail of volontary/Involontary) 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 = 12 rolling months Leavings / Avg Registered over 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).
The best way to get IT support is to use the new
Service One Platform.