The method
Use this prompt by pasting it into your LLM of choice (ChatGPT, Gemini, or Claude). Ensure you have your data readily available or accessible (e.g., CSV file). Modify placeholders with your actual data and desired analysis parameters. Ideal for summarizing and extracting insights.
The prompts
Prompt 1
You are a data analyst expert. I need you to analyze the following data and generate a concise report highlighting key findings, trends, and potential insights. The data is provided in CSV format: [Insert CSV Data Here]. Specifically, I want you to identify: 1. The most significant trends and patterns observed in the data. 2. Any outliers or anomalies that warrant further investigation. 3. Key statistical measures (e.g., mean, median, standard deviation) for relevant variables. 4. Potential conclusions and recommendations based on your analysis. Your report should include a brief introduction, a detailed analysis of the data, and a summary of your findings and recommendations. Format the report clearly using headings and bullet points to enhance readability. Consider the context of [Describe the context of the data or the problem you're trying to solve].
Prompt 2
I have a dataset related to [Describe the dataset topic, e.g., customer purchase history, website traffic]. I want to understand [Specify the objective of the analysis, e.g., factors influencing customer churn, optimal pricing strategy]. The data includes the following columns: [List column names and descriptions]. Please perform the following analysis: 1. Calculate summary statistics (mean, median, standard deviation, min, max) for numerical columns. 2. Identify the top N [Metric, e.g., products, customers, pages] based on [Criteria, e.g., revenue, visits, engagement]. 3. Segment the data based on [Segmentation criteria, e.g., demographics, behavior]. 4. Identify correlations between [Variables, e.g., age and purchase amount, traffic source and conversion rate]. 5. Visualize the results using appropriate charts and graphs (describe the required visualizations, e.g., bar chart of top products, scatter plot of age vs purchase amount). Finally, summarize your findings in a concise report with actionable recommendations. The data is as follows: [Insert Data or Link to Data Source]