Looker Studio dashboard for Dun & Bradstreet

This page describes the insights you can get from the Looker Studio dashboard for Dun & Bradstreet data. By integrating Dun & Bradstreet's ESG (Environment, Society, and Governance) ranking data with SAP ERP supplier data, you can gain insights into ESG risks and opportunities in their supply chain. These insights can guide strategic decisions, monitor suppliers' ESG performance, assess vendors' capabilities in managing emissions, evaluate adherence to compliance and governance standards, and identify resilient suppliers.

You can also extend the insights beyond Sustainability with other data sources in Cortex Framework.

Available insights

The Looker Studio dashboard for Dun & Bradstreet data from Cortex Framework offers the following insights.

Vendor ESG performance overview

Overview of high-level vendor delivery and ESG performance including:

  • Number of active vendors in selected invoice date range
  • Average ESG ranking score across active vendors
  • Total spend with active vendors
  • Average GHG Emissions score across active vendors
  • OnTimeInFull (OTIF) delivery percentage across active vendors

Insights into ESG risks and opportunities attached to total spend with vendors:

  • Total Spend by top vendors
  • Total Spend by ESG Ranking Score
  • Average ESG ranking score trend across active vendors
  • Number of active vendors by ESG ranking score

Distribution of active vendors into individual ESG ranking scores:

  • Number of vendors by environmental ranking score
  • Number of vendors by social ranking score
  • Number of vendors by governance ranking score

Vendor environmental, social and governance insights

Detailed environmental, social and governance insights for active vendors:

  • Natural resource management scores
  • GHG emissions and climate scores
  • Environmental risk and opportunities scores
  • Human capital scores
  • Products quality management scores
  • Customer engagement scores
  • Community and supplier engagement and certifications scores
  • Corporate governance scores
  • Corporate behaviors scores
  • Business resiliency scores
  • Individual environmental, social and governance score trends

Vendor ESG Performance Details

Top vendor comparison to their industry peers and holistic assessment using delivery and ESG performance insights:

  • Average peer ESG ranking score
  • ESG ranking score
  • Total spend to date
  • OnTimeInFull delivery percentage

Dashboard

To access the Cortex Looker Studio dashboard for Dun & Bradstreet, see Cortex Framework - Vendor ESG Performance. This dashboard contains predefined resources with a solid foundation for creating custom reports, visualizations, and dashboards tailored to your specific needs.

Deployment

You can customize the Cortex Looker Studio dashboard for Dun & Bradstreet by copying and connecting it to your own data with the following instructions:

  1. Deploy Cortex Framework: Ensure you have Cortex Framework set up and configured with your data sources. For more information, see Cortex Framework prerequisites for deployment.
  2. Copy the dashboard.
    1. Go to the Cortex Framework - Vendor ESG Performance dashboard.
    2. On the top bar, select the three-dot More options button .
    3. Click Make a copy to copy the dashboard.
    4. A dialog would come up. Ignore the mapping of the new data source for now and click Copy Report.
    5. A copy is now created under your account.
  3. Enter the Edit mode.
  4. On the top bar, select Resources > Manage added data sources. You would see the two data sources that are powering this dashboard.
  5. Edit the SustainableSourcing data source by clicking Edit. You would see that this dashboard uses a CUSTOM QUERY.
    1. Choose the Billing Project in CUSTOM QUERY.
    2. Update the query accordingly to point to the location where your sustainability tables are deployed.
    3. Verify if you have access to the underlying source. You can copy and run the query directly in the BigQuery console which should complete successfully and return results.
    4. Click RECONNECT. The page should take about a minute to come back with any configuration changes.
    5. Click Apply and Done in the following page. This should bring you back to the Data Sources page.
  6. Edit the SustainableVendorSourcing data source by clicking Edit. Repeat procedure from previous step.
  7. Close windows for Manage added data sources.
  8. Reload the your dashboard. You should be able to see the dashboard with your data.