Xmas Sales Dashboard

🔍 Key Insights from My Report on Xmas Sales & Trends Analysis:

1️⃣ Overall Sales Performance:

Xmas sales experienced a 7.23% YoY growth, reaching an impressive $274K, compared to $256K last year.

Quantity sold increased by 4.12%, indicating stronger demand for products during the Xmas period.

2️⃣ Shipping Trends:

During Xmas, Express (33.05%) and Overnight (35.36%) shipping options were highly favored over Standard (31.59%), showcasing customer urgency.

3️⃣ Top Performing Locations:

Ontario and British Columbia consistently led in sales, with average Xmas sales at $84K, while Nunavut showed the least activity.

Regional sales growth aligned closely with targeted Xmas promotions.

4️⃣ Product Category Winners:

Toys topped the charts with a 17.42% growth and $326K in net sales, followed by strong performances in Decorations (14.19%) and Electronics (1.10%).

Food sales dipped slightly by 1.70%, potentially due to shifting holiday preferences.

5️⃣ Customer Demographics:

The 41-50 age group made the most purchases, followed by the 31-40 group, indicating a key target audience for Xmas campaigns.

Gender-wise, male customers (33.67%) led purchases slightly over females and others.

6️⃣ Customer Preferences:

Gift-wrapping was included in 26% of orders, underscoring the importance of offering this seasonal service.

Events like Black Friday contributed significantly to sales, with higher average spending during these events.

7️⃣ Peak Shopping Times:

Sales peaked during weekdays in the afternoon, with noticeable spikes between 12 PM and 4 PM, offering valuable insights for targeted marketing.

8️⃣ Satisfaction and Delivery Times:

Customer satisfaction remained high (avg. 3.0/3.0) across categories like Toys, Electronics, and Food, reflecting well-managed delivery and quality services.