1. Create the String Data sheet and work through the different ways of visualizing proportions and...

 

Transcribed Image Text:

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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344 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 D E 1 Purchase Order JD Purchase_Order_Date Purchase_Employee_D Supplier ID Quantity_Purchased - Raw_Materlal_Purchase_Price raw_materials description 19.99 Malt -Barley supplier st supplier city Fayetteville 43770 1009 43774 1009 43779 1009 2 20500 3 AR 3 20501 2 10 29 Ноps 29 Hops WA Mabton 4 20502 2. WA Mahton 43782 1008 43785 1009 43788 1008 43792 1009 43792 1009 43795 1009 43798 1009 43803 1009 43808 1009 43811 1008 43815 1a09 20503 44.99 Malt- Wheat Minneapolis 1 1 12 MN 6 20504 4 19.99 Malt - Barley MN Minneapolis 7. 20505 2 12 19.99 Malt - Barley WA Mabton 20506 5 19.99 Malt - Barley Minneapolis MN 9 20506 1 29 Hops MN Minneapolis 10 20507 1 1 19.99 Malt -Barley MN Minneapolis 19.99 Malt - Barley Fayetteville Minneapolis Mabton Fayetteville Fayetteville 11 20508 3 4 AR 12 20509 1 12 19.99 Malt - Barley IMN 13 20510 11 19.99 Malt- Barley WA 3. 6 29 Норs 19.99 Malt - Barley 14 20511 AR 15 20512 3 7 AR 43818 1008 43823 1009 43827 1009 43832 1008 43835 1009 43839 1009 43844 1008 43848 1008 43853 1008 43856 1009 43861 1009 43865 1009 43869 1008 43869 1009 16 20513 11 44.99 Malt -Wheat WA Mabton 17 20514 3 11 44.99 Malt - Wheat AR Fayetteville 18 20515 1 4 44.99 Malt - Wheat MN Minneapolis Minneapolis 19 20516 1 11 29 Hops MN 20 20517 10 19.99 Malt - Barley WA Mabton 21 20518 12 29 Ноps MN Minneapolis 1 19.99 Malt - Barley 29 Hops 19.99 Malt - Barley 44.99 Malt - Wheat 19.99 Malt- Barley 22 20519 WA Mabton Minneapolis Fayetteville Fayetteville Minneapolis 23 20520 1 12 MN 24 20521 AR 25 20522 3 10 AR 26 20523 1 MN 27 20524 1 19.99 Malt - Barley WA Mabton 28 20525 3. 5 44.99 Malt - Wheat AR Fayetteville 29 20525 3 2 44.99 Malt -Wheat AR Fayetteville Fayetteville 43869 1008 43874 1009 30 20525 29 Hops AR 31 20526 2 11 19.99 Malt - Barley WA Mabton 43877 1009 43877 1009 32 20527 2 12 19.99 Malt - Barley WA Mabton 33 20527 2 29 Hops 19.99 Malt- Rarley WA Mabton 43882 1008 43885 1008 43889 1008 43889 1009 43894 1008 43897 1008 43902 1009 43905 1008 Minneapolis Fayetteville Fayetteville 34 20528 1 3 MN 35 20529 3. 10 29 Hops AR 36 20530 3 19.99 Malt - Barley AR 37 20530 2 29 Hops AR Fayetteville Fayetteville 38 20531 3. 29 Ноps AR 39 20532 1 2 44.99 Malt-Wheat MN Minneapolis Minneapolis 40 20533 1 12 44.99 Malt - Wheat MN 41 20534 5 44.99 Malt - Wheat WA Mabton 43909 1009 43913 1009 43917 1008 43921 1009 44.99 Malt -Wheat 19.99 Malt - Barley 42 20535 AR Fayetteville 43 20536 12 WA Mabton 44 20537 29 Hops 44.99 Malt . Wheat WA Mabton 45 20538 1 Minneapolis Fayetteville Mabton Fayetteville MN 43925 1008 43929 1008 43932 1009 43932 1008 43935 1009 43935 1009 43939 1009 43942 1008 46 20539 6 29 Hops AR 19.99 Malt - Barley 29 Hops 47 20540 3 WA 48 20541 3. 10 AR 49 20541 3. 3 29 Hops AR Fayetteville 50 20542 1 6 29 Hops MN Minneapolis 51 20542 1 44.99 Malt - Wheat MN Minneapolis 52 20543 1. 44.99 Malt .Wheat MN Minneapolis 53 20544 4. 44.99 Malt - Wheat WA Mahton Required: 1. From which state were the most products purchased? O Arkansas O Minnesota O Washington 2. How many products were purchased from Arkansas? O 134 O 135 O 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley О Ноps 4. How many purchase orders were generated grand total (count, across all states and products)? O 152 O 98 O 52 О 344

Answer rating: 100% (QA)

Answer to question 1 Option 3 is correct ie Washington Supplier State T... View the full answer