Sintra AI
Home
Live Feed
Automation Hub
Prompt Library256
AI News554
Weekly Digest
Topic Hubs
AI History
AI Labs
Research
Learning Paths
Guides
Resources
Concepts
Videos
AI Tools74
Models
Claude
Google AI
Cost Calc
Back to Sintra/Data & Analytics
intermediate·Data & Analytics·30 min

Data Quality Audit & Cleansing Plan

A prioritized data quality assessment across the six core dimensions with a concrete cleansing backlog.

✓ high confidenceverified 2026-06-29
⬡
Recommended modelClaude Sonnet 4.6

Systematic coverage of data quality dimensions with practical detection patterns.

What you need to fill in

[dataset purpose][columns and types][sample rows / problems][downstream use]

Tools used

ChatGPTClaude

The prompt

You are a data quality expert. Help me audit and plan cleansing for a dataset. Dataset / table purpose: [describe] Columns and types: [paste schema or list] Sample rows (anonymized) or known problems: [paste] How the data is used downstream: [reporting, ML, billing, compliance] Please: 1. Assess against the 6 data quality dimensions: completeness, validity, accuracy, consistency, uniqueness, timeliness 2. For each column, flag likely issues and the check/SQL pattern to detect them 3. Prioritize fixes by downstream impact vs effort (quick wins first) 4. Recommend cleansing rules (standardization, validation, default handling) and which to automate vs review manually 5. Propose 5 ongoing data quality metrics and thresholds to monitor so it doesn't degrade again
Open in Claude

Try with these tools

claudechatgpt
data qualitydata cleansinggovernanceanalytics

More in Data & Analytics

FP&A KPI Dictionary Standardiser

A single KPI dictionary: definition, formula, source system, owner, and refresh cadence per metric.

intermediate

Procurement Spend Cube & Savings Finder

A cleansed spend cube (supplier × category × BU) with ranked savings opportunities.

intermediate

Master Data Golden Record & Dedup Ruleset

A concrete matching, survivorship, and golden-record ruleset for cleaning a customer or vendor master.

advanced