Required information

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

Lab Insight: Complete the Alt Lab by using steps similar to original Lab $3-1$ in the text. Open Tableau or Power BI$,$ and connect to Excel File Alt$\_$Lab$\_3-1\_$Data.xIsx below. The $3-1$ Alt Data is purchasing data rather than sales, so instead of working with Sales Order Quantity Sold, you will work with Quantity Purchased, and instead of working with Products, you will work with Raw Materials.

Required:

Adjust the data types as necessary.

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

Subtotal the purchase orders by average across raw materials.

Data: Alt Lab $3-1$ Data.xIsx

Perform the Analysis: Refer to original Lab $3-1$ in the text for your software version instructions and steps for each of the original lab parts.

Note: Submit your answers for the following Analysis Questions in the text entry field below.

How does SUM vs COUNT impact the way you analyze this data?

What additional data could help you further investigate the position of this company based on what you have observed so far?