Stay organized with collections
Save and categorize content based on your preferences.
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.
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
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:
- 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.
- Copy the dashboard.
- Go to the Cortex Framework - Vendor ESG Performance dashboard.
- On the top bar, select the three-dot More options button more_vert.
- Click Make a copy to copy the dashboard.
- A dialog would come up. Ignore the mapping of the new data source for now and click Copy Report.
- A copy is now created under your account.
- Enter the Edit mode.
- On the top bar, select Resources > Manage added data sources. You
would see the two data sources that are powering this dashboard.
- Edit the SustainableSourcing data source by clicking Edit. You would
see that this dashboard uses a CUSTOM QUERY.
- Choose the Billing Project in CUSTOM QUERY.
- Update the query accordingly to point to the location where your
sustainability tables are deployed.
- 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.
- Click RECONNECT. The page should take about a minute to come back
with any configuration changes.
- Click Apply and Done in the following page. This should bring you
back to the Data Sources page.
- Edit the SustainableVendorSourcing data source by clicking Edit. Repeat
procedure from previous step.
- Close windows for Manage added data sources.
- Reload the your dashboard. You should be able to see the dashboard with your
data.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eThe Looker Studio dashboard integrates Dun & Bradstreet's ESG data with SAP ERP supplier data to provide insights into supply chain ESG risks and opportunities.\u003c/p\u003e\n"],["\u003cp\u003eThe dashboard offers a vendor ESG performance overview, including average ESG and GHG emissions scores, total spend, and on-time delivery.\u003c/p\u003e\n"],["\u003cp\u003eUsers can analyze the distribution of active vendors by their environmental, social, and governance ranking scores, and compare them to industry peers.\u003c/p\u003e\n"],["\u003cp\u003eDetailed insights are provided for each vendor, including scores for natural resource management, emissions, human capital, product quality, community engagement, corporate governance, and business resiliency.\u003c/p\u003e\n"],["\u003cp\u003eThe Looker Studio dashboard is customizable, allowing users to copy and connect it to their own data after setting up the Cortex Framework.\u003c/p\u003e\n"]]],[],null,["# Looker Studio dashboard for Dun & Bradstreet\n\nLooker Studio dashboard for Dun \\& Bradstreet\n=============================================\n\nThis page describes the insights you can get from the Looker Studio\ndashboard for Dun \\& Bradstreet data. By integrating Dun \\& Bradstreet's ESG\n(Environment, Society, and Governance) ranking data with SAP ERP supplier data,\nyou can gain insights into ESG risks and opportunities in their supply chain.\nThese insights can guide strategic decisions, monitor suppliers' ESG\nperformance, assess vendors' capabilities in managing emissions, evaluate\nadherence to compliance and governance standards, and identify resilient suppliers.\n\nYou can also extend the insights beyond Sustainability with other data sources\nin [Cortex Framework](/cortex/docs/data-sources-and-workloads).\n\nAvailable insights\n------------------\n\nThe Looker Studio dashboard for Dun \\& Bradstreet data from\nCortex Framework offers the following insights.\n\n### Vendor ESG performance overview\n\nOverview of high-level vendor delivery and ESG performance including:\n\n- Number of active vendors in selected invoice date range\n- Average ESG ranking score across active vendors\n- Total spend with active vendors\n- Average GHG Emissions score across active vendors\n- *OnTimeInFull* (OTIF) delivery percentage across active vendors\n\nInsights into ESG risks and opportunities attached to total spend\nwith vendors:\n\n- Total Spend by top vendors\n- Total Spend by ESG Ranking Score\n- Average ESG ranking score trend across active vendors\n- Number of active vendors by ESG ranking score\n\nDistribution of active vendors into individual ESG ranking scores:\n\n- Number of vendors by environmental ranking score\n- Number of vendors by social ranking score\n- Number of vendors by governance ranking score\n\n### Vendor environmental, social and governance insights\n\nDetailed environmental, social and governance insights for active vendors:\n\n- Natural resource management scores\n- GHG emissions and climate scores\n- Environmental risk and opportunities scores\n- Human capital scores\n- Products quality management scores\n- Customer engagement scores\n- Community and supplier engagement and certifications scores\n- Corporate governance scores\n- Corporate behaviors scores\n- Business resiliency scores\n- Individual environmental, social and governance score trends\n\n### Vendor ESG Performance Details\n\nTop vendor comparison to their industry peers and holistic assessment\nusing delivery and ESG performance insights:\n\n- Average peer ESG ranking score\n- ESG ranking score\n- Total spend to date\n- *OnTimeInFull* delivery percentage\n\nDashboard\n---------\n\nTo access the Cortex Looker Studio dashboard for Dun \\& Bradstreet, see\n[Cortex Framework - Vendor ESG Performance](https://lookerstudio.google.com/c/reporting/cab436f2-ff83-4cfa-b7e4-e99b9fd9a8d0/page/p_wa5lq4dsfd).\nThis dashboard contains predefined resources with a solid foundation\nfor creating custom reports, visualizations, and dashboards tailored to your\nspecific needs.\n\nDeployment\n----------\n\nYou can customize the Cortex Looker Studio dashboard for Dun \\& Bradstreet\nby copying and connecting it to your own data with the following instructions:\n\n1. **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](/cortex/docs/deployment-prerequisites).\n2. Copy the dashboard.\n 1. Go to the [Cortex Framework - Vendor ESG Performance](https://lookerstudio.google.com/c/reporting/cab436f2-ff83-4cfa-b7e4-e99b9fd9a8d0/page/p_wa5lq4dsfd) dashboard.\n 2. On the top bar, select the three-dot **More options** button more_vert.\n 3. Click **Make a copy** to copy the dashboard.\n 4. A dialog would come up. Ignore the mapping of the new data source for now and click **Copy Report**.\n 5. A copy is now created under your account.\n3. Enter the **Edit mode**.\n4. On the top bar, select **Resources** \\\u003e **Manage added data sources**. You would see the two data sources that are powering this dashboard.\n5. Edit the *SustainableSourcing* data source by clicking **Edit** . You would see that this dashboard uses a *CUSTOM QUERY* .\n 1. Choose the Billing Project in *CUSTOM QUERY*.\n 2. Update the query accordingly to point to the location where your sustainability tables are deployed.\n 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.\n 4. Click **RECONNECT**. The page should take about a minute to come back with any configuration changes.\n 5. Click **Apply** and **Done** in the following page. This should bring you back to the Data Sources page.\n6. Edit the *SustainableVendorSourcing* data source by clicking **Edit**. Repeat procedure from previous step.\n7. Close windows for **Manage added data sources**.\n8. Reload the your dashboard. You should be able to see the dashboard with your data."]]
