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
