The Crane Rental KPI Dashboard in Power BI scores 13 crane hire KPIs across 7 KPI groups on four report pages, with five slicers, five headline cards and a 12-column scorecard that rates every metric against target for both MTD and YTD. A full 2025 sample year and a 2024 prior year ship inside the data pack, so the report opens populated. Setup takes under 10 minutes: keep Data.xlsx next to the .pbix, replace the sample rows with your own and press Refresh.
🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.
✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access
This listing belongs to our Power BI KPI dashboard family: a month-picker scorecard with red, amber and green status lights, a KPI Trend page and a KPI Definition page. It is not one of our analytical Power BI dashboards, which slice transaction-level data across overview and analysis pages. If you want to know whether each crane hire metric hit target this month, and whether it is better or worse than last year, this is the right file.
🔑 Key Features of the Crane Rental KPI Dashboard in Power BI
🎯 13 crane-hire KPIs, each with its own direction. Six are higher-is-better (Crane Rental Revenue, Revenue per Crane, Rental Rate Realisation %, Quote-to-Order Win Rate %, Time Utilisation % and PM Schedule Compliance %) and seven are lower-is-better (Days Sales Outstanding, Mobilisation Lead Time, Lift Plan Turnaround, Unplanned Downtime Hours, Maintenance Cost per Engine Hour, Lift Incidents per 100k Crane Hours and Operator Overtime %).
🚦 Direction-aware achievement. Higher-is-better KPIs score Actual divided by Target; lower-is-better KPIs score Target divided by Actual, so getting a crane rigged on site faster than target scores above 100%. The bands are fixed and documented: On Target at 100% or more, At Risk from 95% to 100%, Missed below 95%.
↕️ A YoY figure that reads the right way round. YoY % is expressed as improvement, so a fall in a lower-is-better KPI shows as a green up-arrow. In the December 2025 sample, Mobilisation Lead Time dropped from 30.32 to 28.51 hours per job and shows +6.0% in green, while Days Sales Outstanding rose from 58.36 to 63.74 days and shows -9.2% in red.
🎛️ Five slicers on the scorecard page: Month, KPI Group, Owner, Priority and Direction. The KPI Trend and KPI Definition pages share a KPI Name selection, so the KPI you pick on one page is ready on the other.
📈 A 12-month sparkline on every row and every card. Total KPIs, MTD Target Met, MTD At Risk, MTD Target Missed and Achievement MTD each carry a month-over-month change and a 12-month trend bar, and every KPI row repeats its own sparkline.
🧾 Nothing is hard-coded. Every card, chart and table is driven by the rows in the data pack. Rename a KPI, add one or delete one, press Refresh, and the counts, the scorecard, the KPI picker and every chart follow.
📦 What is Inside This Power BI KPI Dashboard
The download is a ZIP holding three files: the .pbix report, Data.xlsx (the data pack) and a Power BI dashboard user manual PDF. The report has four visible pages plus two hidden tooltip pages, KPI Detail and Trend Detail, that appear when you hover a visual.
Page 1: KPI Scorecard
The month view. Five slicers sit above five header cards, and a 13-row table gives each KPI its group, unit, 12-month sparkline, MTD actual, target, achievement %, status light and YoY arrow, then YTD actual, achievement % and status light. In the shipped December 2025 sample, 7 KPIs are On Target, 3 At Risk and 3 Missed, at 98.9% Achievement MTD. The three misses are Lift Plan Turnaround (86.5%), Unplanned Downtime Hours (656 against a 569-hour target, 86.7%) and Days Sales Outstanding (91.1%).
Page 2: KPI Trend
Pick one KPI from the list on the left and the page becomes that KPI: six context cards (KPI, group, unit, direction, owner and priority), five value cards (MTD actual, target, achievement %, status and YoY %), then CY MTD vs PY MTD vs Target MTD by Month and CY YTD vs PY YTD vs Target YTD by Month. For Crane Rental Revenue it reads 4,090,002 against a 3,892,170 target, 105.1%, On Target and +7.2% on last year.
Page 3: KPI Definition
The same KPI, explained. Cards show the formula (for example Sum of Invoiced Operated Hire, Bare Hire & Mobilisation Charges), the plain-English definition, group, unit, direction, owner, priority and a 12-month trend. Below sit a Monthly Detail for the Selected KPI table covering January to December with a total, plus MTD Actual vs Target by Month and Achievement % by Month charts. In the sample, August (98.9%) and November (99.9%) 2025 are the two At Risk months for revenue.
Page 4: Get More Templates
A catalogue and help page rather than a data page. It lists other Power BI dashboards, our services, and a Using and Customizing This Template panel covering the month picker, the KPI Trend selection, swapping in your own data, UTB and LTB scoring and recolouring the theme in one place.
The data pack
Data.xlsx carries four sheets: a Read Me; Input_ Target with 156 rows (13 KPIs x 12 months); Input_ Actual with 312 rows covering 2025 and the 2024 prior year; and KPI Definition, which holds each KPI’s group, unit, formula, definition, UTB or LTB type, owner and priority. The shipped KPIs are owned by 10 named roles, from General Manager and Fleet Manager to Dispatch Manager and Workshop Manager, at three priority levels: 5 Critical, 6 High and 2 Medium.
📊 Power BI vs. Tableau or Qlik vs. Rental Management Software – Where This Fits
| Feature | This Power BI KPI Dashboard | Tableau / Qlik | Rental management software |
|---|---|---|---|
| Cost | $12.99 one-time ✅ | $70-115 / user / month | Quote-based subscription |
| Platform | Power BI Desktop (free) ✅ | Paid desktop plus server | Vendor cloud or server |
| Setup time | Under 10 minutes ✅ | Days of modelling | Weeks of implementation |
| KPI targets and RAG bands built in | Yes, 13 KPIs pre-scored ✅ | Build it yourself | Reports fixed to their schema |
| Lower-is-better metrics scored correctly | Yes, per-KPI UTB/LTB flag ✅ | Manual calculated field | Varies |
| Add or rename a KPI | Edit a spreadsheet row ✅ | Edit the workbook | Vendor-controlled fields |
| Bookings, dispatch and hire invoicing | No, reporting only | No | Yes ✅ |
| Mobile access | Power BI mobile app | Yes ✅ | Yes ✅ |
| Year-1 cost at 5 users | $12.99 ✅ | $4,200-6,900 | Recurring, several thousand dollars |
For a crane hire company that wants a scored, target-driven monthly KPI pack without a per-seat BI bill or a software migration, this Power BI KPI dashboard sits in the sweet spot.
👥 Who This Template Is For – and Who It Is Not For
✅ This template is built for:
- Owners and general managers of crane hire companies running mobile, crawler or tower cranes on operated or bare hire
- Fleet, dispatch and workshop managers who already log utilisation, mobilisation times and breakdown hours in spreadsheets and want them scored monthly
- Finance and sales leads reporting rate realisation, win rate and debtor days to an owner or board
- Power BI users who want a finished, well-modelled KPI report to adapt rather than a blank canvas
❌ This template is NOT for:
- Anyone needing bookings, dispatch boards, hire contracts or invoicing; this is a reporting layer, not a rental management system
- Teams wanting live telematics or a direct connection to their rental ERP; the source is an Excel workbook you maintain
- Anyone looking for lifting operations or safety-compliance software; it produces no lift plans, load charts, inspection records or operator training records, and it makes no regulatory claim
- Anyone who needs industry benchmarks; every target in the file is one you set yourself, and the sample figures are fictional
⚙️ How to Use This Power BI KPI Dashboard
- Unzip the download and keep the .pbix and Data.xlsx in the same folder.
- Open the .pbix in Power BI Desktop (free from Microsoft). The sample year loads immediately.
- If you moved the files, re-point the source once: Home > Transform data > Data source settings > Change Source.
- Edit the KPI Definition sheet: names, groups, units, formulas, owners, priorities and the UTB or LTB flag that decides how each KPI is scored.
- Fill Input_ Target and Input_ Actual, one row per KPI per month, and load last year into Input_ Actual so every PY and YoY figure has something to read.
- Enter YTD as a running total for money and counts, and as the average of the months so far for %, days and rates.
- Press Home > Refresh, then use the Month slicer and the KPI Name list to review the month.
💼 Real-World Use Cases
Daniel owns a crane hire company with a mixed fleet of mobile and crawler cranes. On the first Monday of each month he filters Priority to Critical and sees Unplanned Downtime Hours Missed at 86.7% while Crane Rental Revenue is still On Target at 105.1%. Revenue is holding for now, but breakdown hours are eating the fleet’s available days, so he books a review with the workshop.
Priya is the credit manager. She selects her name in the Owner slicer before the month-end finance meeting, which leaves Days Sales Outstanding on screen: 63.74 days against a 58.08-day target, and 9.2% worse than December 2024. That gives her a specific number to take into the conversation about account terms with slow-paying contractors.
Tom runs dispatch. He lives on the KPI Trend page, flipping between Mobilisation Lead Time and Time Utilisation %. The CY vs PY chart shows mobilisation is faster than last year at 28.51 hours per job, and utilisation is up to 72.86%, so he can show the operations meeting that the improvement is real and not one good month.
❓ Frequently Asked Questions
What KPIs does the Crane Rental KPI Dashboard in Power BI track?
It tracks 13 KPIs in 7 groups: Financial, Commercial, Fleet, Operations, Maintenance, Safety and People. They run from Crane Rental Revenue, Revenue per Crane and Rental Rate Realisation % to Time Utilisation %, Mobilisation Lead Time, Unplanned Downtime Hours and Operator Overtime %, each with a formula and definition.
How long does setup take?
Under 10 minutes if your monthly actuals and targets already exist somewhere. Unzip, open the .pbix in Power BI Desktop, replace the rows in Data.xlsx with your own and press Refresh. Deciding your targets takes longer than configuring the file.
Does it handle metrics where lower is better?
Yes. Seven of the thirteen shipped KPIs carry an LTB flag and score Target divided by Actual, so cutting downtime, debtor days or mobilisation time pushes achievement above 100%. The YoY % follows the same rule, so green always means better than last year and red always means worse.
How does this compare to rental management software?
Rental management platforms are sold as subscriptions and handle bookings, dispatch, contracts and hire invoicing. This template is a $12.99 one-time reporting layer that scores the monthly numbers you already have. It reports; it does not book cranes, dispatch crews or raise invoices.
Do I need a paid Power BI licence?
No. Power BI Desktop is free from Microsoft and opens, refreshes, filters and prints the report. A Power BI Pro licence is only needed if you want to publish the report to the Power BI Service and share it with colleagues online.
Is there an Excel or Google Sheets version?
Excel and Google Sheets editions of this crane rental KPI dashboard are in preparation. Available now is the Crane Rental KPI Scorecard in Google Sheets, which is our scorecard line rather than this dashboard line: a lighter monthly scorecard built in Google Sheets instead of a multi-page Power BI report.
Does it cover lifting safety or regulatory compliance?
No. Lift Incidents per 100k Crane Hours and PM Schedule Compliance % are performance counts you enter yourself, not inspection, certification or incident records. Nothing in the file plans lifts, checks load charts or verifies operator competence. Keep those in the systems your regulator and insurer expect.
👤 About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PKAnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.
🔗 Explore Related Templates
Same trade, different format: the Crane Rental KPI Scorecard in Google Sheets is a lighter monthly scorecard, and the Equipment Rental Business KPI Scorecard in Google Sheets covers general plant and tool hire.
Fleet and machinery analytics in Power BI: the Heavy Machinery Dashboard in Power BI, the Agro Machinery Rental Dashboard in Power BI and the Rental Services Dashboard in Power BI slice transaction-level data rather than scoring KPIs.
More KPI dashboards on this platform: Elevator Maintenance KPI Dashboard in Power BI, Concrete Contractor KPI Dashboard in Power BI and Paving Contractor KPI Dashboard in Power BI. Browse all KPI Dashboard Templates or the full range of Power BI Dashboards.
📖 Click here to read the Detailed Blog Post
🎥 Visit our YouTube channel for step-by-step video tutorials
👉 YouTube.com/@NextGenTemplates
📅 Last updated: September 2026
