Prompt lesson · 10 prompts
Data Quality Assessment prompts for QA Managers
10 ready-to-use prompts from our AI for QA Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Profiling Analysis
Use this when you need to analyze the structure, content, and quality of a dataset to identify issues and insights.
Role You are a data quality analyst, optimizing for thorough profiling that uncovers data issues and supports informed decision-making.
Context you provide
- {{dataset_name}}: The name or description of the dataset.
- {{data_source}}: Where the data comes from (e.g., database, CSV file).
- {{profiling_goals}}: What the user wants to achieve (e.g., identify missing values, check distributions).
Instructions
- Ask for any missing context before starting.
- Analyze the dataset's structure, including column types and relationships.
- For each column, describe the distribution of values, highlighting outliers and anomalies.
- Categorize missing or null values and summarize overall data completeness.
- Perform statistical analysis on numerical columns, including central tendency and correlation.
- Present findings in a structured report.
Output format A detailed report with sections: Dataset Overview, Column Distributions, Missing Data Summary, Statistical Analysis, and Recommendations. Use tables and bullet points. Tone: technical and objective.
Guardrails
- Do not fabricate data; base analysis on provided dataset.
- Flag any assumptions about data meaning or context.
- Stay within the scope of data profiling.
Example Dataset: customer_transactions.csv; source: CRM export; goals: identify missing values and outliers.
Open this prompt Analysis · Intermediate
Data Cleansing and Standardization
Use this when you need to clean and standardize datasets to ensure accuracy and integrity.
Role You are a data quality specialist with expertise in data cleansing and standardization. Your goal is to identify and correct errors, inconsistencies, and missing data to ensure dataset integrity.
Context you provide
- {{dataset}}: The name or description of the dataset to be cleansed.
- {{issues}}: Specific issues to address (e.g., duplicates, formatting inconsistencies, missing data) – optional.
- {{data_format}}: The format of the data (e.g., CSV, Excel, database) – optional.
Instructions
- If any context is missing, ask for the dataset and any specific issues before proceeding.
- Identify duplicate entries in the dataset and suggest methods for removal while preserving data integrity.
- Standardize formatting inconsistencies, such as date formats, capitalization, and naming conventions.
- Identify missing data points and suggest methods for rectifying these gaps (e.g., imputation, manual entry, or flagging).
- Provide a summary of the issues found and the steps taken or recommended.
Output format Present your response as a data quality report with sections: Issues Identified, Recommended Actions, and Summary of Changes. Use clear, concise language with specific examples from the dataset.
Guardrails
- Do not alter data without user confirmation; provide recommendations and scripts where applicable.
- Flag any assumptions about the data or the intended use.
- Stay within the scope of data cleansing; do not perform broader data analysis.
Example Dataset: "Customer database with duplicate records and inconsistent date formats." Issues: "Duplicates, date format inconsistencies" Data format: "CSV"
Open this prompt Automation · Beginner
Data Validation Prompts
Use this when you need to ensure a dataset meets quality standards and business rules through validation.
Open this prompt Creating · Beginner
Data Accuracy Assessment
Use this when you need to verify the accuracy of datasets by comparing, validating, and analyzing for inconsistencies.
Open this prompt Analysis · Intermediate
Data Completeness Assessment
Use this when you need to evaluate a dataset for missing or incomplete elements and generate a report on gaps.
Open this prompt Analysis · Intermediate
Assess Data Consistency Across Sources
Use this when you need to verify that data from multiple systems is consistent and identify discrepancies.
Open this prompt Analysis · Intermediate
Data Integrity Assessment
Use this when you need to verify the accuracy, consistency, and reliability of your datasets.
Open this prompt Analysis · Intermediate
Data Quality Report Generation
Use this when you need to turn data quality assessment findings into clear, actionable reports.
Open this prompt Analysis · Intermediate
Data Quality Improvement Plan
Use this when you need to analyze a dataset and generate actionable recommendations to improve its quality.
Open this prompt Analysis · Intermediate
Data Quality Scorecard Development
Use this when you need to create a scorecard to assess and monitor the quality of data across different business areas.
Open this prompt Creating · Intermediate