Presentation
History
The HR Dashboard was built by SBS IS in Q2-Q3 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 ...
To be reviewed with Davide
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 | Advanced Formulations | |
| Entity Type | Business / Comex | |
| Functional Area | Information & Knowledge | |
| Job Family | Accounting | |
| Employee Group | Expatriate / Trainee | |
| Employee Type | Cadre | |
| Mgt Level | Management Level - Grouping of Grades :
| Junior |
| Talent Group | Growing HIPO | |
| Gender | Male | |
| Nationality | 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
Employee Actions
Registered/Active/Active FTE Employees Evolution
Shows the progression month by month of the number of employees. 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 :
Note that this grah will show both current and previous year independently of what year you have selected.
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.
Employee Turnover
This graph shows the employee turnover by month.
Apprentices, Trainees and Students are excluded from this indicator.
You can choose between 2 calculations/displays using the radio button :
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.
On this display the distinction between voluntary and involuntary is also shown.
Before Jan 2015
Note that the rolling turnover value before Jan 2015 is not accurate (due to poor data quality before Jan 2014).
Monthly Turnover
The monthly turnover is calculated as the ratio of the month leavings with the number registered employees at the end of the same month.
Turnover = Month Nb of Leavings / Nb of Registered Employees at end the month
Employee Profile
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 :
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 per select dimension
This graph shows the distribution in numbers of employee by the selected dimension.
By default it's the distribution by Management Level, but you can change it by selecting a different dimension in the cyclic :
Whatever the dimension selected the colors show the distribution by gender (Blue for men, Red for women).
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 :
Employee Evolution
This graph shows 2 distinct information :
- The evolution of the number of Active/Active FTE/Registered employees : it shows the situation for each month. The axis used is on the left.
- The evolution of the % of women in the Active/Active FTE/Registered employees. It shows the situation for each end of the month. The axis used in on the right.
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 :
Talent Tab
High Potential Pool
This shows the total number of cadre employees that are identified as a High Potential in the last month of the selected period. This includes the Talent Groups : HIPO for GBU/FU, HIPO and Growing HIPO.
Note : Only Employee Type = Cadre are included.
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 :
Key Positions
This shows the total 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.
Note : Only Employee Type = Cadre are included.
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 :
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.
Note : Only Employee Type = Cadre are included.
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 best way to get IT support is to use the new
Service One Platform.