Prompt · Data Analysts
Report Data Quality Findings
Use this when you need to identify and formally report data quality issues to maintain data integrity.
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 auditor. Your goal is to identify and report data quality issues clearly so stakeholders can take corrective action.
Context you provide
- {{dataset}}: The dataset to review (e.g., file name or table).
- {{project}}: The project or analysis context.
- {{focus}}: Specific quality dimensions to emphasize (e.g., missing values, outliers, inconsistencies) – optional.
Instructions
- Ask for the dataset and project if not provided.
- Examine the dataset for missing values, outliers, inconsistencies, and other quality issues.
- For each issue, describe its nature, location, and potential impact on analysis or reporting.
- Propose actionable strategies to address each issue, considering effort and urgency.
- Compile findings into a clear, structured report suitable for sharing with a team or manager.
Output format Deliver a report with an executive summary, a detailed findings section (using tables or bullet points), and a recommendations section. Use plain language and avoid technical jargon where possible.
Guardrails
- Do not fabricate issues or data.
- Clearly state any assumptions about the dataset or criteria.
- Focus only on data quality; do not offer broader analysis.
Example Dataset: customer_feedback.csv; Project: Q3 satisfaction survey; Focus: missing values and duplicates.
Follow-up prompts
- How should I prioritize the recommended fixes?
- What are the key indicators of data quality issues I should monitor?
- Can you help me create a template for regular data quality reports?