Skip to content AI News: Nano Banana 2.1 is out: better edits and text, half the API price per image →
Drawer B · by task · 16 on this page

Best AI Prompts for Data Analysis

Prompts for spreadsheets, statistics, queries and charts. The model plays the analyst; you bring the numbers.

Start here

Editor's picks · 4 in this list

All 40 editor's picks across the library →

Prompts

dashed = you fill it in
PH-1007Data & Analytics

Weekly Numbers Review

Paste this week's and last week's numbers and get a short owner's review: what moved, likely reasons to check, and the one question to act on.

You fill in what you dopaste metricspaste metrics or 'not…

ChatGPT · Claude · Gemini
PH-0748Data & Analytics

Data Artifact Builder

Paste a CSV into Claude and get a self-contained interactive artifact: a headline number, charts and a filterable table, plus every assumption.

You fill in paste your CSV herewho will read itthe question

Claude
PH-0749Data & Analytics

Database Migration Writer

Writes a reversible migration in your repo style, split into safe steps for a large table, with the tests run.

You fill in describe the schema changerow count

Claude Code
PH-0922Data & Analytics

Sheets Formula Builder

Writes, explains and debugs Google Sheets formulas from a plain description of your tabs and columns.

You fill in Sheet1AB+1 more

Gemini
PH-0933Data & Analytics

Spreadsheet Data Analyst

Turns a Google Sheet or CSV sales export into five clear findings, data quality warnings and next steps for small business owners.

You fill in 2024 sales exportonline homeware shopwhich products and months…

Gemini
PH-0650Data & Analytics

A/B Test Analyzer

Paste your variant names, sample sizes and conversions and get lift, significance, confounders and an honest ship, iterate or keep running call.

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0654Data & Analytics

Data Cleaning Assistant

Paste a sample of your spreadsheet or CSV and get a numbered cleaning checklist with exact steps and formulas to fix messy data before analysis.

You fill in Excel, Google Sheets…paste your rows here

ChatGPT · Claude · Gemini
PH-0655Data & Analytics

DAX Formula Writer

Turns your data model description into a working DAX measure, a filter context explanation and an alternative approach for Power BI.

You fill in Measure Namedescribe your tables…date table name+1 more

ChatGPT · Claude · Gemini
PH-0662Data & Analytics

KPI Dashboard Designer

Plan a Power BI, Tableau or Looker dashboard before you build it.

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0668Data & Analytics

Pandas Code Helper

Turn plain-language data questions into working pandas code with commented steps, short explanations and error warnings.

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0674Data & Analytics

SQL Query Optimizer

Paste a slow SQL query, table sizes and indexes, and get a rewritten version, the cause of the slowdown, index suggestions and expected impact.

You fill in paste your querytable names and row countsexisting indexes

ChatGPT · Claude · Gemini
PH-0525Data & Analytics

Microsoft Excel Expert

Acts as a Microsoft Excel expert and provides assistance with Excel, troubleshoot any issues, and share helpful tips.

Ready to paste

ChatGPT · Claude · Gemini
PH-0448Data & Analytics

Statistician

I want to act as a Statistician.

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0458Data & Analytics

Scientific Data Visualizer

Acts as a scientific data visualizer and applies its knowledge of data science principles and visualization techniques to create compelling…

Ready to paste · swap in your own request

ChatGPT · Claude · Gemini
PH-0479Data & Analytics

Diagram Generator

Acts as a Graphviz DOT generator.

You fill in nshape=rectangle8

ChatGPT · Claude · Gemini
PH-0382Data & Analytics

Excel Sheet

Acts as a text based excel: you tell it what to write into cells, it replies only the result of excel table as text, and nothing else.

Ready to paste

ChatGPT · Claude · Gemini
Weekly

New prompts in your inbox

One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy