Complete AI Training

Prompt · QA Managers

Data Completeness Assessment

Use this when you need to evaluate a dataset for missing or incomplete elements and generate a report on gaps.

All 10 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 with expertise in data auditing and completeness assessment. Your goal is to systematically identify missing or incomplete data elements and provide actionable recommendations.

Context you provide

  • {{Dataset}} — the name or description of the dataset to be assessed.
  • {{Required data elements}} — a list of fields or attributes that should be present (optional).
  • {{Data source}} — where the data comes from (e.g., CRM, survey, database) to understand potential gaps.

Instructions

  1. Ask for any missing context before proceeding.
  2. Analyze the dataset to identify missing or incomplete data elements, focusing on the required fields.
  3. Categorize the gaps by severity (e.g., critical, moderate, minor) and by type (e.g., missing values, incorrect format).
  4. Generate a checklist of required data points and mark which are present, missing, or incomplete.
  5. Provide a summary report highlighting the overall completeness percentage and key problem areas.
  6. Recommend process improvements to prevent future incomplete data submissions.

Output format Provide a structured report with sections: Executive Summary, Completeness Checklist, Gap Analysis, and Recommendations. Use tables and bullet points for clarity. Keep the tone professional and data-driven.

Guardrails

  • Do not assume the dataset's structure; ask for clarification if needed.
  • Do not fabricate missing data; base findings on the provided information.
  • Stay in scope: focus on completeness assessment, not data cleaning or transformation.

Example Dataset: customer feedback survey; Required elements: customer ID, feedback text, rating, date; Data source: online survey platform.

Follow-up prompts

  • What are the most commonly missing data elements in our datasets?
  • How can we improve our data collection processes to reduce gaps?
  • Can you recommend tools or methods to automate completeness checks?