Скачать или смотреть Do Holidays Boost Sales? Correlation Analysis in Excel for Retail Decisions

In this video, we answer a critical question for retail revenue planning: whether state holidays consistently increase sales across stores. Using the Rossmann sales dataset, we’ll determine if the holiday effect is strong enough to justify further promotional investment.

You’ll learn how to:
Clean and prepare holiday data in Excel (merging A, B, C into a single holiday flag)
Calculate overall correlation between sales and holidays
Compute store-specific correlations using the CORREL + FILTER functions
Interpret mild, strong, and weak correlations for strategic planning
Translate statistical results into actionable business recommendations for executives

Key takeaway: Even a mild correlation can influence multi-million-dollar budget decisions — but only if you can present it clearly and back it with data.

Dataset: Rossmann Sales Dataset
The dataset is available at Lumen's github repository: https://github.com/digital-munich/lum....

This dataset and guided lessons are part of Lumen’s Data Analytics Program — designed to help you future-proof your tech career, master in-demand data and AI skills, and launch your dream career in just 5 weeks.

Learn more: https://digitalmunich.com/lumen/data-...
Contact us: [email protected]