In this lab, you will: Required: 1. Create the relationships among the three tables in the data source window. 2. Change the data type of Supplier St to geographic if necessary. 3. Create four sheets: a. Sum of Raw Materials Purchased. b. Count of Purchase Orders by Raw Material. c. Purchases by Day. d. Sum of Raw Materials Purchased by State. 4. Create a Dashboard with all four sheets. 5. Create dashboard-level filters from the following two sheets: a. Sum of Raw Materials Purchased. b. Sum of Raw Materials Purchased by State. Ask the Question: What are the different reports and charts that would be useful to place together for regular analysis? Master the Data: Open Tableau and Connect to Excel File Lab 10-2 Alt Data.xlsx. This dataset contains similar data to the 10-2 data, except it shows purchase orders, raw materials, and suppliers. Software needed Tableau Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Lab 10-2 Alt Data.xlsx. Raw_Materials_Code 3 Raw_Material_Purchase_Price 3 Quantity Purchased 1001 1003 1003 10 2 Z 6 1 1 2 2 1 1 1002 1001 1001 1001 1003 1001 12 4 12 5 1 1 4 1 3 1 12 11 2 1 Purchase_Order_ID Purchase_Order_Date Purchase_Employee_ID 2 2 20500 11/1/19 3 20501 11/5/19 4 20502 11/10/19 5 20503 11/13/19 6 20504 11/16/19 7 20505 11/19/19 8 20506 11/23/19 9 20506 11/23/19 10 20507 11/26/19 11 20508 11/29/19 12 20509 12/4/19 13 20510 12/9/19 14 20511 12/12/19 15 20512 12/16/19 16 20513 12/19/19 17 20514 12/24/19 18 20515 12/28/19 19 20516 1/2/20 20 20517 1/5/20 21 20518 1/9/20 22 20519 1/14/20 23 20520 1/18/20 24 20521 1/23/20 25 20522 1/26/20 26 20523 1/31/20 27 20524 2/4/20 28 20525 2/8/20 29 20525 2/8/20 30 20525 2/8/20 31 20526 2/13/20 32 20527 2/16/20 33 20527 2/16/20 34 20528 2/21/20 1001 1001 1001 1003 1001 1002 1002 Supplier_ID 1009 1009 1009 1008 1009 1008 1009 1009 1009 1009 1009 1009 1008 1009 1008 1009 1009 1008 1009 1009 1008 1008 1008 1009 1009 1009 1008 1009 1008 1009 1009 1009 1008 3 2 3 2 3 1 1 2 6 7 11 11 4 11 1002 1003 1001 19.99 29 29 44.99 19.99 19.99 19.99 29 19.99 19.99 19.99 19.99 29 19.99 44.99 44.99 44.99 29 19.99 29 19.99 29 19.99 44.99 19.99 19.99 44.99 44.99 29 19.99 19.99 29 19.99 1 2 1 1 1003 1001 1003 1001 1002 1001 10 12 1 12 6 6 10 3 3 1 8 1 2 1001 1002 5 3 3 1002 3 2 2 6 11 12 1003 1001 1001 1003 1001 2 2 6 3 1 35 20529 1008 3 1003 10 29 36 20530 1008 3 1001 2 19.99 37 20530 1009 3 1003 2 29 20531 1008 3 1003 7 29 20532 1008 1 1002 2 44.99 38 39 40 41 20533 1009 1 1002 12 44.99 20534 1008 2 1002 5 44.99 20535 1009 3 1002 7 44.99 20536 1009 2 1001 12 19.99 42 43 44 45 20537 12/24/20 12/28/20 2/28/20 3/4/20 3/7/20 3/12/20 3/15/20 3/19/20 3/23/20 3/27/20 3/31/20 4/4/20 4/8/20 4/11/20 4/11/20 14/14/20 4/14/20 4/18/20 4/21/20 1008 2 1003 6 29 20538 1009 1 1002 5 44.99 46 20539 1008 3 1003 6 29 47 20540 1008 2 1001 3 19.99 48 20541 1009 3 1003 10 29 49 20541 1008 3 1003 3 29 20542 1009 1 1003 6 29 44.99 20542 1009 1 1002 5 50 51 52 53 20543 1009 1 1002 1 44.99 20544 1008 2 1002 4 44.99 B C D E F G H J Supplier_ID Supplier_St MN WA AR Supplier_company_name Supplier_Address Supplier_City 1 Northern Brewery Homebrew $ 6021 Lyndale Ave S Minneapolis 2 Hops Direct, LLC 686 Green Valley Road Mabton 3 The Home Brewery 455 E. Township St. Fayetteville 4 The Payroll Company 408 N. Walton Blvd Bentonville 5 City of Fayetteville - Water 113 West Mountain Str Fayetteville 6 Southwestern Gas P.O. Box 98890 Las Vegas 7 Bob's Repair 3541 Horse Meadow Dr Fayetteville 8 Farmer's Insurance 1943 College Avenue Fayetteville 9|Lindsey Management Co. 1200 East Joyce Blvd. Fayetteville AR AR Supplier_Zip 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 - Notes Bulk Malt Supplier Bulk Hops Supplier Small batch and Speciality Ingredient Supplier Payroll Water Electric and Gas Repairs Insurance Rent NV AR AR AR 2 Raw_Materials_Code Raw_Materials_Description 1001 Malt - Barley 1002 Malt - Wheat 1003 Hops Raw_Materials_Price $19.99 $44.99 $29.00 3 I 5 Required: 1. Which raw material is purchased most frequently from suppliers in Arkansas (AR)? Malt - Barley O Malt - Wheat O Hops 2. Which raw material is purchased most frequently from suppliers in Washington? O Malt - Barley O Hops Malt - Wheat 3. On which day was the most Malt - Barley purchased from suppliers in Minnesota? February 21, 2019 O December 1, 2019 O December 4, 2019 O January 31, 2019 4. From which state are most raw materials purchased, overall? O Arkansas O Nebraska O Washington O Minnesota 5. From which state are least raw materials purchased, overall? Arkansas Minnesota Washington O Nebraska