🎄Christmas Sales and Trends Analysis🎄

Summary

Report submitted for the FP20 Analytics ZoomCharts Challenge, December 2024. The report was built using the Christmas Sales & Trends Dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI.

Author's description:

📊 From the Overview Page:

1. Total Sales: The total sales from 2018-2023 amount to $1.65M, with Christmas sales (Nov-Dec) outperforming non-Christmas periods every year. In 2023, Christmas sales reached an impressive $196,768.
2. Sales Channels: Online shopping has gained popularity each year, surpassing offline sales since 2020. By 2023, 1,339 customers shopped online.
3. Best-Selling Products:
   • During Christmas: The top-selling product is Toys.
   • Non-Christmas Periods: The best-seller is Food.
4. Top Sales Locations:
   • During Christmas: British Columbia leads in sales.
   • Non-Christmas Periods: New Brunswick takes the top spot.
5. Product Returns:
   • During Christmas: Online payments have the highest return rate at 53%.
   • Non-Christmas: Debit card payments also have a return rate of 53%.

🎄 From the Christmas Page:

1. Customer Demographics: Most Christmas customers are men aged 51-60, with the most popular products being Clothing and Toys.
2. Gift Wrapping Usage:
   • Overall: 50.21% of orders during Christmas include gift wrapping.
   • Most Likely to Use: Men aged 31-40.
3. Shipping Methods and Satisfaction:
   • Express: The most popular method, with 2-day delivery being the most satisfying.
   • Overnight: Second most popular, with 1-day delivery being ideal.
   • Standard: Third, with 5-day delivery meeting satisfaction.
4. Discount Usage: Women tend to use discount amounts more than other genders.
5. External Factors Influencing Sales:
   • Highest Sales Weather: Surprisingly, it’s Rainy rather than Snowy.
   • Top Event for Sales: Black Friday.
6. Customer Satisfaction Scores: The highest satisfaction scores are recorded during Sunny weather.