UpGrad Capstone Project Marketing & Retail Analytics

UpGrad Capstone Project Marketing & Retail Analytics.

Problem Statement. OList is an 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..

Chart, bar chart Description automatically generated.

Chart, bar chart Description automatically generated.

Chart, bar chart Description automatically generated.

Chart, histogram Description automatically generated.

Table Description automatically generated.

Insights. The Product Category ‘ toys ’ is the most ordered product as well as it contributes to most of the Revenue. After toys, bed_bath_table and is the most ordered Product category whereas in terms of revenue, health_beauty is the most revenue generating Product category. This implies that there are Product categories that are ordered less but contributes more revenue and people tend to buy branded or costly products if they like them or used to the product. Along with toys customers are also buying bed_bath_table product category more frequently..

Recommendations. The company should give attractive offers to customers who frequently purchase products to retain them . The company should start loyalty program for frequent customers. Target customers with newborn or kids as they tend to buy bed_bath_table along with toys. Create combos and sell at customized prices including discounts on combos as this would significantly increase the sales..