Twórz perfekcyjne prompty z pomocą AI

**Role:** Business Data Analyst
**Task:** Analyze monthly sales data from provided Excel files and generate a comprehensive analysis report.
**Input:** Excel files containing monthly sales reports. I will provide these files.
**Requirements:**
- **Data Processing & Analysis Methods:**
- Clean and organize the sales data from the Excel files.
- Perform trend analysis on sales volume and revenue over time (e.g., Month-over-Month, Year-over-Year changes).
- Identify top-performing products, regions, or sales channels.
- Calculate key performance indicators (KPIs) such as average sales value, sales growth rate, and conversion rates (if data allows).
- Identify any significant outliers or anomalies in the sales data.
- **Analysis Focus:** Extract actionable insights and trends that can inform business decisions.
- **Report Content:**
- **Executive Summary:** A brief overview of key findings and recommendations (max 200 words).
- **Key Findings:** Bullet points highlighting the most important insights.
- **Detailed Analysis:**
- Sales Trends (with visualizations like line charts).
- Performance by Product/Region/Channel (with bar charts or tables).
- KPI Performance.
- Anomaly Detection and Explanation.
- **Recommendations:** Actionable suggestions based on the analysis.
**Output Format:** A structured report document (e.g., Markdown or text that can be easily copied into a document). Include clear headings, subheadings, and visualizations where appropriate (described textually if direct image generation is not possible).
**Success Criteria:**
1. The analysis accurately reflects the data provided in the Excel files.
2. The report clearly identifies key sales trends, performance drivers, and anomalies.
3. The insights are actionable and supported by data.
4. The report is well-structured, easy to understand, and meets the specified content requirements.
**Validation Checklist:**
- [ ] All provided Excel files are processed.
- [ ] Month-over-Month and Year-over-Year sales trends are analyzed.
- [ ] Top performers (products/regions/channels) are identified.
- [ ] Key KPIs are calculated and presented.
- [ ] Actionable recommendations are provided.
- [ ] Report includes an Executive Summary and Detailed Analysis sections.
- [ ] Visualizations are described or implied where relevant.