Skip to content

Water management dashboard builder

Water use, leaks, quality and supply levels in one view. Replace the sample readings with your meter or SCADA data, then download.

New here? — takes 2 minutes.

Water monitoring dashboard

Municipal supply system — Rolling six months to September

Water produced, Sep

788 ML
+3.4% YoY

Non-revenue water

18.6%
−1.9 pts

Quality compliance

99.7%
+0.2 pts

Main breaks, 6 months

23
−7 vs last yr

Reservoir storage (% of capacity)

Lake CorwinRidge ReservoirDrought trigger
0
25
50
75
100
636155
AprMayJunJulAugSep

Non-revenue water vs target

18.6%Target 15%

Leakage by district metered area (L/conn/day)

DMA 07 Old Town214
DMA 03 Riverside168
DMA 11 Hillcrest142
DMA 05 Eastgate118
DMA 09 Parkview96
DMA 02 Northfield71

Water quality sampling

ParameterResultLimitSites testedStatus
Free chlorine, good0.9 mg/L0.2–4.0 mg/L64Pass
Turbidity, good0.18 NTU≤ 0.3 NTU64Pass
Total coliform, warning1 positive0 repeat positives120Resample
Lead (90th pct), good6 ppb≤ 15 ppb40Pass
pH, good7.66.5–8.564Pass

3 Water Management Dashboard templates

Every template opens as a finished dashboard. Pick the closest one, then change anything.

Metrics and how to calculate them

The KPIs these templates are built on, with the formula behind each one.

Water consumption
Total volume through the meters in the period (m³, ML or gallons), best shown per occupant, unit or connection.
Non-revenue water
(System input volume − billed authorized consumption) ÷ system input volume × 100.
Leakage per connection
Estimated real losses in liters ÷ number of service connections ÷ days in the period.
Minimum night flow
Average flow between about 1am and 4am; steady night flow in a building usually signals a leak.
Quality compliance
Samples meeting every regulatory limit ÷ total samples taken × 100.
Reservoir storage
Current stored volume ÷ usable capacity × 100, compared with drought trigger levels.

How to make your Water Management Dashboard

Pick a template, put your numbers in, download — about two minutes. Nothing to install; the PDF and every other format come with a SlideTeam plan.

  1. 1

    Pick your dashboard

    Click Pick Your Dashboard. This dashboard has 3 ready-made layouts, such as Water monitoring and Water consumption by building. Each opens finished, with example figures.

  2. 2

    Change the numbers

    Point at any widget (tap it on a phone) and choose Edit to type or paste its numbers and labels — a column copied from Excel pastes straight in. Click the dashboard's title to rename it.

  3. 3

    Use your own data

    Upload CSV or Excel takes a CSV, .xlsx or .xls file and shows exactly what it read: pick the sheet, the label column and how repeated rows are combined (sum, average, count), then Build a new dashboard or Fill this template with your columns. Not sure of the layout? Download the sample CSV and replace the numbers.

  4. 4

    Download PDF, PowerPoint, Excel and more

    Download (right end of the toolbar) lists every format: a PDF (free), PowerPoint with native charts you can still edit (right-click › Edit data), a report pack (summary slide plus one slide per chart) as PowerPoint or PDF, Excel (opens on a Dashboard sheet with live charts) and a CSV for Power BI, Tableau or Google Sheets.

  5. 5

    More options: add widgets, brand it, share

    More options (top right) shows the rest: Add widget puts in a chart, KPI tile, table, funnel or a Text / commentary box; the arrows on a widget move it and ✕ removes it; click the subtitle to edit it. Customise sets the currency, template language, slide size, brand colour and logo. Sheets / Slides shows how to open your file in Google Sheets or Slides; Share copies a link to this exact dashboard.

Common questions

What is a water management dashboard?

A single view of how much water is produced or used, where it is lost, whether it meets quality limits and how much supply is left. The templates above cover a utility monitoring view, building consumption and a watershed view.

How do I spot leaks on a water consumption dashboard?

Watch minimum night flow by meter: a building should use almost nothing between 1am and 4am, so a steady reading points to a leak. The consumption template includes a night-flow heatmap and a leak log.

Can I add readings from SCADA or smart meters?

Yes. Export the readings to CSV and upload them, or type values into any widget, then download an editable PowerPoint slide or Excel workbook.

Goes well with this — from our other free tools

The figures in the example dashboards are illustrative and exist so each page shows a finished dashboard rather than an empty grid. Replace them with yours before sharing anything.