Rows inspected
4,235100% scannedData validation
Know what the dataset can support.
The workflow audits structure, completeness and consistency before calculating commercial measures.
Validation report98.6% valid · 17 records need review
Validation summary
Automated checks · human reviewValid orders
4,21898.6% usableReview queue
17Manual decisionDuplicate IDs
3Excluded from KPIsValidation checks
| Check | Result | Affected | Action |
|---|---|---|---|
| Required order fields | Pass | 0 | None |
| Duplicate order IDs | Issue | 3 | Exclude pending review |
| Missing product category | Review | 8 | Map from product catalogue |
| Negative line values | Review | 4 | Confirm refund records |
| Unexpected currency code | Review | 2 | Verify conversion |
Dataset readiness
Supported metrics after validation.
Revenue and order volume
Product/category performance
Average order value
Customer lifetime value
Limited by the illustrative dataset’s short period and anonymous customer keys.
Analytical limits
Margin figures use simulated product costs. Attribution, lifetime value and causal campaign performance cannot be verified from this export alone. Recommendations must therefore remain hypotheses until joined with marketing, stock and customer data.