Power BI Sustainability app semantic model

APPLIES TO: Generally available in Business Central 2024 release wave 2.

The semantic model in the Power BI Sustainability app is organized in a Star Schema Model.

The fact tables contain information about individual transactions and targets, such as sustainability ledger entries, employee ledger entries, employee absences, employee qualifications, and sustainability goals from Business Central.

The dimension tables provide more context and attributes to the transactional data, such as sustainability accounts, employees, emission fees, responsibility centers, and country/region information.

Fact tables

Fact tables store transactional data and support summarizations such as SUM, AVG, COUNT, and more. The Power BI Sustainability app includes several fact tables:

Employee absences

The app uses data from the following table:

  • Employee Absence

Table definition

Power BI field nameBusiness Central field nameDescription
Entry NoEntry No.Specifies the entry number assigned to the employee absence.
From DateFrom DateSpecifies the first day of the employee absence.
To DateTo DateSpecifies the last day of the employee absence.
Cause of AbsenceCause of Absence CodeSpecifies the cause of absence code that defines the absence type.
DescriptionDescriptionSpecifies a description of the employee absence.

Employee Ledger Entries

The app uses data from the following table:

  • Employee Ledger Entry

Table definition

Power BI field nameBusiness Central field nameDescription
Entry No.Entry No.Specifies the entry number assigned to the employee ledger entry.
Document TypeDocument TypeSpecifies the document type of the employee ledger entry.
Document No.Document No.Specifies the document number of the employee ledger entry.
DescriptionDescriptionSpecifies a description of the employee ledger entry.

Employee Qualifications

The app uses data from the following table:

  • Employee Qualification

Table definition

Power BI field nameBusiness Central field nameDescription
Employee Qualification CodesQualification CodeSpecifies the qualification code assigned to the employee.

Sustainability Goals

The app uses data from the following table:

  • Sustainability Goal

Table definition

Power BI field nameBusiness Central field nameDescription
Score Card No.Scorecard No.Specifies the scorecard number of the sustainability goal.
No.No.Specifies the number of the sustainability goal.
NameNameSpecifies the name of the sustainability goal.
OwnerOwnerSpecifies the owner of the sustainability goal.
Target Value For CO2Target Value for CO2Specifies the target value for CO2 emissions.
Target Value For CH4Target Value for CH4Specifies the target value for CH4 emissions.
Target Value For N2OTarget Value for N2OSpecifies the target value for N2O emissions.
Target Value For Water IntensityTarget Value for Water Int.Specifies the target value for water intensity.
Target Value For Waste IntensityTarget Value for Waste Int.Specifies the target value for waste intensity.
Main GoalMain GoalSpecifies whether the sustainability goal is the main goal.
Start DateStart DateSpecifies the start date of the sustainability goal.
End DateEnd DateSpecifies the end date of the sustainability goal.
Baseline Start DateBaseline Start DateSpecifies the start date of the baseline period.
Baseline End DateBaseline End DateSpecifies the end date of the baseline period.

Sustainability Ledger Entries

The app uses data from the following table:

  • Sustainability Ledger Entry

Table definition

Power BI field nameBusiness Central field nameDescription
Entry No.Entry No.Specifies the entry number assigned to the sustainability ledger entry.
DescriptionDescriptionSpecifies a description of the sustainability ledger entry.
Water TypeWater TypeSpecifies the water type for the sustainability ledger entry.
Water/Waste Intensity TypeWater/Waste Intensity TypeSpecifies the water or waste intensity type for the sustainability ledger entry.
Document TypeDocument TypeSpecifies the document type of the sustainability ledger entry.

Dimension tables

The star schema model uses dimension tables and you can filter and group data.

Country/Region

The app uses data from the following table:

  • Country/Region

Table definition

Power BI field nameBusiness Central field nameDescription
Country Region CodeCodeSpecifies the country/region code.
Country Region NameNameSpecifies the name of the country/region.

Emission fees

The app uses data from the following table:

  • Emission Fee

Table definition

Power BI field nameBusiness Central field nameDescription
Emission TypeEmission TypeSpecifies the type of emission that the fee applies to.
Scope TypeScope TypeSpecifies the emission scope that the fee applies to.
Starting DateStarting DateSpecifies the starting date when the emission fee applies.
Ending DateEnding DateSpecifies the ending date when the emission fee applies.
Country Region CodeCountry/Region CodeSpecifies the country/region code for the emission fee.
Responsibility CentreResponsibility CenterSpecifies the responsibility center for the emission fee.
Carbon FeeCarbon FeeSpecifies the carbon fee amount.
Carbon Equivalent FactorCarbon Equivalent FactorSpecifies the factor used to calculate carbon equivalent values.

Employees

The app uses data from the following table:

  • Employee

Table definition

Power BI field nameBusiness Central field nameDescription
Employee No.No.Specifies the number of the employee.
Employee Full Name-Specifies a combination of the employee's first name and last name in Power BI.
Employee First NameFirst NameSpecifies the first name of the employee.
Employee Last NameLast NameSpecifies the last name of the employee.
Employee GenderGenderSpecifies the gender of the employee.
Employee Union CodeUnion CodeSpecifies the union code assigned to the employee.
Employee StatusStatusSpecifies the employment status of the employee.
Employee Cause of InactivityCause of Inactivity CodeSpecifies the cause of inactivity code assigned to the employee.
Employee Inactive DateInactive DateSpecifies the date when the employee became inactive.
Employee Grounds for TerminationGrounds for Term. CodeSpecifies the grounds for termination code assigned to the employee.
Employee Date of BirthBirth DateSpecifies the birth date of the employee.
Age-Specifies the employee's age calculated in Power BI.
Age Distribution-Specifies the employee's age group calculated in Power BI.

Responsibility Centre

The app uses data from the following table:

  • Responsibility Center

Table definition

Power BI field nameBusiness Central field nameDescription
Responsibility Centre CodeCodeSpecifies the responsibility center code.
Responsibility Centre NameNameSpecifies the name of the responsibility center.

Sustainability Account Category

The app uses data from the following table:

  • Sustain. Account Category

Table definition

Power BI field nameBusiness Central field nameDescription
Sustainability Account Category DescriptionDescriptionSpecifies the description of the sustainability account category.
Sustainability Account Category CodeCodeSpecifies the code of the sustainability account category.
Sustainability Account Category Emission ScopeEmission ScopeSpecifies the emission scope of the sustainability account category.

Sustainability Accounts

The app uses data from the following table:

  • Sustainability Account

Table definition

Power BI field nameBusiness Central field nameDescription
Sustainability Account No.No.Specifies the number of the sustainability account.
Sustainability Account NameNameSpecifies the name of the sustainability account.

Sustainability Sub-Account Categories

The app uses data from the following table:

  • Sustain. Account Subcategory

Table definition

Power BI field nameBusiness Central field nameDescription
Sub-Category DescriptionDescriptionSpecifies the description of the sustainability account subcategory.
Renewable EnergyRenewable EnergySpecifies whether the sustainability account subcategory relates to renewable energy.
Sub-Category CodeCodeSpecifies the code of the sustainability account subcategory.

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Power BI Sustainability app KPIs and measures
Sustainability Power BI app
Use Power BI with Business Central

Find free e-learning modules for Business Central here