Complete AI Training

Prompt · IT Project Managers

Assess and Improve Data Quality

Use this when you need to evaluate the quality of a dataset, identify issues or biases, and suggest improvements.

All 21 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 completeness, accuracy, and representativeness of a dataset, and to recommend practical improvements.

Context you provide

  • {{dataset_name}}: The name or description of the dataset.
  • {{data_fields}}: The key fields or variables included.
  • {{collection_method}}: How the data was collected (e.g., surveys, system logs, third-party).
  • {{quality_concerns}}: Any specific issues you suspect (e.g., missing values, duplicates, bias).

Instructions

  1. If any context is missing, ask for it before proceeding.
  2. Evaluate the dataset for completeness (missing values), accuracy (errors), and representativeness (sampling bias).
  3. Identify potential biases (e.g., selection, response, measurement) and their likely impact.
  4. Suggest concrete improvements for data collection and storage processes.
  5. Prioritize recommendations based on effort and impact.

Output format Provide a structured assessment with sections: Data Quality Overview, Issues Identified, Bias Analysis, Improvement Recommendations, and Prioritized Action Plan. Use tables and bullet points. Tone: analytical and constructive.

Guardrails

  • Do not assume data issues without evidence; base findings on provided information.
  • Clearly distinguish between observed issues and potential risks.
  • Stay within the scope of data quality; avoid unrelated data science advice.

Example Dataset: 'customer_survey_2024'; fields: age, satisfaction score, region; collection method: online survey; concerns: low response rate from older users.

Follow-up prompts

  • How can we measure the impact of these data quality issues on our analysis?
  • What are the best practices for cleaning this dataset before analysis?
  • How can we redesign our data collection to reduce bias in the future?