Data Analysis Prompt Framework
By Cameron Chen · Published · Updated
Structure a data analysis request to get precise insights from a dataset.
Tags: data, analytics, analysis
Prompt template
## Introduction Structure a precise data analysis request to extract meaningful insights from your dataset. ## Dataset Description - Data Type: [dropdown: Sales data, Customer behaviour, Marketing metrics, Financial data, Survey results, Web analytics, Product usage, HR data, Other] - Data Source: [text: e.g., Google Analytics, Salesforce, Excel export, SQL database] - Time Period Covered: [text: e.g., Jan 2024 – Dec 2024, Last 90 days] - Number of Records (approx): [text: e.g., 5,000 rows, 1M events] ## Analysis Goal - Primary Question to Answer: [textarea: What business decision does this analysis inform?] - Key Metrics to Analyse: [textarea: e.g., Conversion rate, CAC, Churn rate, ARPU] - Audience for Results: [dropdown: CEO/Exec, Marketing team, Engineering, Investors, Myself] ## Analysis Type [multi: Descriptive statistics, Trend analysis, Cohort analysis, A/B test evaluation, Funnel analysis, Segmentation, Correlation analysis, Forecasting/prediction, Anomaly detection] ## Output Format - Preferred visualisation: [multi: Bar chart, Line chart, Pie chart, Heat map, Table, Scatter plot] - Summary report format: [dropdown: Executive summary (1 page), Detailed report, Slide deck outline, Dashboard mockup]