Category · Data & Analysis

Prompts for Data & Analysis

SQL, spreadsheet formulas, cohort analysis and turning a dataset into a readable finding.

Popular: Blog outline Code review Midjourney Cover letter SQL

56 Prompts

14 Categories

12 AI models

16 Featured

AI Directory Companies Comparisons Alternatives Best-of Guides Use Cases Collections AI Tools AI Models AI Courses

4 prompts

Updating…

Featured

SQL From a Question in English

Data & Analysis

Writes the query, states the assumptions it made, and flags where the schema is ambiguous.

ChatGPT Claude GitHub Copilot

Code Intermediate 3 340

Open

Write a [DIALECT] query that answers this question:

[QUESTION]

Schema:
[SCHEMA]

Return:
1. The query, formatted and commented where a clause is non-obvious
2. Every assumption you made — especially about NULLs, duplicates, time zones and what counts as "active"
3. Any place the schema is ambiguous enough that a reasonable person would write a different query, and what you would need to know to decide
4. A rough note on what will be slow at scale and which index would fix it

Do not invent columns. If the question cannot be answered from this schema, say which column is missing.

Find the Finding in a Dataset

Data & Analysis

Turns numbers into the one sentence a decision-maker needs, with the caveat attached.

ChatGPT Claude Gemini

Text Advanced 3 380

Open

Here is a dataset:

[DATA]

Context: [CONTEXT]. The decision on the table is [DECISION].

Do this in order:
1. State what the data shows in ONE sentence a busy person could act on
2. The three numbers that sentence rests on
3. What the data does NOT show that someone will assume it does
4. The strongest alternative explanation for the pattern, taken seriously
5. Sample size, time window and any obvious selection effect — say plainly whether this is enough to decide on
6. The one additional cut of the data that would most change your confidence

No chart suggestions. No "further analysis is recommended". If the honest answer is that the data cannot support the decision, lead with that.

Spreadsheet Formula Explained Both Ways

Data & Analysis

Writes the formula and explains it in English, so you can maintain it later.

ChatGPT Gemini Mistral

Code Beginner 3 220

Open

In [TOOL], I need a formula that does this:

[GOAL]

My data: [DATA_LAYOUT]

Give me:
1. The formula, ready to paste
2. A plain-English reading of it, left to right, so I could rebuild it from memory
3. What it returns when the range is empty, contains text where it expects a number, or has duplicates
4. A simpler version if one exists, even if slightly less flexible
5. The one mistake people make when copying this formula down a column

Use the function names as they appear in [TOOL], not the generic ones.

Browse Prompt Categories

Every prompt in the library, grouped by the job it does — pick the shelf, then the prompt.

Writing & Content

Blog posts, newsletters, scripts and long-form drafts you can edit rather than start from scratch.

4 prompts

Marketing & Ads

Ad copy, landing pages, launch emails and positioning built around a real offer and audience.

4 prompts

SEO & Search

Keyword clustering, briefs, metadata and on-page rewrites aimed at search intent.

4 prompts

Coding & Development

Refactors, test suites, code review, migrations and debugging with the context an LLM needs.

4 prompts

Data & Analysis

SQL, spreadsheet formulas, cohort analysis and turning a dataset into a readable finding.

4 prompts

Design & Image

Image prompts with subject, lens, lighting and style separated so you can swap one at a time.

4 prompts

Video & Motion

Shot lists, scene descriptions and camera language for text-to-video models.

4 prompts

Business & Strategy

Positioning, pricing, competitor teardowns, board updates and decision memos.

4 prompts

Education & Learning

Lesson plans, explanations at a chosen level, quizzes and study schedules.

4 prompts

Productivity

Meeting notes, inbox triage, weekly planning and turning a mess into a next action.

4 prompts

Customer Support

Reply templates, macro libraries, escalation summaries and tone-matched apologies.

4 prompts

Social Media

Hooks, threads, captions and repurposing one idea across every platform.

4 prompts

Research & Insights

Literature summaries, interview guides, synthesis and steel-manning the other side.

4 prompts

Career & Resume

Resume bullets, cover letters, interview prep and performance-review self-assessments.

4 prompts

See all categories

Questions

Prompt FAQs

Still stuck? Our team answers every message.

Still have a question? We usually reply within one working day.

How do I use these prompts?

Copy any prompt with one click, paste it into your AI assistant, then replace the bracketed blanks — [TOPIC], [AUDIENCE] and so on — with your own details before sending. The blanks are listed on every prompt page so you know what to prepare.

Which AI models do these work with?

Each prompt lists the models it was written for. The text prompts are largely model-agnostic and run well on ChatGPT, Claude, Gemini and other assistants; the image and video prompts use syntax specific to their tool, such as aspect-ratio flags, so those are worth matching to the model named on the card.

Are the prompts free to use?

Yes. Every prompt in the library is free to copy, edit and use commercially. You do not need an account to copy one.

Why do some prompts tell the model to say “I do not know”?

Because a confident wrong answer is more expensive than an admission of uncertainty. Several prompts here ask the model to mark unverified claims or to stop and ask rather than guess — that instruction is doing real work and is worth keeping when you edit them.

Still have a question? We usually reply within one working day.

Prompts for Data & Analysis

SQL From a Question in English

Find the Finding in a Dataset

Spreadsheet Formula Explained Both Ways

Cohort Retention Read-Out

Browse Prompt Categories

Writing & Content

Marketing & Ads

SEO & Search

Coding & Development

Data & Analysis

Design & Image

Video & Motion

Business & Strategy

Education & Learning

Productivity

Customer Support

Social Media

Research & Insights

Career & Resume

Prompt FAQs

How do I use these prompts?

Which AI models do these work with?

Are the prompts free to use?

Why do some prompts tell the model to say “I do not know”?

Popular Searches

Try Something New

Trending Tools