Sales | Freight Analysis Dashboard

Project Overview:

This dashboard provides a strategic overview of sales operations, with a specialized focus on optimizing freight costs (shipping expenditures) and evaluating territory performance.

Key Contributions & Data Insights:

Financial Overview: Tracked core financial metrics, including $34M in Total Due, $30M Sub-Total, and managed $916K in Total Freight Costs across 1,465 orders.

Product-Level Freight Analysis: Discovered that the "Bikes" category accounts for the vast majority of shipping costs, enabling better inventory and shipping strategy planning.

Geographic Distribution: Visualized the dependency of sales reach, with North America and Europe dominating the geographic distribution of orders.

Root-Cause Drill-Down: Implemented a decomposition tree to analyze how specific product categories (e.g., Bikes) interact with different territories (e.g., Canada), identifying areas with high logistics expenses.