Preserve the source
The original text is not changed. Every issue cites the row or field where it was observed.
All open work
BUILD 01 / Data QA Workbench
A dirty order export becomes an auditable handoff.
A seven-row synthetic order export is deliberately small enough to inspect by eye, but contains the same classes of failure that break imports and monthly reports: a blank amount, duplicate key, exact duplicate row, casing drift, outer whitespace, and invalid date text.
Demonstration built from synthetic data. It proves the inspection method and export structure; it does not claim a customer result.
01 / INPUT CONTRACT
Synthetic order export
7 data rows · 5 fields · CSV · no personal or customer data
- record_id is intended to be unique
- amount should be numeric and required
- status should use one controlled vocabulary
- order_date should be an ISO date
02 / METHOD01 02 03 04
Profile structure
The audit measures fill rate, uniqueness, dominant type, whitespace, row width, exact duplicates, and the selected key.
Separate signal from correction
Potential problems enter an issue register. A human decides whether an apparent outlier or exception is legitimate.
Create handoff evidence
The result exports to Markdown for review, CSV for issue tracking, and JSON for a repeatable record.
03 / OBSERVED OUTPUT6 2 1 0
structural signals
Across missingness, duplicate key, duplicate row, whitespace, casing/type interpretation, and invalid date text.
high-severity blockers
The repeated business key and exact duplicate can double-count or overwrite records.
missing required value
The blank amount needs recovery, explicit null handling, or exclusion before aggregation.
source uploads
The public checker performs the review inside the browser tab.
DECISIONS FROM THE BUILD
- Block dashboard refresh until the repeated record_id is resolved.
- Preserve the blank amount as an exception; do not convert it silently to zero.
- Normalize outer whitespace and status casing only in a derived clean file.
- Keep the source register and audit output beside the clean delivery.
04 / OPEN ARTIFACTS
Download and inspect the files.
No email gate. No screenshot standing in for an output.
05 / RELEASE CHECK
What had to be true.
- Input can be inspected row by row
- Every finding is reproducible
- No correction overwrites the source
- The audit states what it cannot verify
TRY THE PUBLIC EDITION