使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
适用于 Dun & Bradstreet 的 Looker Studio 信息中心
本页介绍了您可以通过 Looker Studio 信息中心针对 Dun & Bradstreet 数据获得哪些数据分析。通过将 Dun & Bradstreet 的环境、社会和治理 (ESG) 排名数据与 SAP ERP 供应商数据相集成,您可以深入了解供应链中的 ESG 风险和机遇。这些数据洞见可用于指导制定战略决策、监控供应商的 ESG 表现、评估供应商在管理排放量方面的能力、评估供应商是否遵守合规性和治理标准,以及识别具有弹性供应商。
您还可以使用 Cortex Framework 中的其他数据源,将可持续发展洞见扩展到其他领域。
可用的数据洞见
用于查看 Cortex Framework 中 Dun & Bradstreet 数据的 Looker Studio 信息中心提供了以下数据分析。
供应商交付和 ESG 表现的概览,包括:
- 所选账单日期范围内的活跃供应商数量
- 所有有效供应商的 ESG 排名平均得分
- 与有效供应商的总支出
- 所有有效供应商的平均温室气体排放量得分
- 所有有效供应商的按时全额 (OTIF) 提交百分比
深入了解与供应商总支出相关的 ESG 风险和机会:
- 前五名供应商的总支出
- 按 ESG 排名得分划分的总支出
- 所有有效供应商的平均 ESG 排名得分趋势
- 按 ESG 排名得分划分的活跃供应商数量
活跃供应商在各个 ESG 排名得分中的分布情况:
- 按环境排名得分划分的供应商数量
- 按社交排名得分划分的供应商数量
- 供应商数量(按治理排名得分)
供应商环境、社会和治理数据分析
有关有效供应商的详细环境、社会和治理数据分析:
- 自然资源管理得分
- 温室气体排放量和气候评分
- 环境风险和机会得分
- 人力资本得分
- 商品质量管理得分
- 客户互动得分
- 社区和供应商互动度和认证得分
- 公司治理评分
- 企业行为评分
- 业务弹性评分
- 各项环境、社会和治理得分趋势
通过投放效果和环境、社会和治理 (ESG) 表现数据分析,对顶级供应商与同行业同类供应商进行比较并进行全面评估:
- 同行 ESG 排名平均得分
- ESG 排名得分
- 截至目前的总支出
- OnTimeInFull 送达百分比
信息中心
如需访问 Dun & Bradstreet 的 Cortex Looker Studio 信息中心,请参阅 Cortex Framework - Vendor ESG Performance。此信息中心包含预定义的资源,为您提供了坚实的基础,可帮助您根据自己的具体需求创建自定义报告、可视化图表和信息中心。
部署
您可以按照以下说明复制并将其关联到您自己的数据,从而自定义适用于 Dun & Bradstreet 的 Cortex Looker Studio 信息中心:
- 部署 Cortex Framework:确保您已设置 Cortex Framework 并将其与数据源配置完毕。如需了解详情,请参阅 Cortex 框架部署前提条件。
- 复制信息中心。
- 前往 Cortex Framework - Vendor ESG Performance 信息中心。
- 在顶栏中,选择三点状图标 更多选项按钮 more_vert。
- 点击复制以复制信息中心。
- 系统随即会弹出一个对话框。暂时忽略新数据源的映射,然后点击复制报告。
- 现在,系统会在您的账号下创建副本。
- 进入编辑模式。
- 在顶部栏中,依次选择资源 > 管理添加的数据源。您会看到为此信息中心提供支持的两个数据源。
- 点击修改,修改 SustainableSourcing 数据源。您会看到此信息中心使用的是自定义查询。
- 在自定义查询中选择结算项目。
- 相应地更新查询,将其指向可持续发展表的部署位置。
- 验证您是否有权访问底层来源。您可以直接在 BigQuery 控制台中复制并运行该查询,该查询应该会成功完成并返回结果。
- 点击重新连接。页面应该会在大约一分钟后返回,并显示任何配置更改。
- 在随后出现的页面中,依次点击应用和完成。您应该会返回到“数据源”页面。
- 点击修改以修改 SustainableVendorSourcing 数据源。重复上一步中的操作。
- 关闭管理添加的数据源窗口。
- 重新加载信息中心。您应该能够看到包含数据的信息中心。
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-08-18。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC):2025-08-18。"],[[["\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."]]