web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Cloud for Sustainability | MSM, SDSF,...
Unanswered

How to Transform Raw Social and Governance Data to ESG Schema

(3) ShareShare
ReportReport
Posted on by 16

Hello Everyone,

I am trying to transform my Social and Governance data into fabric solution. I have created new folder in Ingested Raw data lake house and uploaded all my raw data files.

Now i want to transform my Raw data into ESG Data Schema. I have seen in we have 40 tables related to Social and Governance in GenerateSocialAndGovernanceTables_INTB notebook parameters Cell 

SELECTIVE_SOCIAL_AND_GOVERNANCE_TABLES = ['BusinessEthicsMetricType', 'BusinessMetric', 'BusinessMetricType', 'Country', 'CountrySubdivisionCategory', 'DataPrivacyMetricType', 'Employee', 'EmployeeLocation', 'EmployeePartyRelationshipType', 'EmployeeRelatedParty', 'Gender', 'GeographicArea', 'HealthSafetyTrainingMetricType', 'Incident', 'IncidentCost', 'IncidentCostType', 'IncidentType', 'LearningEvent', 'LearningEventClassification', 'LearningEventPartyRelationshipType', 'LearningEventRelatedParty', 'LearningEventType', 'Location', 'MetricPurpose', 'Party', 'PartyBusinessMetric', 'PartyCustomerGroupServiceDisruption', 'PartyDataPrivacyMetric', 'PartyEvent', 'PartyGeographicAreaBusinessEthicsMetric', 'PartyGeographicAreaHealthSafetyTrainingMetric', 'PartyResponsibleSourcing', 'RacialCategory', 'ResponsibleSourcingType', 'ServiceDisruptionType', 'Standard', 'StandardTraining', 'StandardType', 'StorageContainerProductActualStorage', 'UnitOfMeasure']

My question is how Social and Governance Raw data is moved to Respective Tables in ESG Schema .

Do we have any json file in config and Demo Lakehouse or Do we have any pre built notebook to transform Social and Governance Raw Data to ESG Schema ?


I watched below May technical summit video but raw data is not provided and Developer Document also not available

Sustainability data solutions in Fabric: Transform your data with the ESG data estate

Embedded Video | Microsoft Learn

Embedded Video | Microsoft Learn

Thanks,
Tejeswari

 
I have the same question (0)
  • Joke Laukens Profile Picture
    142 on at
    For a test case once, I created a separate notebook and used queries and the functions defined in the ESG_Utilities Notebook to move data from one lake house to another.
     
    For a production environment, it would be better to create a framework to automate steps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Cloud for Sustainability | MSM, SDSF, EID

#1
Siv Sagar Profile Picture

Siv Sagar 49 Super User 2025 Season 2

#2
VS-01071403-0 Profile Picture

VS-01071403-0 8

#2
Anne-Laure D'Hondt Profile Picture

Anne-Laure D'Hondt 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans