Your manager is interested in finding out if total sales by product type are impacted by market size

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Access the file attached, load the data into Tableau and answer the questions. 

1. Your manager is interested in finding out if total sales by product type are impacted by market size? Please create a report showing that. Show it both as a table and as a chart. What type of chart did you use? Why?

2. Which product types are doing better in small markets vs. large markets? Why do you think this is the case?

3. How are the total sales related to total profit by product type? Which product type has the highest profit vs. highest sales?

4. You are interested in finding out more about business in California. Show the profit margin and profit by Product and Product type. In which product/type the company is losing money in California?

5. Which Products are not available in decaf in California? Which products are only available in decaf (“Type” is the dimension for decaf and regular)

6. Product manager responsible for coffee is interested in sales of coffee across all the states. Which state has the highest coffee sales? Show it on a geo graph and a table. From the geo graph, can you identify the top 5 states for the highest coffee sales?

7. Look at Profit by Regions (Market) by-product group and Type. Can you identify a region with negative Profit? Can you drill down and find out what is causing it? Find out which product and which state is causing negative sales?

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme