Marketing & Retail Analytics Capstone Group Project :-Olist
Scene 1 (0s)
Marketing & Retail Analytics Capstone Group Project :- Olist.
Scene 2 (10s)
Problem Statement:. OList is one such e-commerce company and It has faced some losses recently and they are planning to manage their inventory very well so as to reduce any unnecessary costs that they might be bearing..
Scene 3 (23s)
Objective:. To identify the most ordered products by quantity and revenue . To identify combinations of product categories that are ordered frequently ( Market basket Analysis).
Scene 4 (34s)
Top 20 Ordered Products by Quantity. Toys are the most ordered Product Category quantity-wise.
Scene 5 (43s)
Top 20 Ordered Products by Revenue. In the Revenue-wise Toys are the being most ordered Product Category..
Scene 6 (52s)
Top 20 Products and Running Totals.
Scene 7 (59s)
Quantity Pareto. Pareto Analysis for quantity has been done to identify the Top 20 product category order by quantity.
Scene 8 (1m 8s)
Revenue Pareto. Pareto Analysis for revenue has been done to identify the Top 20 product category responsible for the revenue generation.
Scene 9 (1m 18s)
Pareto Analysis.
Scene 10 (1m 24s)
Product Category Ordered. Depicting the product categories which has been ordered more than 5 times.
Scene 11 (1m 32s)
Market Basket Analysis. Market Basket Analysis showing the different combinations of baskets/ product categories has been ordered along with.
Scene 12 (1m 42s)
Market Basket Summary.
Scene 13 (1m 48s)
Insights:. Toys are the most ordered category and ordered 74,929 times and generating the most of the revenue (Toys category contributes to more than 75% of the total category) Apart from toys category other categories which are ordered frequently are health_ beauty, computers_ accessories, watches_gift , etc. Despite of high cost , the customers prefer to buy the certain products..
Scene 14 (2m 7s)
Recommendations:. Stock Level of those categories which sales frequently and contributes to the maximum revenue should be maintained in the ample quantity in the warehouses. As the toy categories sells the most, the company should keep introducing loyalty benefits and promotional offers to retain the customers. Categories which are not selling much, company should start offering freebies/ gift to cross sell those categories..