Fleet Energy Efficiency Dashboard

This dataset provides granular, real-time insights into energy consumption, operational efficiency, and sustainability metrics for commercial transportation fleets. It enables fleet managers and planners to benchmark routes, identify inefficiencies, and optimize logistics for reduced emissions and improved cost-effectiveness.

  • last updated 1 Dec 2025
  • by GoMask
The brief that made it

Benchmarking route and vehicle energy efficiency

Sample rows

preview · 8 of 120 rows · all 20 columns
fleet_idstringvehicle_typestringdistance_kmfloatinefficiency_flagbooleanvehicle_idstringroute_idstringroute_namestringstart_locationstringend_locationstringtrip_start_datetimedatetimetrip_end_datetimedatetimeenergy_consumed_kwhfloatfuel_typestringaverage_speed_kphfloatidle_time_minutesfloatcargo_weight_kgfloatco2_emissions_kgfloatdriver_idstringefficiency_scorefloatbenchmark_comparisonstring
FLEET_Atruck1300.2trueVEH001ROUTE1001Pacific Interstate HaulSeattle DepotSan Jose Terminal2024-01-09T06:15:002024-01-10T03:05:001600.7diesel68.545.3219806520.3DRV000154.8below average
FLEET_Bvan32.5falseVEH002ROUTE1002Downtown Delivery RunDenver CentralAurora West2024-03-16T08:20:002024-03-16T09:05:004.8electric39.46.2451.70DRV000294.2above average
FLEET_Cbus18.7falseVEH003ROUTE1003School Express NorthSalt Lake NorthOgden School District2024-04-04T07:15:002024-04-04T07:54:0011.9hybrid28.113.510233.1DRV000373.5above average
FLEET_Dcar43.2falseVEH004ROUTE1004Executive Shuttle SouthDallas UptownPlano Center2024-02-21T09:00:002024-02-21T09:38:006.2hybrid68.22.185.42.7DRV000481.7above average
FLEET_Eother0falseVEH005ROUTE1005blankPhoenix WestTempe Distribution2024-05-18T13:50:002024-05-18T13:50:000other0000DRV0005100above average
FLEET_Ftruck550.8trueVEH006ROUTE1006Northern Timber HaulPortland MillSpokane Yard2024-03-26T05:45:002024-03-27T00:37:00655.1diesel60.627.918234.62751.8DRV000658.6below average
FLEET_Gvan24.9falseVEH007ROUTE1007Suburban Parcel LineMiami NorthCoral Springs Depot2024-06-02T08:10:002024-06-02T08:43:003.7electric41.85.3384.20DRV000797.6above average
FLEET_Hbus14.2falseVEH008ROUTE1008Commuter Loop EastChicago WestEvanston Station2024-05-07T07:05:002024-05-07T07:35:0013.4diesel32.79.891023.1DRV000862.2average

What the 120 rows show

from the 120-row sample

Truck (vehicle type) stands out: mean distance_km is 659.5, against 20.0 for the rest.

  • 26%inefficiency_flag = true
  • 18.8median distance_km
  • 3benchmark comparisons
  • 4fuel types
  • 7.1median energy_consumed_kwh
  • 40.6median average_speed_kph
Mean distance_km by vehicle_type120 rows
0400800659.5truck25 rows25.1van24 rows13.2bus28 rows29.8car22 rows12.9other21 rows
distance_km120 rows, in bands of 200
050100976651211101,0001,800distance_km →

Median 18.8, from 0.0 to 1,633.

fleet_id120 rows · top 10 of 11 values
  1. FLEET_A12
  2. FLEET_D12
  3. FLEET_E12
  4. FLEET_B11
  5. FLEET_C11
  6. FLEET_F11
  7. FLEET_G11
  8. FLEET_H10
  9. FLEET_I10
  10. FLEET_J10
20 columns by typefrom the column list below
  • string 10
  • float 7
  • datetime 2
  • boolean 1

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 10 columns
fleet_idstringUnique identifier for the fleet (company or group of vehicles)11 fleetsFLEET_A
vehicle_idstringUnique identifier for each vehicle in the fleetuniqueVEH001
vehicle_typestringType of vehicle (e.g., truck, van, bus)truck · van · bus · car · othertruck
route_idstringUnique identifier for the route taken by the vehicleROUTE1001
route_namestringHuman-readable name or description of the routeoptionalPacific Interstate Haul
start_locationstringStarting point of the route (city or depot name)Seattle Depot
end_locationstringEnding point of the route (city or depot name)San Jose Terminal
fuel_typestringType of fuel or energy source used (e.g., diesel, electric, hybrid)diesel · electric · hybrid · gasoline · otherdiesel
driver_idstringUnique identifier for the driver assigned to the tripoptionalDRV0001
benchmark_comparisonstringComparison result against route or fleet benchmarks (e.g., 'above average', 'below average')above average · average · below average · optionalbelow average
Numbers 7 columns
distance_kmfloatTotal distance of the route in kilometers0 or more1300.2
energy_consumed_kwhfloatTotal energy consumed during the trip in kilowatt-hours0 or more1600.7
average_speed_kphfloatAverage speed of the vehicle during the trip in kilometers per hour0 or more · optional68.5
idle_time_minutesfloatTotal time vehicle was idling during the trip, in minutes0 or more · optional45.3
cargo_weight_kgfloatWeight of cargo carried during the trip, in kilograms0 or more · optional21980
co2_emissions_kgfloatEstimated CO2 emissions for the trip, in kilograms0 or more · optional6520.3
efficiency_scorefloatCalculated operational efficiency score for the trip (0-100 scale)0 to 100 · optional54.8
Dates and times 2 columns
trip_start_datetimedatetimeDate and time when the trip started2024-01-09T06:15:00
trip_end_datetimedatetimeDate and time when the trip ended2024-01-10T03:05:00
True or false 1 column
inefficiency_flagbooleanIndicates if the trip was flagged for inefficiency (true/false)optionaltrue

Use it for

  • inefficiency f…26%31 of 120 rowsmean distance km by v…659.5truck25.1van13.2bus29.8car

    A transportation dashboard

    The inefficiency_flag rate, distance_km by vehicle_type and a breakdown of fleet_id. Excel, Power BI or Tableau.

  • Why do the 25 truck rows have a mean distance_km of 659.5?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable fleets with vehicle_id, vehicle_type and route_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset120 rows20 columns
Yours1,000 rows20 columnsstart_location: UK only

blueprint · fleet-energy-efficiency-dashboard

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each row records a unique fleet vehicle trip
  • Include timestamp, route type, energy used (kWh), distance (km), and efficiency score
  • Flag trips with efficiency score below set threshold
  • Highlight any trips on high-traffic routes for sustainability analysis
  • Aggregate daily fleet averages for comparative benchmarking
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
fleet-energy-efficiency-dashboard

More in Transportation

Browse all
Also in TransportationTransportation Fleet Energy ConsumptionFleet Predictive Maintenance LogsVehicle Route Efficiency ScoresAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.