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.
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.
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
- Ask for any missing context before proceeding.
- Analyze the dataset to identify missing or incomplete data elements, focusing on the required fields.
- Categorize the gaps by severity (e.g., critical, moderate, minor) and by type (e.g., missing values, incorrect format).
- Generate a checklist of required data points and mark which are present, missing, or incomplete.
- Provide a summary report highlighting the overall completeness percentage and key problem areas.
- 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?