Skip to main content

Notifications

Announcements

Announcing Our 2025 Season 1 Super Users!
Announcing Forum Attachment Improvements!
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Cloud for Sustainability | MSM, SDSF,... / How to Transform Raw S...
Microsoft Cloud for Sustainability | MSM, SDSF,...
Unanswered

How to Transform Raw Social and Governance Data to ESG Schema

(3) ShareShare
ReportReport
Posted on by teju 12

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

 
Categories:
Sustainability data solutions in Microsoft Fabric
  • Joke Laukens Profile Picture
    Joke Laukens 25 on at
    How to Transform Raw Social and Governance Data to ESG Schema
    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

News and Announcements

Announcing Our 2025 Season 1 Super Users!
Announcing Forum Attachment Improvements!

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans