Use when performing data quality assessment — conducts a systematic assessment of data quality across key dimensions including completeness, accuracy, consistency, timeliness, uniqueness, and validity. Identifies data quality issues, quantifies their business impact, and produces a remediation plan with automated quality monitoring.
| Table | Rows | Columns | Null Rate (avg) | Last Updated | Update Frequency |
|---|---|---|---|---|---|
| % | hourly/daily/etc |
| Table | Field | Expected | Actual | Null Rate | Score |
|---|---|---|---|---|---|
| 100% | % | /100 |
| Table | Field | Validation Rule | Pass Rate | Sample Failures | Score |
|---|---|---|---|---|---|
| % | /100 |
| Field | Source A | Source B | Match Rate | Discrepancy Count | Score |
|---|---|---|---|---|---|
| % | /100 |
| Dataset | Expected Freshness | Actual Freshness | SLA Met | Score |
|---|---|---|---|---|
| < hours | hours | Yes/No | /100 |
| Table | Key Fields | Total Rows | Duplicate Rows | Duplicate Rate | Score |
|---|---|---|---|---|---|
| % | /100 |
| Table | Field | Rule | Valid Rate | Invalid Examples | Score |
|---|---|---|---|---|---|
| format/range/enum | % | /100 |
| Issue | Dimension | Affected Records | Business Impact | Root Cause | Fix Effort | Priority |
|---|---|---|---|---|---|---|
| High/Med/Low | Low/Med/High | 1-5 |
| Shortcut | Counter | Why |
|---|---|---|
| "We can skip some steps for this case" | Adapt the workflow steps, don't skip them | Skipped steps are where incidents and oversights originate |
| "The user seems to already know what to do" | Complete all workflow phases with the user | The workflow catches blind spots that experience alone misses |
| "This is a minor case, full process is overkill" | Scale the process down, don't turn it off | Minor cases become major when unstructured; the process scales, not disappears |
| "I'll fill in the details later" | Complete each section before moving on | Deferred details are forgotten; real-time capture is more accurate |
| "The template output isn't necessary" | Always produce the structured output format | Structured output enables comparison, audit trails, and handoff to other teams |