Skip to content
0

Supply Chain Analytics in Tableau or Power BI

🧾 Executive summary

  1. Profits, Orders, Inventory, Unique Customer Ids trend down significantly in the same window between Q3 2017 & Q4 2017, while Supply and Demand Ratio increased proportionally inverse to the trend.
  2. Products scheduled for faster shipments are disproportionally late to ship.
  3. Almost half of all total shipments were late, but that did not noticeably impact the average orders being made.
  4. On average, unique customers engagements decreased over the same window between Q3 2017 & Q4 2017, and less quantities are being ordered in each unique order.
  5. Anomalies exist in the shipment records, however these are small portion of all shipments. These anomalies are orders with order dates that are later than shipment dates, with no obvious pattern of data-entry match, so such a date format error.

🧾 Recommendations

  1. Reassess inventory stock listings to better identify the products that are being desired seasonally, to mitigate a spike in the s/d ratio and prevent Orders and Shipments from trending negatively. We may be listing items that are not being demanded.
  2. Address fulfilment processes to drive better on time shipment metrics.
  3. There is a need to optimize the shipment process, as it is staggeringly inefficient.
  4. Identify customer product preferences, and retool offerings to suit their needs, as late shipments did not seem to impact orders being made.
  5. Investigate the root of the anomalies.

📷 Dashboard screenshot