Environmental data and insights
The Environmental data and insights capability helps you 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. Then, you can use the transformed environmental data to generate ESG metrics for reporting and dashboard visualization to meet ESG disclosure requirements.
Before you can use the Environmental data and insights capability, you must deploy the ESG data estate capability first. If you don't deploy the ESG data estate first, then when you deploy the Environmental data and insights capability, the system automatically deploys ESG data estate.
Your first task is to bring your organization’s environmental data from the Sustainability Manager data model in Microsoft 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 that deploy as part of this capability to transform the data into the ESG data model schema. This transformation occurs in two stages:
Stage 1 - The system transforms carbon emissions, water, and waste measurement data into a set of intermediary tables, called raw data import tables, to lower the complexity of the transformation process.
Stage 2 - The system 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 that are present in the ESG data model. Then, you can use the transformed data to compute metrics, generate reports, and perform analytics.
The Fabric items that deploy 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 the ESG data model schema. All Fabric items that deploy as a part of this capability are open for customizations to meet the needs of your organization. If you encounter errors, refer to the Troubleshoot Environmental data and insights documentation.