Marketing and Retail Analytics
- Varun 2001
- Oct 17, 2022
- 2 min read
In the recent past, e-commerce companies have emerged and flourished in the industry. They offer the convenience to order from a wide variety of options from the comfort of one’s home. But how do they offer these “wide variety of options or products”? To be able to meet the demands of the customers, any e-commerce company would obviously need to store tons and tons of products in warehouses. Now, some of these warehoused products might be fast-moving products which sell very quickly and some others might be slow-moving. Each of the products being stored incurs a cost to the company in terms of space and maintenance. Since storing these products obviously add to the costs that the company incurs, it is absolutely necessary for the organisations to plan their inventory well.
Now, OList is one such e-commerce company that has faced some losses recently and they want to manage their inventory very well so as to reduce any unnecessary costs that they might be bearing. In this assignment, you have to manage the inventory cost of this e-commerce company OList. You need to identify top products that contribute to the revenue and also use market basket analysis to analyse the purchase behaviour of individual customers to estimate with relative certainty, what items are more likely to be purchased individually or in combination with some other products.
Dataset Download :
Project Pipeline :
Data exploration and cleaning: Identify missing and duplicate values in each column and treat them accordingly. Also, treat any and all data quality issues associated with the dataset.
Data visualisation: Create appropriate visualisations to identify the most ordered products by quantity and revenue.
Market basket analysis: Identify combinations of product categories that are ordered frequently and visualise them as required. This can be done by creating a simple matrix with product categories in the rows and columns and then checking which of the pairs show associations.
Dashboarding and final PPT: Create a neat dashboard containing the important visualisations and supplement it with an executive summary containing valuable insights and recommended steps of action.
Exploratory Data Analysis :
Clean Dataset :
Market Basket Analysis Data :
Executive Summary :
Comments