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:
  • Executive summary
  • Product drill down (self-service)
  • Key insights