How do I Demand Plan for Holidays?
Using the BDSA Seasonality Dashboard to plan for holiday sales spikes
Key Steps
Access the Seasonality Dashboard 0:00
-
Navigate to the Analyst Suite.
-
Select the Seasonality Dashboard.
-
Click on the Holiday tab to focus on holiday trends.
Analyze Sales Trends 0:26
-
Review the last 13 months of sales data for your specific area (e.g., Illinois).
-
Understand overall seasonality dynamics using the Day of Week and Seasons tab.
Identify Key Holiday Days and Weeks 0:45
-
Compare sales on actual holiday days (e.g., Black Friday, Green Wednesday).
-
Analyze average daily sales for holiday weeks (e.g., week of 420) to prioritize stock and discounts.
Evaluate Sales vs. Non-Holiday Sales 1:21
-
Look at incremental sales increases during holidays compared to non-holidays.
-
For example, during the week of 420, sales were 40% higher than non-holidays.
Assess Discounting Trends 1:47
-
Review discount metrics year by year.
-
Analyze how discounts differ on holidays versus non-holidays (e.g., deeper discounts on 420).
Examine Product Sale Percentages 2:26
-
Check the percentage of products on sale versus not on sale by discount grouping.
-
Understand average discount depths for different holidays.
Review Raw Data by Category 2:50
-
Look at average daily sales by category for each holiday.
-
Use indices to compare holiday sales against non-holiday weeks.
Export Data for Further Analysis 3:25
-
Utilize the export tool to download data for a deeper analysis of trends over time.