Water and waste analysis (Power BI report)

APPLIES TO: Business Central 2025 release wave 1 and later.

The Water and Waste Analysis report provides a detailed analysis of the organization's water usage and waste generation. The report organizes the information by facility and location. You can compare water usage with the configured water capacity of responsibility centers, and review different types of water and waste. The year-over-year and day-over-day calculations show percentage changes in usage.

[Screenshot of the Water and Waste Analysis Power BI report]

Use the report

Sustainability Managers use the report to monitor water usage and waste generation at an organizational level. You can explore water capacity, water usage, waste generation, and the different types of water and waste for each facility or location. Available water is the configured water capacity for the selected period minus water usage. The report doesn't calculate waste capacity.

Facility Managers can quickly and effectively monitor how your facility is performing against your baseline and targets, and compare the different types of water and waste.

Key performance indicators (KPIs)

The Water and Waste Analysis report includes the following KPIs and measures:

Choose the link for a KPI to learn more about what it means, its calculation, and what data is used in the calculations.

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.

Data used in the report

The Water and Waste Analysis report uses data from the following tables in Business Central:

  • Sustainability Ledger Entry
  • Sustainability Account Category
  • Sustainability Account
  • Sustainability Goals
  • Responsibility Center
  • Country/Region

Try the report

Try the report here: Water and Waste Analysis

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

Sustainability Overview (Power BI Report)
Sustainability management overview
Sustainability reports and analytics in Business Central

Find free e-learning modules for Business Central here