AdventureWorks Global Sales & Customer Insights Dashboard

Key Insights

YTD Performance Summary (2022)

1. Total Orders: 12K – slightly below target, showing a mid-year dip followed by recovery.
2. Total Revenue: $9.2M – consistently below target throughout the year.
3. Total Profit: $3.9M – missed target most months, with a sharp drop mid-year and partial recovery toward year-end.

Performance by Continent

→ Pacific region delivers the highest revenue ($9.7M) despite lowest order volume → highest average order value.

→ North America leads in volume (11.7K orders) and profit ($4.12M).

→ Europe lags in both revenue and profit relative to its order count. Customer Segmentation: Orders, Revenue & Profit by Annual Income and Gender

1. Peak purchasing activity (orders, revenue, and profit) occurs in the $30K–$80K annual income range across both genders.
2. Male customers consistently outperform female customers in volume and value across almost all income brackets.
3. Highest profit contribution comes from male customers earning $50K–$80K.
4. Very low activity above $150K income and minimal contribution from “Not Available” gender/income segments.

Key Takeaways

1. Overall performance in 2022 remained below target in revenue and profit, driven largely by a weak mid-year period.
2. Pacific region is the most profitable per order – opportunity for pricing optimization or upselling.
3. North America remains the volume and profit engine and should continue to receive strong marketing/sales focus.
4. Core customer sweet spot is middle-income males ($30K–$80K) – tailor promotions, product bundles, and loyalty programs to this segment.
5. Limited penetration in high-income segments (> $150K) – potential for premium product lines or targeted campaigns.

Recommended Actions

1. Investigate and address the mid-year slump (supply chain, marketing, or seasonality issues).
2. Replicate Pacific region’s high AOV strategies in North America and Europe.
3. Increase focus on middle-income male segment with personalized offers.
4. Explore premium offerings to capture untapped high-income customers.

The dashboard is designed using Flexa Design, Flexa Tables, and Flexa Charts from Flexa Intel.