Presentation

The Facilities Dashboard (project code 6833) was designed in 2017 to help monitor Facilities Sites (headquarters).

Dashboard owners: Ana Cordeiro, Veronique Cock.

Scope

The Dashboard displays current and previous year, and it is reloaded once a month on the 10th of the month.

Target Audience: Facilities Excellence Function (around 12 users).

Security: the users have access to all or nothing in this dashboard (no specific confidentiality).

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

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 (it will be submitted for approval to the dashboard owners). 

Sources

The Facilities dashboard displays data from the BW HR system (Headcount), BW Fixed Costs query, Google Spreadsheets for Facilities Budget and mapping, and Archibus (FMIS tool). All theses sources are reloaded once a month on the 10th of the month.

QV - Facilities Dashboard - Sources File

Mapping Files

 4 Google Spreadsheets are available to do the mapping between the different sources of the dashboard.

They have to be updated every time there is a change in the mapping by the dashboard owners, especially if there is a new Site in Archibus or a new Site under Facilities Excellence's perimeter.

Be careful, the columns titles and the structure of the file should not be updated in order to allow the automatic reload in the dashboard!

The best way to get IT support is to use the new Service One Platform.