AI Prompts for Data Analysts
36 prompts — copy-ready
AI tools are transforming data analysis workflows by generating SQL queries, writing Python scripts, and creating visualizations from natural language descriptions. Data analysts who master AI prompting can explore datasets faster, automate repetitive analysis, and communicate insights more effectively. These curated AI prompts for data analysts cover SQL generation, Python data manipulation, statistical analysis, dashboard design, and stakeholder reporting. Each prompt is designed for real analyst workflows and produces code and insights you can use immediately.
- 1
CSV Data Analysis Report Generator
Turning raw data into actionable insights is where most analysis efforts stall. This prompt provides a structured analytical framework that ensures no...
- 2
Data Visualization Recommender
This prompt helps analysts and data professionals select the most effective chart types for their specific data and audience. Rather than defaulting t...
- 3
Chart Type Recommender
This prompt provides expert-level data visualization guidance by analyzing your specific data and recommending the optimal chart type with detailed ju...
- 4
Spreadsheet Formula Builder
This prompt converts plain English descriptions of calculations into working spreadsheet formulas for Excel or Google Sheets. Whether you need a compl...
- 5
Data Cleaning Script Generator
Data cleaning typically consumes 60-80% of any analysis project, yet it is often done ad-hoc with no documentation of what transformations were applie...
Get More AI Prompts for Data Analysts Weekly
New prompts, tips, and guides delivered to your inbox every week. Free.
Opens the Indexed newsletter. No spam — unsubscribe anytime.
- 6
KPI Dashboard Designer
This prompt generates a complete KPI dashboard specification including metric selection, calculation formulas, layout design, and drill-down architect...
- 7
Survey Results Analyzer
This prompt turns raw survey data into a structured analysis report with actionable insights. It goes beyond simple tallying by identifying hidden pat...
- 8
Data Dashboard Layout Planner
This prompt produces a complete dashboard design specification including layout structure, chart type recommendations, interaction patterns, and respo...
- 9
A/B Test Design and Results Analyzer
Most A/B tests fail not because of bad ideas but because of poor experimental design: underpowered tests, peeking at results too early, or no pre-defi...
- 10
Data Dashboard Design and Layout
Designing effective data dashboards requires balancing information density with clarity, and choosing the right visualization for each metric. This pr...
- 11
Customer Survey Response Analyzer
Customer survey data is only valuable if you can extract actionable insights from it, and many teams lack the analytical framework to do so systematic...
- 12
Professional Email Response Templates
This prompt generates polished, ready-to-send email responses for common professional scenarios including client follow-ups, meeting requests, complai...
- 13
SQL Query Debugger
This prompt transforms ChatGPT into a SQL debugging assistant that systematically diagnoses and fixes problematic database queries. Whether your query...
- 14
Cohort Analysis Interpreter
Cohort analysis is the most powerful tool for understanding retention, but interpreting cohort tables requires pattern recognition skills that take ye...
- 15
Research Paper Summarizer and Critic
Research papers are dense, time-consuming to read, and often require specialized knowledge to evaluate critically. This prompt transforms any paper in...
- 16
Meeting Agenda and Facilitator Guide
Unproductive meetings cost organizations an estimated $37 billion annually, and the root cause is almost always poor planning and facilitation. This p...
- 17
Python Data Pipeline Builder
Data pipelines are the backbone of modern data infrastructure, but building reliable ones from scratch involves many subtle decisions around error han...
- 18
Regex Pattern Builder and Explainer
Regular expressions are notoriously difficult to write, read, and debug, yet they are essential for text processing, validation, and data extraction....
- 19
DALL-E Infographic Designer
This prompt generates professional infographic layouts with clear visual hierarchy, icon illustrations, and data visualization placeholders. Infograph...
- 20
Cover Letter Customizer
This prompt creates tailored cover letters that directly connect your experience to specific job requirements, moving far beyond the generic templates...
- 21
Resume Achievement Rewriter
This prompt transforms bland, responsibility-focused resume bullets into compelling, quantified achievement statements that catch the attention of bot...
- 22
Personalized Resume Cover Letter Writer
This prompt creates tailored cover letters that hiring managers actually want to read, moving beyond the generic templates that get immediately discar...
- 23
Personalized Learning Path Generator
Self-directed learning fails most often due to lack of structure, not lack of motivation. This prompt creates a detailed 90-day learning roadmap that...
- 24
SQL Query Optimizer and Explainer
Slow SQL queries are one of the most common performance problems in production applications, and optimizing them requires understanding both the query...
- 25
Market Opportunity Analyzer
This prompt delivers a structured market opportunity analysis that covers every dimension an entrepreneur or product team needs to evaluate before com...
- 26
LinkedIn Post Generator for Thought Leadership
LinkedIn has become the most important platform for professional thought leadership, but most posts fail because they read like corporate press releas...
- 27
Copilot Regex Explainer
This prompt demystifies regular expressions by providing character-by-character breakdowns, visual explanations, comprehensive test cases, and perform...
- 28
Meeting Notes Summarizer
This prompt converts raw meeting transcripts or rough notes into polished, actionable meeting summaries that ensure nothing falls through the cracks....
- 29
Competitor Analysis Framework
Understanding your competitive landscape is essential for strategic decision-making, but thorough competitor analysis usually takes days of research....
- 30
Weekly Email Newsletter Writer
Email newsletters are the most reliable content distribution channel with an average ROI of $36 for every $1 spent, but consistent quality writing is...
- 31
Freelance Proposal Writer
This prompt creates personalized freelance project proposals that stand out from the hundreds of generic copy-paste responses clients receive on platf...
- 32
ATS-Optimized Resume Rewriter
Most resumes get rejected by ATS software before a human ever reads them. This prompt rewrites your experience using the Google-recommended XYZ formul...
- 33
Freelance Rate Calculator
This prompt provides a complete freelance pricing strategy that goes far beyond a simple hourly rate calculation. It factors in the hidden costs most...
- 34
Weekly Newsletter Content Creator
This prompt generates complete newsletter editions that feel personal and engaging rather than corporate and forgettable. Every section is optimized f...
- 35
AI Slop Remover
This prompt turns ChatGPT, Claude, or Gemini into a disciplined line editor that strips out the tell-tale patterns of AI-generated writing — binary co...
- 36
Flashcard Generator
This prompt creates study flashcards grounded in cognitive science principles like active recall and spaced repetition, producing cards that are far m...
How to Get the Best Results
- Provide your database schema or table structure when asking AI to generate SQL — this avoids incorrect column names and joins.
- Ask AI to write pandas code with comments explaining each transformation step so you can learn and modify the analysis.
- Use AI to translate technical findings into executive summaries with key metrics, trends, and actionable recommendations.
Frequently Asked Questions
- What are the best AI prompts for data analysts?
- The best data analyst prompts include your data schema, the specific question you need answered, and the desired output format. Categories include SQL generation, Python/pandas analysis, visualization creation, and stakeholder reporting.
- Can AI write SQL queries for me?
- Yes. Describe your data tables and the analysis you need. AI can generate complex SQL with joins, window functions, CTEs, and aggregations. Always review the query logic and test on a sample before running on production data.
- How do I use AI for data visualization?
- Describe your data and the story you want to tell. AI can generate matplotlib, seaborn, plotly, or Tableau calculation code. Specify chart type, color scheme, and labeling preferences for presentation-ready visuals.
Related Collections
AI Prompts for Teachers
Curated AI prompts for educators to create lesson plans, quizzes, rubrics, and differentiated instruction materials. Save hours of prep time.
AI Prompts for Students
Curated AI prompts for students to study effectively, understand complex topics, and prepare for exams. Ethical AI study techniques.
AI Prompts for Real Estate
Curated AI prompts for real estate agents to write listings, generate leads, create market reports, and automate client communication.
AI Prompts for Small Business
Curated AI prompts for small business owners to streamline operations, marketing, customer service, and financial planning.
Get the Best AI Prompts Weekly
Curated prompts, tips, and guides delivered to your inbox every week. Free.
Opens the Indexed newsletter. No spam — unsubscribe anytime.