Decision$-$Making Context: The Sl$$inte brewing company operates locally and also distributes its beer across several states in the United States. Specifically, it brews the following beers: Pale Ale, Imperial IPA, IPA, Imperial Stout, Stout, and Wheat. When the business analysis team at Sl$$inte is working with the company$$s sales transaction data, it$$s important that they recognize the data types of each attribute. When analysts do not correctly identify the data types and ensure that data have been imported appropriately, errors or confusion can occur. Taking the time to assess and set the data type as soon as you import it into Tableau can ease your data analysis work.

Adjust the data types as necessary.

Aggregate the sum and then the average of all sales orders $($quantity$).$

Subtotal the sales orders by average across product sold.

Data: Lab $2\mathrm{.}2$ Data.xlsx

Specify the Question: How do data types affect the way I can analyze data in Tableau?

Obtain the Data: The dataset contains information about sales transactions with different customers. There are $132$ unique transactions but $149$ rows because some of the transactions include multiple products.

Analyze the Data: Refer to lab $2\mathrm{.}2$ in your text for additional instructions and steps.

Answer the following questions based on the details computed.