Dataset Profiling Prep
Get a fast structural read of a dataset before analysis. Verify counts in the source.
The prompt
Profile the dataset I've opened/referenced. Summarize: - Columns and apparent data types - Row count and any obviously missing/blank fields - Value ranges or categories per key column - Anything that looks inconsistent (mixed formats, duplicates, outliers) This is a first read to plan analysis — confirm counts and quality in the source system before relying on them.
How to use it
- 1Select Copy the prompt above.
- 2Paste it into Microsoft 365 Copilot.
- 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, BI Analyst, Business Analyst
More for Data & Analytics
- Data & Analytics Critical Guardrails - Read First
- Anomaly / Outlier Exploration
- Ad-hoc Analysis Plan
- Data Story / Insight Draft
From the source collection in awesome-microsoft-copilot-prompts, licensed CC BY-SA 4.0.