Set up demo data for Sustainability data solutions in Microsoft Fabric (preview)

  • Article

Microsoft Cloud for Sustainability Technical Summit May 2024

Important

Some or all of this functionality is available as part of a preview release. The content and the functionality are subject to change.

You can set up demo data for each capability:

ESG data estate (preview)

Demo data across sustainability areas (such as water, waste, emissions, and social) is deployed to your workspace under the Demo data folder in the ConfigAndDemoData lakehouse. The demo data helps you to quickly explore the functionality. The demo data is in the standard ESG data model schema so you can compute analytical datasets and metrics and explore the Power BI report with these steps:

  1. Run the LoadDemoDataInProcessedESGDataTables notebook to copy the demo data from the Demo data folder in the ConfigAndDemoData lakehouse to ProcessedESGData lakehouse tables.

    Note

    Currently, ESG data estate (preview) only supports full refresh snapshots. Before loading the demo data, ensure you don't have any of your data in the ProcessedESGData lakehouse in the tables that this notebook is loading. If data exists, it will be overwritten.

  2. After the notebook runs successfully, you can view the loaded tables in the ProcessedESGData lakehouse under Tables.

Social and governance metrics and reports (preview)

Demo data for social and governance sustainability area is deployed to your workspace under the Files section in the ConfigAndDemoData lakehouse. The demo data helps you to quickly explore the functionality. The demo data is in the standard ESG data model schema so you can compute analytical datasets and metrics and explore the Power BI report with these steps:

  1. Run the LoadDemoDataInProcessedSGDataTables notebook to copy the demo data from the Files section in the ConfigAndDemoData lakehouse to the ProcessedSocialAndGovernanceData lakehouse tables.

    Note

    Currently, Social and governance metrics and reports (preview) only supports full refresh snapshots. Before loading the demo data, ensure you don't have any of your data in the ProcessedSocialAndGovernanceData lakehouse in the tables that this notebook is loading. If data exists, it will be overwritten.

  2. After the notebook runs successfully, you can view the loaded tables in the ProcessedSocialAndGovernanceData lakehouse under Tables.

Environmental metrics and analytics (preview)

Demo data for Sustainability Manager deploys to your workspace under the Files section in the IngestedMSMData lakehouse. The demo data helps you to quickly explore the functionality without integrating your own data. After the demo data loads, you can compute analytical datasets and metrics and explore the Power BI report with these steps:

  1. Run the LoadMSMDataToLakehouseTables notebook with the MSMDataFolderName variable set to MSMDemoData to copy the demo data from the Files section to the Tables section of the IngestedMSMData lakehouse.

    Note

    Currently, Environmental metrics and analytics (preview) only supports full refresh snapshots. Before loading the demo data, ensure you don't have any of your data in the IngestedMSMData lakehouse in the tables that this notebook is loading. If data exists, it will be overwritten.

  2. After the notebook runs successfully, you can view the loaded tables in the IngestedMSMData lakehouse under Tables.

Microsoft Azure emissions insights (preview)

Demo data for Azure emissions deploys to your workspace under the DemoData folder in the Azure Emissions folder in the Files section of the ConfigAndDemoData lakehouse. The demo data helps you to quickly explore the functionality without integrating your own data. After the demo data loads, you can explore Azure emissions using the datasets and analyze the same using the Power BI report with these steps:

  1. Run the LoadEmissionsDataToTables notebook with the SOURCE_ABFSS_PATH variable set to DEMO_DATA_ABFSS_PATH to copy the demo data from the Files section of the ConfigAndDemoData lakehouse to the Tables section of the AggregatedData lakehouse.

Note

Microsoft Azure emissions insights (preview) only support full refresh snapshots. Before loading the demo data, ensure you don't have any of your data in the tables of AggregatedData lakehouse. If data exists, it will be overwritten.

  1. Run the GenerateAggregateTables notebook to modify the tables that are compatible with the report. It also performs a few data aggregations to provide more insights about the emissions data.

  2. Provide your credentials. You can skip this step if you already provided your credentials.

    1. Open the AnalyzeAzureEmissionsDataset semantic model from your workspace or from the Microsoft Azure emissions insights (preview) capability detail page.

    2. On the top left, select File, and then select Settings. In the Data source credentials section, select Edit credentials.

    3. Provide your Fabric credentials in the dialog box for authenticating the AggregatedData lakehouse data source. Select the following values:

      Field Value
      Authentication method OAuth2
      Privacy level setting for this data source Organizational

    4. Select Sign in.

  3. Go back to the semantic model home page and select Refresh now from the Refresh menu option. After the refresh completes, the dataset is refreshed with data from the AggregatedData lakehouse.

If there are any errors in the refresh, you can find the error details by viewing the Refresh history option on the Refresh menu.

  1. Open the AnalyzeAzureEmissions report from the capability detail page or from your workspace. The report with the emissions data appears.

See also