Learning objective
- Ability to perform text, date, math processing
- Ability to perform data operations like filter, merge, pivot, formatting etc.
Overview
Demonstrate your data wrangling skills using Excel to analyze order returns for GlobalMart
Story
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?