📊Data Analyst Toolkit

25 prompts for data analysis & reporting

SQL query generators, data cleaning, dashboard summaries, executive reports, and visualization recommendations.

What this guide covers

25 prompts for analysts, data scientists, and business intelligence professionals. Covers: SQL Generation (5 prompts — complex joins, window functions, CTEs, performance optimization, migration scripts), Data Cleaning (5 prompts — missing value strategy, outlier detection, normalization, deduplication, format standardization), Analysis & Insights (5 prompts — trend analysis, cohort analysis, A/B test interpretation, funnel analysis, RFM segmentation), Reporting (5 prompts — executive summary, weekly metrics report, quarterly business review, dashboard commentary, data dictionary generator), Visualization (5 prompts — chart type recommender, dashboard layout planner, KPI definition, data storytelling framework, presentation slide data narrative).

How to use these prompts

Every prompt in this collection is written to be pasted into a chat with a large language model and adapted to your situation. You do not need any special tools — just an AI assistant and the placeholders filled in with your own details. Work through them one at a time:

• 1.Replace every [BRACKETED] placeholder with your own specifics — the more concrete the input, the sharper the output.
• 2.Give the model a role and an audience first ("You are a senior copywriter writing for busy founders"), then the task.
• 3.Ask for 3 variations, pick the strongest, then request one refinement pass. Two rounds beats one long prompt.
• 4.Paste real context — your product, tone samples, or data — so the answer is grounded, not generic.
• 5.Keep a short "house style" note you prepend to every prompt for a consistent voice across outputs.

Example prompt from this guide

Here is one of the 25 prompts, shown exactly as you would use it:

Prompt #1 — Complex SQL Query Generator:

You are a senior data engineer. Write an optimized SQL query that [REQUIREMENT]. The database uses PostgreSQL 15...

Works with your favourite AI

These prompts are model-agnostic — they produce great results across the major assistants. Tested with:

Topics: #data #sql #analytics #reporting #dashboard