Open Tableau. After Tableau opens, select Connect to Excel data and browse to the location of the spreadsheet Ch11_problems_set_2.xlsx. After importing, there will be two worksheets, Customers and Orders. Drag both of those to the box that says Drag sheets here.

The two sheets will join and the joined data will appear in the bottom box. You can click on the two icons between the boxes to toggle between showing data and showing file structure. Click on Worksheet 1 at the bottom of the page to go to the worksheet associated with the data. Now you are ready to analyze the data. LO 11-4

a. Graph the quantity sold. Drag the Qty Sold measure to the Columns shelf. Notice that the measure is automatically summed.

b. Change the measure to show the average quantity sold.

c. Drag the measure from the Columns shelf to the Rows shelf. What changes?

d. Compare the average quantity sold by state. Drag the State dimension to the Columns shelf. What changes in the graph? Which state has the highest average sales quantity? Which state has the lowest average sales quantity?

e. Rename sheet 1 to “average quantity sold by state.”

f. Create a new Dashboard.

g. Add your worksheet to the Dashboard.

h. Save your Tableau file as a Tableau Workbook.