Data Quality Spreadsheet Audit
Prompts
-
Data Cleaning Audit
Profile a dataset and list cleaning rules.
-
Duplicate and Entity Matching Review
Plan how to detect and merge near-duplicate records.
-
Survey and Form Response Data Validation
Check collected data for bad responses and bias.
-
Data Dictionary and Governance Check
Create documentation and ownership for a dataset.
-
Master Data and Reference Table Governance
Keep lookup tables correct and consistent.
-
Unit and Currency Consistency Audit
Prevent mixing units, currencies, and scales.
-
Sampling Method for Auditing Large Datasets
Check quality without checking every row.
-
Missing Data Strategy Review
Decide how to handle blanks responsibly.
-
Outlier and Anomaly Investigation Guide
Separate errors from real extremes.
-
Date, Address and Name Standardization Plan
Normalize messy text fields.
-
Reconciliation Between Two Data Sources
Compare systems and explain differences.
-
Data Entry Template and Validation Design
Prevent bad data at the point of entry.
-
Data Freshness and Pipeline Reliability Check
Assess whether reports use current data.
-
Privacy Review of a Spreadsheet or Dataset
Find personal data before sharing.
No prompts match those filters.