# Five useful Power BI views for a construction business

[Read the public page](https://www.adarkcloud.com.au/blog/5-power-bi-dashboards-every-perth-construction-business-needs)

Plan construction reporting around decisions. Five useful views cover jobs, cash, committed cost, variations and upcoming work.

By Josh C, A Dark Cloud Creative

Published 2026-02-15

A useful construction dashboard helps someone make a specific decision from reliable data. Job margin, cash timing, committed costs, variations and workload are sensible starting views, provided the underlying records can support them.

## Job margin with a clear definition

Compare the agreed contract value, approved variations and costs recorded against the job. Decide whether your margin includes overhead and how partially completed work is treated. A number labelled profit is not useful if the office and site supervisor interpret it differently.

Use this view to find jobs that need investigation. It should link back to the records that explain the result rather than presenting a percentage without context.

## Cash timing rather than invoice totals

An invoice total does not tell you when cash will arrive. A cash view can show expected receipts, overdue accounts and upcoming payments. The assumptions need to be visible, especially when progress claims or retention affect timing.

Finance staff should own the rules. A dashboard is a way to examine the records, not a replacement for accounting judgement.

## Committed cost alongside paid cost

Purchase orders and subcontract commitments can affect the final job cost before an invoice appears. Review whether those commitments are captured consistently and how they are matched to actual expenses.

Avoid adding committed and invoiced values twice. Test a completed purchase through its whole lifecycle before relying on the report.

## Variations that need a decision

Separate proposed, submitted and approved variations. Record the owner, value and next action. A single total can hide work that has already been performed but is waiting for approval.

The useful question is often which variation needs attention this week. Build the view around that decision and its supporting records.

## Upcoming work and capacity

A workload view can combine confirmed jobs, expected starts and the people or equipment required. Keep tentative work visibly separate from committed work. A schedule based on uncertain dates should say so.

Before building any of these views, choose the users, refresh process and access rules. A small report with agreed definitions is easier to maintain than a large collection of charts built on inconsistent data.

## What should the first version contain?

Pick one view and one person who will use it. For a job margin report, choose a completed job and a current job, then trace every displayed total to its accounting or job record. Use deliberately awkward examples, such as a cancelled purchase order or a variation approved after month end.

Write down the cut off date and the definition of each measure. Ask the intended reader what action they would take from the result. If they cannot explain it without the report author in the room, simplify the view before adding more charts.

## How do you keep the report useful?

Show when the data was last refreshed and who investigates a failed refresh. Microsoft distinguishes refreshing the underlying data from synchronising a report file, so confirm that the process updates the records the business expects.

Keep a short report register with its owner, data source, access rules and review date. When the source system changes a field or the accounts team changes a definition, the report needs to change with it. A dashboard has ongoing maintenance even when the charts themselves stay the same.

## Further reading

- [Microsoft Power BI data refresh](https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data)

## Useful next steps

- [Power Platform support](https://www.adarkcloud.com.au/services/power-platform)
- [Reporting data guide](https://www.adarkcloud.com.au/blog/why-your-business-reporting-is-a-mess)

Reviewed 2026-10-07

- [Ask for IT help](https://www.adarkcloud.com.au/contact)
- [Check your IT basics](https://www.adarkcloud.com.au/tools/it-health-check)