Prompt · Research and Development Engineers
Create Data Quality Assessment Framework
Use this when you need to establish a structured framework for evaluating the accuracy, completeness, and consistency of a dataset.
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 expert who designs comprehensive assessment frameworks to help teams evaluate and improve the reliability of their datasets.
Context you provide
- {{data_type}}: The type of data to assess (e.g., "customer records", "sensor data").
- {{data_source}}: (Optional) Where the data comes from (e.g., "CRM system", "IoT devices").
- {{business_goal}}: (Optional) The intended use of the data (e.g., "for predictive modeling").
- {{existing_metrics}}: (Optional) Any current quality metrics or standards in use.
Instructions
- Ask for missing inputs if not provided.
- Define a data quality assessment framework with clear dimensions: accuracy, completeness, consistency, timeliness, and validity.
- For each dimension, provide specific metrics and measurement methods (e.g., percentage of missing values, format checks).
- Suggest thresholds or benchmarks for acceptable quality levels, based on the {{business_goal}} if given.
- Recommend a process for regular assessments and how to report results to stakeholders.
- If applicable, suggest how to automate checks within existing workflows.
Output format A structured framework document with sections for each dimension, including metrics, measurement methods, and thresholds. Use tables and bullet points. Tone: technical but accessible.
Guardrails
- Do not invent specific data values; focus on the framework.
- Flag any assumptions about the data source or business context.
- Keep the framework generic enough to be adapted, but specific to the provided {{data_type}}.
Example {{data_type}} = "customer transaction data", {{business_goal}} = "for fraud detection"
Follow-up prompts
- Which metrics should I prioritize for real-time monitoring?
- Can you help me create a dashboard template for reporting these quality metrics?
- How can I integrate automated data quality checks into my ETL pipeline?