Page History

PCF Application relies on 2 workbooks published on Tableau Cloud, and available to a selection of Syensqo’s Users as per security requirements specified prior.

This document aims at navigating the data source panel as well as knowing how to reach underlying data from the source. But also, outline all computed elements on each dashboard currently available on all Tableau servers projects:

PCF - Product Carbon Footprint

PCF - Carbon Footprint - UAT

PCF - Product Carbon Footprint - DEV

1. Data connection

             a. Service Account

While dashboards can have a User as project or workbook owner. Connection and extraction of data from Google big query will always be used from a dedicated Service account. Credentials need to be requested to and granted by CloudOps team.

These credentials will allow connection and data extraction from each GCP projects and are available on Google Drive. 

               b. Data Source Panel

Tableau workbook will only extract data from Google Big Query following the same model for all dashboards and each data source as seen below:

         2. PCF - Product Carbon Footprint Advanced Workbook

1. 1. Product List dashboard

Image RemovedImage Added

                  b. Product List Calculated fields

Please refer to the document:

                    c. Biogenic dashboard

Image RemovedImage Added

                  d. Biogenic Calculated fields

Please refer to the document:

                  e. Breakdown dashboard

Image Added

                  f. Breakdown Calculated fields

Please refer to the document:

                  g. PCF validation status overview

                  h. PCF Validation status Calculated fields

Please refer to the document:

                  I. Raw Materials

Image Added

                  J. Bom Balance

Image Added

                  K. Bom Balance Calculated fields

Please refer to the document:

                  L. Emission Changes

Image Added

                  M. Emission Changes Calculated fields

Please refer to the document:

                  N.Attributes Dependencies - Advanced workbook

Please, download and open this document for an interactive version: Advanced Network dependencies

                 I O. PCF - Product Carbon Footprint Advanced Workbook data model

         3. PCF - Validated Product Carbon Footprint

                 a. Validated Product list dashboard

Image RemovedImage Added

                  b. Validated Product list Calculated fields

Please refer to the document:

                 c. Biogenic Validated Product list dashboard

Image RemovedImage Added

                  d. Validated Biogenic Product list Calculated fields

Please refer to the document:

                 e. Net PCF Validated Product list Breakdown dashboard

Image RemovedImage Added

                f. Validated Product Breakdown list Calculated fields

Please refer to the document:

                g. Contribution Dashboard

Image Added

                g. Contribution Changes list Calculated fields

Please refer to the document:

                 h.Attributes Dependencies - Advanced workbook

Please, download and open this document for an interactive version: 

                 h i. PCF - Product Carbon Footprint validated Workbook data model