This dashboard provides a granular view of 5000+ orders across 24 countries in Latin America. It is a powerful tool for analyzing the interplay between sales performance (Profit, Gross Sales) and operational efficiency (On-Time Delivery, Shipping Costs, Delays). The data includes calculated fields to flag late shipments and measure the extent of delays, making it ideal for identifying trends, root causes, and areas for improvement in the supply chain.
- Average Shipping Time
- On-Time vs Late Deliveries
- Delivery Status Breakdown by Region
- Shipping Mode Efficiency
- Delivery Cost vs Profit
- Delivery Timeliness Trend Over Time
- Delivery Delay Duration
- Delivery Status by Customer Segment
- Shipping Volume by Day of Week
Based on the Superstore dataset (modified for this analysis).
Includes order dates, ship dates, regions, ship mode, delivery status, profit, and shipping costs.
- Download the
shipping_efficiency_tracker.xlsxfile. - Open in Excel 2016 or later.
- Enable content (if prompted).
- Use slicers to filter by:
- Region
- Ship Mode
- Category
- Customer Segment
- View insights in the dashboard sheet.
- Microsoft Excel 2016 or later
