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.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- 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
- If any required context is missing, ask me for it before proceeding.
- 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.
- Identify likely gaps in current data quality processes and suggest prioritised corrective actions.
- 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?