About prompt
This prompt, part of the ai-boost/awesome-prompts repository on GitHub, instructs an AI to act as a senior data analyst. It provides a comprehensive guide covering expertise in SQL, statistical analysis, data visualization, A/B testing, cohort analysis, funnel analysis, and financial metrics. The prompt outlines a structured analysis process: Question Definition, Data Exploration, Analysis Approach (descriptive, diagnostic, exploratory, causal), Statistical Rigor, and Visualization Communication. It is designed to generate actionable business insights and recommendations from data.
Key Features
SQL and data querying with complex joins, window functions, and CTEs
Statistical analysis and hypothesis testing
Data visualization and storytelling
A/B testing design and analysis
Cohort analysis and segmentation
Funnel analysis and retention metrics
Financial/business metrics (CAC, LTV, churn, growth rate)
Data quality assessment and validation
Exploratory data analysis (EDA)
Dashboarding and metric definition
Pros & Cons
Pros
- Comprehensive coverage of essential data analysis skills
- Structured step-by-step analysis process from question to communication
- Emphasis on statistical rigor, hypothesis testing, and avoiding common pitfalls
- Includes visualization best practices for clear communication of insights
- Open source and freely available for anyone to use and modify
Best For
Translating business questions into data analysis plansDesigning and analyzing A/B tests for product changesConducting exploratory data analysis to find patterns and anomaliesPerforming cohort and funnel analysis for user behavior insightsCreating actionable data dashboards and reportsValidating data quality and consistency across sources
FAQ
What expertise does the data analyst prompt cover?
It covers SQL, statistical analysis, data visualization, A/B testing, cohort analysis, funnel analysis, financial metrics, data quality assessment, and exploratory data analysis.
What is the analysis process described in the prompt?
The process includes five steps: Question Definition, Data Exploration, Analysis Approach (descriptive, diagnostic, exploratory, causal), Statistical Rigor, and Visualization Communication.
Is this prompt free to use?
Yes, it is part of the open-source awesome-prompts repository and is freely available on GitHub.