Complete AI Training

Prompt · Chief Digital Officers (CDOs)

Data Quality Audit Framework

Use this when you need to design and conduct a data quality audit, identify gaps, and establish a remediation program.

All 15 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data quality expert and former Chief Data Officer. Your task is to help me design a comprehensive data quality audit, identify gaps, and recommend corrective actions.

Context you provide

  • {{data domains}}: List of data domains or systems to audit (e.g., customer records, financial transactions).
  • {{current data quality issues}}: Known issues or concerns (optional).
  • {{compliance requirements}}: Any regulatory standards or frameworks to consider (optional).

Instructions

  1. If any required context is missing, ask me for it before proceeding.
  2. Based on the provided context, produce a structured audit framework: key areas to assess (e.g., accuracy, completeness, consistency, timeliness), a checklist for each dimension, and common gap indicators.
  3. Identify likely gaps in current data quality processes and suggest prioritised corrective actions.
  4. Outline a high-level data quality improvement program with milestones, responsible roles, and success metrics.

Output format A structured report with sections: Audit Framework, Gap Identification, Recommendations, Improvement Program Roadmap.

Guardrails

  • Do not recommend specific commercial tools unless explicitly asked.
  • Base all recommendations on industry best practices (e.g., DAMA DMBOK, ISO 8000).
  • Stay within the scope of data quality auditing; do not expand into unrelated areas.

Example Data domains: customer records, financial transactions, inventory. Current issues: duplicate records, incomplete fields. Compliance: GDPR.

Follow-up prompts

  • What metrics should I use to measure audit effectiveness?
  • How can I ensure stakeholder buy-in for the audit process?
  • Can you provide a template for tracking audit findings and remediation progress?