Skip to content

Latest commit

 

History

History
42 lines (23 loc) · 2.89 KB

README_Sustainability.md

File metadata and controls

42 lines (23 loc) · 2.89 KB

Sustainability & ESG insights with Cortex Framework

With increasing demand from customers, corporate investors, and regulators for transparent and sustainable operations, timely insights into environmental, social and governance (ESG) risks and opportunities is important.

Cortex Framework enables vendor ESG performance insights using Dun & Bradstreet ESG ranking data connected with SAP ERP supplier performance data to help answer questions like:

  • What is my raw material suppliers' ESG performance against industry peers?
  • What is their ability to measure and manage GHG emissions?
  • What is their adherence and commitment to environmental compliance and corporate governance?

Data model overview

Two BigQuery views are provided for this module, in the K9 Reporting dataset:

  • SustainableSourcing provides ESG Insights for each vendor.
  • SustainableVendorSourcing provides vendor performance insights alongside ESG Insights.

You can adjust the reporting settings file as described in our README.

ERD of Sustainability & ESG Insights

Prerequisites

The following is required for this module to function:

  • Dun & Brandstreet source table - loaded as dun_bradstreet_esg table in K9 Processing dataset. See section below for details.
  • A full Cortex SAP ECC or S/4 deployment, containing CDC and Reporting datasets. Refer to the main README for details.

Acquiring Dun & Bradstreet data

Navigate to the BigQuery Analytics Hub and search for "esg ranking". There is an option to choose between four datasets: US Full File, UK Full File, Global Full File & Global Financial Services. Click on one of them, then select Request Access to get in touch with D&B for further instructions. Alternatively navigate to the Google Cloud Marketplace and select Dun & Bradstreet ESG Intelligence offering.

Analytics Hub

Loading Dun & Bradstreet data

Table dun_bradstreet_esg in K9 Processing dataset hosts Dun & Bradstreet ESG data, and it should be loaded through a CSV file provided by DnB. Please refer to the data dictionary and sample data.

Looker Studio Dashboard

Refer to this sample Looker Studio dashboard on how the data could be used to showcase insights.