Using Tableau Desktop answer the following 6 multiple choice questions the excel file to upload to tableau is attached

question1-Which day of the week do orders produce the highest dollar amount in Sales?

qUESTION 2

1. Customer complaints are rising on late deliveries. Use your filters to drill down on the data. Filter on Ship status = Late and order dates of 2014 only. then use # of records as # of orders for your measure. Hint: when you drag order date to the shelf, use the + sign in the order date box, to expand to quarter and month. What month(s) in 2014 have the highest ship status of ‘late’?

   		January
   		September and December
   		March
   		July

QUESTION 3

1. Which product ‘category’ has the highest ships late status? remember to use number of records as a measure

   		office supplies
   		technology
   		furniture
   		none of them

QUESTION 4

1. Tamara Chand is our highest profit generating customer, what two days of the week does she put in the highest number of orders?

   		Monday & Tuesday
   		Wednesday and Friday
   		Saturday & Monday
   		all days of week generate same number of orders

QUESTION 5

1. Let’s take a look at returns data. Go back to the Data source tab. Drag returns data to the right side of orders, the join function appears, click on the join circles, and set the join to order ID’s. What Produce Name is returned most often?

   		Staples
   		Paper clips
   		Rubber bands
   		Note Cards

QUESTION 6

1. When wanting to join tables, you can do so on the Tableau Data Source tab. Match the following about joins.

   –A.B.C.D. Inner Join –A.B.C.D. Left Join –A.B.C.D. Right Join –A.B.C.D. Outer Join

   A. Includes all values from the right table, and all matches from the left table. members without matches will show up as nulls on the left side. B. Includes all values from the left table, and all matches from the right table. members without matches will show up as nulls on the right C. Includes all values from both tables, members without matches show up as nulls. D. Includes only values with matches from both tables