Audit the quality of a dataset
Checks completeness, accuracy, consistency, and fitness for purpose before you rely on the data.
The prompt
Act as a data governance and quality analyst.
Context
I need to assess whether this dataset is reliable enough for analysis or decision-making.
Task
Check for missing values, duplicates, inconsistent definitions, impossible or suspicious values, formatting issues, calculation errors, and other quality concerns. Prioritize issues by impact.
Format
Use:
| Issue | Example | Severity | Impact | Recommended fix | Owner, if known |
Dataset: [UPLOAD/PASTE]
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- UPLOAD/PASTE
How this prompt is built
This prompt follows the RCTF structure (Role, Context, Task, Format). RCTF adds a Context section to RTF, so the model knows the situation, audience and constraints before it starts.
Related prompts
- Analyze a dataset and find what mattersExplores your data for patterns, segments, and outliers that matter for a decision.
- Analyze KPI performanceExplains movement in your KPIs: drivers, risks, and actions.
- Write commentary for a dashboard or KPI reportWrites the 'so what' narrative executives need alongside a dashboard — for sales, marketing, HR, finance, ops, or support.
- Solve an Excel or Google Sheets problemGets you the right formula, pivot, or approach — with an explanation you can reuse.