Question #1:

o Which state has the lowest or highest Sales (Sum)? What is the total Sales for that state?

o Required Components:

o A.) Map of U.S. B.) A color scale indicating total sales C.) Each state labeled with state name D.) Each state labeled with total sales

Question #2:

o Which customer segment has both the highest order quantity and average discount rate? What is the order quantity and average discount rate for that state?

o Required Components:

o A.) Bar Chart displaying Order Quantity for each Customer Segment B.) A color scale indicating average discount rate C.) Each customer segment labeled with average discount rate D.) Each customer segment labeled with total Order Quantity

Question #3:

o Which Product Category has the highest total Sales? Which Product Category has the worst Profit? Name the Product Category and $ amount for each.

o Required Components:

o A.) Bar Chart displaying total Sales for each Product Category B.) A color scale indicating Profit C.) Each Product Category labeled with total Sales D.) Each Product Category labeled with Profit

Question #4:

o Use the similar visualization created for Question #3 or you can create new chart for this question.

o What was the Profit on Phones (Phone is one of Sub-category under Technology Category)? And which city has the highest profit on Phones Sub-category?

o Required Components:

o A.) All components from Question #3 B.) Filters for each of the Dimensions needed to create a visualization with only one Bar indicating the answer to the question

o Hint: Use Quick Filters

Question #5:

o (A) Which Product Category has the highest Sale per Customer and Profit per Order? Name the Category for the highest Sale per Customer and Profit per Order

o Required Components:

o A.) Packed bubble chart showing each Product Category as a colored bubble B.) Use Profit per Customer to display the size of each bubble.

o (B) Which Product Sub-Category has the highest Sale per Customer and Profit per Order? Name the Sub-Category for the highest Sale per Customer and Profit per Order

o Required Components:

o A.) Packed bubble chart showing each Product Sub-Category as a colored bubble B.) Use Profit per Customer to display the size of each bubble.

Question #6:

o Use the similar visualization created for Question #5 or you can create new chart for this question.

o What was the Sale per Customer and Profit per Order for Belkin products) in the Category or Sub-Category? You should include Category, Sub-Category, and Product Name (Please drag and drop those three from Dimensions)

o Which Product Name starting with Belkin has the highest Sale per Customer and Profit per Order? Name the Product Name and Profit per Customer.

o And Which Product Name starting with Belkin has the worst Profit per Customer? Name the Product Name and Profit per Customer.

o Required Components:

o A.) Filters for each of the Dimensions needed to create a visualization indicating the answer to the question

Question Which state has the lowest or highest Sales Som? What is the total Sales for that state? Required Components A Map of US )Acolo scale indicating total sales Each state labeled with state ame.Each state labeled with total sales Question 2: Which customer segment has both the highest order quantity and average discount rate? What is the order quantity and average discount rate for that state? Required Components A) Bar Chart displaying Order anty for each customer Segment B) A color scale indicating average discount rate) Each customer segment labeled with average discount rate) Lach customer segment beled with total Order Quantity Question : Which Product Category has the highest total Sales? Which Product Category has the worst Profit? Name the Product Category and mount for each Required Components A) Bar Chart displaying totul Sales for each product Category.) A color sale indicating Profitch Each Product Category labeled with soal Sales D) Cach Product Category tabeled with Profit Question 4 Use the similar visualization created for Guestion 33 you can create new chart for this question, What was the Profit on Phones (Phone is one of Subcategory under Technology Category? And which city has the highest profiton Phones Subcategory? Required Components: A)All components from Question 13 Fers for each of the Dimensions needed to create a visualization with only one Bar indicating the answer to the question Hint: Use Quick Filters Question : (A) Which Product Category has the highest Sali per Customer and Profit per Order Name the Category for the highest Sale per Customer and Profit per Order Required Components: A) Packed bubble chart showing each Product Category as a colored bubble. Use Profit per Customer to display the size of each bubble (B) Which Product Sub Category has the highest Sale per Customer and Profit per Order? Name the Sub Category for the highest Sale per Customer and Profit per Order Required Components Alracked bubble chart showing each productSub Category as a colored bubble B) Use Profit per Customer to display the size of each bubble Question 16: Use the similar visualization created for Questions or you can create new chart for this question. What was the "Sale per Customer and Profit per Order for Belkin products) in the Category of Sub Category? You should include Category. Sub Category and Product Name Please drag and drop those three from Dimensions Which Product Name starting with Belkin has the highest 'Sale per Customer and Profit per Order Name the Product Name and Profit per Customer And Which Product Name starting with Bein has the worst Profit per Customer? Name the Product Name and Profit per Customer Required Components A) Filters for each of the Dimensions needed to create a visualization indicating the answer to the