General presentation

This dashboard is the result of the "HR Dashboard" IS project.

Code : 3297

Accolade link : http://biarritz.solvay.com/Pages/Project/Home.aspx?projectid=6070

GBU / Function / SBS	SBS HTR	BRM	DEWILLE, Isabelle
Project Cost (k€)	36K Euro	Customer / Requestor	Davide DelCanale
Requested Start Date	March 2015	Sponsor / Approval
Requested Go-Live Date	Dec 2015	Project Manager	David Tonda

Access for the dashboard

There is no confidentiality on objects/perimeter in the dashboard except for 2 specific tabs :

The expertise tab should only be provided to a selected number of users (not all users by default)
The compensation tabs should only be provided to a selected number of users (not all users by default)

On top of that, most graphics have a restriction not to show any data if the selection corresponds to less than 5 persons (or 25 entries for the "Expertise" as each person has around 5 expertises).

Source location & documentation

All data in the dashboard comes the BW PQ2 (HR BI) server via BW queries, except for the "Talent" sources which are from excel files extracted from the Taleo HR tool.

https://docs.google.com/spreadsheets/d/1oZhwv0w-IW4eH7-ohH0bqsZ-yMi1XorRUtoAvVKvL3E/edit

Important notes

Development plan KPI

This KPI is not shown on any the sheets because at the time the dashboard was developped the source data was not good enough. But the developments and source already exist if needed.

About the Taleo Source

For the talent KPI's, the source of the data is the Taleo tool that HR uses for recrutement.

Taleo is a cloud service (https://solvay.taleo.net/) so it was first tried to extract the data via a web service. But :

After several tests by the web team, it was found to be impossible to load data from their SOAP API.
HTR confirmed that due to our contract, we do not have access to their REST API.

On top of the webservices not beeing usable, it was found that many fields did not share the same codings as the HR BI SAP System (country, GBU, domains...).

Due to those 2 limitations, it was decided to use a monthly manual extraction from Taleo with a manual (by HTR) correction of the values to fit with BI HR :

One with the list of all closed requisitions in the past 2 years
One with the list of CURRENTLY open requisitions.

Links with other dashboards

The training costs (QVHR_ZLSO_MC11_Q0099) and Active/Registered (QVHR_ZPA_C01_Q0027) sources are also used for the SBS Delivery Dashboard.