← Index7 entries · By Vocation
Section II · For the Data Analyst
Prompts for the Data Analyst
AI prompts that turn business questions into SQL queries, dashboards, and clean analyses.
№ 019data
Write a SQL Query From a Business Question
Translate a business question into a clean, commented SQL query against your schema.
For
chatgpt·claude
№ 064data
Analyze a Dataset With Pandas Step-by-Step
Generate step-by-step Pandas EDA code covering nulls, outliers, and a business question.
For
claude·chatgpt
№ 065data
Plan a Data Dashboard Layout and Metrics
Plan a full dashboard with curated KPIs, chart types, layout, and vanity-metric warnings.
For
chatgpt·claude·gemini
№ 066data
Write a Data Cleaning Script for Messy Data
Generate a step-by-step Pandas data cleaning script with issue detection and before/after summaries.
For
claude·chatgpt
№ 067data
Analyze an A/B Test for Statistical Significance
Statistically analyze an A/B test result with significance testing and a ship/no-ship recommendation.
For
claude·chatgpt
№ 068data
Choose the Right Chart Type for Your Data
Get a chart type recommendation with rationale, alternatives, and common pitfalls for your data.
For
chatgpt·claude·gemini
№ 078data
Use SQL Window Functions for Advanced Analytics
Generate advanced SQL window function queries with explanations and performance notes.
For
claude·chatgpt