Power BI dashboard + website for logistics operators, carriers and shippers

Your cargo arrives.But logistics loses money on the way.

Delays that start at the warehouse, freight that eats the margin, trucks that return empty and idle at the dock. A logistics dashboard that shows where delivery leaks, and a website that brings the next shipment.

Network stress test

Switch on an event and watch the network react. The number is a simulation; the method is the dashboard's.

OTIF · P85 · cost per ton-km · empty returns · detention · PT · EN · ES

Simulated OTIF · illustrative96,2%

Why logistics is the topic that weighs most on results

15.5%of GDP is Brazil's logistics cost (2025)
8.8%of GDP in the US, almost half of ours
5 hfor loading and unloading before detention applies (Brazilian Law 11,442/2007)

Sources: ILOS, via CNN Brasil · Times Brasil / CNBC · Law 11,442/2007 (Brazil)

Occurrence conveyor

Eight parcels stuck on the belt of anyone managing in the dark.

Each box is a real road-freight pain. Scan it to open the manifest: what the manager says, what the dashboard shows and on which screen.

0/8 checkedTap a box to scan it

No parcel scanned yet

Pick a box. Each one carries the pain, the sentence heard on the operation floor and the dashboard's answer.

Occurrence manifestNº 01/08

The average says everything is fine

Manager's account“Average delivery is three days. Customers still complain every week.”
What the dashboard shows

Percentile lead time: P50, P85 and P95 transit by route against the promised date. P85 is the lead time you can really keep.

Dashboard screen: Lead timeKPI: P50 · P85 · P95

Occurrence manifestNº 02/08

On time, but incomplete

Manager's account“It arrived on the right day, but an item was missing, damaged or had no invoice. For the customer, it failed.”
What the dashboard shows

OTIF and perfect order: they show the stage where the order is lost (delay, damage, paperwork, first attempt).

Dashboard screen: Lead timeKPI: OTIF

Occurrence manifestNº 03/08

Freight eats the margin and nobody sees it

Manager's account“I close the month billing more and keeping less. I don't know which customer or route pays the bill.”
What the dashboard shows

A waterfall from freight to margin, and cost per ton-kilometer by customer, route and cargo type.

Dashboard screen: CostKPI: R$ / ton-km

Occurrence manifestNº 04/08

The truck returns empty

Manager's account“We take cargo to the Northeast and come back with nothing. Nobody measures what that costs.”
What the dashboard shows

Empty km, load factor per vehicle and the corridors with most empty returns, with cost and CO₂ alongside.

Dashboard screen: FleetKPI: % empty km

Occurrence manifestNº 05/08

Vehicle idle waiting to unload

Manager's account“The driver spent the day in the customer's queue. Detention exists, but I don't charge it.”
What the dashboard shows

Dwell time per customer and segment and the cost of detention, to negotiate or bill what is owed.

Dashboard screen: CustomersKPI: idle hours

Occurrence manifestNº 06/08

The delay is born at the warehouse

Manager's account“Everyone blames the road. When I look, the truck already left the DC late.”
What the dashboard shows

A 24-hour clock: departures and deliveries by hour, weekday × hour heat map and OTIF by departure hour.

Dashboard screen: ClockKPI: OTIF by hour

Occurrence manifestNº 07/08

Full DC and a jammed dock

Manager's account“At year-end the DC goes past 95% and the dock turns into a queue. We only find out about overflow afterwards.”
What the dashboard shows

Monthly occupancy per DC, pallets per cargo type and arrivals by hour with the dock queue.

Dashboard screen: WarehousesKPI: % occupancy

Occurrence manifestNº 08/08

Who is late: supplier or carrier?

Manager's account“Late inbound, short stock, and each one blames the other.”
What the dashboard shows

On-time ranking of suppliers and carriers, distance × delay and a list of routes to renegotiate.

Dashboard screen: Suppliers and ActionsKPI: punctuality

Lead time ruler

Promising the average is promising what only half can keep.

Drag the promised lead time and see how many deliveries arrive in time. That's why the dashboard shows percentiles (P50, P85, P95) and not just the average.

Transit time (days)

Deliveries on time—
Late per 1,000—

The average mixes the normal day with the bad day. P85 says in how many days 85% of deliveries have already arrived; it is the lead time the operation can sustain. P95 shows the tail, where complaints and fines live.

Illustrative (lognormal) distribution to explain the concept. In the dashboard, the P50–P95 band uses each route's real transit.

See it working

A logistics operator's control tower, open for you to explore.

This is Rotavia Logística, a dashboard we built as a demo for a fictional operator. Filter, browse the screens and open it full screen. The data is made up; the design, the questions and the care in reading are the ones we deliver.

Rotavia Logística: a logistics operator's dashboardFictional data

Questions the dashboard answers

  • CommandHow is the network: freight, lead time and margin per DC?
  • ClockWhat time do vehicles leave and when do deliveries arrive?
  • Lead timeHow many orders arrive perfect and where is the perfect order lost?
  • RoutesWhich routes make money and which lose it?
  • CostHow much does each ton-kilometer cost?
  • FleetDo vehicles leave full? What does returning empty cost?
  • WarehousesWhich DC is full and where does the dock jam?
  • ActionsWhat to do this month?
Open full screen ↗
94routes in the demo network
734fictional customers
111,000fictional deliveries over two years
167calculated, documented measures
24hours on the departure clock
Do the math

What does returning empty and waiting at the dock cost?

Enter your operation's numbers. The calculation runs in your browser, nothing is sent, and the result is an estimate to start a conversation, not a promise.

ROTAVIA · Weighbridge ticketOperation: yours
Empty returns per year
Waiting and detention per year
Hidden cost per year
Recoverable with the improvement

Checked by: 1 dashboard, continuous use, weekly review.

See this with my real data →

Simple estimate. Empty = trips × km × cost per km × % empty (return leg). Waiting = trips × hours × hourly cost. Detention billing depends on the contract and Brazilian Law 11,442/2007; confirm current values with ANTT.

Decision speedometer

How fast does your operation decide?

Switch on the statements that describe your reality today. Nobody sees it, and the needle shows your visibility level.

0/6 views active

Talk about my level →
KPI quick guide

Eight logistics KPIs every manager should master.

What it is, how it is calculated, how to read it and where the trap lies. The dashboard ships all of them ready and documented.

OTIF (On Time In Full)

Delivery on time and complete.

Formula
orders on time and complete ÷ orders delivered
How to read
Compare by customer, route and carrier; the target depends on the contract.
Trap
Counting “on time” without “in full” inflates the result.

Perfect order

Delivery with no failure at all.

Formula
on time, complete, undamaged, correct paperwork and first attempt
How to read
Shows the stage where the order is lost.
Trap
A single index hides the cause: break it down by criterion.

Transit time (P50, P85, P95)

In how many days half, 85% and 95% of deliveries arrive.

Formula
sort transit times and read the percentile value
How to read
Promise close to P85; P95 reveals the tail.
Trap
The average mixes the normal day with the disaster.

Cost per ton-kilometer

What it costs to move one ton for one kilometer.

Formula
total freight cost ÷ (tons × km)
How to read
Lets you compare routes of different distances and see cost inflation.
Trap
Freight per trip misleads: a long route always looks expensive.

Empty return

Share of kilometers driven without cargo.

Formula
empty km ÷ total km
How to read
Points to corridors where trucks return empty and call for backhaul cargo.
Trap
The fleet average hides the corridor that bleeds.

Vehicle load factor

How much of the capacity travels filled.

Formula
cargo carried ÷ capacity (weight or volume)
How to read
Low load on thin routes calls for consolidation.
Trap
Measuring by weight alone ignores bulky cargo.

Detention (waiting time)

Time a vehicle sits at the customer or dock.

Formula
departure time − arrival time
How to read
Brazilian Law 11,442/2007 sets 5 h for loading and unloading; beyond that, detention is billable per contract and current table.
Trap
Without arrival and departure records, there is nothing to bill.

First-attempt delivery

Deliveries completed without a second trip.

Formula
first-attempt deliveries ÷ deliveries made
How to read
Cross with time of day and customer profile, e.g. absence during business hours.
Trap
Every extra attempt becomes cost and complaints, yet disappears from the report.
Two fronts, one goal

A dashboard that shows. A website that brings the shipment.

Each front works alone, but together they close the loop: the site brings the quote, the dashboard shows what to do with the operation.

Power BI dashboard

For the board and operations managers
  • OTIF, perfect order and percentile lead time by route and carrier
  • Cost per ton-kilometer, margin per route and freight-to-goods ratio
  • Fleet load factor, empty returns, diesel and CO₂
  • Detention, receiving hours and dock queue
  • Warehouses, suppliers, seasonality and the month's action list
94%OTIF
30%Empty
6,2Ton-km
⚠ Northeast route returns 41% empty: renegotiate backhaul
Illustrative example

Website for carriers and operators

For the shipper looking for freight
  • A page per route, service and region, built for Google
  • Quote request with a short form and WhatsApp with the message ready
  • Shipment tracking and status with simple access
  • Fast on the driver's and the buyer's phone
  • Privacy-first, with tracking of which channel brought each quote

Example Carrier

Quote in 2 minutes
Request a quoteTrack cargo
Origin and destination, weight and deadline. No commitment.
Illustrative example

Website, landing page and web page design

We also build your carrier's website, landing pages for freight and storage campaigns, and pages for Google ads.

I want a site like this →
Restricted cargo

What the dashboard does not do, on purpose.

In logistics, the most tempting data is often the riskiest. That's why the design starts with what is left out.

No driver or plate exposed

Vehicles are identified by code. A person's name and plate are personal data and stay out of the analytics dashboard.

It doesn't replace your TMS

The dashboard reads what your TMS, ERP and WMS export. Routing and document issuing stay in their own systems.

It doesn't invent market benchmarks

Limits and targets are your operation's. When a reference comes from an outside source, the source shows on screen.

It doesn't hide the math

Every KPI has a written definition, and what the data can't compute is said. A percentile never becomes an average for convenience.

Project route

Four stops, from problem to live dashboard.

  1. Stop 1

    Diagnosis

    We talk about the questions you can't answer today and where the data comes from: TMS, ERP, WMS, spreadsheets.

  2. Stop 2

    Design

    We define KPIs, alerts and the look before writing the first line. You approve on paper.

  3. Stop 3

    Build

    We connect, model and publish. You validate each step with your own numbers.

  4. Stop 4

    Follow-up

    We see what the team really opens and adjust. The dashboard evolves with the operation.

FAQ

Frequently asked questions about logistics dashboards

What is a logistics dashboard?

A panel that gathers the operation's KPIs (lead time, OTIF, cost per ton-kilometer, load factor, empty returns, detention, warehouses and suppliers) in one view, so you decide with data instead of an end-of-month spreadsheet.

Do I need to replace my TMS or ERP?

No. We work with what your TMS, ERP, WMS and spreadsheets can export (CSV, Excel or database). We confirm the sources in the diagnosis.

Is it for small carriers or only large operators?

Both. With a few vehicles the focus is usually lead time, cost per trip and empty returns. With many routes and DCs, warehouses, suppliers, targets and seasonality come in.

Why use P85 instead of average lead time?

Because the average hides the tail: half the deliveries sit above the average lead time. P85 is the lead time 85% of deliveries meet, and it is what you can safely promise.

Does the dashboard show real-time vehicle tracking?

This version is analytical: it shows what happened and where to act. Real-time tracking depends on the telemetry you already use and can be integrated later, case by case.

Is driver and customer data safe?

We work with the minimum necessary, per-user access profiles and aggregates instead of individual data. Named drivers and plates stay out. The data remains yours.

Do I already need Power BI?

No. We assess with you the publishing format and licensing that suit the size of your operation.

How long does it take and what does it cost?

It depends on scope and source quality. In the diagnosis we set deadlines, deliverables and prices in writing before starting.

Next shipment

Cargo ready. Now dispatch.

Tell us which question your logistics still can't answer. We'll return with a clear path, no commitment.

Chat on WhatsApp →

Reply by WhatsApp or email. No bots.

Chat on WhatsApp →