Syensqo IS - Customer Support

Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Presentation

History

The HR Dashboard was built 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

Accessing the 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

Navigation

Dimensions availability

Access Approval

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

 

 

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

  • The Month is not available for all indicators in the "PDCR" Tab (PDCR is a yearly process).
  • The Talent Group is not available for :
    • PDCR - Individual Objectives
    • PDCR - PDCR Completion
  • The Learning Domain, Delivery Method, Type of Learning and Budget Type are only available for the "Training" Tab.

Filtering

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

Dimensions definitions

http://teamsites.solvay.com/sites/BSCPDP/CCB%20EuHReka/Forms/Reporting.aspx

Time dimensions

 

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. The 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 Voluntary Leavings / Avg Registered over 12 rolling months.

Apprentices, Trainees and Students are excluded from this indicator.

Before Jan 2015

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

Employee Profile

Gender Balance

Shows the % distribution of employees by Gender for the last month in the selected period

Ex : i 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 best way to get IT support is to use the new Service One Platform.