analytics
3 x
3.
Use Tableau to determine the market segment of sales by product category and consumer market re
gion.
What category of product has the highest sales volume? What category has the lowest sales volume? What are the top two regions in the world for sales volume of consumer office supplies? Which market region is an emerging market for ABC Company?
Market segment of sales by product category
Office supplies = $3,752,762 .
Furniture
= $5,178,591.
Technology
= $5,984,248
What category of product has the highest sales volume? Technology What category has the lowest sales volume?Office supplies
Market segment of sales by consumer market region.
0K500K1000K1500K2000K2500K3000K3500K4000K4500K5000K5500K6000K
Sales
Office Supplies
Furniture
Technology
Sheet 1
Sum of Sales for each Product Category.
Region
Product Category
FurnitureOffice SuppliesTechnology
West
Ontario
Prarie
Atlantic
Quebec
Yukon
Northwest
Territories
Nunavut
34,215
301,160
417,991
552,588
827,057
1,198,023
1,026,164
1,627,049
38,615
216,849
221,978
351,823
478,464
720,090
927,431
797,511
43,546
282,838
335,898
605,784
708,727
919,191
1,109,618
1,172,989
Sheet 1
Sales
34,215
500,000
1,000,000
1,627,049
Sum of Sales (size) broken down by Product Category vs. Re-
gion.
Region
Order Date
2009201220102011
West
Ontario
Prarie
Atlantic
Quebec
Yukon
Northwest
Territories
Nunavut38,900
240,699
271,317
319,538
357,272
711,561
656,742
840,788
31,693
200,178
270,225
369,739
508,428
545,010
772,618
851,790
26,204
169,593
207,869
450,595
480,155
798,208
728,213
859,127
19,580
190,378
226,456
370,323
668,393
782,526
905,639
1,045,843
Sheet 1
Sales
19,580
200,000
400,000
600,000
800,000
1,045,843
Sum of Sales (size) broken down by Order Date Year vs.
Region.