Mission
This project turns 2,000 shipment records, warehouse activity, and carrier performance into a decision layer that helps operations teams reduce failures, improve on-time delivery, and tighten cost control.
Back to projects
Project 02
Excel Dashboard
Logistics Mission Control Dashboard
A logistics decision dashboard built to expose delivery failures, benchmark warehouse performance, and reduce avoidable transport cost across a simulated nationwide network.
Tools
Microsoft Excel Power Pivot DAX Custom UI/UX Design (Warm Clay Theme)
1 / 2
Key findings
- Identified a 13.8% problem rate across yearly shipments, including delays, losses, and returns.
- Flagged Amazon Logistics as a high-risk outlier and recommended reallocating volume toward stronger partners such as UPS and FedEx.
- Established the NYC warehouse as the internal benchmark and defined a rollout path for underperforming hubs in Los Angeles and San Francisco.
- Uncovered USPS as the most cost-efficient partner for sub-500-mile deliveries, revealing a clear short-haul savings opportunity.
Project intent
This project turns 2,000 shipment records, warehouse activity, and carrier performance into a decision layer that helps operations teams reduce failures, improve on-time delivery, and tighten cost control.
Impact
- $24,000 in projected annual cost savings
- 86% on-time delivery, up from 82.4%
- Approximately 112 prevented logistics failures per year
Tools used
Microsoft Excel Power Pivot DAX Custom UI/UX Design (Warm Clay Theme)