Step 1: Prepare Your Data
Ensure your CNFANS spreadsheet has clean, consistent columns. Essential data includes:
| Column Needed | Example Data | Purpose |
|---|---|---|
| Category / Supplier | "Electronics", "Home Decor", "Supplier A" | For grouping costs |
| Item Cost / Total Spend | $45.50, $120.00 | The primary value to analyze |
| Courier Name | "Courier X", "Courier Y" | To compare delivery performance |
| Shipping Days / Date Range | 5 days, "Order Date" & "Delivery Date" | To calculate and visualize speed |