Environmental data and insights
The environmental data and insights capability 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.
The Environmental data and insights capability requires the ESG data estate capability to be deployed prior. If the ESG data estate isn't deployed, then when you deploy the Environmental data and insights capability, automatically the ESG data estate is deployed.
First, you must 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 supports 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.