The Demolition Services KPI Dashboard in Power BI gives a demolition contractor one monthly scorecard for 13 KPIs in 6 groups, with MTD and YTD traffic lights, a 12-month trend per KPI and a month picker, across 4 report pages. Its sample data runs to December 2025 and shows 7 KPIs On Target, 3 At Risk and 3 Missed, at 97.4% Achievement MTD.
Demolition firms earn and lose money in places that rarely share a spreadsheet. Contract revenue and margin sit with finance, cost per tonne and debris tonnage with operations, plant utilisation and breakdowns with the fleet team, and debris diversion with the environmental lead. This template puts those numbers on one page, scored the same way, so the monthly review starts with what is off track instead of a hunt for files.
It belongs to our Power BI KPI Dashboard family: a month-picker KPI scorecard with traffic lights plus KPI Trend and KPI Definition pages. It is not an analytical dashboard with transaction-level charts.
Key Features of the Demolition Services KPI Dashboard
- 13 demolition KPIs in 6 groups. Financial (3), Operations (2), Safety (2), Project Delivery (2), Plant & Equipment (2) and Environmental (2), each with a unit, formula, definition, owner and priority.
- Month picker plus four more slicers. Month, KPI Group, Owner, Priority and Direction filter the header cards and the scorecard table.
- Direction-aware achievement. Nine KPIs are higher-is-better and score Actual ÷ Target. Four are lower-is-better and score Target ÷ Actual, so a Cost per Tonne Demolished figure below target scores above 100%.
- Consistent traffic lights. On Target means 100% or more, At Risk means 95% to 100%, and Missed means below 95%, for both MTD and YTD.
- Prior-year comparison built in. Data.xlsx carries actuals for 2024 and 2025, so YoY % and the PY lines on the trend charts read from real rows.
- No hard-coded KPIs. Rename, add or remove KPIs in the input sheets and press Refresh; counts, lists and charts follow.
Dashboard Pages Explanation
Page 1: KPI Scorecard
Five header cards show Total KPIs, MTD Target Met, MTD At Risk, MTD Target Missed and Achievement MTD, each with a month-on-month change and a 12-month trend. Below them the scorecard lists every KPI with KPI Group, Unit, 12M Trend, Actual and Target (MTD), Achievement % (MTD), Status Light (MTD), YoY Arrow (MTD), Actual (YTD), Achievement % (YTD) and Status Light (YTD).
Page 2: KPI Trend
Select a KPI from the list on the left. Context cards show the selected group, unit, direction, owner and priority, and value cards show KPI Actual, Target, Achievement %, Status and YoY % for the month. Two line charts compare CY MTD vs PY MTD vs Target MTD by Month and CY YTD vs PY YTD vs Target YTD by Month.
Page 3: KPI Definition
A synced KPI selector shows the chosen KPI’s formula, definition and 12-month trend. A Monthly Detail for the Selected KPI table lists Actual, Target, Achievement % and Status by month for MTD and YTD. Charts show MTD Actual vs Target by Month and Achievement % by Month.
Page 4: Get More Templates
A support page with usage tips (change the month, pick a KPI, swap in your data, recolour the theme) and a list of more Power BI templates. The file also holds two hidden tooltip pages, KPI Detail and Trend Detail, which are not separate tabs.
The 13 KPIs
| KPI Group | KPI | Unit | Direction | Owner (sample) |
|---|---|---|---|---|
| Financial | Contract Revenue | USD | Higher is better | Chief Financial Officer |
| Financial | Gross Margin % | % | Higher is better | Commercial Director |
| Financial | Scrap & Salvage Revenue | USD | Higher is better | Salvage & Materials Manager |
| Operations | Cost per Tonne Demolished | USD/Tonne | Lower is better | Estimating & Cost Manager |
| Operations | Debris Tonnage Processed | Tonnes | Higher is better | Director of Operations |
| Safety | Total Recordable Incident Rate | Rate | Lower is better | HSE Director |
| Safety | Site Safety Audit Score | Index | Higher is better | Site Safety Manager |
| Project Delivery | On-Time Project Completion % | % | Higher is better | Project Director |
| Project Delivery | Permit & Pre-Demolition Survey Days | Days | Lower is better | Pre-Construction Manager |
| Plant & Equipment | Plant Utilization % | % | Higher is better | Plant Manager |
| Plant & Equipment | Unplanned Equipment Downtime Hours | Hours | Lower is better | Fleet Maintenance Lead |
| Environmental | Debris Diversion Rate % | % | Higher is better | Environmental Compliance Manager |
| Environmental | Asbestos Air Clearance Pass Rate % | % | Higher is better | Abatement Superintendent |
Power BI KPI Scorecard vs. Tableau / Qlik vs. Construction SaaS: Feature Comparison
| Feature | This Power BI template | Tableau / Qlik build | Construction SaaS (e.g. Procore analytics) |
|---|---|---|---|
| Cost | ✅ $12.99 one-time | Per-user licences plus build time | Recurring subscription, usually quote-based |
| Platform | Power BI Desktop (free, Windows) | Tableau or Qlik client | Vendor web app |
| Setup | ✅ Open the .pbix and explore at once | Design from a blank canvas | Onboarding and integration |
| Demolition KPIs included | ✅ 13 with formulas and definitions | None until built | Generic project metrics |
| Direction-aware traffic lights | ✅ Yes | Custom calculation | Varies |
| Customisable KPIs | ✅ Edit Data.xlsx, then Refresh | Yes, with development | Limited to vendor fields |
| Share with a team | Needs a Power BI service licence | Server or cloud licence | ✅ Built in |
| Field and mobile apps | Power BI mobile once published | Vendor apps | ✅ Usually included |
| Year-1 cost at 5 users | ✅ $12.99 for the file (sharing licences separate) | Five annual licences | Five seats or a quote |
For demolition contractors that want a monthly KPI scorecard without a new software contract, this Power BI template sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Owners, operations directors and finance managers of demolition, strip-out and site clearance contractors running a monthly KPI review
- Plant and fleet managers who watch utilisation and unplanned downtime
- Power BI analysts who want a working KPI scorecard model to adapt rather than build from scratch
Not a fit if:
- You need permit, survey, air-monitoring or compliance software. This template reports monthly values you enter and makes no regulatory or certification check
- You only use a Mac and have no Windows machine for Power BI Desktop
- You need live, daily or job-by-job reporting instead of monthly KPI values
Real-World Use Cases
An operations director preparing the monthly board pack sets Priority to Critical and gets six KPIs: Contract Revenue, Gross Margin %, Cost per Tonne Demolished, Total Recordable Incident Rate, On-Time Project Completion % and Asbestos Air Clearance Pass Rate %. In the December sample Gross Margin % shows Missed at 93.4% (17.76 against a 19.01 target), so margin comes first on the agenda.
A commercial manager reviewing salvage income opens KPI Trend for Scrap & Salvage Revenue. The sample shows it Missed at 78.5% with a -19.4% YoY change, and the CY vs PY lines show whether that gap is a one-month dip or a trend before salvage pricing on upcoming jobs is reset.
A pre-construction manager filters Owner to their role. Permit & Pre-Demolition Survey Days reads 26.25 days against a 22.28-day target, scoring 84.9% and Missed, which gives the next planning meeting a clear starting point.
Advantages of This Demolition KPI Scorecard
- One scoring rule for every KPI. Revenue in dollars, cost per tonne, survey days and incident rates all land on the same Achievement % scale.
- Accountability by owner. Thirteen named owner roles in the sample, from Plant Manager to HSE Director, make the Owner slicer a ready meeting filter.
- Definitions travel with the numbers. The KPI Definition page shows each formula, for example Enclosures Passing First Clearance Air Test ÷ Enclosures Tested, so nobody argues about how a percentage was calculated.
- One-time cost. The .pbix and Data.xlsx are yours to edit and extend, with no subscription.
Opportunities for Improvement
- The YoY Arrow is not direction-aware. Its colour follows the sign of the change, so Unplanned Equipment Downtime Hours falling 6.7% shows a red down arrow and Total Recordable Incident Rate rising 8.7% shows a green up arrow. Read YoY together with the direction; Achievement % and the status lights are direction-aware.
- YTD values are typed, not calculated. Input_ Target and Input_ Actual hold both MTD and YTD columns. Follow the Read Me: sum additive KPIs and average rates, days and indexes.
- Monthly grain only, no drillthrough. There is no job, site or depot drill-down; add columns and visuals if you need them.
- Sample figures are fictional. They show how the report behaves and are not industry benchmarks.
Best Practices
- Agree each KPI’s formula and owner before typing numbers, and record them in the KPI Definition sheet.
- Set Type correctly: UTB for higher-is-better and LTB for lower-is-better, or achievement and traffic lights will read backwards.
- Enter the prior year’s actuals as well, so YoY figures and PY lines have data.
- Review Critical KPIs first each month, then filter by owner for follow-up actions.
- Keep Data.xlsx beside the .pbix and use Power BI data refresh after each monthly update. Power BI Desktop itself is a free download from Microsoft.
Explore Relevant Templates
On this blog, the same KPI scorecard model is covered for the Scaffolding Services KPI Dashboard in Power BI, the Concrete Contractor KPI Dashboard in Power BI, the Home Renovation Contractor KPI Dashboard in Power BI and the Kitchen Remodeling KPI Dashboard in Power BI.
On NextGenTemplates, demolition firms can pair this scorecard with the Demolition Contractor Management System Web App for day-to-day job records, or choose the Demolition Services KPI Scorecard in Google Sheets, which is a different template built in Sheets. Excel and Google Sheets KPI dashboard editions of this topic are in preparation. Browse all Power BI KPI Dashboard templates.
Frequently Asked Questions
What KPIs does the Demolition Services KPI Dashboard in Power BI track?
The Demolition Services KPI Dashboard in Power BI tracks 13 KPIs in six groups, including Contract Revenue, Gross Margin %, Cost per Tonne Demolished, Debris Tonnage Processed, Debris Diversion Rate %, Plant Utilization %, Total Recordable Incident Rate and On-Time Project Completion %, each scored MTD and YTD against target.
Do I need a paid Power BI licence?
No. Power BI Desktop is free and is all you need to open, edit and refresh the file. A Power BI service licence is only needed if you want to publish the report online and share it with colleagues.
How long does setup take?
The sample report works as soon as it opens. To use your own figures, edit the KPI Definition sheet, paste monthly MTD and YTD values into Input_ Target and Input_ Actual, and press Refresh. The time depends mainly on how quickly you can collect your monthly numbers.
Does it manage permits, surveys or air monitoring?
No. It reports monthly KPI values you enter, such as Permit & Pre-Demolition Survey Days and Asbestos Air Clearance Pass Rate %, but it does not issue permits, record test results or check any regulation. The shipped figures are fictional sample data.
How does it compare with a construction SaaS platform?
The template is a one-time $12.99 file focused on a monthly KPI scorecard. Construction SaaS platforms add job management and field apps but charge a recurring subscription. If the scorecard is what you need, this template covers it without a contract.
Can I add my own KPIs?
Yes. Add a row to KPI Definition and matching monthly rows to Input_ Target and Input_ Actual, then press Refresh. The KPI name is the join key, so spell it the same in all three sheets.
About the Author
Built by PK, a Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience and the founder of NextGenTemplates. Every template is hand-built and tested before release.
Conclusion
If your monthly review still means stitching together revenue, tonnage, plant and safety numbers from different files, the Demolition Services KPI Dashboard puts all 13 KPIs on one scored page with a trend and a definition for each.
👉 Click here to Purchase the Demolition Services KPI Dashboard in Power BI
✅ Instant download · One-time payment · No subscription
🎥 Watch step-by-step tutorials on Youtube.com/@PKAnExcelExpert
Last updated: September 2026
