supplier st AR WA WA MN MN supplier city Fayetteville Mabtan Mabton Minneapolis Minneapolis Mabtan Minneapolis Minneapolis WA MN Minneapolis MN MN AR IMIN WA AR AR WA AR MN MN WA MN WA 1 Purchase_Order_ID Purchase_Order_Date Purchase_Employee_ID Supplier_ID Quantity_Purchased Raw Material_Purchase_Price raw_materials_description 2 20500 43770 1009 3 3 19.99 Malt-Barley 3 20501 43774 1009 2 10 29 Haps 20502 43779 1009 2 6 29 Hops 5 20503 43782 1008 1 12 44.99 Malt-Wheat 6 20504 43785 1009 1 4 19.99 Malt-Barley 7 20505 43788 1009 2 12 19.99 Malt-Barley 8 20505 43792 1009 1 5 19.99 Malt-Barley 9 20506 43792 1009 1 1 29 Hops 10 20507 43795 1009 1 1 19.99 Malt-Barley 11 20508 43798 1009 3 4 4 19.99 Malt Barley 12 20509 43803 1009 1 12 19.99 Malt-Barley 13 20510 43808 1009 2 11 19.99 Malt-Barley 14 20511 43811 1008 3 6 29 Haps 15 20512 43815 1009 3 7 19.99 Malt Barley 16 20513 43818 1008 Z 11 44.99 Malt - Wheat 17 20514 43823 1009 3 11 44.99 Malt-Wheat 18 20515 43827 1009 1 4 44.99 Malt-Wheat 19 20516 43832 1008 1 29 Haps 20 20517 43835 1009 Z 10 19.99 Malt-Barley 21 20518 43839 1009 1 12 29 Hops 22 20519 43844 1008 2 1 19.99 Malt-Barley 23 20520 43848 1009 1 12 29 Hags 24 20521 43853 1008 3 6 19.99 Malt-Barley 25 20522 43856 1009 3 10 44.99 Malt - Wheat 26 20523 43861 1009 1 B 19.99 Malt-Barley 27 20524 43865 1009 2 1 19.99 Malt-Barley 28 20525 43869 1008 3 5 44.99 Malt - Wheat 29 20525 43869 1009 3 2 44.99 Malt-Wheat 30 20525 43869 1008 3 6 29 Haps 31 20526 43874 1009 11 19.99 Malt-Barley 32 20527 43877 1009 2 12 19.99 Malt-Barley 33 20527 43877 1009 Z Z 6 29 Hops 34 20528 43882 100B 1 3 3 19.99 Malt - Barley 35 20529 43885 100g 3 10 29 Haps 36 20530 43889 1008 3 2 19.99 Malt-Barley 37 20530 43889 1009 3 2 2 29 Hops 38 20531 43994 100 3 7 29 Haps 39 20532 43897 1008 1 2 44.99 Malt Wheat 40 20533 43902 1009 1 12 44.99 Malt - Wheat 41 20534 43905 1008 2 5 44.99 Malt-Wheat 42 20535 43909 1009 3 7 44.99 Malt - Wheat 43 20536 43913 1009 2 12 19.99 Malt-Barley 44 20537 43917 1008 2 5 29 Hops 45 20538 43921 1009 1 5 44.99 Malt - Wheat 46 20539 43925 1008 3 6 29 Haps 47 20540 43929 100g 3 19.99 Malt-Barley 48 20541 43932 1009 3 3 10 29 Hops 49 20541 43932-1003 29 Hoos Fayetteville Minneapolis Mabton Fayetteville Fayetteville Mabton Fayetteville Minneapolis Minneapalis Mabton Minneapolis Mabtan Minneapolis Fayetteville Fayetteville MIN AR AR MN WA Minneapolis AR AR AR WA WA WA MN AR AR AR AR MN MN Mabtan Fayetteville Fayetteville Fayetteville Mabtan Mabton Mabton Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minneapolis Minneapolis Mabton Fayetteville Mabtan Mabton Minneapolis Fayetteville Mabtan Fayetteville Fayetteville WA AR WA WA MN AR WA AR AR 44 2 6 WA 20537 20538 20539 1 45 46 47 5 MN AR 3 6 20540 2 3 WA AR 48 3 10 43917 1008 43921 1009 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 29 Hops 44.99 Malt - Wheat 29 Hops 19.99 Malt - Barley 29 Hops 29 Hops 29 Hops 44.99 Malt - Wheat 44.99 Malt - Wheat 44.99 Malt - Wheat Mabton Minneapolis Fayetteville Mabton Fayetteville Fayetteville Minneapolis Minneapolis Minneapolis Mabton 3 20541 20541 20542 20542 20543 20544 3 1 49 50 51 52 6 5 AR MN MN MN 1 1 1 2 4 WA 53 54 55 Required information [The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Create the String Data sheet and work through the different ways of visualizing proportions and counts. 2. Create the Geographic Data sheet and work through symbol and filled maps for quantity purchased. Ask the Question: How do data types affect the way I can analyze data in Tableau? Master the Data: This lab is a continuation of Lab 3-2. Make sure to work through the Master the Data steps in Lab 3-2 before proceeding to this lab to ensure that you have imported the data from Lab 3-2 and changed all the data types appropriately according to Steps 1 and 2. Software needed Tableau Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: 3-3 Alt Data.twbx or you may use your solution file for Lab 3-2 Alt Data.xlsx. Perform the Analysis: Refer to Lab 3-3 Alternate in the text for instructions and Lab 3-3 steps for each of the lab parts. Share the Story: You have now visualized a variety of different data types, compared different charts for analyzing and exploring categorical data, and created maps to analyze and explore geographic data. Part 1: Upload Your Files Part 2: Assessment 1 2 3 4 5 supplier_st AR WA WA MN MN WA MN MN MN 6 7 8 9 10 11 12 AR MN WA 13 14 15 16 AR AR WA AR MN MN Purchase_Order_ID Purchase_Order_Date Purchase_Employee_ID Supplier_ID Quantity_Purchased Raw Material_Purchase_Price raw_materials_description 20500 43770 1009 3 3 19.99 Malt - Barley 20501 43774 1009 2 10 29 Hops 20502 43779 1009 2 6 29 Hops 20503 43782 1008 1 12 44.99 Malt - Wheat 20504 43785 1009 1 4 19.99 Malt - Barley 20505 43788 1008 2 12 19.99 Malt - Barley 20506 43792 1009 1 5 19.99 Malt - Barley 20506 43792 1009 1 1 29 Hops 20507 43795 1009 1 1 19.99 Malt - Barley 20508 43798 1009 3 4 19.99 Malt - Barley 20509 43803 1009 1 12 19.99 Malt - Barley 20510 43808 1009 2 11 19.99 Malt - Barley 20511 43811 1008 3 6 29 Hops 20512 43815 1009 3 7 19.99 Malt - Barley 20513 43818 1008 2 11 44.99 Malt - Wheat 20514 43823 1009 3 11 44.99 Malt - Wheat 20515 43827 1009 1 4 44.99 Malt - Wheat 20516 43832 1008 1 11 29 Hops 20517 43835 1009 2 10 19.99 Malt - Barley 20518 43839 1009 1 12 29 Hops 20519 43844 1008 2 1 19.99 Malt - Barley 20520 43848 1008 1 12 29 Hops 20521 43853 1008 3 6 19.99 Malt - Barley 20522 43856 1009 3 10 44.99 Malt - Wheat 20523 43861 1009 1 8 19.99 Malt - Barley 20524 43865 1009 2 1 19.99 Malt - Barley 20525 43869 1008 3 5 44.99 Malt - Wheat 20525 43869 1009 3 2 44.99 Malt - Wheat 20525 43869 1008 3 6 29 Hops 20526 43874 1009 2 11 19.99 Malt - Barley 20527 43877 1009 2 12 19.99 Malt - Barley 20527 43877 1009 2 6 29 Hops 20528 43882 1008 1 3 19.99 Malt - Barley 20529 43885 1008 3 10 29 Hops 20530 43889 1008 3 2 19.99 Malt - Barley 20530 43889 1009 3 2 29 Hops 20531 43894 1008 3 7 29 Hops 20532 43897 1008 1 2 44.99 Malt - Wheat WA MN WA MN supplier_city Fayetteville Mabton Mabton Minneapolis Minneapolis Mabton Minneapolis Minneapolis Minneapolis Fayetteville Minneapolis Mabton Fayetteville Fayetteville Mabton Fayetteville Minneapolis Minneapolis Mabton Minneapolis Mabton Minneapolis Fayetteville Fayetteville Minneapolis Mabton Fayetteville Fayetteville Fayetteville Mabton Mabton Mabton Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minneapolis 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 AR AR MN WA AR AR AR WA WA WA MN AR AR 38 39 AR AR MN F17 fx 44.99 Supplier_IC Quantity_Purchased J 35 b 1 3 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Purchase_Order_ID 20527 20528 20529 20530 20530 20531 20532 20533 20534 20535 20536 20537 20538 20539 20540 20541 20541 20542 20542 20543 20544 Purchase_Order_Date Purchase_Employee_ID 43877 1009 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 43909 1009 43913 1009 43917 1008 43921 1009 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 3 3 3 1 1 2 3 2 2 1 3 2 Raw_Material_Purchase_Price raw materials_description 29 HOPS 3 19.99 Malt - Barley 10 29 Hops 2 19.99 Malt - Barley 2 29 Hops 7 29 Hops 2 44.99 Malt - Wheat 12 44.99 Malt - Wheat 5 44.99 Malt - Wheat 7 44.99 Malt - Wheat 12 19.99 Malt - Barley 6 29 Hops 5 44.99 Malt - Wheat 6 29 Hops 3 19.99 Malt - Barley 10 29 Hops 3 29 Hops 6 29 Hops 5 44.99 Malt - Wheat 1 44.99 Malt - Wheat 4 44.99 Malt - Wheat supplier_st WA MN AR AR AR AR MN MN WA AR WA WA MN supplier_city Iviadton Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minneapolis Minneapolis Mabton Fayetteville Mabton Mabton Minneapolis Fayetteville Mabton Fayetteville Fayetteville Minneapolis Minneapolis Minneapolis Mabton AR WA AR 3 3 1 1 AR MN MN MN WA 1 2 54 55 56 5. Switch the measure in the Geographic Data from Quantity_Purchased to Raw_Material_Purchase_Price. Which state had the lowest purchase price? Washington O Arkansas Minnesota supplier st AR WA WA MN MN supplier city Fayetteville Mabtan Mabton Minneapolis Minneapolis Mabtan Minneapolis Minneapolis WA MN Minneapolis MN MN AR IMIN WA AR AR WA AR MN MN WA MN WA 1 Purchase_Order_ID Purchase_Order_Date Purchase_Employee_ID Supplier_ID Quantity_Purchased Raw Material_Purchase_Price raw_materials_description 2 20500 43770 1009 3 3 19.99 Malt-Barley 3 20501 43774 1009 2 10 29 Haps 20502 43779 1009 2 6 29 Hops 5 20503 43782 1008 1 12 44.99 Malt-Wheat 6 20504 43785 1009 1 4 19.99 Malt-Barley 7 20505 43788 1009 2 12 19.99 Malt-Barley 8 20505 43792 1009 1 5 19.99 Malt-Barley 9 20506 43792 1009 1 1 29 Hops 10 20507 43795 1009 1 1 19.99 Malt-Barley 11 20508 43798 1009 3 4 4 19.99 Malt Barley 12 20509 43803 1009 1 12 19.99 Malt-Barley 13 20510 43808 1009 2 11 19.99 Malt-Barley 14 20511 43811 1008 3 6 29 Haps 15 20512 43815 1009 3 7 19.99 Malt Barley 16 20513 43818 1008 Z 11 44.99 Malt - Wheat 17 20514 43823 1009 3 11 44.99 Malt-Wheat 18 20515 43827 1009 1 4 44.99 Malt-Wheat 19 20516 43832 1008 1 29 Haps 20 20517 43835 1009 Z 10 19.99 Malt-Barley 21 20518 43839 1009 1 12 29 Hops 22 20519 43844 1008 2 1 19.99 Malt-Barley 23 20520 43848 1009 1 12 29 Hags 24 20521 43853 1008 3 6 19.99 Malt-Barley 25 20522 43856 1009 3 10 44.99 Malt - Wheat 26 20523 43861 1009 1 B 19.99 Malt-Barley 27 20524 43865 1009 2 1 19.99 Malt-Barley 28 20525 43869 1008 3 5 44.99 Malt - Wheat 29 20525 43869 1009 3 2 44.99 Malt-Wheat 30 20525 43869 1008 3 6 29 Haps 31 20526 43874 1009 11 19.99 Malt-Barley 32 20527 43877 1009 2 12 19.99 Malt-Barley 33 20527 43877 1009 Z Z 6 29 Hops 34 20528 43882 100B 1 3 3 19.99 Malt - Barley 35 20529 43885 100g 3 10 29 Haps 36 20530 43889 1008 3 2 19.99 Malt-Barley 37 20530 43889 1009 3 2 2 29 Hops 38 20531 43994 100 3 7 29 Haps 39 20532 43897 1008 1 2 44.99 Malt Wheat 40 20533 43902 1009 1 12 44.99 Malt - Wheat 41 20534 43905 1008 2 5 44.99 Malt-Wheat 42 20535 43909 1009 3 7 44.99 Malt - Wheat 43 20536 43913 1009 2 12 19.99 Malt-Barley 44 20537 43917 1008 2 5 29 Hops 45 20538 43921 1009 1 5 44.99 Malt - Wheat 46 20539 43925 1008 3 6 29 Haps 47 20540 43929 100g 3 19.99 Malt-Barley 48 20541 43932 1009 3 3 10 29 Hops 49 20541 43932-1003 29 Hoos Fayetteville Minneapolis Mabton Fayetteville Fayetteville Mabton Fayetteville Minneapolis Minneapalis Mabton Minneapolis Mabtan Minneapolis Fayetteville Fayetteville MIN AR AR MN WA Minneapolis AR AR AR WA WA WA MN AR AR AR AR MN MN Mabtan Fayetteville Fayetteville Fayetteville Mabtan Mabton Mabton Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minneapolis Minneapolis Mabton Fayetteville Mabtan Mabton Minneapolis Fayetteville Mabtan Fayetteville Fayetteville WA AR WA WA MN AR WA AR AR 44 2 6 WA 20537 20538 20539 1 45 46 47 5 MN AR 3 6 20540 2 3 WA AR 48 3 10 43917 1008 43921 1009 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 29 Hops 44.99 Malt - Wheat 29 Hops 19.99 Malt - Barley 29 Hops 29 Hops 29 Hops 44.99 Malt - Wheat 44.99 Malt - Wheat 44.99 Malt - Wheat Mabton Minneapolis Fayetteville Mabton Fayetteville Fayetteville Minneapolis Minneapolis Minneapolis Mabton 3 20541 20541 20542 20542 20543 20544 3 1 49 50 51 52 6 5 AR MN MN MN 1 1 1 2 4 WA 53 54 55 Required information [The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Create the String Data sheet and work through the different ways of visualizing proportions and counts. 2. Create the Geographic Data sheet and work through symbol and filled maps for quantity purchased. Ask the Question: How do data types affect the way I can analyze data in Tableau? Master the Data: This lab is a continuation of Lab 3-2. Make sure to work through the Master the Data steps in Lab 3-2 before proceeding to this lab to ensure that you have imported the data from Lab 3-2 and changed all the data types appropriately according to Steps 1 and 2. Software needed Tableau Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: 3-3 Alt Data.twbx or you may use your solution file for Lab 3-2 Alt Data.xlsx. Perform the Analysis: Refer to Lab 3-3 Alternate in the text for instructions and Lab 3-3 steps for each of the lab parts. Share the Story: You have now visualized a variety of different data types, compared different charts for analyzing and exploring categorical data, and created maps to analyze and explore geographic data. Part 1: Upload Your Files Part 2: Assessment 1 2 3 4 5 supplier_st AR WA WA MN MN WA MN MN MN 6 7 8 9 10 11 12 AR MN WA 13 14 15 16 AR AR WA AR MN MN Purchase_Order_ID Purchase_Order_Date Purchase_Employee_ID Supplier_ID Quantity_Purchased Raw Material_Purchase_Price raw_materials_description 20500 43770 1009 3 3 19.99 Malt - Barley 20501 43774 1009 2 10 29 Hops 20502 43779 1009 2 6 29 Hops 20503 43782 1008 1 12 44.99 Malt - Wheat 20504 43785 1009 1 4 19.99 Malt - Barley 20505 43788 1008 2 12 19.99 Malt - Barley 20506 43792 1009 1 5 19.99 Malt - Barley 20506 43792 1009 1 1 29 Hops 20507 43795 1009 1 1 19.99 Malt - Barley 20508 43798 1009 3 4 19.99 Malt - Barley 20509 43803 1009 1 12 19.99 Malt - Barley 20510 43808 1009 2 11 19.99 Malt - Barley 20511 43811 1008 3 6 29 Hops 20512 43815 1009 3 7 19.99 Malt - Barley 20513 43818 1008 2 11 44.99 Malt - Wheat 20514 43823 1009 3 11 44.99 Malt - Wheat 20515 43827 1009 1 4 44.99 Malt - Wheat 20516 43832 1008 1 11 29 Hops 20517 43835 1009 2 10 19.99 Malt - Barley 20518 43839 1009 1 12 29 Hops 20519 43844 1008 2 1 19.99 Malt - Barley 20520 43848 1008 1 12 29 Hops 20521 43853 1008 3 6 19.99 Malt - Barley 20522 43856 1009 3 10 44.99 Malt - Wheat 20523 43861 1009 1 8 19.99 Malt - Barley 20524 43865 1009 2 1 19.99 Malt - Barley 20525 43869 1008 3 5 44.99 Malt - Wheat 20525 43869 1009 3 2 44.99 Malt - Wheat 20525 43869 1008 3 6 29 Hops 20526 43874 1009 2 11 19.99 Malt - Barley 20527 43877 1009 2 12 19.99 Malt - Barley 20527 43877 1009 2 6 29 Hops 20528 43882 1008 1 3 19.99 Malt - Barley 20529 43885 1008 3 10 29 Hops 20530 43889 1008 3 2 19.99 Malt - Barley 20530 43889 1009 3 2 29 Hops 20531 43894 1008 3 7 29 Hops 20532 43897 1008 1 2 44.99 Malt - Wheat WA MN WA MN supplier_city Fayetteville Mabton Mabton Minneapolis Minneapolis Mabton Minneapolis Minneapolis Minneapolis Fayetteville Minneapolis Mabton Fayetteville Fayetteville Mabton Fayetteville Minneapolis Minneapolis Mabton Minneapolis Mabton Minneapolis Fayetteville Fayetteville Minneapolis Mabton Fayetteville Fayetteville Fayetteville Mabton Mabton Mabton Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minneapolis 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 AR AR MN WA AR AR AR WA WA WA MN AR AR 38 39 AR AR MN F17 fx 44.99 Supplier_IC Quantity_Purchased J 35 b 1 3 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Purchase_Order_ID 20527 20528 20529 20530 20530 20531 20532 20533 20534 20535 20536 20537 20538 20539 20540 20541 20541 20542 20542 20543 20544 Purchase_Order_Date Purchase_Employee_ID 43877 1009 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 43909 1009 43913 1009 43917 1008 43921 1009 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 3 3 3 1 1 2 3 2 2 1 3 2 Raw_Material_Purchase_Price raw materials_description 29 HOPS 3 19.99 Malt - Barley 10 29 Hops 2 19.99 Malt - Barley 2 29 Hops 7 29 Hops 2 44.99 Malt - Wheat 12 44.99 Malt - Wheat 5 44.99 Malt - Wheat 7 44.99 Malt - Wheat 12 19.99 Malt - Barley 6 29 Hops 5 44.99 Malt - Wheat 6 29 Hops 3 19.99 Malt - Barley 10 29 Hops 3 29 Hops 6 29 Hops 5 44.99 Malt - Wheat 1 44.99 Malt - Wheat 4 44.99 Malt - Wheat supplier_st WA MN AR AR AR AR MN MN WA AR WA WA MN supplier_city Iviadton Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minneapolis Minneapolis Mabton Fayetteville Mabton Mabton Minneapolis Fayetteville Mabton Fayetteville Fayetteville Minneapolis Minneapolis Minneapolis Mabton AR WA AR 3 3 1 1 AR MN MN MN WA 1 2 54 55 56 5. Switch the measure in the Geographic Data from Quantity_Purchased to Raw_Material_Purchase_Price. Which state had the lowest purchase price? Washington O Arkansas Minnesota