Objective:
Background Comprehension: Learned about the client’s e-commerce business. Explored the E- commerce Business Model, Website Architecture, Website Functionalities, Order initiation Process, Payment process, Order processing, Logistics, and Order closure, etc.
Brainstorming & EDA:Engaged in a brainstorming session to identify potential factors influencing partial or full order cancellations, aiming for guidance. Subsequently, delved into data associated with order initiation, the availability and selection of delivery slots, order processing, products ordered, and the availability of their stock.
Cause and Effect Analysis:Exhaustive analysis was further performed on various factors to understand the shortfalls leading to order cancellations. Elements like trends in canceled orders concerning timing, product types, product inventory, efficiency of the delivery process, and customer support were investigated.
Story Design and Client Communication:A story was meticulously crafted to convey the insights derived from the analysis conducted. Communicated insights drawn from the analysis and recommendations to improve order fulfillment and customer satisfaction.