business-analytics-reporter

これはレビュー時に保存された抜粋です。完全で最新の内容は外部ソースを確認してください。

---
name: business-analytics-reporter
description: This skill should be used when analyzing business sales and revenue data from CSV files to identify weak areas, generate statistical insights, and provide strategic improvement recommendations. Use when the user requests a business performance report, asks to analyze sales data, wants to identify areas of weakness, or needs recommendations on business improvement strategies.
---

# Business Analytics Reporter

## Overview

Generate comprehensive business performance reports that analyze sales and revenue data, identify areas where the business is lacking, interpret what the statistics indicate, and provide actionable improvement strategies. The skill uses data-driven analysis to detect weak areas and recommends specific strategies backed by business frameworks.

## When to Use This Skill

Invoke this skill when users request:
- "Analyze my business data and tell me where we're lacking"
- "Generate a report on what areas need improvement"
- "What do these sales numbers tell us about our business performance?"
- "Create a business analysis report with improvement strategies"
- "Identify weak areas in our revenue data"
- "What strategies should we use to improve our business metrics?"

The skill expects CSV files containing business data (sales, revenue, transactions) with columns like dates, amounts, categories, or products.

## Core Workflow

### Step 1: Data Loading and Exploration

Start by understanding the data structure and what the user wants to analyze.

**Ask clarifying questions if needed:**
- What specific metrics or areas should the analysis focus on?
- Are there particular time periods or categories of interest?
- Should the report include visualizations or focus on written analysis?

**Load and explore the data:**
```python
import pandas as pd

# Load the CSV file
df = pd.read_csv('business_data.csv')

# Display basic information
print(f"Data shape: {df.shape}")
print(f"Columns: {df.columns.tolist()}")
print(f"Date range: {df['date'].min()} to {df['date'].max()}")
print(df.head())
```

### Step 2: Run Automated Analysis

Use the bundled analysis script to generate comprehensive insights:

```bash
python scripts/analyze_business_data.py path/to/business_data.csv output_report.json
```

The script will:
1. Automatically detect data structure (revenue columns, date columns, categories)
2. Calculate statistical metrics (mean, median, growth rates, volatility)
3. Identify trends and patterns
4. Detect weak areas and underperforming segments
5. Generate improvement strategies based on findings
6. Output a structured JSON report

**Output structure:**
```json
{
  "metadata": {...},
  "findings": {
    "basic_statistics": {...},
    "trend_analysis": {...},
    "category_analysis": {...},
    "variability": {...}
  },
  "weak_areas": [...],
  "improvement_strategies": [...]
}
```

### Step 3: Interpret the Analysis Results

Read the generated JSON report and interpret the findings for the user in plain language.

**Focus on:**
1. **Current State**: What the data shows about business performance
2. **Weak Areas**: Specific problems identified with severity levels
3. **Root Causes**: Why these issues exist (use business frameworks from references/)
4. **Impact**: What these weaknesses mean for the business

**Example interpretation:**
```
Based on the analysis of your sales data from January to December 2024:

Current State:
- Total revenue: $1.2M with average monthly revenue of $100K
- Average growth rate: -3.5% indicating declining performance
- Revenue stability: High volatility (CV: 58%) suggesting inconsistent performance

Weak Areas Identified:
1. Revenue Growth (High Severity): Negative average growth rate of -3.5%
2. Performance Consistency (Medium Severity): 45% of periods show declining performance
3. Category Performance (Medium Severity): 4 underperforming categories identified
```

### Step 4: Generate Detailed Recommendations

Consult the business frameworks re