次の方法で共有


Overview of Environmental data and insights

The environmental data and insights capability in Sustainability data solutions in Microsoft Fabric helps you to unify and harmonize your organization’s environmental data from Microsoft Sustainability Manager and transform it into the environmental, social, and governance (ESG) data model schema. You can then use the transformed environmental data to generate ESG metrics for reporting and dashboard visualization to meet ESG disclosure requirements.

First, you bring your organization’s environmental data from the Sustainability Manager data model in Dataverse to the IngestedRawData lakehouse in your Fabric workspace. You can use any of these methods:

After your environmental data from Sustainability Manager is available in the IngestedRawData lakehouse, you can use the notebooks and data pipelines deployed as part of this capability to transform the data into the ESG data model schema. This transformation occurs in two stages:

  • Stage 1: Carbon emissions, water, and waste measurement data are transformed into a set of intermediary tables called raw data import tables to lower the complexity of the transformation process.

  • Stage 2: Performs the transformation from raw data import tables to the complex ESG data model tables.

The notebooks help unify and harmonize your source environmental data with the reference data and tables present in the ESG data model. You can then use the transformed data to compute metrics, generate reports and perform analytics.

The Fabric items deployed as a part of this capability support the transformation of the environment data from the latest version of the Sustainability Manager data model. If you're using an older or a customized version of the Sustainability Manager data model, you might need to modify the notebooks to support the transformations to ESG data model schema. All the Fabric items deployed as a part of this capability are open for customizations to meet the needs of your organization. If you encounter any errors, refer to Troubleshoot Environmental data and insights.

Dependencies

For deployment, the ESG data estate capability is required. If it's not already deployed, deploying Environmental data and insights automatically deploys it.

Fabric items deployed

Item name Type Description
LoadMSMDataToLakehouseTables_INTB Notebook Loads Sustainability Manager data from CSV to tables in IngestedRawData lakehouse. You can configure it to load demo data for getting started with the transformation.
TransformMSMDataToProcessedESGData_INTB Notebook Performs Stage 1 transformations for Sustainability Manager data to the ESG data model.
TransformMSMDataToProcessedESGData_DTPL Data pipeline Orchestrates the notebooks for transforming Sustainability Manager data to the ESG data model.

Sustainability Manager tables

This is the list of tables that you need to select from Sustainability Manager’s Dataverse environment.

Common tables

  • msdyn_facility
  • msdyn_sustainabilityorganizationalunit
  • msdyn_unit
  • msdyn_industrialprocesstype
  • msdyn_sustainabilitydatadefinitionsetting
  • msdyn_sustainabilitysetting
  • msdyn_material
  • msdyn_organizationalprofile
  • msdyn_sustainabilityorganizationalhierarchy
  • msdyn_organizationalunitrevenue

Carbon emission tables

  • msdyn_emission
  • msdyn_emissionfactor
  • msdyn_calculationlibrary
  • msdyn_accountingmethod

Water data tables

  • msdyn_waterquantity
  • msdyn_watersource
  • msdyn_waterriskindex
  • msdyn_storedwater

Waste data tables

  • msdyn_wastequantity
  • msdyn_wastetype

Circularity data tables

  • msdyn_itemsustainablecontent
  • msdyn_facilityitemconsumption
  • msdyn_facilityitemproduction
  • msdyn_itembillofmaterial
  • msdyn_sustainabilityitemsku

Next step