AI Prompts for Data Analysts
44 prompts — copy & paste 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 GitHub Copilot advanced Featured
Python Decorator Generator
This prompt generates production-ready Python decorators that follow best practices for metadata preservation, type safety, and async compatibility. I...
python decorators design-patterns - 2 Claude intermediate Featured
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...
survey research insights - 3 ChatGPT intermediate Featured
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...
data-analysis reporting statistics - 4 Cursor intermediate Featured
React Component Generator with TypeScript
This prompt generates complete, production-quality React components that follow modern best practices from day one. Instead of scaffolding a basic com...
react typescript component - 5 GitHub Copilot intermediate
API Documentation Generator from Code
This prompt transforms raw API code into developer-friendly documentation that follows the standards engineers expect from tools like Stripe and Twili...
api documentation openapi
Get More AI Prompts for Data Analysts Weekly
New prompts, tips, and guides delivered to your inbox every week. Free.
- 6 Gemini intermediate
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...
data-visualization charts analytics - 7 Cursor intermediate
Docker Compose Generator for Multi-Service Apps
This prompt generates Docker Compose configurations that follow production best practices out of the box, saving you from the hours of trial-and-error...
docker docker-compose devops - 8 Cursor beginner
Conventional Git Commit Message Writer
This prompt generates precise, conventional commit messages by actually analyzing the diff rather than relying on vague descriptions. The emphasis on...
git commit-messages conventional-commits - 9 GitHub Copilot advanced
GitHub Actions Workflow Builder
This prompt generates complete, production-grade GitHub Actions CI/CD workflows with proper caching, matrix testing, deployment gates, and notificatio...
github-actions ci-cd devops - 10 Gemini advanced
KPI Dashboard Designer
This prompt generates a complete KPI dashboard specification including metric selection, calculation formulas, layout design, and drill-down architect...
kpi dashboard business-intelligence - 11 Cursor intermediate
Next.js API Route Handler with Validation
This prompt generates Next.js API route handlers that handle the boring but critical parts of API development — validation, error handling, authentica...
nextjs api-routes typescript - 12 Cursor intermediate
Prisma Schema Generator
This prompt generates complete Prisma database schemas from application requirements, including models, relationships, indexes, enums, and seed data....
prisma database schema - 13 ChatGPT beginner
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...
excel google-sheets formulas - 14 ChatGPT intermediate
SQL Query Debugger
This prompt transforms ChatGPT into a SQL debugging assistant that systematically diagnoses and fixes problematic database queries. Whether your query...
sql debugging database - 15 GitHub Copilot intermediate
TypeScript Type Generator from JSON
This prompt converts raw JSON data into a complete TypeScript type system with runtime validation, going far beyond simple JSON-to-TypeScript converte...
typescript types zod - 16 Gemini intermediate
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...
data-visualization charts analytics - 17 GitHub Copilot beginner
Copilot Code Comment Generator
This prompt adds professional-quality documentation comments to existing code without modifying the code itself. Good comments explain the why, not th...
documentation code-comments jsdoc - 18 GitHub Copilot advanced
Copilot Error Handler Generator
This prompt generates a production-grade error handling system that goes far beyond simple try-catch blocks. It creates a structured error hierarchy,...
error-handling reliability backend - 19 GitHub Copilot advanced
Copilot Interface Generator
This prompt generates a complete TypeScript type system for any domain, producing interfaces, DTOs, union types, utility types, type guards, and runti...
typescript type-system interfaces - 20 GitHub Copilot intermediate
Copilot Regex Explainer
This prompt demystifies regular expressions by providing character-by-character breakdowns, visual explanations, comprehensive test cases, and perform...
regex pattern-matching debugging - 21 Cursor advanced
Cursor Migration Helper
This prompt generates comprehensive database and system migration plans with executable scripts that handle the full lifecycle from planning through v...
database-migration devops data-engineering - 22 Cursor advanced
Cursor API Client Generator
This prompt generates production-ready API client libraries that handle all the complexity of external API integration. Instead of making raw HTTP cal...
api-integration typescript http-client - 23 Cursor intermediate
Cursor Refactor Assistant
This prompt transforms messy, hard-to-maintain code into clean, well-structured code following industry best practices. It applies key software engine...
refactoring code-quality clean-code - 24 Cursor intermediate
Cursor Test Writer
This prompt generates comprehensive test suites that go far beyond basic happy-path testing. It produces tests organized into logical categories cover...
testing unit-tests test-driven-development - 25 ChatGPT advanced
Data Dashboard Layout Planner
This prompt produces a complete dashboard design specification including layout structure, chart type recommendations, interaction patterns, and respo...
dashboard data-visualization ux-design - 26 Midjourney advanced
MJ Architecture Visualizer
This prompt generates photorealistic architectural visualizations that showcase buildings in their intended environment with stunning detail. Architec...
architecture 3d-rendering visualization - 27 Gemini advanced
Property Investment Analyzer
This prompt transforms Gemini into a real estate investment calculator and advisor that evaluates properties using the same financial metrics professi...
real-estate investment-analysis financial-modeling - 28 Claude intermediate
Real Estate Market Analyzer
This prompt turns Claude into a real estate market analyst capable of delivering structured, data-driven market assessments for any location. It cover...
real-estate market-analysis investing - 29 Stable Diffusion intermediate
SD Interior Design Concept
This prompt generates photorealistic interior design concept visualizations that look like they belong in an architectural digest magazine. It produce...
interior-design architecture home-decor - 30 Claude advanced
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...
AB-testing experimentation statistics - 31 GitHub Copilot advanced
REST API Endpoint Builder
Building robust API endpoints involves much more than writing a route handler. This prompt generates the full stack of an endpoint including validatio...
api rest backend - 32 Midjourney advanced
Architectural Visualization Render
Architectural visualization typically requires expensive 3D rendering software and hours of setup time. This prompt generates photorealistic architect...
architecture visualization 3D-render - 33 GitHub Copilot advanced
CI/CD Pipeline Configuration Generator
Setting up a comprehensive CI/CD pipeline from scratch involves dozens of configuration decisions that can take days to get right. This prompt generat...
CI-CD devops automation - 34 GitHub Copilot advanced
Code Review Checklist and Feedback
Code reviews are one of the highest-leverage activities in software engineering, but their quality varies enormously based on the reviewer's experienc...
code-review best-practices security - 35 Claude advanced
Cohort Analysis Interpreter
Cohort analysis is the most powerful tool for understanding retention, but interpreting cohort tables requires pattern recognition skills that take ye...
cohort-analysis retention growth - 36 Claude intermediate
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...
survey-analysis customer-insights NPS - 37 Gemini intermediate
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...
dashboard data-visualization UX-design - 38 Claude intermediate
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...
data-cleaning ETL data-quality - 39 Cursor advanced
Database Schema Designer
A well-designed database schema is the foundation of any application, and mistakes made at this level are extremely expensive to fix later. This promp...
database schema-design SQL - 40 Cursor beginner
Debug Error Detective
Debugging is often the most frustrating part of development, especially when error messages are cryptic or misleading. This prompt turns the AI into a...
debugging error-handling troubleshooting - 41 Cursor advanced
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...
python ETL data-pipeline - 42 ChatGPT beginner
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....
regex pattern-matching validation - 43 Claude advanced
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...
SQL database performance - 44 GitHub Copilot intermediate
Comprehensive Unit Test Generator
Writing thorough unit tests is tedious but critical for code reliability. This prompt generates test suites that go far beyond basic happy-path testin...
testing unit-tests TDD
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.