Interactive BI dashboard built in Looker Studio, connected to a self-generated logistics dataset simulating multi-region freight operations across air and sea shipments. Built to demonstrate reporting and operational tracking skills alongside the SOP Library and Job Order Dashboard.
Current sample period shown below: Q2 2026. The dashboard structure is built to extend to future quarters or a live data feed without needing to be rebuilt.
Dashboard Overview: Q2 2026
Total Delivered: 285
Canceled: 4
Total 3PL: 57
Total High-Stakes: 78
Total Aero: 66
Total CBR: 14
Total INTEL: 74
What it tracks
- Pickup-to-delivery log - pickup date, pickup/drop-off addresses, delivery time, sector (Intel, High-Stakes, Aero, 3PL, CBR), and delivery type (Air NFO or Sea)
- Carrier Type split - 58.8% Air (NFO), 41.2% Sea
- Vehicle Used breakdown - Car, Truck, Van, and MPV/AUV volumes across all job orders
- Destination Country geo map - shipment volume plotted globally, with a sortable country breakdown table (Delivered count per country, e.g. United States 28, China 20, Canada 17)
- Delivered vs. Canceled trend - daily line chart from late April through end of June 2026, tracking delivery completions against cancellations
- Date range filter - lets a viewer isolate any custom period across the quarter
What this demonstrates
- Structuring and cleaning multi-field logistics data (job orders, sectors, delivery types, geo data) for reporting
- Building KPI summaries that stay consistent across every level of the dashboard (total delivered matches the sum of sector counts)