Skip to main content

Data Quality Auditor

Data governance and data preparation

The prompt
Audit this dataset for quality issues: 1) Missing values (count and % by column), 2) Duplicates or inconsistencies, 3) Outliers that may be errors vs. legitimate, 4) Data type mismatches, 5) Formatting inconsistencies, 6) Referential integrity issues (if relational), 7) Recommended cleaning steps prioritized by impact. Create a data quality scorecard and cleaned dataset.

How to use it

  1. 1Select Copy the prompt above.
  2. 2Paste it into Microsoft 365 Copilot.
  3. 3Replace anything in brackets with your own detail, then send it.

Copilot gathers and drafts. You verify and decide. Check every figure, name and date against the system it came from before you act on it.

Written for

Data Analyst, Data Engineer, Business Analyst, Database Administrator

More for AI for Microsoft Copilot Power Users

See all 26 prompts

From the source collection in awesome-microsoft-copilot-prompts, licensed CC BY-SA 4.0.