Fleet maintenance dashboard: what to measure.

A fleet maintenance dashboard is more than a pretty screen. It is a decision panel that shows, in seconds, where the fleet is healthy, where it needs attention, and where the risk of an unplanned stop is imminent.

KPIs that cannot be missing

1. Vehicle status

Each vehicle needs a clear status: up to date, expiring soon, or expired. Without this view, the team relies on scattered spreadsheets, and decisions get delayed.

2. Preventive maintenance on track (%)

The share of vehicles with preventive maintenance inside its deadline. This is the overall fleet health indicator. As a working rule of thumb, a drop below 80% usually deserves attention.

3. Upcoming expirations

List of vehicles expiring in the next 7, 15, or 30 days. It lets you plan the workshop, reserve parts, and line up replacement vehicles.

4. Risk score

A number (0–100) that combines failure history, item type, and days since the last replacement. The higher the score, the higher the attention priority. It is not a prediction of downtime — it is a transparent ranking of where to look first. The preventive vs predictive maintenance article explains how it works.

5. Maintenance cost per vehicle/month

Tracks cost evolution. A sudden increase may point to a recurring problem or to a component reaching the end of its life.

Metrics that complete the panel

The five indicators above show the current state. To see the trend, add:

• MTBF — mean time between failures: how long the fleet runs between one breakdown and the next.
• MTTR — mean time to repair: how long it takes from the problem appearing to the vehicle being back in service.
• Availability — the share of time a vehicle is fit to run.
• Cost per km — total maintenance cost divided by the distance covered in the period.
• Preventive vs corrective share — how much was spent before a failure and how much after it.

Together they separate two stories that look identical: a fleet that is expensive because of its age, and a fleet that is expensive because of weak method.

Where the data comes from

Most fleets already have the sources: work orders, replacement logs, fuel, tires, and document expirations. What is missing is putting them in one place.

No server and no installation required: free visualization tools such as Looker Studio connect spreadsheets and build the panel your team opens every day.

How to turn spreadsheets into a dashboard

What is missing is structure. Pirbrain Fleet was born from exactly this problem: loose spreadsheets that do not talk to each other.

The result is a panel the team runs on its own, without relying on IT, without installation, and without a server. And if the choice is between improving the spreadsheet or changing format, spreadsheet or dashboard: how to decide will help you pick.

Frequently asked questions

Which metric should I look at first?

Availability and preventive coverage: together they tell you whether the fleet can operate right now. Cost indicators explain why afterwards. Start with a handful of numbers and add more as the update routine settles in.

How often should the data be refreshed?

Status, expirations, and the vehicle queue need to be current daily. Cost, MTBF, and MTTR can be reviewed weekly or monthly. A stale dashboard is worse than a spreadsheet: it signals confidence it has not earned.

Does the dashboard replace the spreadsheet?

No. The spreadsheet stays as the record layer wherever the team can fill it in quickly. The dashboard is the reading layer: consolidate, compare, and show it to whoever decides.

How long until the panel becomes useful?

It depends on how consistently records are kept, not on the tool. A panel with three well-fed indicators beats ten charts with old data. Routine first, screen second.

With the metrics in place, you can compare tools and processes without guessing: see alternatives to spreadsheets before you migrate.