BC Observatoryunofficial, made by waldo
topic hubSustainabilityofficial - Microsoftreviewed - checked by Opus

Power BI sustainability app

The Power BI sustainability app section covers the Sustainability Power BI app, its individual reports, the semantic model, and the KPIs and measures behind them. It answers questions about which report shows emissions, water, waste, social (ESG), target and baseline data, and how the data is modeled.

Open in Claudepower-bi-sustainability-app.md

Path: Business functionality > Sustainability management > Sustainability analytics > Power BI sustainability app · tier official · system sustainability · narrative reviewed (checked by Opus)

Overview

The Sustainability Power BI app bundles several reports for tracking emissions, water, waste, and ESG metrics. Different reports suit different roles, from sustainability teams and managers to HR managers and executives.

Start with the Sustainability Power BI app page for the list of reports. Then open the report pages: Sustainability Overview, Journey to Net Zero Carbon, Realized Emissions vs Target, Realized Emissions vs Baseline, Emissions by Category and Scope, Water and Waste Analysis, Social Analysis, and the CO2e reports (Analysis, Decomposition Tree, Key Influences).

For the data side, the semantic model page describes the fact and dimension tables in a star schema. The KPIs and measures page lists the measures with formulas and data sources.

Key points

  • Sustainability Overview gives high-level emissions, water, and waste metrics by category, scope, and month, including CO2, CH4, N2O, water, and waste Realized %.
  • Realized Emissions vs Target compares actual emissions to scorecard targets; Realized Emissions vs Baseline compares them to predefined baselines.
  • Journey to Net Zero Carbon tracks emissions metrics and renewable energy use by global dimensions, with year-over-year comparison.
  • Emissions by Category and Scope breaks values down by account category, subcategory, and scope to inform supplier and procurement decisions.
  • CO2e Analysis tracks monthly CO2e by category and purchased carbon credits; Decomposition Tree and Key Influences help find the main emission contributors and drivers.
  • Water and Waste Analysis covers usage by facility and location, with year-over-year and day-over-day comparisons and intensity vs baseline measures.
  • Social Analysis shows employee ESG metrics such as gender distribution, absence hours, qualifications, and union membership.
  • The semantic model uses sustainability ledger entries, employee data, and sustainability goals as fact tables, with dimensions for accounts, employees, emission fees, and responsibility centers.

Learn pages

  • CO2e Analysis: The CO2e Analysis report provides detailed insight into your CO2e emissions and how you’re purchasing carbon credit.
  • CO2e Decomposition Tree: The CO2e Decomposition Tree report breaks down CO2e emission metrics into its key contributing components to help users understand what is driving changes in CO2 emissions and why.
  • CO2e Key Influences: The CO2e Key Influencers report identifies the key factors driving CO2e emission increases, highlighting the most impactful variables and trends based on the sustainability account categories.
  • Emissions by Category and Scope: The Emission by Scope report organizes emission types based on the account category and scope to show how they’re tracking.
  • Journey to Net Zero Carbon: The Journey to Net Zero highlights the journey to net zero within an organization.
  • Power BI Sustainability app semantic model: Learn how tables and fields in the Power BI Sustainability app semantic model map to Business Central data for emissions and workforce analysis.
  • Realized Emissions vs Baseline: The Realized Emissions by Baseline report breaks down your carbon emissions and allows for comparison against a defined baseline period. Track your progress against the baseline and monitor trends against a previous period.
  • Realized Emissions vs Target: The Realized Emissions by Target report breaks down your carbon emissions and allows for comparison against the target. This allows you to effectively monitor planned progress and drive continuous improvement to sustainability goals.
  • Social Analysis: The Social Analysis report displays employee details as part of Social reporting for ESG.
  • Sustainability KPIs and measures (Power BI): Get an overview of all the KPIs and measures in the semantic model for the Sustainability Power BI app.
  • Sustainability Overview: The Sustainability Overview gives you a high-level view of all the key sustainability metrics.
  • Sustainability Power BI app: The Power BI app for sustainability in Business Central provides comprehensive sustainability analytics to stakeholders at all levels of your organization.
  • Water and Waste Analysis: The Water and Waste Analysis allows you to effectively monitor your water and waste usage by different metrics such as Water Type, Intensity Type, and Responsibility Center.

Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.

What Learn documents here 8 of 13 Learn pages

Show 5 more