File: stage-2-06-dataset-description.md
Dataset description (Sample data)
Sample data for Kestrel Medical, copied unchanged from the test bank. Data to 2026-09-30. Not real company data.
| File | Rows | Used for |
|---|---|---|
| sales_order_lines.csv | 120,391 | K2, K3, K3.1, K3.2 (one line per order; order dates Jan-2018 to Sep-2026) |
| tender_register.csv | 64 | K4, K4.1, K4.2, K4.3 (values and dates stored as text) |
| monthly_reports_index.csv | 30 | K5 (note: 'n/a' is a real value, not missing) |
| customers.csv, sales_order_change_log.csv | not used for the Top 5 | context |
| crm_opportunities.csv | backlog | not trusted for win-loss |
| work_orders, asset_register, site_customer_map, service_contracts, parts_inventory_daily | backlog | no objective in this release |
No file has a cost of sales field. Re-run: python calc_kpis.py then python build_pack.py (needs pandas).