3. Use Tableau to determine the market segment of sales by product category and consumer market region. 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.

Product Category0K500K1000K1500K2000K2500K3000K3500K4000K4500K5000K5500K6000KSalesOffice SuppliesFurnitureTechnologySheet 1Sum of Sales for each Product Category.RegionProduct CategoryFurnitureOffice SuppliesTechnologyWestOntarioPrarieAtlanticQuebecYukonNorthwestTerritoriesNunavut34,215301,160417,991552,588827,0571,198,0231,026,1641,627,04938,615216,849221,978351,823478,464720,090927,431797,51143,546282,838335,898605,784708,727919,1911,109,6181,172,989Sheet 1Sales34,215500,0001,000,0001,627,049Sum of Sales (size) broken down by Product Category vs. Re-gion.RegionOrder Date2009201220102011WestOntarioPrarieAtlanticQuebecYukonNorthwestTerritoriesNunavut38,900240,699271,317319,538357,272711,561656,742840,78831,693200,178270,225369,739508,428545,010772,618851,79026,204169,593207,869450,595480,155798,208728,213859,12719,580190,378226,456370,323668,393782,526905,6391,045,843Sheet 1Sales19,580200,000400,000600,000800,0001,045,843Sum of Sales (size) broken down by Order Date Year vs.Region.