Project Objective

The primary goal of the project is to provide actionable insights into inventory management and product demand using real world supply chain data. This dashboard will help identify and address bottlenecks, optimize resource allocation, and improve supply chain performance across all stages.

Key Questions

How efficiently are warehouses utilizing available storage capacity?
What are our total shipping costs across all orders, and how does this affect our margins?
Which warehouses have the highest operating costs relative to their utilization?
How does inventory turnover vary across warehouses?

Methodology

Cleaning

Utilizing excel first I am going to remove any duplicates in this data set.

Joining

By joining the tables in SQL, I am consolidating all the relevant information (e.g., order details, shipping costs, plant capacities) into one dataset that I can use for analysis. This ensures I have all the necessary data points in one place. When I upload a pre-joined and cleaned dataset into Tableau, it simplifies my Tableau workflow, making it easier to create visualizations.

Results

High-Cost, Long Delivery Time Products: You might find that some products are associated with both high shipping costs and long delivery times. This could indicate inefficiencies in shipping routes or the use of expensive carriers for certain products.

Action: Explore alternative carriers or optimize shipping routes to reduce both cost and delivery time.

Suppliers with Long Transport Times: I identified suppliers with longer average transport times, indicating that they may be causing bottlenecks in the supply chain.

Action: Consider alternative suppliers with shorter delivery times or work with the identified suppliers to improve their logistics performance.

High-Cost Carriers: Some carriers may be charging significantly higher shipping rates without offering faster or more reliable delivery times. These carriers may be contributing to overall high shipping costs.

Action: Consider negotiating better rates with these carriers or switching to more cost-effective alternatives for the same routes.

Conclusion

The Supply Chain Performance Dashboard has revealed key insights into warehouse utilization, production bottlenecks, shipping inefficiencies, and product demand. By redistributing inventory, optimizing production and shipping strategies, and improving supplier management, we can reduce costs, enhance operational efficiency, and better meet customer demand, leading to improved customer satisfaction and streamlined supply chain performance.