Capstone Project: Marketing and Retail Analytics

Capstone Project: Marketing and Retail Analytics.

Agenda. Problem Definition Visualization of Charts Insights Recommendations.

Problem Definition. 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. Need to identify top products that contribute to the revenue and also use market basket analysis to analyze the purchase behavior of individual customers to estimate with relative certainty, what items are more likely to be purchased individually or in combination with some other products..

Visualization of Charts. 2/21/2023. 4. Distinct count of Order ld 99a4788cb2485696. aca2eb7dOOea1a7b8 422879e10f466829. dlc427060aOf73f6b. 389d119b48cf3043d. 53b36df67ebb7c415w 368c6c730842d780. 53759a2ecddad2bb. 154e7e31ebfa09220. 2b4609f8948be188. 3dd2a17168ec895c7 7c1bd920dbdf22470. eOd64dcfaa3b6db5c. 5a848e4ab52fd5445. bb50f2e236e5eea01. a62e25e09e05e6fafr 42a2c92a0979a949c- 02930027948861_ e53e557d5a159f5aa. 35afc973633aaeb6bn.

Visualization of Charts. 2/21/2023. 5. Toys category has the highest revenue generation which is of 63,885.

Visualization of Charts. 2/21/2023. 6. product id (Products) bb50f2e236e5eeaO.. dic427060aOf73f6b.. 6cdd53843498f928.. 99a4788cb2485696.. 3dd2a17168ec895c.. d6160fb7873f1840.. aca2eb7dooea1a7b.. 5f504b3a1c75b73d.. 25c38557cf793876c.. 53b36df67ebb7c41.. eOd64dcfaa3b6db5c.. 422879e10f466829.. fic7f353075ce59d8.. d285360f29ac7fd97.. 7a10781637204d8d.. f819fOc84a64f02d3.. 588531f8ec37e7d5f.. 389d119b48cf3043.. 368c6c730842d780.. a62e25e09e05e6faf.. % of Total Fl (Products) al.. 4.12% 6.51% 1.39% 0.00% 1.37% 3.13% 9.61% 4.11% 1.55% 0.76% 2.52% 9.29% % of Total REVENUE alon.. 8.35% 7 _ 32% 7.19% 6.19% 5.87% 5.18% 5.00% 4.36% 4.25% 4.11% 4.04% 3.70% 3.61% 3.47% 3.44% REVENUE PARETO CHART REVENUE 67.258 58,957 57.934 49,908 47,876 47.314 44,198 41,726 40.312 39,713 35.162 34,201 33,087 32.509 32,329 29.846 29.080 28 , 544 27.984 27 , 743.

Visualization of Charts. 2/21/2023. 7. Categories Ordered More than 5 times product categor.. toys bed bath table sports_leisure furniture decor health _ beauty housewares auto computers _ accessor. _ watches _ gifts telephony baby stationery perfumery fashion_bags_acces.. cool stuff garden_tools pet_shop electronics luggage _ accessories office furniture construction tools home_appliances consoles _ games 789 687 631 • 425 • 286 236 1 212 1 1 185 1 1 155 197 189 0K 2K 4K 6K 8K 10K 12K 14 16K 18K 20K 22K 24K 24,895 26K 28K Count of Product ld F-.

Visualization of Charts. 2/21/2023. 8. toys toys toys bed_bath_table toys 770 auto toys toys toys Product Category Association toys toys toys toys bed bath table 770 toys.

Visualization of Charts. 2/21/2023. 9.

Insights. The product category “Toys” institutes 20% of the product which generates around 80% of the revenue. Bed_bath_table, sports_leisure, furniture_decor and health_beauty are the product categories which are ordered atleast 5 times and having high order quantity. Combination of above categories with toys and each other are frequently ordered. It is observed that even the price of the certain products is high, it is still bought by customer more often..

Recommendations. Customers purchasing frequently should be provided with some exclusive offers and benefits to them. Company should put some good offers and discounts to attract more customers . Customers who are more towards buying toys should be targeted. Customers who are parents of newly born should be focused more by company. It is observed that even the price of the certain products is high, it is still bought by customer more often..

Thank you. Anil S.