The Facilities Dashboard (project code 6833) is built in 2017 to help monitor Facilities Sites (Headquarters).
Dashboard owners: Ana Cordeiro, Veronique Cock.
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).
The Facilities dashboard displays data from the BW HR system (for Headcount), BW Fixed Costs query, Google Spreadsheets for Facilities Budget and mapping, and Archibus (FMIS tool). All theses sources are relaod once a month on the 10th of the month.
QV - Facilities Dashboard - Sources File
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 owner, especially if there is a new Site in Archibus.
Be careful, the columns titles and the structure of the file should not be updated in order to reload it automatically in the dashboard!
| Facilities Budget | Site Mapping | Cost Type Mapping | Room Type Mapping |
|---|---|---|---|