Case study · Power BI · Retail & supply chain
Supply chain delivery
Three years of a retailer’s orders, rebuilt as a Power BI model: what sold, what it earned, and whether it arrived when promised. The premium shipping mode is late on every single order — and the reason is the promise, not the warehouse.
Loading the data…
The promise against the delivery
Shipped orders only. Each bar is the share of that mode’s orders taking that many days; gold bars are past the promise.
Late rate by mode
| Mode | Promised | Average days | Orders | Late |
|---|
By department
| Department | Net sales | Margin | Lines at a loss |
|---|
About one line in five loses money in every department — a flat rate the report shows rather than explains.