Trucking KPI Dashboard Expert Needed (Google Sheets)

I am looking for an experienced professional to build a clean, automated KPI dashboard for my trucking operation using Google Sheets as the data source.

The dashboard must clearly show the most important trucking metrics so I can quickly understand overall performance, truck profitability, cost control, and cash flow.
All visuals must update automatically when Google Sheets data changes.

⸻

Key Metrics (KPIs) Required:

Revenue & Profitability
• Total Revenue (weekly & monthly)
• Net Profit
• Net Profit Margin %
• Revenue per Truck
• Revenue per Mile (RPM)
• Cost per Mile (CPM)

Truck & Driver Performance
• Revenue per Truck
• Miles per Truck
• Net Profit per Truck
• Driver pay vs revenue
• Loaded vs empty miles (deadhead %)

Expenses
• Fuel costs
• Maintenance costs
• Driver pay
• Fixed vs variable expenses
• Visual expense breakdown

Cash Flow
• Cash balance
• Accounts receivable (paid vs unpaid invoices)
• Days to get paid

⸻

Data Source & Structure
• All data will be provided via Google Sheets
• Multiple tabs (loads, trucks, drivers, expenses)
• Dashboard must be fully dynamic and automated
• Weekly reporting period: Sunday–Saturday

⸻

Dashboard Requirements
• Direct connection to Google Sheets
• Automatic updates (no manual refresh)
• Filters for:
• Date range
• Truck / Unit #
• Driver
• Clean, professional, easy-to-read visuals

⸻

Required Skills
• Advanced Google Sheets
• Dashboard & KPI visualization experience
• Strong understanding of trucking or logistics data
• Ability to calculate RPM, CPM, profit per truck
• Fluent English (must clearly understand requirements)

⸻
Deliverable
• Fully functional KPI dashboard
• Ready for daily & weekly decision-making
• Clear explanation of formulas and structure

⸻
When Applying, Please Include
• Examples of dashboards you’ve built
• Experience with trucking or logistics (preferred)