# Data Quality Remediation Backlog Builder

Public URL: https://amo.ng/prompts/data-quality-remediation-backlog-builder

Summary: Turn messy data quality findings into a prioritized remediation backlog with root causes, owners, validation checks, controls, and governance cadence.

Use this for: Use this for converting data quality issues into a practical remediation backlog, root causes, owner actions, validation checks, controls, and verification steps.

Category: Data Analysis
Tool: ChatGPT
Difficulty: Expert
Prompt type: data audit

## Best Use Cases

1. Data quality remediation planning
2. Analytics trust repair
3. CRM or warehouse cleanup backlog
4. Dashboard reliability improvement
5. Data governance operating review
6. Data owner action planning
7. Validation rule design

## Prompt Body

You are a senior data quality lead building a remediation backlog for analytics, operations, data governance, and business reporting teams.

Translate the supplied data quality findings into root causes, prioritized fixes, ownership, acceptance criteria, validation checks, prevention controls, and a governance cadence that restores trust in affected data assets.

The goal is to help data, analytics, operations, product, finance, customer success, and leadership teams move from messy findings to a practical remediation plan.

## Context Placeholders

Use the context below. If the dataset, known quality issues, or affected reports are missing, ask for them before producing the backlog. If other inputs are missing, continue only with clearly labeled assumptions.

- [Dataset or system]
- [Known data quality issues]
- [Affected reports or workflows]
- [Business impact and owners]
- [Sources and validation rules]
- [Tooling constraints and deadline]
- [Governance or control needs]

## Important Constraints

- Do not invent facts, metrics, schemas, SQL results, dashboard figures, source-system behavior, data lineage, owners, approvals, or stakeholder decisions.
- Separate confirmed evidence from assumptions, hypotheses, and recommendations.
- Label confidence level and uncertainty for every major conclusion.
- Do not recommend production data changes without data owner approval, backup, dry-run checks, rollback plan, and verification steps.
- Treat missing ownership, unclear lineage, weak validation rules, and undocumented transformations as data quality risks.
- If the schema is not supplied, provide validation query ideas instead of pretending to know exact table or column names.
- If sensitive, personal, financial, customer, employee, legal, security, or regulated data may be involved, include human review gates before cleanup, export, access changes, or broad sharing.
- Do not present this output as legal, financial, security, medical, or regulatory advice.
- Make recommendations specific to the supplied dataset, issues, affected reports, owners, sources, validation rules, tooling constraints, and deadline.

## Step-by-Step Instructions

1. Summarize the data quality scope:
   - dataset or system
   - affected reports, dashboards, workflows, or teams
   - known issues
   - business impact
   - data owners
   - upstream sources
   - current validation rules
   - current controls
   - tooling constraints
   - deadline

2. Classify each issue by data quality dimension:
   - completeness
   - accuracy
   - consistency
   - timeliness
   - uniqueness
   - validity
   - lineage
   - access or permission risk
   - definition mismatch
   - reporting logic issue

3. Identify likely root causes:
   - manual entry errors
   - upstream source changes
   - missing required fields
   - weak validation at entry
   - duplicate records
   - identity resolution problems
   - broken sync or pipeline failure
   - delayed ingestion
   - schema drift
   - transformation logic error
   - inconsistent business definitions
   - dashboard calculation issue
   - unclear ownership
   - missing monitoring

4. Assess business impact:
   - affected decisions
   - affected reports
   - affected teams
   - customer or revenue impact if supplied
   - trust risk
   - compliance or access risk if relevant
   - urgency

5. Build a remediation backlog:
   - issue
   - root cause hypothesis
   - affected asset
   - severity
   - effort
   - owner role
   - dependency
   - acceptance criteria
   - validation check
   - prevention control
   - due date

6. Design validation and verification:
   - data profiling checks
   - duplicate checks
   - missing value checks
   - referential integrity checks
   - freshness checks
   - reconciliation checks
   - dashboard comparison checks
   - sample review
   - stakeholder sign-off

7. Recommend prevention controls:
   - source-system validation
   - required fields
   - automated tests
   - data contracts
   - pipeline monitoring
   - anomaly alerts
   - ownership rules
   - definition glossary
   - dashboard certification
   - review cadence

8. Create a governance review plan for tracking fixes, communicating known issues, and restoring trust in data assets.

## Output Format

### 1. Data Quality Findings Summary

Provide a concise summary of the dataset, known issues, affected reports or workflows, business impact, owners, available evidence, and missing inputs.

### 2. Issue Classification

Use this table:

| Issue | Data Quality Dimension | Evidence | Affected Asset | Business Impact | Confidence |
|---|---|---|---|---|---|

### 3. Root Cause Map

Use this table:

| Issue | Likely Root Cause | Evidence | Owner Role | Confidence | Follow-Up Needed |
|---|---|---|---|---|---|

### 4. Remediation Backlog

Use this table:

| Backlog Item | Severity | Effort | Owner Role | Dependency | Acceptance Criteria | Due Date |
|---|---|---|---|---|---|---|

### 5. Validation Check Plan

Use this table:

| Check | Purpose | Query or Test Idea | Expected Result | Review Owner |
|---|---|---|---|---|

If exact schema is missing, provide query ideas rather than exact SQL.

### 6. Control Improvements

Use this table:

| Control | Risk Prevented | Where It Should Run | Owner Role | Verification Method |
|---|---|---|---|---|

### 7. Dashboard or Report Trust Notes

List affected dashboards, reports, metrics, or workflows that should be marked as unreliable, partially reliable, under review, or restored.

### 8. Governance Review Plan

Summarize review cadence, data owner responsibilities, status reporting, escalation triggers, sign-off process, and communication plan.

### 9. Missing Inputs and Human Checks

List missing inputs, assumptions made, unresolved risks, confidence level, and human reviews required before execution.

## Verification Checklist

Before finalizing, confirm that:

- remediation items include owner roles
- each backlog item includes acceptance criteria
- validation checks are included
- production data changes require approval, backup, dry run, rollback, and verification
- affected dashboards or reports are clearly identified
- root causes are separated from hypotheses
- sensitive or regulated data has human review gates where relevant
- prevention controls are included
- missing inputs and unresolved risks are clearly listed

## Final Instruction to Begin

Begin now. First review the supplied dataset, known issues, affected reports, business impact, owners, sources, validation rules, tooling constraints, and deadline. If required context is missing, ask for it. Otherwise, produce the full data quality remediation backlog in the requested markdown format.

## Variables to Replace

1. Dataset or system
2. Known data quality issues
3. Affected reports or workflows
4. Business impact and owners
5. Sources and validation rules
6. Tooling constraints and deadline
7. Governance or control needs

## How to Use

Fill in the variables with the dataset or system, known data quality issues, affected reports or workflows, business impact, owners, sources, validation rules, tooling constraints, deadline, and governance needs. Then run the complete prompt on ChatGPT. Use the output for data quality standups, remediation planning, dashboard trust repair, and governance reviews.

## Example Use Case

A revenue dashboard has duplicate accounts, missing lifecycle dates, inconsistent owner fields, and delayed CRM syncs, so the data team needs a prioritized cleanup backlog with validation checks and prevention controls.

## Tags

1. data-quality
2. data-governance
3. analytics
4. remediation
5. backlog
6. root-cause
7. dashboard
8. data-controls
9. ownership
10. verification
11. data-cleanup
12. data-validation
13. analytics-trust

## Dates

Published: 2026-07-08
Updated: 2026-07-08