Back to Library

Data Quality Auditor

Excel & DataExcel●BeginnerMicrosoft CopilotMicrosoft 365ProductivityOfficeWork Users

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.
Generate sample demo data

Generic sample context ready for adaptation.

Related Prompts

Excel & Data

Forecasting Model Builder

Build a forecasting model for [METRIC] based on this historical data. Include: 1) Trend analysis and seasonality detection, 2) Forecast for next [3/6/12] months...
Excel●●IntermediateWorkflow-ready
Excel & Data

Dashboard Insight Generator

Create an executive dashboard from this data including: 1) Top 5 KPIs with current value, trend (↑↓), and vs. target, 2) Alert indicators for metrics off-track ...
Excel●●IntermediateExecutive-readyWorkflow-ready
Excel & Data

Data Storyteller

Analyze this dataset and tell the data story: 1) Key trends over time, 2) Notable outliers or anomalies with potential explanations, 3) Correlations or relation...
Excel●●IntermediateWorkflow-ready
Productivity & Automation

Escalation Radar Detector

Scan the last 45 days of emails and detect: 1) Rising tensions or conflict indicators, 2) Missed deadlines and their follow-ups, 3) Requests repeated multiple t...
Outlook●●IntermediateWorkflow-ready
Back to Library