Required information

Lab $2\mathrm{.}4$ Alternate: Aggregating and Visualizing Different Data Types $($LO $2-5)$

$[$The following information applies to the questions displayed below.$]$

Lab Insight: Apply the same steps in Lab $2\mathrm{.}4$ to the Alt Lab $2\mathrm{.}4$ Data.xlsx dataset. The same scenario exists as before with

the Sl$$inte brewery, only this time you are looking at the purchasing transactions $($instead of sales$).$ The raw materials that

Sl$$inte orders are hops, barley, malt, wheat, and seasonal items.

Required:

Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased by year.

Create a slicer to interactively filter the pivot chart by state from which the products were ordered.

Adjust the pivot chart to show horizontal bars.

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

Analyze the Data: Alternate Labs don't have step$-$by$-$step instruction or video support. Apply your experience from the

original lab. If needed, reference the text or eBook for instructions and steps from the original lab.

Lab $2\mathrm{.}4$ Alternate: Assessment Questions

Answer the following questions based on the details computed. The same scenario exists as before with the Sl$$inte brewery, only this time you are looking at the purchasing transactions $($instead of sales$).$ The raw materials that Sl$$inte orders are hops, barley, malt, wheat, and seasonal items.

Required:

Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased by year.

Create a slicer to interactively filter the pivot chart by state from which the products were ordered.

Adjust the pivot chart to show horizontal bars.