Analyzing Walmart Data
Weekly Readings and Videos
What is a Sales Analysis Report? Akers, H. (2019, Mar 6). smallbusiness.chron.com
Goals of Data Analysis. (n.d.). courses.lumenlearning.com
Critical Thinking Skills. (n.d.). courses.lumenlearning.com
Retail Analytics: How to Use Data to Win More Sales and Customers. Nicasio, F. (2020, Dec 20). vendhq.com
Sales Trend Analysis. (2020, Oct 5). accountingtools.com
How to Measure Retail Performance? 5 Essential Metrics. (n.d.). erply.com
The Right vs. the Wrong Key Performance Indicators. (3:47). RareBrain. (2016, Apr 19). YouTube
Instructions
- Review this example Comp Sales Report for a single Walmart store location:
- Use course content and the example Comp Sales Report to complete the following:
- Choose two departments that are under-performing in the YTD vs. Plan column.
- Develop two questions you would ask the managers in these departments to help you understand the performance results
- Identify two internal or external factors you would look at to help you understand the performance results
- Choose two departments that are over-performing in the YTD vs. Plan column.
- Develop two questions you would ask the managers in these departments to help you understand the performance results
- Identify two internal or external factors you would look at to help you understand the performance results
- What customer feedback would be useful to you for understanding the under- and over-performance in these departments (categories)?
- Develop two specific recommendations for the store: one to take advantage of opportunities in the over-performing departments, and one to improve performance in the under-performing departments.
- Choose two departments that are under-performing in the YTD vs. Plan column.