In this lab, you will:

Required:

1. Create a calculated field for the Gross Margin.

2. Create a summary table that shows the gross margin per customer.

Ask the Question: Which customers are the most profitable?

Master the Data: Fruitopia sells exotic fruit from throughout the world to customers throughout the country by mail order. The company keeps a sales journal that records each sale and its related sales and cost details. This sales journal is for March 14, 2021. Use data file Lab 2-4 Data.xlsx, but open in Tableau.

Software needed

• Tableau
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

Data: Lab 2-4 Data.xlsx.

Perform the Analysis: Refer to Lab 2-4 in the text for instructions and steps for each of the lab parts.