capstone sougata (1)

UpGrad Capstone Project Marketing & Retail Analytics By Sougata Saha.

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..

Product Category Name Product ld aca2eb7dOOea1a758e.. toys 99a47S8cb248SS9SSco toys 422S7SeiOf466S2SSO„ toys 389d119b48cf3043d3m toys 368csc730842d78016n garden_tools S37S9a2eceead2Sb87- toys dic4270SOaOf73f6b8S.. computers _ accessories S3i3Sdf67ebb7c4iSS- watches _ gifts 1S4e7e31ebfa092203. . hea lth_beauty toys 2b4S09f8948Se18874_ health_Seauty 7c1bd920dbdf22470b„ health _ beauty a62e2SeOSeOSeSfaf31-. toys Sa848e4aSS2fdS44Scd. . toys bbSOf2e236eSeea0100- toys toys eS3eSS7dSa1SSfS„2c.. toys 42a2cS2a0979a94Sca_ toys bS32349fe4SS38fbc7b. toys 3Safc973633aaeb6S87- toys Top 20 Products ( By Quantity) 281 274 260 231 o so 100 ISO 200 250 300 392 373 343 323 3SO 4SO 527 sso Count of Product ld for each Product Category Name broken down by Product ld. keeps 20 of 32,9S1 members. Count of Product ld The marks are labeled by count of Product ld. The view is filtered on Product ld, which.

Top 20 Products (By Revenue) Product ld bbSOf2e23SeSeea0100- dic42706CaOf73f6bS8.. 6cddS3843498f928SO_ 99a4788cb248S696Scm 3dd2a17Z68ec8SSc78n d6160fb7873f18409Sd. aca2eS7COOea1a7b8e.. SfS04b3a1c7Sb73dS1„ S3b3Sdf67ebb7c41SS- 2Sc3SSS7cf793S76cSa„ 422879e10f4S6829SO- eOd64Ccfaa3b6CSScS4.. fic7f3S307SceSSdSa6- d28S3SOf2Sac7fdS764.. 7ai07S1637204dSd10m 389d1iSS48cf3043d3. 368cSc730842d780ZS. f819fOc84a64f02d3aS. SSSS31fSec37e7dSffS. Product Category Name toys computers_accessories toys toys toys toys toys cool_stuff watches_gifts toys toys toys toys toys toys toys toys garden_tools toys toys 0K 10K ISK 20K 30K 47,963 47,314 44,297 41,886 40,743 40,541 38,0S3 36,1SS 33,245 32,760 32,671 32,28S 31.086 3SK 40K Payment Value SSK 60,948 58,226 S7,oss 60K 67,706 70K 7SK Sum of Payment Value for each Product Category Name broken down by Product ld. The marks are labeled by sum of Payment Value. The view is filtered on Product ld and sum of Payment Value. The Product ld filter keeps 20 of 32,952 members. The sum of Payment Value filter keeps non-Null values only..

Top 20 Product Categories (by Quantity) Product Category Name toys snrts_leisure furniture_decor health—beauty 2.04% 1.99% housewares auto 1.54% computers_accessories i. watches_gifts 2.06% telephony 0.90% | 0.78% stationery 0.74% perfumery | 0.71% | 0.67% cool-stuff | garden—tools o.s8% pet_shop | 0.54% electronics 0.49% office—furniture | 0.31% | 0.30% 0K 2K 4K 10K 12K 14K 16K 18K 20K 22K 24K 78.47% 26K Distinct count Of Product ld for each Product Category Name. Product Category Name, which keeps 20 of 70 members. Distinct count of Product ld The marks are labeled by % Of Total Distinct count Of Product ld (Products!Cleaned). The view is filtered on.

Top 20 Product Categories (by Revenue) Product Category Name toys health-beauty 245% 212% watches_gifts computers_accessories sports_leisure 1.67% furniture_decor cool_stuff 1.44% 1.3S% housewares auto I.IS% office_furniture 0.94% garden_t0015 0.90% | 0.76% perfumery | 0.71% telephony | 0.64% pet_shop 0.48% Stationery 0.48% computers | 0.39% small_appliances 0.37% electronics | 0.33% 0M 2M 3M SM 7M Payment Value 8M 10M 12M 13M Sum of Payment Value for each Product Category Name. of 71 members. The marks are labeled by % of Total Payment Velue. The view is filtered on Product Category Name, which keeps 20.

MARKET BASKET ANALYSIS Order ld oa 77b 770428bccbea7f9dbf8aecSd6ae Icaa92d82c1bOdec18bef12da3fa77S6 OObcee890ebaS7a9767c7bSca12d3a1b 02cdfOf2bOS84S468fdfOc10ae24ae17 03ecec24S220b63fd7f68c1737ba99ba 04a2b4ee7fcf9fa8bf2Sb8dSbc7701S2 04b7738adSfbb213eeb7a214Sbea8242 OSc163d46637e5cOc23a007Sdc1c854c OSe1843fbS76fbOai8a1e9bdfa3c18bO 91beS1c8S6a90d7efe86cf9d082d6ae3 Oi3a98b3a668bcefOSb98898177f6923 017dcb6892d4469a13dee3af241f8c4e 034afd1b074e3Sa1d1dcf70c4aS641bS 034bc91b27dOde97e2ffa04946137764 03Sda4996S6c96f8f1cf920ddS7ddc49 063f237Secf74934dOSe78a476f92cbS 0268c7S309d10Sbb28b7S23fS7f46a69 0307d42d9c781d32f86edf1faSc8670b 0343fa2096b6d04743321f9b9f62c1eO 0362e923f80Sae4dceS8fd78c86c96c4 0446b999eS7cddf002396ed4baa07074 Product Category Name bed _bath_ta51e furniture_decor electronics toy S computers_accessories stationery toys rfu mery toys toy 5 musical_instruments toys telephony toys toys cine_phOtO telephony toys toys toys •.•u atches_gifts toy S telephony toys cost _ toys toys coo _ stuff 5p0rts_Iei5ure housewares toys garden 2 2 2 1 2 2 2 1.

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..