business-analytics-reporter_skill

Overview

This skill analyzes business sales and revenue CSVs to produce data-driven performance reports that pinpoint weak areas and recommend targeted improvement strategies. It combines statistical metrics, trend detection, and business frameworks to turn raw transaction data into actionable priorities. Reports include clear severity assessments, prioritized initiatives, and optional visualizations for stakeholder presentation.

How this skill works

The skill loads CSV files, inspects structure (dates, revenue, categories), and computes core metrics like growth rates, volatility (CV), and category contributions. It flags underperforming segments and declining periods, maps weaknesses to likely root causes, and generates structured strategic recommendations with actions, timelines, and success metrics. Optionally it creates Plotly charts and compiles results into HTML or Markdown reports.

When to use it

• When you want a clear performance diagnostic from sales or revenue CSVs
• If you need to identify weakest products, categories, or time periods
• When you require prioritized strategic recommendations to improve revenue
• To generate executive-ready reports with metrics and visualizations
• When assessing whether trends indicate systemic problems vs. seasonality

Best practices

• Provide cleaned CSVs with date, revenue/amount, and category/product columns where available
• Specify the time range and any segments to prioritize before analysis
• Request visualizations when communicating with executives or cross-functional teams
• Prioritize recommendations by severity and expected impact in follow-up planning
• Combine the report with industry benchmarks or context for more accurate interpretation

Example use cases

• Analyze quarterly sales CSV to identify declining product lines and recommend recovery actions
• Generate an executive HTML report showing revenue trend, volatility, and 3 high-impact initiatives
• Detect customer-segmentation weaknesses and propose retention and upsell programs
• Review monthly transaction data to propose pricing optimizations and promotional tests
• Deliver a prioritized improvement roadmap after a merger or product launch