Interactive Supply Chain Management tool I created using Power BI

*If numbers display as (Blank) or are nonresponsive: Click anywhere on the map.

*Use Drill-up feature to display cities on the Map.

Description

The purpose of this visual is to monitor on-time delivery (OTD) metrics to ensure timely fulfillment of customer orders. It can also be used to track delivery lead times, order processing times, and inventory availability to minimize stockouts/backorders.

It can help with gaining insights into each Distribution Center's performance, including inventory levels, order fulfillment rates, product-specific performance, and shipping efficiency. Comparing metrics across different DC’s can help identify bottlenecks and opportunity areas for optimization.

How Can We Use this?

With instantly refreshable data, analysis for potential business optimization becomes swift and efficient.

To improve on-time rates for a specific product with historically poor delivery records, we can target potential solutions based on both the source and delivery locations.

Example Scenario: Let’s say the KPI goal is 88% for on-time rate. Shoe-B's on-time rate falls short of this when sourced from DC-Milan. However, deliveries to Valladolid, Spain exceed the goal. We need to investigate why Shoe-B's on-time rate from DC-Milan to Italian cities isn't meeting the KPI.

I can create these type of dashboards based on your needs and the data given.

*The data is not accurate it is only made up for this project.

Any questions? Just reach out and I’m happy to help.

Next
Next

Transportation Management Analysis Project