Data management prompts

Prompts to clean data, write formulas, analyze tables and build reports.

9 prompts

Data management
KPI definitions and dashboard spec: formulas, sources and owners
Define your KPIs with no ambiguity: a metric tree, a definition card per KPI with exact formula, source and owner, and a dashboard spec your data team can build straight away.
ChatGPT · Claude · Gemini · Microsoft Copilot
View prompt
Data management
Clean a messy CSV step by step without losing data
Get a data quality diagnosis of your CSV and an ordered cleaning plan: types, duplicates, blanks, dates, inconsistent categories, code or formulas, and final validation checks.
ChatGPT · Claude · Gemini · Microsoft Copilot
View prompt
Data management
Analyze survey results with open and closed questions
Analyze your survey properly: response cleaning, percentages and top-2-box, segment cross-tabs with small-sample warnings, themes from open-ended answers and clear limitations.
ChatGPT · Claude · Gemini · Microsoft Copilot
View prompt
Data management
Regex formulas for Google Sheets and Excel, explained and tested
Extract, validate or replace text with REGEXEXTRACT, REGEXMATCH and REGEXREPLACE: the exact formula for your examples, explained piece by piece, tested on edge cases and applied to a whole column.
ChatGPT · Claude · Gemini · Microsoft Copilot
View prompt
Data management
Monthly business report: from numbers to a clear narrative
Turn the month's metrics into a report people read in five minutes: executive summary, results vs target, confirmed causes vs hypotheses, risks and next month's priorities.
ChatGPT · Claude · Gemini · Microsoft Copilot
View prompt
Data management
Pivot table guide built around the question you need answered
Learn to build a pivot table in Excel or Google Sheets from your own columns: data prep, fields in rows, columns and values, grouping dates, extra views and common errors fixed.
ChatGPT · Claude · Gemini · Microsoft Copilot
View prompt
Data management
Analyze A/B test results and make a sound decision
Interpret an A/B test rigorously: sanity checks, conversion rates, lift, confidence interval and p-value, practical significance and a clear recommendation for your team.
ChatGPT · Claude · Gemini · Microsoft Copilot
View prompt
Data management
Analyze a CSV dataset and propose insights and charts
Analyze a CSV dataset: data quality checks, exploratory analysis, actionable insights and recommended charts with the code to build them.
ChatGPT · Claude · Gemini
View prompt
Data management
Create Excel or Google Sheets formulas
Describe what you need to calculate and get the exact Excel or Google Sheets formula, explained and with alternatives.
ChatGPT · Claude · Gemini · Microsoft Copilot
View prompt