The dataset (Retail.xlsx) contains anonymised weekly sales data for 45 stores of a retail corporation that operates a chain of hypermarkets, discount stores and neighborhood stores. The data is available from the week of 11/11/2011 to the week of 26/10/2012. The stores offer five types of markdowns or discounts throughout the period of one-year.
There were four holiday weeks – 25/11/2011, 30/12/2011, 10/02/2012, 07/09/2012 in this one-year period.
There are three tabs in the Retail.xlsx excel file – Stores, Sales, and MarkDowns. Relevant information about the columns in these tabs is given below:
Stores tab:
- Store - the store number
- Type - the type of store (A - hypermarket, B – discount store, C – neighbourhood store)
- Size - the size of store (in square feet)
Sales tab:
- Store - the store number
- Dept - the department number
- Date - the week (in dd-mm-yyyy format)
- Weekly_Sales - net weekly sales for the given department in the given store
- IsHoliday - whether the week is a holiday week or not
MarkDowns tab:
- Store - the store number
- Date - the week (in dd-mm-yyyy format)
- MarkDown1-5 - five different promotional markdown or discount types. Data in these five columns correspond to absolute markdown values. Markdown rates i.e., discount percentages are not given. Also, these markdown values are not available for all stores at all time. Any missing value is marked with a 0
- IsHoliday - whether the week is a holiday week
A Tableau dashboard is created that can help analyse the sales patterns across stores and their departments.
The dashboard consists of two controls that will work across entrie dashboard:
- A Month,Year filter
- A user control to select either one of the five markdowns or total markdown
The dashboard consists of three visualisations-
- a dual-axis visualization showing sales & markdowns by week
- sales during holiday weeks should be colored differently from sales during non-holiday weeks
- a dual-axis visualization showing sales & markdowns by store
- a visualization showing top five departments by sales within each store
A sample view of the Tableau dashboard for Retail Stores analysis