In this lab, you will: Required: 1. Connect to the Lab 4-t Alt Data.xlsx dataset through...

  
 
 

Transcribed Image Text:

In this lab, you will: Required: 1. Connect to the Lab 4-t Alt Data.xlsx dataset through Tableau. 2. Add the Suppliers table to the Data Source. 3. Join in the Purchase_Orders table-first as an Inner join, then edit it to be a Left join. Notice how the number of records changes when you switch to a Left join. 4. Explore the data to assess which Suppliers aren't listed on any Purchase Orders. Ask the Question: How can we pull in data from a relational database into Tableau in a way that best suits our analysis needs? Master the Data: Apply the same steps as Lab 4-5 to the Lab 4-5 Alt Data.xlsx dataset. The 4-5 Alt dataset contains three tables related to the purchasing process. Software needed • Tableau • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 4-5 Alt Data.xlsx. Perform the Analysis: Refer to Lab 4-5 Alternative in the text for instructions and Lab 4-5 steps for each the of lab parts. Share the Story: You can continue to analyze your data in Tableau in ways that you have learned in other Tableau labs; you just have more flexibility now that you have data from more than one table joined in your Tableau connection. Part 1: Upload Your Files Part 2: Assessment A 1 Supplier_ID 2 3 4 5 6 7 8 9 10 11 B Supplier_Company_name ▼ Supplier_Address 1 Northern Brewery Homebrew St 6021 Lyndale Ave S 2 Hops Direct, LLC 3 The Home Brewery C 4 The Payroll Company 5 City of Fayetteville - Water 6 Southwestern Gas 7 Bob's Repair 8 Farmer's Insurance 9 Lindsey Management Co. D Supplier_City Minneapolis 686 Green Valley Road Mabton 455 E. Township St. Fayetteville 408 N. Walton Blvd Bentonville 113 West Mountain Stre Fayetteville P.O. Box 98890 Las Vegas 3541 Horse Meadow Dri Fayetteville 1943 College Avenue Fayetteville 1200 East Joyce Blvd. Fayetteville E Supplier_St MN WA AR AR AR NV AR AR AR F Supplier_Zip G Supplier_Phone 55419 612-843-4444 98935 509-837-3616 72703 479-587-1440 72712 1-866-899-8439 72701 479-521-1258 877-860-6020 72703 479-345-2345 72701 479-236-0013 72703 479-521-6686 V H Notes Bulk Malt Supplier Bulk Hops Supplier Small batch and Speciality Ingredient Supplier Payroll Water Electric and Gas Repairs Insurance Rent K L Required: 1. How many Suppliers exist in the Suppliers table that have not been on any orders in the Purchase _Orders table? 08 04 02 6 2. Add Supplier Company Name to your sheet so you can see the names associated with the supplier IDs. Which of the following is one of the companies that has not yet had an order placed with them? O The Home Brewery O Hops Direct O Northern Brewery Homebrew Supply O Bob's Repair 3. What do the three companies who have orders placed with them have in common? O There doesn't seem to be anything in common with the three companies O The three companies are each brewing supply companies O The three companies are each located in Missouri O The three companies are each utility companies 4. How many orders have been placed with Hops Direct (Supplier ID 2)? O 18 0 000 ° – ಹ 15 OO 10 5. How many orders have been placed with suppliers in Arkansas (AR)? 10 18 14 In this lab, you will: Required: 1. Connect to the Lab 4-t Alt Data.xlsx dataset through Tableau. 2. Add the Suppliers table to the Data Source. 3. Join in the Purchase_Orders table-first as an Inner join, then edit it to be a Left join. Notice how the number of records changes when you switch to a Left join. 4. Explore the data to assess which Suppliers aren't listed on any Purchase Orders. Ask the Question: How can we pull in data from a relational database into Tableau in a way that best suits our analysis needs? Master the Data: Apply the same steps as Lab 4-5 to the Lab 4-5 Alt Data.xlsx dataset. The 4-5 Alt dataset contains three tables related to the purchasing process. Software needed • Tableau • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 4-5 Alt Data.xlsx. Perform the Analysis: Refer to Lab 4-5 Alternative in the text for instructions and Lab 4-5 steps for each the of lab parts. Share the Story: You can continue to analyze your data in Tableau in ways that you have learned in other Tableau labs; you just have more flexibility now that you have data from more than one table joined in your Tableau connection. Part 1: Upload Your Files Part 2: Assessment A 1 Supplier_ID 2 3 4 5 6 7 8 9 10 11 B Supplier_Company_name ▼ Supplier_Address 1 Northern Brewery Homebrew St 6021 Lyndale Ave S 2 Hops Direct, LLC 3 The Home Brewery C 4 The Payroll Company 5 City of Fayetteville - Water 6 Southwestern Gas 7 Bob's Repair 8 Farmer's Insurance 9 Lindsey Management Co. D Supplier_City Minneapolis 686 Green Valley Road Mabton 455 E. Township St. Fayetteville 408 N. Walton Blvd Bentonville 113 West Mountain Stre Fayetteville P.O. Box 98890 Las Vegas 3541 Horse Meadow Dri Fayetteville 1943 College Avenue Fayetteville 1200 East Joyce Blvd. Fayetteville E Supplier_St MN WA AR AR AR NV AR AR AR F Supplier_Zip G Supplier_Phone 55419 612-843-4444 98935 509-837-3616 72703 479-587-1440 72712 1-866-899-8439 72701 479-521-1258 877-860-6020 72703 479-345-2345 72701 479-236-0013 72703 479-521-6686 V H Notes Bulk Malt Supplier Bulk Hops Supplier Small batch and Speciality Ingredient Supplier Payroll Water Electric and Gas Repairs Insurance Rent K L Required: 1. How many Suppliers exist in the Suppliers table that have not been on any orders in the Purchase _Orders table? 08 04 02 6 2. Add Supplier Company Name to your sheet so you can see the names associated with the supplier IDs. Which of the following is one of the companies that has not yet had an order placed with them? O The Home Brewery O Hops Direct O Northern Brewery Homebrew Supply O Bob's Repair 3. What do the three companies who have orders placed with them have in common? O There doesn't seem to be anything in common with the three companies O The three companies are each brewing supply companies O The three companies are each located in Missouri O The three companies are each utility companies 4. How many orders have been placed with Hops Direct (Supplier ID 2)? O 18 0 000 ° – ಹ 15 OO 10 5. How many orders have been placed with suppliers in Arkansas (AR)? 10 18 14