Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required information [ The following information applies to the questions displayed below. ] Lab Insight: Complete the Alt Lab by using steps similar to original
Required information
The following information applies to the questions displayed below.
Lab Insight: Complete the Alt Lab by using steps similar to original Lab in the text. Open Tableau or Power BI and connect to Excel File AltLabData.xIsx below. The 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 Data.xIsx
Perform the Analysis: Refer to original Lab 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started