The method
To effectively utilize this prompt, provide context on your dataset including source, variables, and goals. Start by feeding the prompt and the data description to the LLM. Refine the output by iterating, focusing on specific areas or analyses of interest.
The prompts
Prompt 1
Based on the provided dataset description, generate a detailed data analysis report. The report should include: 1. An executive summary highlighting key findings and insights. 2. A description of the data, including source, variables, data types, and any data cleaning or preprocessing steps taken. 3. Exploratory Data Analysis (EDA) visualizations, such as histograms, scatter plots, and box plots, to illustrate data distributions and relationships. 4. Statistical analysis, including descriptive statistics (mean, median, standard deviation) and inferential statistics (hypothesis testing, confidence intervals) where appropriate. 5. Identification of any data quality issues, such as missing values or outliers, and recommendations for addressing them. 6. Interpretation of the results, explaining the implications of the findings for the specific context of the data. 7. Conclusions and recommendations based on the analysis. Please ensure that the report is clear, concise, and easy to understand for a non-technical audience. Include a brief overview of the methods and tools used. Consider focusing on impactful actionable insights derived from the data analysis.
Prompt 2
You are a data analyst tasked with creating a preliminary analysis report for a business. Given the following details about our customer purchase data, craft a professional report outline including suggested visualizations and key metrics that should be included. We collect data on customer demographics, purchase history (items bought, price paid, time of purchase), website activity (pages visited, time spent), and marketing campaign interactions (emails opened, clicks). Key business goals are to increase customer lifetime value (LTV), improve customer retention, and optimize marketing spend. Your outline should include sections for Executive Summary, Data Overview, Exploratory Data Analysis, Customer Segmentation, Predictive Modeling (churn analysis and LTV prediction), Marketing Campaign Analysis, and Recommendations. In each section specify the purpose, key metrics and the analysis to be performed, and suggested visualizations.