All examples for Instant Insights - Conversational Data Analysis

Regional Sales Trends with MoM and YoY Growth

Comprehensive regional performance analysis showing month-over-month changes, year-over-year growth rates, seasonal patterns, and specific recommendations for underperforming regions.

Input

What you provide to the skill

I have a CSV file at /tmp/regional_sales.csv with columns: date, region, product_category, revenue, units_sold, customer_count. How have regional sales trends changed month-over-month with year-over-year growth rates?

Output

What the skill generates for you

==========================================================================================
REGIONAL SALES TRENDS: MONTH-OVER-MONTH & YEAR-OVER-YEAR ANALYSIS

REGIONAL PERFORMANCE SUMMARY (Last 6 Months)

Region Avg Monthly Avg MoM Avg YoY Trend
Revenue Change Growth

West $ 2,237,270 2.4% 15.3% Growth
Northeast $ 2,105,760 2.6% 14.9% Growth
Midwest $ 1,544,809 1.3% 14.8% Growth
Southwest $ 1,466,399 2.2% 17.4% Growth
Southeast $ 1,370,607 2.5% 14.1% Growth

DETAILED MONTHLY TRENDS BY REGION (2024)

Northeast:
Month Revenue MoM Change Units Sold Customers

Jan 2024 $ 2,911,135 +32.1% 25,420 12,034
Feb 2024 $ 3,145,786 +8.1% 29,580 13,049
Mar 2024 $ 3,478,684 +10.6% 31,474 14,534
Apr 2024 $ 3,053,444 -12.2% 28,710 13,521
May 2024 $ 3,069,870 +0.5% 27,827 13,019
Jun 2024 $ 2,386,197 -22.3% 22,794 10,464
Jul 2024 $ 2,296,864 -3.7% 21,201 10,030
Aug 2024 $ 1,943,149 -15.4% 19,102 8,689
Sep 2024 $ 1,741,843 -10.4% 15,374 7,047
Oct 2024 $ 1,876,088 +7.7% 18,010 8,571
Nov 2024 $ 2,135,860 +13.8% 19,371 8,633
Dec 2024 $ 2,640,755 +23.6% 24,134 10,937

==========================================================================================

KEY INSIGHTS & RECOMMENDATIONS

  1. REGIONAL PERFORMANCE RANKINGS:

    • WEST leads with $2.2M avg monthly revenue (H2 2024) and 15.3% YoY growth
    • NORTHEAST second at $2.1M monthly with 14.9% YoY growth
    • SOUTHEAST trailing at $1.4M monthly with 14.1% YoY growth (39% below West)
  2. YEAR-OVER-YEAR GROWTH PATTERNS:

    • All regions showing positive YoY growth (14-17% range)
    • SOUTHWEST highest YoY growth at 17.4% - emerging growth market
    • Consistent growth suggests strong market conditions across all territories
    • West and Northeast maintaining leadership positions year-over-year
  3. MONTH-OVER-MONTH VOLATILITY:

    • Strong seasonal patterns: Q1/Q4 peaks, Q3 summer decline across all regions
    • January shows strongest MoM jumps (+28-40%) recovering from December baseline
    • Summer months (Jun-Sep) experience consistent declines of 10-20% MoM
    • Q4 recovery evident with October showing 6-10% MoM gains accelerating through December
  4. CRITICAL OPPORTUNITIES:

    • SOUTHEAST & SOUTHWEST underperforming by $700K-900K monthly vs top regions
    • Southeast showing most concerning pattern: sustained Q3 decline without full Q4 recovery
    • Bringing underperformers to median would add $43M annually
    • Focus sales resources on product mix and customer acquisition in weak regions
  5. ACTIONABLE RECOMMENDATIONS:

    • Conduct sales audit in Southeast/Southwest to identify root causes of performance gap
    • Replicate West region strategies (product mix, sales tactics) in lagging areas
    • Address Southeast’s structural weakness: customer count 40% below West in peak months
    • Increase marketing investment pre-Q1 to maximize seasonal peak performance
    • Monitor MoM trends closely for early detection of regional declines

==========================================================================================