How to Analyze Supply Chain Data
How to analyze supply chain data starts with the export your ERP or warehouse management system produces — SAP, Oracle, NetSuite, and similar platforms export purchase orders, receipts, and inventory records with different column structures and date formats. The first step is identifying the key metric columns: lead time, fill rate, stockout count, and inventory turnover.
Upload your supply chain export to Datamimi and get supplier performance, lead time, and inventory metrics in one session.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| PO Number |
| Supplier Name |
| Order Date |
| Promised Date |
| Receipt Date |
| Quantity Ordered |
| Quantity Received |
| Unit Cost |
| SKU |
| Warehouse Location |
What usually goes wrong with it
Lead time calculation requires both Order Date and Receipt Date
Supplier lead time = Receipt Date minus Order Date — but Receipt Date is often null for open POs, which must be filtered out before computing the average.
DataMimi Datamimi filters open POs from lead time calculations automatically, computing average lead time only for POs where Receipt Date is populated.
Fill rate requires comparing Quantity Ordered to Quantity Received
Fill Rate = Quantity Received divided by Quantity Ordered. Short shipments where Quantity Received is less than Quantity Ordered but the PO is marked 'complete' will show a fill rate below 100% that is hard to catch without a calculated column.
DataMimi It adds a Fill Rate column by dividing Quantity Received by Quantity Ordered for every row, and surfaces suppliers with fill rates below a threshold.
Supplier performance comparisons require consistent PO date ranges
Comparing supplier lead times across a period requires filtering to POs where Receipt Date falls within the same window — otherwise a supplier with many open POs will appear faster than one with closed POs.
DataMimi It filters the comparison period consistently by Receipt Date, so all suppliers are evaluated on the same closed-PO population.
Common questions
How do I calculate supplier lead time in Excel?
Add a Lead Time Days column: =Receipt_Date - Order_Date. Filter to rows where Receipt Date is not blank (closed POs only). Use AVERAGEIF to compute average lead time by Supplier Name. Add a comparison against Promised Date: =Receipt_Date - Promised_Date to see which suppliers deliver early vs late.
What is fill rate in supply chain and how do I track it in a spreadsheet?
Fill rate is the share of an order that was shipped complete. Fill Rate = Quantity Received divided by Quantity Ordered. Add this as a calculated column, then average by Supplier Name to get a supplier-level fill rate. Flag rows where the PO is marked 'complete' but fill rate is below 95%.
What columns should a supply chain tracking spreadsheet include?
At minimum: PO Number, Supplier Name, Order Date, Promised Date, Receipt Date, SKU, Quantity Ordered, Quantity Received, Unit Cost, and Warehouse Location. Add calculated columns for Lead Time Days, Fill Rate, On-Time Delivery, and Cost Variance.
What does Datamimi cost?
Free plan: $0/month, 40 credits, no credit card required. Lite: $9/month, 400 credits. Starter: $24/month, 1,500 credits, up to 3 simultaneous files. Pro: $59/month, 5,000 credits with rollover. Team: $199/month, 20,000 credits, 5 users.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file