The clean dataset
Excel · .xlsxA full year of sales, 320 transactions, as an Excel table named Sales. Total revenue reconciles to 1,486,717.56. For Chapters 6, 8, 9, 10 and 11.
The sample data and the numbers that prove your work.
A full year of sales, 320 transactions, as an Excel table named Sales. Total revenue reconciles to 1,486,717.56. For Chapters 6, 8, 9, 10 and 11.
The same year as it really arrives: trailing spaces, European text numbers, mixed dates, a block pasted twice. Clean it and prove your work (Chapter 7).
The reconciliation checkpoints, revenue by region, and per-product price bands for anomaly detection.
The twelve institutional prompts in one plain-text file.
Every figure below is computed directly from the clean dataset.
| Checkpoint | Value |
|---|---|
| Total revenue, all rows | 1,486,717.56 |
| North revenue on the Online channel | 136,767.11 |
| Revenue by region · North | 307,047 |
| Revenue by region · South | 410,292 |
| Revenue by region · East | 411,678 |
| Revenue by region · West | 357,700 |
| Gross margin | 44% |