Enqurious logo
Back to scenario

Challenge | Analyzing Order Returns


Learning objective

  • Ability to perform text, date, math processing
  • Ability to perform data operations like filter, merge, pivot, formatting etc.


Demonstrate your data wrangling skills using Excel to analyze order returns for GlobalMart


GlobalMart, a global e-commerce player has been growing steadily for the past few years. 


Although, the supply chain operations of the company has been stable, there is one concern that regularly keeps the Operations team awake : Order Returns. 


Returning an already delivered product is cost to the company. However, for the customer, a hassle free return experience is an important factor which can result in customer staying or attriting. 


You've got order delivery and returns details available in the form of Excel sheets :

  • Order Details :
  • Vendor Details :

  • Return Details :


You are required to answer few key questions posted by the Vendor Operations team at GlobalMart.


How would you go about solving this challenge?