ESG data model

  • 5 minutes

You can build a comprehensive Environmental, Social, and Governance (ESG) data estate by using the extensible analytical data model. This model helps you effectively manage and process data for advanced analytics and reporting. The model includes over 400 tables in the following areas to support your business analytics and sustainability insights:

  • Carbon

  • Water

  • Waste

  • Biodiversity

  • Social

  • Governance

Screenshot of an E S G and financial overview report.

This data model helps you track your organization's key goals and metrics that pertain to different sustainability regulatory reporting directives and standards. You can use the tables based on your sustainability use cases and transform your source ESG data from disparate source systems into the tables. As a result, you can establish a standardized ESG data estate.

ESG data model resources

The data model resources are:

  • Data dictionary Excel file - Includes data definitions and examples for all tables and columns that help you select the appropriate table for your sustainability use cases.

  • Data model PDF files - Contain a subset of tables from each business area. With these files, you can determine how to combine tables to meet regulatory reporting requirements for carbon emissions, water, waste, social, and governance areas.

  • Synapse database template - Designed for the data model on Azure Synapse, this template helps make it easier for you to explore and visualize tables and relationships in the model.

You can use the data dictionary Microsoft Excel and PDF files that are available on GitHub and the sustainability data model template on Azure Synapse.

ESG data model entities help you manage and process data for advanced analytics and reporting. For more information on the data model, see ESG data model and ESG data model entities.