business-analytics-reporter

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:

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:

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