MBA_Analysis

##   InvoiceNo StockCode                         Description Quantity
## 1    536365    85123A  WHITE HANGING HEART T-LIGHT HOLDER        6
## 2    536365     71053                 WHITE METAL LANTERN        6
## 3    536365    84406B      CREAM CUPID HEARTS COAT HANGER        8
## 4    536365    84029G KNITTED UNION FLAG HOT WATER BOTTLE        6
## 5    536365    84029E      RED WOOLLY HOTTIE WHITE HEART.        6
## 6    536365     22752        SET 7 BABUSHKA NESTING BOXES        2
##        InvoiceDate UnitPrice CustomerID        Country
## 1 01-12-2010 08:26      2.55      17850 United Kingdom
## 2 01-12-2010 08:26      3.39      17850 United Kingdom
## 3 01-12-2010 08:26      2.75      17850 United Kingdom
## 4 01-12-2010 08:26      3.39      17850 United Kingdom
## 5 01-12-2010 08:26      3.39      17850 United Kingdom
## 6 01-12-2010 08:26      7.65      17850 United Kingdom

Data Exploration

Let us explore the data and find some important facts

Most frequently bought products (irrespective of Quantity)

Most bought products (Quantity)

Highest Revenue Generating Products

Monthly Revenue Generation

Most Profitable Customers

Buying patterns of the 10 most profitable customers

Below are the key statistics regaring the purchase behaviour. As we can see, the customers tanking 1,2 and 5 have a more cyclic behaviour. The customer ranking 4 is a frequent purchaser.

CustomerID	price	mean	sd
14646	279489.02	5946.5749	6549.0119
18102	256438.49	9497.7219	9292.0863
17450	187322.17	5676.4294	12824.8189
14911	132458.73	907.2516	937.6916
12415	123725.45	6873.6361	8250.0711
14156	113214.59	2219.8939	3558.6184
17511	88125.38	2670.4661	1919.0160
16684	65892.08	3660.6711	4524.5035
13694	62690.54	1529.0376	1440.9319
15311	59284.19	651.4746	647.8338

Most Profitable Countries

Product Associations

By Top 5 Customers

Customer ID: 14646

##    lhs                                   rhs                                     support confidence     lift
## 1  {72 SWEETHEART FAIRY CAKE CASES}   => {DOLLY GIRL LUNCH BOX}                0.1038961          1 4.052632
## 2  {72 SWEETHEART FAIRY CAKE CASES}   => {SPACEBOY LUNCH BOX }                 0.1038961          1 3.080000
## 3  {PACK OF 60 SPACEBOY CAKE CASES}   => {ROUND SNACK BOXES SET OF4 WOODLAND } 0.1168831          1 3.208333
## 4  {PACK OF 60 MUSHROOM CAKE CASES}   => {SPACEBOY BIRTHDAY CARD}              0.1038961          1 4.812500
## 5  {LUNCH BAG SPACEBOY DESIGN }       => {ROUND SNACK BOXES SET OF4 WOODLAND } 0.1168831          1 3.208333
## 6  {LUNCH BAG PINK POLKADOT}          => {ROUND SNACK BOXES SET OF4 WOODLAND } 0.1038961          1 3.208333
## 7  {FOOD CONTAINER SET 3 LOVE HEART } => {STRAWBERRY LUNCH BOX WITH CUTLERY}   0.1038961          1 5.500000
## 8  {PLASTERS IN TIN WOODLAND ANIMALS} => {ROUND SNACK BOXES SET OF4 WOODLAND } 0.1298701          1 3.208333
## 9  {PLASTERS IN TIN SPACEBOY}         => {ROUND SNACK BOXES SET OF4 WOODLAND } 0.1558442          1 3.208333
## 10 {DOLLY GIRL LUNCH BOX}             => {SPACEBOY LUNCH BOX }                 0.2467532          1 3.080000

Customer ID: 18102

##    lhs                                   rhs                                   support confidence     lift
## 1  {VINTAGE UNION JACK MEMOBOARD}     => {CREAM HEART CARD HOLDER}           0.1129032          1 2.818182
## 2  {MEMO BOARD RETROSPOT  DESIGN}     => {WOOD BLACK BOARD ANT WHITE FINISH} 0.1290323          1 3.263158
## 3  {MEMO BOARD RETROSPOT  DESIGN}     => {CREAM HEART CARD HOLDER}           0.1290323          1 2.818182
## 4  {3 HOOK PHOTO SHELF ANTIQUE WHITE} => {SMALL ZINC HEART WALL ORGANISER}   0.1129032          1 6.888889
## 5  {3 HOOK PHOTO SHELF ANTIQUE WHITE} => {BLACK HEART CARD HOLDER}           0.1129032          1 3.875000
## 6  {3 HOOK PHOTO SHELF ANTIQUE WHITE} => {WOOD BLACK BOARD ANT WHITE FINISH} 0.1129032          1 3.263158
## 7  {3 HOOK PHOTO SHELF ANTIQUE WHITE} => {CREAM HEART CARD HOLDER}           0.1129032          1 2.818182
## 8  {SMALL ZINC HEART WALL ORGANISER}  => {BLACK HEART CARD HOLDER}           0.1451613          1 3.875000
## 9  {SMALL ZINC HEART WALL ORGANISER}  => {WOOD BLACK BOARD ANT WHITE FINISH} 0.1451613          1 3.263158
## 10 {SMALL ZINC HEART WALL ORGANISER}  => {CREAM HEART CARD HOLDER}           0.1451613          1 2.818182

Customer ID: 17450

##    lhs                                     rhs                                    support confidence     lift
## 1  {RED HANGING HEART T-LIGHT HOLDER}   => {HEART OF WICKER LARGE}              0.1272727  0.8750000 4.375000
## 2  {RED HANGING HEART T-LIGHT HOLDER}   => {HEART OF WICKER SMALL}              0.1272727  0.8750000 4.812500
## 3  {RED HANGING HEART T-LIGHT HOLDER}   => {WHITE HANGING HEART T-LIGHT HOLDER} 0.1454545  1.0000000 6.111111
## 4  {RED HANGING HEART T-LIGHT HOLDER}   => {WASHROOM METAL SIGN}                0.1090909  0.7500000 4.583333
## 5  {HEART OF WICKER LARGE}              => {HEART OF WICKER SMALL}              0.1636364  0.8181818 4.500000
## 6  {WHITE HANGING HEART T-LIGHT HOLDER} => {HEART OF WICKER LARGE}              0.1272727  0.7777778 3.888889
## 7  {WHITE HANGING HEART T-LIGHT HOLDER} => {HEART OF WICKER SMALL}              0.1272727  0.7777778 4.277778
## 8  {WHITE HANGING HEART T-LIGHT HOLDER} => {WASHROOM METAL SIGN}                0.1272727  0.7777778 4.753086
## 9  {WASHROOM METAL SIGN}                => {LAUNDRY 15C METAL SIGN}             0.1272727  0.7777778 4.753086
## 10 {BATHROOM METAL SIGN}                => {GIN + TONIC DIET METAL SIGN}        0.1090909  0.7500000 4.583333

Customer ID: 14911

##    lhs                                  rhs                                   support confidence      lift
## 1  {REGENCY TEA PLATE GREEN }        => {REGENCY TEA PLATE ROSES }         0.07661290  1.0000000 10.782609
## 2  {REGENCY MILK JUG PINK }          => {REGENCY SUGAR BOWL GREEN}         0.07258065  0.9000000  9.300000
## 3  {REGENCY SUGAR BOWL GREEN}        => {ROSES REGENCY TEACUP AND SAUCER } 0.07661290  0.7916667  5.453704
## 4  {REGENCY SUGAR BOWL GREEN}        => {REGENCY CAKESTAND 3 TIER}         0.07661290  0.7916667  3.569697
## 5  {REGENCY TEA PLATE ROSES }        => {ROSES REGENCY TEACUP AND SAUCER } 0.07661290  0.8260870  5.690821
## 6  {REGENCY TEA PLATE ROSES }        => {REGENCY CAKESTAND 3 TIER}         0.07661290  0.8260870  3.724901
## 7  {PINK REGENCY TEACUP AND SAUCER}  => {GREEN REGENCY TEACUP AND SAUCER}  0.10080645  0.8928571  7.380952
## 8  {PINK REGENCY TEACUP AND SAUCER}  => {ROSES REGENCY TEACUP AND SAUCER } 0.10887097  0.9642857  6.642857
## 9  {PINK REGENCY TEACUP AND SAUCER}  => {REGENCY CAKESTAND 3 TIER}         0.08467742  0.7500000  3.381818
## 10 {GREEN REGENCY TEACUP AND SAUCER} => {ROSES REGENCY TEACUP AND SAUCER } 0.11290323  0.9333333  6.429630

Customer ID: 12415

##    lhs                                rhs                                   support confidence     lift
## 1  {CIRCUS PARADE LUNCH BOX }      => {SPACEBOY LUNCH BOX }               0.1923077  1.0000000 4.333333
## 2  {CIRCUS PARADE LUNCH BOX }      => {DOLLY GIRL LUNCH BOX}              0.1923077  1.0000000 4.333333
## 3  {MINI PAINT SET VINTAGE }       => {SET OF 3 CAKE TINS PANTRY DESIGN } 0.1923077  0.8333333 3.611111
## 4  {36 PENCILS TUBE RED RETROSPOT} => {RED RETROSPOT CAKE STAND}          0.1923077  1.0000000 5.200000
## 5  {36 PENCILS TUBE RED RETROSPOT} => {SET OF 3 CAKE TINS PANTRY DESIGN } 0.1923077  1.0000000 4.333333
## 6  {RED RETROSPOT CAKE STAND}      => {SET OF 3 CAKE TINS PANTRY DESIGN } 0.1923077  1.0000000 4.333333
## 7  {REGENCY CAKESTAND 3 TIER}      => {SPACEBOY LUNCH BOX }               0.1923077  1.0000000 4.333333
## 8  {REGENCY CAKESTAND 3 TIER}      => {DOLLY GIRL LUNCH BOX}              0.1923077  1.0000000 4.333333
## 9  {REGENCY CAKESTAND 3 TIER}      => {ROSES REGENCY TEACUP AND SAUCER }  0.1923077  1.0000000 4.333333
## 10 {SPACEBOY LUNCH BOX }           => {DOLLY GIRL LUNCH BOX}              0.2307692  1.0000000 4.333333

By Months

Month: 1

##    lhs                                      rhs                                      support confidence     lift
## 1  {BAKING SET SPACEBOY DESIGN}          => {BAKING SET 9 PIECE RETROSPOT }       0.02426343  0.8484848 13.35207
## 2  {PINK REGENCY TEACUP AND SAUCER}      => {GREEN REGENCY TEACUP AND SAUCER}     0.02021953  0.8045977 28.13654
## 3  {WOODEN TREE CHRISTMAS SCANDINAVIAN}  => {WOODEN STAR CHRISTMAS SCANDINAVIAN}  0.03870595  0.8815789 12.55978
## 4  {WOODEN HEART CHRISTMAS SCANDINAVIAN} => {WOODEN STAR CHRISTMAS SCANDINAVIAN}  0.05459272  0.8289474 11.80994
## 5  {CHRISTMAS CRAFT TREE TOP ANGEL,                                                                             
##     CHRISTMAS CRAFT WHITE FAIRY }        => {CHRISTMAS CRAFT LITTLE FRIENDS}      0.01848642  0.8311688 14.83251
## 6  {SET OF 3 WOODEN SLEIGH DECORATIONS,                                                                         
##     SET OF 3 WOODEN TREE DECORATIONS}    => {SET OF 3 WOODEN STOCKING DECORATION} 0.01993068  0.8313253 23.98373
## 7  {SET OF 3 WOODEN STOCKING DECORATION,                                                                        
##     SET OF 3 WOODEN TREE DECORATIONS}    => {SET OF 3 WOODEN HEART DECORATIONS}   0.02166378  0.8333333 20.17483
## 8  {SET OF 3 WOODEN HEART DECORATIONS,                                                                          
##     SET OF 3 WOODEN SLEIGH DECORATIONS}  => {SET OF 3 WOODEN TREE DECORATIONS}    0.01819757  0.8400000 24.85538
## 9  {SET OF 3 WOODEN HEART DECORATIONS,                                                                          
##     SET OF 3 WOODEN SLEIGH DECORATIONS}  => {SET OF 3 WOODEN STOCKING DECORATION} 0.01848642  0.8533333 24.61867
## 10 {JUMBO BAG PAISLEY PARK,                                                                                     
##     JUMBO BAG VINTAGE CHRISTMAS }        => {JUMBO BAG 50'S CHRISTMAS }           0.01848642  0.8421053 10.87824

Month: 12

##    lhs                                    rhs                                  support confidence      lift
## 1  {ALARM CLOCK BAKELIKE ORANGE}       => {ALARM CLOCK BAKELIKE GREEN}      0.01677632  0.8644068 16.631624
## 2  {POPPY'S PLAYHOUSE LIVINGROOM }     => {POPPY'S PLAYHOUSE BEDROOM }      0.01677632  0.8095238 30.761905
## 3  {LARGE POPCORN HOLDER }             => {SMALL POPCORN HOLDER}            0.01973684  0.8333333 20.105820
## 4  {ALARM CLOCK BAKELIKE IVORY,                                                                            
##     ALARM CLOCK BAKELIKE RED }         => {ALARM CLOCK BAKELIKE GREEN}      0.01677632  0.8644068 16.631624
## 5  {ALARM CLOCK BAKELIKE PINK,                                                                             
##     ALARM CLOCK BAKELIKE RED }         => {ALARM CLOCK BAKELIKE GREEN}      0.01710526  0.8253968 15.881053
## 6  {ALARM CLOCK BAKELIKE RED ,                                                                             
##     PAPER CHAIN KIT 50'S CHRISTMAS }   => {ALARM CLOCK BAKELIKE GREEN}      0.01611842  0.9074074 17.458978
## 7  {HOT WATER BOTTLE I AM SO POORLY,                                                                       
##     RETROSPOT HEART HOT WATER BOTTLE}  => {CHOCOLATE HOT WATER BOTTLE}      0.01710526  0.8125000 11.488372
## 8  {HOT WATER BOTTLE I AM SO POORLY,                                                                       
##     SCOTTIE DOG HOT WATER BOTTLE}      => {CHOCOLATE HOT WATER BOTTLE}      0.02138158  0.8666667 12.254264
## 9  {REGENCY CAKESTAND 3 TIER,                                                                              
##     ROSES REGENCY TEACUP AND SAUCER }  => {GREEN REGENCY TEACUP AND SAUCER} 0.01611842  0.8305085 24.752409
## 10 {ALARM CLOCK BAKELIKE GREEN,                                                                            
##     PAPER CHAIN KIT VINTAGE CHRISTMAS} => {PAPER CHAIN KIT 50'S CHRISTMAS } 0.01611842  0.9074074  9.816792

Month: 10

##    lhs                                   rhs                                      support confidence     lift
## 1  {FELTCRAFT PRINCESS OLIVIA DOLL}   => {FELTCRAFT PRINCESS LOLA DOLL}        0.01516875  0.8000000 32.96250
## 2  {ROLL WRAP 50'S RED CHRISTMAS }    => {ROLL WRAP 50'S CHRISTMAS}            0.02085703  0.8730159 23.02143
## 3  {JUMBO BAG STRAWBERRY}             => {JUMBO BAG RED RETROSPOT}             0.01934016  0.7500000 10.03934
## 4  {REGENCY TEA PLATE GREEN }         => {REGENCY TEA PLATE ROSES }            0.01668563  0.8148148 36.41808
## 5  {REGENCY TEA PLATE GREEN }         => {GREEN REGENCY TEACUP AND SAUCER}     0.01592719  0.7777778 26.98684
## 6  {PINK REGENCY TEACUP AND SAUCER}   => {GREEN REGENCY TEACUP AND SAUCER}     0.02009860  0.8030303 27.86304
## 7  {PINK REGENCY TEACUP AND SAUCER}   => {ROSES REGENCY TEACUP AND SAUCER }    0.02085703  0.8333333 23.37766
## 8  {SET OF 3 WOODEN TREE DECORATIONS} => {SET OF 3 WOODEN STOCKING DECORATION} 0.02313235  0.8026316 23.78134
## 9  {SET OF 3 WOODEN TREE DECORATIONS} => {SET OF 3 WOODEN HEART DECORATIONS}   0.02199469  0.7631579 17.96828
## 10 {REGENCY TEA PLATE ROSES }         => {ROSES REGENCY TEACUP AND SAUCER }    0.01706485  0.7627119 21.39650

MBA_Analysis

Nithya

22 July 2016

Data Exploration

Product Associations

By Top 5 Customers

By Months