Clothing Sales Dashboard

Category-wise correlation

HEAVY WINTER JACKET 64 KNITS JACKET -11 -23 CO-ORDINATE -5 -17 -20 KNITS TOP -13 -13 -20 78 FOOTWEAR -1 -11 -21 92 80 T-SHIRT -20 -14 -28 57 67 55 ACCESSORIES -14 -3 14 -17 9 -8 29 TRACK PANT -8 0 17 -2 17 11 3 53 WOVEN JACKET -1 15 -15 23 40 56 13 18 29 SWEAT SHIRT -16 6 -27 12 22 36 43 27 18 55 CAPRI -10 24 -30 3 24 24 38 40 18 56 80 TROUSER -14 1 -22 -1 13 15 39 18 21 28 46 52 LEGGING -16 -1 -22 -3 8 14 58 55 22 36 51 51 57 BARMUDA -18 2 -29 14 13 22 62 45 14 21 52 66 55 79 SHORTS HEAVY WINTER JACKET KNITS JACKET CO-ORDINATE KNITS TOP FOOTWEAR T-SHIRT ACCESSORIES TRACK PANT WOVEN JACKET SWEAT SHIRT CAPRI TROUSER LEGGING BARMUDA SHORTS

This is a clusterplot of the 25-week sales of each category, and shows the correlation between the sales of every pair of categories.

The number in each cell represents the correlation between a pair of categories. For example, on the top left, 13% is the correlation between sales of 'COORDINATE' and 'LEGGING'. Diagonally opposite to that is the scatterplot of COORDINATE AND LEGGING weekly sales. The colour of each cell is based on the degree of correlation. -1 0 1

From this, we observe that two categories of products -- HEAVY WINTER JACKET and KNITS JACKET -- are highly correlated with each other, but negatively correlated with most other products. People come in to buy these, or other products, but rarely both.

Two other groups of categories emerge. For example, T-SHIRT, KNITS TOP, FOOTWEAR, SHORTS and ACCESSORIES are all positively correlated amongst themselves, and form a group. Specifically, T-SHIRT and KNITS TOP have a very high correlation: 96%. Similarly, LEGGING, SWEAT SHIRT, TROUSER, etc are positively correlated. SWEAT SHIRT and TROUSER as a category have a 92% correlation.

The most negatively correlated products are LEGGING and ACCESSORIES, at -47%. HEAVY WINTER JACKET is negatively correlated with every single category except KNITS JACKET.

Season-wise correlation

2009Q1I 2 2011Q1 32 51 2010Q4 21 60 89 2010Q1 25 33 62 85 2009Q1 2 43 44 77 82 2009Q1II -24 8 3 32 45 59 2011Q4 -18 -6 -18 -23 -22 -20 47 2011Q4I 2009Q1I 2011Q1 2010Q4 2010Q1 2009Q1 2009Q1II 2011Q4 2011Q4I

This is a clusterplot of the 25-week sales of each season's catalogue, and shows the correlation between the sales of every pair.

The number in each cell represents the correlation between a pair of season's catalogue. For example, on the top left, 74% is the correlation between sales of 'WINTER 09 - III' and 'WINTER 09 - II'. Diagonally opposite to that is the scatterplot of WINTER 09 - III and WINTER 09 - II weekly sales. The colour of each cell is based on the degree of correlation. -1 0 1

From this, we observe that the SUMMER 11 - I catalogue sales is negatively correlated with every other catalogue over the last 25 weeks. People come in to buy these, or other products, but rarely both.

Two groups of categories emerge. WINTER 11 - I and WINTER 11 - II often sold well together in the last 25 weeks. The WINTER 09 and WINTER 10 catalogues, along with the SUMMARY 10 catalogue, sold well together too. But across these categories, there is a negative correlation.

Channel-wise correlation

ODP 77 FLPCN 84 97 LFD -0 -4 -6 OSF -13 -1 -19 -7 PDS -9 9 3 65 63 OEB 21 31 26 35 59 72 SFL ODP FLPCN LFD OSF PDS OEB SFL

This is a clusterplot of the 25-week sales of each type of channel (the 'REVENUE' column), and shows the correlation between the sales of every pair of channels.

The number in each cell represents the correlation between a pair of channels. For example, on the top left, -2% is the correlation between sales of 'FSO' and 'EBO'. Diagonally opposite to that is the scatterplot of FSO and EBO weekly sales. The colour of each cell is based on the degree of correlation. -1 0 1

From this, we observe that the FSO sales is neutrally or negatively correlated with almost every other channel over the last 25 weeks. The sales of this channel appears mildly counter-cyclic, or at least unaffected, by most other channels.

LFD sales is heavily counter-cyclic to PDS and EBO sales, but highly correlated with LFS, LPCNF and PDO sales. In general, when PDO, LPCNF or LFD sales increases, EBO and PDS sales dips a bit, and vice versa.

Sub-Category-wise sales by Revenue

FLPCN sold 10 qty of BAGS FLPCN sold nan qty of BARMUDA ELASTICATED FLPCN sold nan qty of BELT FLPCN sold nan qty of BOTTLE FLPCN sold nan qty of CAPRI ELASTICATED FLPCN sold 4 qty of CAPS FLPCN sold nan qty of CO-ORDINATE 2 PIECE FLPCN sold 20 qty of FLIP FLOP FLPCN sold nan qty of FOOT BALL FLPCN sold nan qty of HEADBAND FLPCN sold nan qty of HEAVY WINTER JACKET FULL SLEEVES FLPCN sold nan qty of HEAVY WINTER JACKET SLEEVE LESS FLPCN sold nan qty of KNITS JACKET FULL SLEEVES FLPCN sold nan qty of KNITS TOP CAP SLEEVES FLPCN sold nan qty of KNITS TOP FULL SLEEVES FLPCN sold 800 qty of KNITS TOP HALF SLEEVES FLPCN sold 30 qty of KNITS TOP SLEEVE LESS FLPCN sold nan qty of LEGGING FLPCN sold 71 qty of SANDALS FLPCN sold 92 qty of SHOES FLPCN sold 9 qty of SHORTS ELASTICATED FLPCN sold nan qty of SOCKS FLPCN sold nan qty of SWEAT PANT FLPCN sold 0 qty of SWEAT SHIRT FULL SLEEVES FLPCN sold nan qty of SWEATSHIRT HALF SLEEVES FLPCN sold nan qty of T-SHIRT FULL SLEEVES FLPCN sold 1186 qty of T-SHIRT HALF SLEEVES FLPCN sold 9 qty of T-SHIRT SLEEVE LESS FLPCN sold nan qty of TRACK PANT FLPCN sold nan qty of TROUSER ELASTICATED FLPCN sold nan qty of TROUSER FIXED WAIST FLPCN sold nan qty of WOVEN JACKET FULL SLEEVES FLPCN sold nan qty of WRIST BANDS LFD sold 16 qty of BAGS LFD sold nan qty of BARMUDA ELASTICATED LFD sold nan qty of BELT LFD sold nan qty of BOTTLE LFD sold nan qty of CAPRI ELASTICATED LFD sold 30 qty of CAPS LFD sold nan qty of CO-ORDINATE 2 PIECE LFD sold 232 qty of FLIP FLOP LFD sold nan qty of FOOT BALL LFD sold nan qty of HEADBAND LFD sold nan qty of HEAVY WINTER JACKET FULL SLEEVES LFD sold nan qty of HEAVY WINTER JACKET SLEEVE LESS LFD sold 270 qty of KNITS JACKET FULL SLEEVES LFD sold nan qty of KNITS TOP CAP SLEEVES LFD sold -4 qty of KNITS TOP FULL SLEEVES LFD sold 384 qty of KNITS TOP HALF SLEEVES LFD sold 60 qty of KNITS TOP SLEEVE LESS LFD sold nan qty of LEGGING LFD sold 100 qty of SANDALS LFD sold -15 qty of SHOES LFD sold 30 qty of SHORTS ELASTICATED LFD sold nan qty of SOCKS LFD sold nan qty of SWEAT PANT LFD sold 40 qty of SWEAT SHIRT FULL SLEEVES LFD sold nan qty of SWEATSHIRT HALF SLEEVES LFD sold -4 qty of T-SHIRT FULL SLEEVES LFD sold 1134 qty of T-SHIRT HALF SLEEVES LFD sold 30 qty of T-SHIRT SLEEVE LESS LFD sold nan qty of TRACK PANT LFD sold -9 qty of TROUSER ELASTICATED LFD sold nan qty of TROUSER FIXED WAIST LFD sold nan qty of WOVEN JACKET FULL SLEEVES LFD sold nan qty of WRIST BANDS ODP sold 143 qty of BAGS ODP sold 15 qty of BARMUDA ELASTICATED ODP sold nan qty of BELT ODP sold nan qty of BOTTLE ODP sold 35 qty of CAPRI ELASTICATED ODP sold 26 qty of CAPS ODP sold nan qty of CO-ORDINATE 2 PIECE ODP sold 305 qty of FLIP FLOP ODP sold nan qty of FOOT BALL ODP sold nan qty of HEADBAND ODP sold 39 qty of HEAVY WINTER JACKET FULL SLEEVES ODP sold 6 qty of HEAVY WINTER JACKET SLEEVE LESS ODP sold 73 qty of KNITS JACKET FULL SLEEVES ODP sold nan qty of KNITS TOP CAP SLEEVES ODP sold nan qty of KNITS TOP FULL SLEEVES ODP sold 598 qty of KNITS TOP HALF SLEEVES ODP sold 54 qty of KNITS TOP SLEEVE LESS ODP sold 2 qty of LEGGING ODP sold 199 qty of SANDALS ODP sold 319 qty of SHOES ODP sold 61 qty of SHORTS ELASTICATED ODP sold nan qty of SOCKS ODP sold nan qty of SWEAT PANT ODP sold -45 qty of SWEAT SHIRT FULL SLEEVES ODP sold 2 qty of SWEATSHIRT HALF SLEEVES ODP sold 18 qty of T-SHIRT FULL SLEEVES ODP sold 1572 qty of T-SHIRT HALF SLEEVES ODP sold 28 qty of T-SHIRT SLEEVE LESS ODP sold nan qty of TRACK PANT ODP sold 30 qty of TROUSER ELASTICATED ODP sold nan qty of TROUSER FIXED WAIST ODP sold nan qty of WOVEN JACKET FULL SLEEVES ODP sold nan qty of WRIST BANDS OEB sold 281 qty of BAGS OEB sold 817 qty of BARMUDA ELASTICATED OEB sold 120 qty of BELT OEB sold 60 qty of BOTTLE OEB sold 729 qty of CAPRI ELASTICATED OEB sold 573 qty of CAPS OEB sold 1 qty of CO-ORDINATE 2 PIECE OEB sold 1577 qty of FLIP FLOP OEB sold 3 qty of FOOT BALL OEB sold 1 qty of HEADBAND OEB sold nan qty of HEAVY WINTER JACKET FULL SLEEVES OEB sold 1 qty of HEAVY WINTER JACKET SLEEVE LESS OEB sold 96 qty of KNITS JACKET FULL SLEEVES OEB sold 171 qty of KNITS TOP CAP SLEEVES OEB sold 463 qty of KNITS TOP FULL SLEEVES OEB sold 2613 qty of KNITS TOP HALF SLEEVES OEB sold 147 qty of KNITS TOP SLEEVE LESS OEB sold 60 qty of LEGGING OEB sold 1622 qty of SANDALS OEB sold 3875 qty of SHOES OEB sold 629 qty of SHORTS ELASTICATED OEB sold 740 qty of SOCKS OEB sold 1 qty of SWEAT PANT OEB sold 746 qty of SWEAT SHIRT FULL SLEEVES OEB sold 1 qty of SWEATSHIRT HALF SLEEVES OEB sold 916 qty of T-SHIRT FULL SLEEVES OEB sold 6366 qty of T-SHIRT HALF SLEEVES OEB sold 1336 qty of T-SHIRT SLEEVE LESS OEB sold 6 qty of TRACK PANT OEB sold 318 qty of TROUSER ELASTICATED OEB sold 0 qty of TROUSER FIXED WAIST OEB sold 2 qty of WOVEN JACKET FULL SLEEVES OEB sold 1 qty of WRIST BANDS OSF sold 3 qty of BAGS OSF sold 8 qty of BARMUDA ELASTICATED OSF sold nan qty of BELT OSF sold nan qty of BOTTLE OSF sold 9 qty of CAPRI ELASTICATED OSF sold 2 qty of CAPS OSF sold nan qty of CO-ORDINATE 2 PIECE OSF sold 0 qty of FLIP FLOP OSF sold nan qty of FOOT BALL OSF sold nan qty of HEADBAND OSF sold nan qty of HEAVY WINTER JACKET FULL SLEEVES OSF sold nan qty of HEAVY WINTER JACKET SLEEVE LESS OSF sold 2 qty of KNITS JACKET FULL SLEEVES OSF sold 4 qty of KNITS TOP CAP SLEEVES OSF sold 13 qty of KNITS TOP FULL SLEEVES OSF sold 6 qty of KNITS TOP HALF SLEEVES OSF sold 0 qty of KNITS TOP SLEEVE LESS OSF sold 2 qty of LEGGING OSF sold 1 qty of SANDALS OSF sold 2 qty of SHOES OSF sold 3 qty of SHORTS ELASTICATED OSF sold 1 qty of SOCKS OSF sold nan qty of SWEAT PANT OSF sold 9 qty of SWEAT SHIRT FULL SLEEVES OSF sold nan qty of SWEATSHIRT HALF SLEEVES OSF sold 35 qty of T-SHIRT FULL SLEEVES OSF sold 138 qty of T-SHIRT HALF SLEEVES OSF sold 44 qty of T-SHIRT SLEEVE LESS OSF sold nan qty of TRACK PANT OSF sold 16 qty of TROUSER ELASTICATED OSF sold nan qty of TROUSER FIXED WAIST OSF sold nan qty of WOVEN JACKET FULL SLEEVES OSF sold nan qty of WRIST BANDS PDS sold 3 qty of BAGS PDS sold 41 qty of BARMUDA ELASTICATED PDS sold nan qty of BELT PDS sold nan qty of BOTTLE PDS sold 56 qty of CAPRI ELASTICATED PDS sold 2 qty of CAPS PDS sold nan qty of CO-ORDINATE 2 PIECE PDS sold 41 qty of FLIP FLOP PDS sold nan qty of FOOT BALL PDS sold nan qty of HEADBAND PDS sold nan qty of HEAVY WINTER JACKET FULL SLEEVES PDS sold nan qty of HEAVY WINTER JACKET SLEEVE LESS PDS sold 1 qty of KNITS JACKET FULL SLEEVES PDS sold nan qty of KNITS TOP CAP SLEEVES PDS sold 3 qty of KNITS TOP FULL SLEEVES PDS sold 306 qty of KNITS TOP HALF SLEEVES PDS sold 33 qty of KNITS TOP SLEEVE LESS PDS sold 0 qty of LEGGING PDS sold 6 qty of SANDALS PDS sold 22 qty of SHOES PDS sold 40 qty of SHORTS ELASTICATED PDS sold 12 qty of SOCKS PDS sold nan qty of SWEAT PANT PDS sold 6 qty of SWEAT SHIRT FULL SLEEVES PDS sold nan qty of SWEATSHIRT HALF SLEEVES PDS sold 17 qty of T-SHIRT FULL SLEEVES PDS sold 860 qty of T-SHIRT HALF SLEEVES PDS sold 24 qty of T-SHIRT SLEEVE LESS PDS sold 0 qty of TRACK PANT PDS sold 19 qty of TROUSER ELASTICATED PDS sold nan qty of TROUSER FIXED WAIST PDS sold nan qty of WOVEN JACKET FULL SLEEVES PDS sold nan qty of WRIST BANDS SFL sold nan qty of BAGS SFL sold 5 qty of BARMUDA ELASTICATED SFL sold nan qty of BELT SFL sold nan qty of BOTTLE SFL sold 11 qty of CAPRI ELASTICATED SFL sold nan qty of CAPS SFL sold nan qty of CO-ORDINATE 2 PIECE SFL sold 1438 qty of FLIP FLOP SFL sold nan qty of FOOT BALL SFL sold nan qty of HEADBAND SFL sold 3 qty of HEAVY WINTER JACKET FULL SLEEVES SFL sold nan qty of HEAVY WINTER JACKET SLEEVE LESS SFL sold 7 qty of KNITS JACKET FULL SLEEVES SFL sold 3 qty of KNITS TOP CAP SLEEVES SFL sold 27 qty of KNITS TOP FULL SLEEVES SFL sold 67 qty of KNITS TOP HALF SLEEVES SFL sold 12 qty of KNITS TOP SLEEVE LESS SFL sold 3 qty of LEGGING SFL sold 1354 qty of SANDALS SFL sold 2228 qty of SHOES SFL sold 12 qty of SHORTS ELASTICATED SFL sold 45 qty of SOCKS SFL sold nan qty of SWEAT PANT SFL sold 64 qty of SWEAT SHIRT FULL SLEEVES SFL sold nan qty of SWEATSHIRT HALF SLEEVES SFL sold 23 qty of T-SHIRT FULL SLEEVES SFL sold 272 qty of T-SHIRT HALF SLEEVES SFL sold 35 qty of T-SHIRT SLEEVE LESS SFL sold nan qty of TRACK PANT SFL sold 13 qty of TROUSER ELASTICATED SFL sold nan qty of TROUSER FIXED WAIST SFL sold nan qty of WOVEN JACKET FULL SLEEVES SFL sold nan qty of WRIST BANDS FLPCN BAGS BARMUDA ELASTICATED BELT BOTTLE CAPRI ELASTICATED CAPS CO-ORDINATE 2 PIECE FLIP FLOP FOOT BALL HEADBAND HEAVY WINTER JACKET FULL SLEEVES HEAVY WINTER JACKET SLEEVE LESS KNITS JACKET FULL SLEEVES KNITS TOP CAP SLEEVES KNITS TOP FULL SLEEVES KNITS TOP HALF SLEEVES KNITS TOP SLEEVE LESS LEGGING SANDALS SHOES SHORTS ELASTICATED SOCKS SWEAT PANT SWEAT SHIRT FULL SLEEVES SWEATSHIRT HALF SLEEVES T-SHIRT FULL SLEEVES T-SHIRT HALF SLEEVES T-SHIRT SLEEVE LESS TRACK PANT TROUSER ELASTICATED TROUSER FIXED WAIST WOVEN JACKET FULL SLEEVES WRIST BANDS LFD ODP OEB OSF PDS SFL

The intensity of colour in each cell indicates sales quantity. White is no sales, blue is high sales, by quantity.

Category-wise growth (week 25)

KNITS:T-SHIRT:T-SHIRT HALF SLEEVES: 11528 units, -82.8% growth T-SHIRT HALF SLEEVES KNITS:T-SHIRT:T-SHIRT FULL SLEEVES: 1005 units, -56.2% growth T-SHIRT FULL SLEEVES KNITS:T-SHIRT:T-SHIRT SLEEVE LESS: 1506 units, -100.0% growth T-SHIRT SLEEVE LESS KNITS:KNITS TOP:KNITS TOP HALF SLEEVES: 4774 units, -48.1% growth KNITS TOP HALF SLEEVES KNITS:KNITS TOP:KNITS TOP SLEEVE LESS: 336 units, 33.3% growth KNITS TOP SLEEVE LESS KNITS:KNITS TOP:KNITS TOP FULL SLEEVES: 502 units, inf% growth KNITS TOP FULL SLEEVES KNITS:KNITS TOP:KNITS TOP CAP SLEEVES: 178 units, nan% growth KNITS TOP CAP SLEEVES KNITS:KNITS JACKET:KNITS JACKET FULL SLEEVES: 449 units, -91.2% growth KNITS JACKET FULL SLEEVES KNITS:SWEAT SHIRT:SWEAT SHIRT FULL SLEEVES: 820 units, -80.0% growth SWEAT SHIRT FULL SLEEVES KNITS:SWEAT SHIRT:SWEATSHIRT HALF SLEEVES: 3 units, nan% growth SWEATSHIRT HALF SLEEVES KNITS:LEGGING:LEGGING: 67 units, inf% growth LEGGING FOOT WEAR:FOOTWEAR:SHOES: 6523 units, -28.7% growth SHOES FOOT WEAR:FOOTWEAR:FLIP FLOP: 3613 units, -43.4% growth FLIP FLOP FOOT WEAR:FOOTWEAR:SANDALS: 3353 units, 11.1% growth SANDALS BOTTOM:BARMUDA:BARMUDA ELASTICATED: 886 units, 37.5% growth BARMUDA ELASTICATED BOTTOM:CAPRI:CAPRI ELASTICATED: 840 units, 0.0% growth CAPRI ELASTICATED BOTTOM:TROUSER:TROUSER ELASTICATED: 387 units, -76.5% growth TROUSER ELASTICATED BOTTOM:TROUSER:SWEAT PANT: 1 units, inf% growth SWEAT PANT BOTTOM:SHORTS:SHORTS ELASTICATED: 784 units, -100.0% growth SHORTS ELASTICATED OTHER:ACCESSORIES:CAPS: 637 units, 75.0% growth CAPS OTHER:ACCESSORIES:BAGS: 456 units, 0.0% growth BAGS OTHER:ACCESSORIES:FOOT BALL: 3 units, inf% growth FOOT BALL OTHER:ACCESSORIES:BELT: 120 units, 100.0% growth BELT OTHER:ACCESSORIES:SOCKS: 798 units, -66.7% growth SOCKS OTHER:ACCESSORIES:HEADBAND: 1 units, nan% growth HEADBAND OTHER:ACCESSORIES:WRIST BANDS: 1 units, nan% growth WRIST BANDS OTHER:ACCESSORIES:BOTTLE: 60 units, -100.0% growth BOTTLE

Each box represents one Sub Category (grouped together by Category and Main Category). The size of the box represents the total sales quantity over the last 25 weeks. The colour of the box represents the growth in the last week (i.e. Week 25 over Week 24).

Zone-wise growth by Category

Group Sales East North South West
T-SHIRT 14039.0
FOOTWEAR 13489.0
KNITS TOP 5790.0
ACCESSORIES 2076.0
BARMUDA 886.0
CAPRI 840.0
SWEAT SHIRT 823.0
SHORTS 784.0
KNITS JACKET 449.0
TROUSER 388.0
LEGGING 67.0
HEAVY WINTER JACKET 49.0
TRACK PANT 6.0
WOVEN JACKET 2.0
CO-ORDINATE 1.0

This table shows the Zone-wise growth by Category. Each row is one Category. The Sales column shows the total 25 week sales. The bar-chart in each cell shows the Zone-wise sales over 25 weeks. The line graph is the 4-week moving average. The colour indicates growth over the last 4 weeks (Red is negative, Green is positive).

Zone-wise growth by Gender

Group Sales East North South West
MEN 15378.0
UNISEX 14398.0
WOMEN 9913.0