Create a Data Dictionary from a Dataset
Documents field meanings, formats, relationships, quality concerns, and questions from a dataset or schema. Why it matters: a ready draft saves you from a blank page.
Work prompt series
Data analysis and analytics prompts
Prompts for KPI trees, metric definitions, cohort and funnel narratives, experiment write-ups, tracking plans, and turning SQL or dashboards into plain English.
30 prompts in this series. Each prompt page shows the full prompt, the variables to fill in, the models it was tested with, and example output.
All prompts in this series
30 data analysis and analytics prompts
Turn a Dashboard into an Executive Narrative
Explains what changed, why it matters, uncertainties, and decisions requiring leadership attention. Why it matters: a ready draft saves you from a blank page.
Metric Anomaly Investigation — ChatGPT Prompt
Structure an investigation plan for a sudden metric swing. Why it matters: a ready draft saves you from a blank page.
Self-Serve BI Guide Outline — ChatGPT Prompt
Outline a self-serve BI enablement guide; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Board Metrics Appendix Notes — ChatGPT Prompt
Notes for a board metrics appendix; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Cohort Analysis Explanation — ChatGPT Prompt
Explain cohort charts in plain language with caveats. Why it matters: a ready draft saves you from a blank page.
Dashboard Requirements — ChatGPT Prompt
Writes dashboard requirements: questions, metrics, grain, and filters. Why it matters: a ready draft saves you from a blank page.
Data Quality Rules — ChatGPT Prompt
Define data quality rules and owners; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
ETL Failure Runbook Narrative — ChatGPT Prompt
Writes an ETL failure triage narrative; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Executive Insights Memo from Metrics — ChatGPT Prompt
Turn metric tables into an executive insights memo with caveats. Why it matters: a ready draft saves you from a blank page.
A/B Experiment Write-Up — ChatGPT Prompt
Document an experiment: hypothesis, design, results, decision. Why it matters: a ready draft saves you from a blank page.
Forecast Assumptions Memo — ChatGPT Prompt
Document forecast assumptions clearly; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Funnel Analysis Narrative — ChatGPT Prompt
Narrate funnel drop-offs with caveats; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
KPI Tree Outline — ChatGPT Prompt
Outline a KPI tree from north star to inputs; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Metric Definition Spec — ChatGPT Prompt
Writes a metric definition with SQL sketch and edge cases. Why it matters: a ready draft saves you from a blank page.
North Star Metric Proposal — ChatGPT Prompt
Propose and stress-test a north-star metric; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Analytics Team OKRs — ChatGPT Prompt
Draft OKRs for an analytics/data team. Why it matters: a ready draft saves you from a blank page.
Post-Launch Metrics Readout — ChatGPT Prompt
Structure a post-launch metrics readout; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Privacy Impact Notes — ChatGPT Prompt
Draft privacy impact discussion notes for a data feature (not legal advice). Why it matters: a ready draft saves you from a blank page.
Qual+Quant Synthesis Memo — ChatGPT Prompt
Synthesize qualitative and quantitative findings; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Retention Report Narrative — ChatGPT Prompt
Writes a retention report narrative; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Audience Segmentation Brief — ChatGPT Prompt
Brief a segmentation analysis; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
SQL Style Guide — ChatGPT Prompt
Draft a team SQL style guide; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
SQL Result Narrative — ChatGPT Prompt
Narrate SQL query results for a non-technical audience. Why it matters: a ready draft saves you from a blank page.
Stakeholder Question Map — ChatGPT Prompt
Map stakeholder questions to metrics; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Survey Analysis Summary — ChatGPT Prompt
Summarize survey results with themes and limitations. Why it matters: a ready draft saves you from a blank page.
Event Tracking Plan — ChatGPT Prompt
Draft an analytics event tracking plan; never invent metrics — mark unknowns. Why it matters: a ready draft saves you from a blank page.
Find Anomalies in My Spreadsheet
Detects suspicious values, missing data, inconsistent formats, duplicates, and unusual trends. Why it matters: a ready draft saves you from a blank page.
Find Themes in User Feedback
Groups customer feedback into themes, contradictions, opportunities, and research gaps without inventing evidence. Why it matters: nice answers don't fix the real problem.
Reconcile Two Conflicting Reports
Finds definition, date, scope, aggregation, and record-level reasons that two reports disagree. Why it matters: a ready draft saves you from a blank page.
Work prompts
More work prompt series
Career and workplace prompts
38 prompts · Prompts for promotions, offers, negotiations, resignations, networking, and 30-60-90 day plans, many with role-specific versions.
Startup and business planning prompts
23 prompts · Lean canvas, board updates, investor emails, pitch deck outlines, OKRs, pricing strategy, hiring plans, and contract red flags.
Product design and UX prompts
20 prompts · UX critiques, accessibility reviews, design specs, error and empty state copy, personas, and handoff notes.
B2B sales prompts
18 prompts · Discovery scripts, battlecards, objection handling, MEDDIC prep, mutual action plans, QBRs, renewals, and RFP responses.
Stock and portfolio research prompts
18 prompts · Research prompts that pull filings and news first: compare stocks, read earnings, stress-test a portfolio, and check valuation math. Research only, not investment advice.
Business finance prompts
13 prompts · Cash flow narratives, runway scenarios, board financial summaries, monthly close checklists, and invoice follow-ups.
Resume, cover letter, and interview prompts
10 prompts · Tailor your resume and cover letter to a job description, prepare interview stories, and review how an interview went.
Meeting, memo, and stakeholder update prompts
9 prompts · Turn meetings, documents, and discussions into decisions, briefs, and updates for different audiences.
LinkedIn profile writing prompts
8 prompts · Rewrite your LinkedIn headline, About section, and experience bullets, audit your profile like a recruiter, and write posts and connection requests.
Returnship application prompts
4 prompts · Returnship applications that explain a career break with confidence, in design, operations, product, and sales versions.
Volunteer impact resume bullet prompts
4 prompts · Turn volunteer work into measurable resume bullets for design, operations, sales, or tech roles.