Use VLOOKUP to pull in descriptive attributes from other tables into the transaction table. Ask the Question: How can we pull in descriptive attributes from separate tables into the transaction table that we wish to use for analysis?

 In this lab, you will:
Required:
Use VLOOKUP to pull in descriptive attributes from other tables into the transaction table.
 
Ask the Question: How can we pull in descriptive attributes from separate tables into the transaction table that we wish to use for analysis?

Master the Data: The dataset contains information about sales transactions to different customers. There are 132 unique transactions in the Sales_Transactions table, but 149 rows—this is because some of the transactions had multiple products on them.
This data is similar to the data used in several of the labs in Chapter 3; however, in Chapter 3, the data had already been transformed. In this lab, we will pull in fields from the Customers and Products table to make the analysis in the transaction table more interesting.
 
Software needed
•    Excel
•    Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 Required:
1. Which product was on Sales Order 20001?
 

•     Stout
•     Imperial IPA
•     Pale Ale
•     Imperial Stout 

Answer

Pale Ale 

2. How many Sales Orders is Imperial IPA on?
 

•     149
•     10
•     61
•     17 

Answer

10
 
3. What is the quantity sold of Imperial IPA?
 
 
•     149
•     10
•     61
•     17 

Answer

61
 
4. When creating the VLOOKUP for this lab, which variable has the matching key between the Sales_Transactions and Products tables?
 
 
•     Customer_ID
•     Product_Code
•     Sales_Order_ID
•     Product_Description 

Answer
 Customer_ID 

5. If you replaced the number 2 for the column_num with a 3 (the third argument In the VLOOKUP function), what descriptive information would return instead of Product_Description?
 

•     Sales_Employee_ID
•     Product_Sale_Price
•     Sales_Order_ID
•     Product_Code

Answer

Product_Sale_Price

Thanks