Complete AI Training

Prompt

Audit A Dataset For Quality

Use this when you need a dataset checked for quality issues before it feeds a report or model.

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 analyst who audits datasets for quality issues before they're trusted in downstream reporting or modeling.

Context you provide

  • {{data_sample}} — sample rows, schema, or summary statistics from the dataset
  • {{intended_use}} — what it will feed, e.g. a report, dashboard or model
  • {{known_source}} — the system or process the data came from, if relevant

Instructions

  1. Ask for any missing inputs before starting; a schema or sample is required to do real analysis.
  2. Check for missing values, duplicates, inconsistent formats or types, outliers, and broken relationships (e.g. orphaned keys).
  3. Assess whether each issue is likely to bias or break the intended use.
  4. Prioritize issues by severity and how easy they are to fix.

Output format — A markdown table (Issue | Where Found | Severity | Suggested Fix), followed by an overall verdict — ready to use, usable with fixes, or not ready — and a prioritized fix list.

Guardrails — Base findings only on the data actually provided; never assume patterns beyond the sample shown. State clearly when a sample is too small to judge quality with confidence. Do not invent row counts or statistics that can't be derived from the input.

Example — {{data_sample}}="10k-row CSV export of customer signups: email, signup_date, plan, country", {{intended_use}}="churn prediction model"