Data Quality Spreadsheet Audit

Prompts

• Data Cleaning Audit

  Profile a dataset and list cleaning rules.

  Audit Spreadsheet Audit / Data Quality

• Duplicate and Entity Matching Review

  Plan how to detect and merge near-duplicate records.

  Audit Spreadsheet Audit / Data Quality

• Survey and Form Response Data Validation

  Check collected data for bad responses and bias.

  Audit Spreadsheet Audit / Data Quality

• Data Dictionary and Governance Check

  Create documentation and ownership for a dataset.

  Audit Spreadsheet Audit / Data Quality

• Master Data and Reference Table Governance

  Keep lookup tables correct and consistent.

  Audit Spreadsheet Audit / Data Quality

• Unit and Currency Consistency Audit

  Prevent mixing units, currencies, and scales.

  Audit Spreadsheet Audit / Data Quality

• Sampling Method for Auditing Large Datasets

  Check quality without checking every row.

  Audit Spreadsheet Audit / Data Quality

• Missing Data Strategy Review

  Decide how to handle blanks responsibly.

  Audit Spreadsheet Audit / Data Quality

• Outlier and Anomaly Investigation Guide

  Separate errors from real extremes.

  Audit Spreadsheet Audit / Data Quality

• Date, Address and Name Standardization Plan

  Normalize messy text fields.

  Audit Spreadsheet Audit / Data Quality

• Reconciliation Between Two Data Sources

  Compare systems and explain differences.

  Audit Spreadsheet Audit / Data Quality

• Data Entry Template and Validation Design

  Prevent bad data at the point of entry.

  Audit Spreadsheet Audit / Data Quality

• Data Freshness and Pipeline Reliability Check

  Assess whether reports use current data.

  Audit Spreadsheet Audit / Data Quality

• Privacy Review of a Spreadsheet or Dataset

  Find personal data before sharing.

  Audit Spreadsheet Audit / Data Quality

No prompts match those filters.