次の方法で共有


Overview of ESG data estate

Microsoft Cloud for Sustainability Tech Summit November 2024.

The environmental, social, and governance (ESG) data estate capability enables you to centralize your organization’s ESG data from disparate sources into a standardized ESG data model. You can use this ESG data to then perform aggregation and analysis for meeting regulatory requirements, such as the Corporate Sustainability Reporting Disclosures (CSRD) in the EU, and for demonstrating transparency and accountability to stakeholders.

The ESG data estate capability contains the ESG data model, which serves as the data estate or the centralized schema in Sustainability data solutions in Fabric for storing ESG data. The ESG data model is a comprehensive and extensible analytical data model for managing and processing your ESG data for advanced analytics and reporting. The ESG data model includes over 500 tables to store ESG data, across various business areas such as carbon, energy, water, waste, biodiversity, social, and governance.

The ESG data estate capability deploys all of the Sustainability data solutions in Fabric lakehouses, configuration files, and the ESG data model. As a result, it's a dependent capability for all of the other Sustainability data solutions in Fabric capabilities.

With the ESG data estate capability, you can:

  • Load demo data tables into the ProcessedESGData lakehouse
  • Ingest data to the ESG data model from external sources

List of Fabric items deployed

This table shows the Fabric items that are deployed as part of this capability.

Name Type Description
IngestedRawData_LH Lakehouse This lakehouse stores the raw ESG data from external data sources.
ProcessedESGData_LH Lakehouse This lakehouse stores the harmonized and processed ESG data conforming to a standardized ESG data model.
ComputedESGMetrics_LH Lakehouse This lakehouse stores the computed ESG metrics and aggregated analytical datasets.
ConfigAndDemoData_LH Lakehouse This lakehouse stores the certain transformation libraries, reference, and demo data.
CleanProcessedESGData_INTB Notebook This notebook clears the data from the ESG data model tables present in the ProcessedESGData lakehouse.
LoadReferenceTables_INTB Notebook This notebook creates and adds data to the reference tables in the ProcessedESGData lakehouse.
LoadDemoDataInProcessedESGDataTables_INTB Notebook This notebook loads demo data as ESG data model tables in the ProcessedESGData lakehouse.
GenerateESGTables_INTB Notebook This notebook creates empty ESG data model tables in the ProcessedESGData lakehouse based on the selected sustainability area.
TransformRawImportESGDataToProcessedESGData_INTB Notebook This notebook transforms the ESG data from the raw data import tables to the ESG data model tables.