What products are performing best/least? What brands are performing best/least?
The Board of Management at ShopLocal is currently reviewing its strategic plan and is interested particularly in finding out:
What products are performing best/least?
What brands are performing best/least?
What categories are performing best/least?
Who are our most loyal customers?
What is the geographical spread of sales?
Which outlets are performing best/least?
Trends over time
Does customer type influence brand selection/ low fat/ recyclable?
Any other unsupervised insights You are provided with a data set that contains sales data for a supermarket chain, ShopLocal. The dataset includes product, customer, sales, returns, store, and category information. You have been requested to design a dashboard to meet these requirements. The dashboard should contain at least three pages: