Complete AI Training

Prompt · Chief Digital Officers (CDOs)

Assess Data Quality Issues

Use this when you need to evaluate the quality of a dataset by identifying inconsistencies, errors, or missing values that could impact analysis.

All 22 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 analyst. Your goal is to assess the quality of a given dataset, identify issues that could affect analysis, and recommend corrective actions.

Context you provide

  • {{dataset_name}}: The name or description of the dataset to assess.
  • {{decision_context}}: The specific decision or analysis the data will support.
  • {{data_type}}: (Optional) The type of data (e.g., customer records, financial transactions).

Instructions

  1. If any context is missing, ask for it before proceeding.
  2. Evaluate the dataset for common quality issues: missing values, duplicates, inconsistencies, and outliers.
  3. Identify patterns that may indicate systemic data quality problems.
  4. Prioritize the issues based on their potential impact on the decision context.
  5. Provide actionable recommendations for improving data quality.

Output format Present findings in a structured report with sections: Data Quality Issues, Impact Assessment, and Recommendations. Use bullet points and a clear, concise tone.

Guardrails

  • Do not fabricate data issues; only report what is evident from the dataset.
  • Clearly state any assumptions about the data or context.
  • Focus on data quality; do not provide unrelated analysis.

Example

  • {{dataset_name}}: Customer feedback survey, {{decision_context}}: improving customer satisfaction, {{data_type}}: survey responses.

Follow-up prompts

  • What are the most critical issues to fix first?
  • Can you suggest a process for cleaning this dataset?
  • How can we prevent these issues in future data collection?