8.1 - Dashboard Components and data model
Each site's workbooks is composed of 5 dashboards as follow:
| Network | Used as landing dashboard. This page focuses on core output KPIs as well as a visual rendering of the network flow of the optimizer | |
| Output Charts | Pre-defined charts displaying models output by category | |
| Custom Charts | Let User select output measure of interest | |
| Comparison Dashboard | Allow the user to compare results of the optimization of choice with any other previous optimization of the same mode | |
| Report | Aiming at displaying a combination of User inputs used to run the model and results by category (energy, materials, consumption, prices) |
Tableau's data model run on 3 tables all located in related Big query projects
- prj-data-robustify-dev
- prj-data-robustify-test
- prj-data-robustify-prod
Each site (6 of them) are using an input, output and marginal views, as seen for the Dombasle site:
- V_FACT_Dombasle_Input
- V_FACT_Dombasle_Output
- V_FACT_Dombasle_Marginal
These views are joined as follows:
8.2 - Report Access and services accounts
All Dashboard URL can be found in the table below:
| Dev | Dombasle | |
| Dev | Devnia | |
| Dev | Benburg | |
| Dev | Rheinbarg | |
| Dev | Rosignano | |
| Dev | Torrelavega | |
| UAT | Dombasle | |
| UAT | Devnia | |
| UAT | Benburg | |
| UAT | Rheinbarg | |
| UAT | Rosignano | |
| UAT | Torrelavega | |
| PROD | Dombasle | |
| PROD | Devnia | |
| PROD | Benburg | |
| PROD | Rheinbarg | |
| PROD | Rosignano | |
| PROD | Torrelavega |
Big Query services accounts will be found in the folder:
8.3 - Workbooks construction specifics comments:
- Each site's workbook are meant to be accessible from a web app only. End users don't access the dashboards from Tableau server interface but instead will only consume report from the Robustify web application.
- Core feature of the dashboards is the web embed
The dashboard, for each site is expected to open on the optimization of choice by Using the Optimization quick filter as well as filt
Responsible & contact points:
- Alessandro Mainardi - Project Owner
- Simon Bourguignon - Delivery Manager
- Alba Carrero/ Gaetan Frenoy - Product Owner
- Rui Ferraz - Project Manager