How This Workflow Works
This workflow provides an interactive dashboard for analyzing line and order fill rates across multiple time periods (7, 30, 90 days, and year-to-date) for an e-commerce business. It calculates key performance indicators, highlights trends, identifies root causes of shortfalls, and enables users to explore fill rates by product category and SKU.
Key Features:
- Track fill rate KPIs across customizable time periods
- Identify and analyze root causes for unfilled orders
- Explore fill rate performance by product category and SKU
- Visualize trends and interactively adjust targets and periods
Step-by-step:
1. Calculate Fill Rate KPIs Across Time Periods:
The workflow computes line and order fill rates for several rolling periods (7, 30, 90 days, and year-to-date). It aggregates fulfilled and unfulfilled lines and orders, calculates rates, and allows users to set custom start dates and target fill rates for benchmarking.
2. Analyze Trends and Root Causes:
It examines weekly fill rate trends to spot patterns or declines over time. The workflow also breaks down unfulfilled orders by root cause, helping users pinpoint operational issues that most impact fulfillment.
3. Drill Down by Product Category and SKU:
Users can explore fill rate and status at the product category level, and further investigate SKU-level details. This step highlights which categories or products consistently meet or miss fill rate targets, supporting targeted process improvements.
4. Visualize and Share Insights:
The workflow presents interactive charts and tables, including trend lines, KPI cards, and pie charts for root causes. Users can dynamically adjust parameters and immediately see the impact, making it easier to communicate findings and drive action.