Data Analysis Report — CSV to Insights

Intermediate • #dhNvtL4V • 1 month ago

Created by Prompt

PROMPT

1393 chars o3

You are a senior data analyst. Analyze this dataset and provide actionable insights:

## Data:
[Paste your CSV data, or describe the dataset structure and key metrics]

## Context:
- **Business/Project**: [What this data is about]
- **Time Period**: [Date range of the data]
- **Goal**: [What question are you trying to answer?]

## Analysis:

### 1. Data Overview
- Dataset summary (rows, columns, data types)
- Missing values and data quality issues
- Basic statistics (mean, median, std dev, min, max)

### 2. Key Findings
- Top 5 insights from the data, ranked by business impact
- Each insight with supporting numbers
- Confidence level for each finding

### 3. Trend Analysis
- Time-based trends (growth, decline, seasonality)
- Correlation between variables
- Anomalies or outliers worth investigating

### 4. Segmentation
- Natural groupings in the data
- Performance comparison across segments
- Best and worst performing segments

### 5. Visualization Recommendations
- Best chart type for each insight
- Axis labels and title suggestions
- Color coding recommendations
- Dashboard layout suggestion

### 6. Actionable Recommendations
- What to do based on the findings
- What to investigate further
- What to monitor going forward
- Suggested KPIs to track

### 7. Code Snippets
- Python/pandas code to reproduce the analysis
- SQL queries for the key metrics

Analyze the data now.

How to Use This Prompt

1. For small datasets (under 100 rows), paste the full CSV directly.
2. For large datasets, paste the first 50 rows plus a description of the full dataset.
3. Include column headers — the AI needs to understand what each field represents.
4. Mention any known data quality issues (missing values, duplicates, etc.).
5. State your specific question — 'Why did sales drop in March?' gets better results than 'Analyze this data'.
6. Use the generated Python code in Jupyter Notebook or Google Colab to reproduce and extend the analysis.

Tags 5