Vehicle Availability Dashboard and Reporting

About the Program

Category: County Administration and Management (Best in Category)

Year: 2023

The Fleet Management Division (FMD) services approximately 9,000 vehicles. These services are performed by 253 budgeted positions throughout 19 maintenance and repairs shops, which conduct more than 190,000 repairs per year for 30 internal departments and 14 external municipal agencies. The shops are divided between light and heavy vehicle service operations. The Vehicle Availability program focuses on the heavy service operation which maintains approximately 2,000 vehicles across five shops. The Vehicle Availability program was developed based on discussions between FMD, the Department of Solid Waste Management (DSWM), and the Information Technology Department (ITD). The discussions centered on the number of garbage collection vehicles available each day for the designated service routes within Miami-Dade County (MDC). Using Power BI, a Microsoft business intelligence reporting and visualization tool, the departments were able to coordinate and build a dashboard and supporting reports from FMD’s software. These tools allow DSWM and FMD to see the current fleet status and make sound operational decisions.