Retail

Retail Store Analysis

A fashion retailer has four stores and 200 transactions from March. The regional manager asks: which store sells the most, how much comes from weekends, and which category drives each store? Discounts are recorded as percentages, so net sales must be calculated first.

Deliverable: Net sales and weekday/weekend columns, a store table with share, weekend average and biggest sale, totals, a Category × Store PivotTable, data bars and a bar chart.

1. 1Net sales10 pts
2. 2Weekday or weekend10 pts
3. 3Store table20 pts
4. 4Weekend average and biggest sale15 pts
5. 5Totals10 pts
6. 6Category by store15 pts
7. 7Data bars10 pts
8. 8Compare the stores10 pts