All skills
ailabs-393 avatar

/business-analytics-reporter

@7d5342d

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.

Use this Skill: https://skilld.dev/gh/ailabs-393/ai-labs-claude-skills/business-analytics-reporter

This session only. Nothing lands on disk.

referencesbusiness_frameworks.md

≈1.6k tokens on demand. Your agent reads this file only when SKILL.md points to it.

Business Analysis Frameworks and Metrics

Key Business Metrics for Sales & Revenue Analysis

Revenue Metrics

  • Total Revenue: Sum of all sales over a period
  • Average Revenue Per Unit (ARPU): Total revenue / Number of customers or units
  • Revenue Growth Rate: ((Current Period Revenue - Previous Period Revenue) / Previous Period Revenue) × 100
  • Month-over-Month (MoM) Growth: Short-term growth trend
  • Year-over-Year (YoY) Growth: Long-term growth comparison

Performance Indicators

  • Sales Velocity: Rate at which deals move through the pipeline
  • Conversion Rate: (Successful conversions / Total opportunities) × 100
  • Average Order Value (AOV): Total revenue / Number of orders
  • Revenue Per Category: Performance breakdown by product/service line

Stability & Risk Metrics

  • Coefficient of Variation (CV): (Standard Deviation / Mean) × 100
    • CV < 25%: Stable performance
    • CV 25-50%: Moderate volatility
    • CV > 50%: High volatility (risk area)
  • Revenue Concentration: Percentage of revenue from top customers/categories
  • Seasonality Index: Measure of seasonal patterns

Business Improvement Frameworks

1. Revenue Growth Strategies

Market Penetration
  • Increase market share in existing markets
  • Aggressive marketing and sales campaigns
  • Competitive pricing strategies
  • Customer acquisition programs
Product Development
  • Launch new products/services
  • Enhance existing offerings
  • Innovation and R&D investment
  • Feature expansion based on customer feedback
Market Development
  • Enter new geographic markets
  • Target new customer segments
  • Expand distribution channels
  • Strategic partnerships
Diversification
  • Add complementary products/services
  • Enter related industries
  • Vertical or horizontal integration
  • Risk mitigation through variety

2. Operational Excellence Framework

Process Optimization
  • Streamline sales processes
  • Reduce cycle times
  • Automate repetitive tasks
  • Eliminate bottlenecks
Resource Allocation
  • Focus on high-performing categories
  • Divest or restructure underperformers
  • Optimize inventory management
  • Strategic capacity planning
Quality Management
  • Improve product/service quality
  • Reduce defect rates
  • Customer satisfaction initiatives
  • Continuous improvement culture

3. Customer-Centric Strategies

Retention & Loyalty
  • Customer loyalty programs
  • Personalized experiences
  • Proactive customer service
  • Regular engagement initiatives
Customer Lifetime Value (CLV) Optimization
  • Increase purchase frequency
  • Upselling and cross-selling
  • Premium tier development
  • Reduce churn rate
Customer Segmentation
  • High-value customer focus
  • Targeted marketing campaigns
  • Customized offerings per segment
  • Resource prioritization

4. Pricing Strategy Framework

Value-Based Pricing
  • Price based on customer perceived value
  • Premium positioning for quality
  • Bundle offerings for value perception
Dynamic Pricing
  • Adjust prices based on demand
  • Seasonal pricing strategies
  • Promotional pricing tactics
Competitive Pricing
  • Market rate alignment
  • Penetration pricing for new markets
  • Price leadership strategy

5. Data-Driven Decision Making

Analytics Maturity Model
  1. Descriptive: What happened? (Historical reporting)
  2. Diagnostic: Why did it happen? (Root cause analysis)
  3. Predictive: What will happen? (Forecasting)
  4. Prescriptive: What should we do? (Recommendations)
Key Performance Indicators (KPI) Framework
  • Leading Indicators: Predict future performance (pipeline, leads)
  • Lagging Indicators: Measure past results (revenue, profit)
  • Balanced Scorecard: Financial, customer, internal process, learning & growth

Common Business Weak Areas and Solutions

Area: Declining Revenue

Symptoms: Negative growth rate, decreasing order volume Root Causes: Market saturation, increased competition, product obsolescence, poor positioning Solutions:

  • Conduct market research to identify opportunities
  • Refresh product offerings
  • Enhance value proposition
  • Improve marketing effectiveness
  • Explore new markets or segments

Area: High Volatility

Symptoms: Inconsistent revenue, unpredictable performance Root Causes: Lack of recurring revenue, seasonal dependency, customer concentration Solutions:

  • Develop subscription or contract-based models
  • Diversify customer base
  • Create counter-seasonal products
  • Build strategic partnerships
  • Implement demand forecasting

Area: Category Underperformance

Symptoms: Low contribution from certain products/categories Root Causes: Poor product-market fit, pricing issues, low awareness, quality problems Solutions:

  • Conduct category review analysis
  • Test price adjustments
  • Invest in targeted marketing
  • Consider product discontinuation
  • Reallocate resources to winners

Area: Low Profit Margins

Symptoms: High revenue but low profitability Root Causes: High costs, pricing pressure, inefficient operations Solutions:

  • Cost optimization initiatives
  • Negotiate better supplier terms
  • Improve operational efficiency
  • Value-based pricing strategy
  • Focus on high-margin segments

Area: Customer Churn

Symptoms: High customer turnover rate Root Causes: Poor customer experience, lack of engagement, competitive alternatives Solutions:

  • Implement customer success programs
  • Regular customer feedback loops
  • Loyalty and retention programs
  • Improve product quality and support
  • Personalized customer engagement

Strategic Recommendation Template

For Each Weak Area Identified:

  1. Current State Assessment

    • What the data shows
    • Severity and business impact
    • Trend direction
  2. Root Cause Analysis

    • Why this weakness exists
    • Contributing factors
    • Internal vs. external causes
  3. Strategic Initiative

    • Named strategy or program
    • Clear objective
    • Expected outcomes
  4. Tactical Actions

    • Specific, actionable steps
    • Prioritized by impact
    • Resource requirements
  5. Success Metrics

    • How to measure improvement
    • Target benchmarks
    • Timeline for results
  6. Implementation Roadmap

    • Phase 1: Quick wins (0-3 months)
    • Phase 2: Medium-term initiatives (3-6 months)
    • Phase 3: Long-term transformation (6-12+ months)

Source: SKILL.md on GitHub

No alerts16d5 checks · Risk SAFE
  • Gen Agent Trust Hub16d

    The skill is a legitimate business analytics tool designed to generate reports and strategic insights from user-provided CSV data. It uses the well-known Plotly library for visualizations and is subject to the standard risks associated with processing untrusted external data files.

  • Socket16d

    No alerts

  • Snyk16d

    Risk: LOW · No issues

  • Runlayer7mo

    3/7 files flagged

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Signed by skilld at 7d5342d. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 months ago.

Dormantupdated 11 months ago
  • csv
  • data-analysis
  • business-analytics
  • sales
  • revenue
  • pandas
  • reporting
  • statistics
  • frameworks

README badge

README badge for ailabs-393/ai-labs-claude-skills/business-analytics-reporter

Analyzes CSV files containing sales and revenue data to identify underperforming segments, calculate statistical metrics like growth rates and volatility, and recommend improvement strategies backed by business frameworks. Use when you need to generate a performance report that pinpoints weak areas and provides actionable strategic initiatives.

Generated from the current SKILL.md.

What data format does this skill expect?
CSV files containing business data with columns like dates, amounts, categories, or products. The skill automatically detects the data structure to identify revenue columns, date columns, and categories.
Does this skill create visualizations?
Visualizations are optional. The skill can generate interactive Plotly charts (revenue trends, category performance, volatility analysis) if requested, but the core workflow focuses on written analysis and recommendations.
What kind of recommendations does this skill provide?
Strategic recommendations tied to identified weak areas, including objective, key actions, expected impact, timeline, and success metrics. Recommendations are grounded in business frameworks like revenue growth strategies, operational excellence, and customer-centric approaches.
Can this skill handle multiple product categories or revenue streams?
Yes. The skill automatically performs category performance analysis, identifies underperforming categories in the bottom 25%, and provides category-specific insights as part of the weak areas detection.
What output formats does this skill support?
The skill generates a structured JSON report from automated analysis, then compiles findings into either HTML (using bundled report template) or markdown format for delivery to the user.

Generated from the current SKILL.md. These answers refresh after source changes.