1. Create the String Data sheet and work through the different ways of visualizing proportions and...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Answer to question 1 Option 3 is correct ie Washington Supplier State T... View the full answer
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-0078110894
6th Edition
Authors: Edmonds, Tsay, olds
Posted Date:
Students also viewed these mathematics questions
-
The norm of a linear transformation TA: Rn Rn can be defined by where the maximum is taken over all nonzero x in Rn. (The subscript indicates that the norm of the linear transformation on the left is...
-
Suppose that f: Rn R and g: Rn Rn are differentiable on Rn and that there exist r > 0 and a Rn such that Dg(x) is the identity matrix, I, for all x Br(a). Prove that there is a function h: Br(a) {a}...
-
Let 5: Rn Rn and T: Rn Rn be linear transformations with matrices A and B respectively. [Theorem 3.] (a) Show that B2 = B if and only if T2 = 7 (where T2 means T o T). (b) Show that B2 = 1 if and...
-
Who are the uppers in your life? Do you have any downers or vultures?
-
From the text Web site, link to the site of the Federal Reserve Bank of St. Louis; also, see the Guide to St. Louis Fed Data." Get data on the inflation rate and the interest rate on 90-day Treasury...
-
Refer to the Journal of Earthquake Engineering study of the time Y (in years) between major earthquakes occurring in the Iranian Plateau, Exercise 5.7. Recall that Y has the following density...
-
General Systems is a firm that manufactures personal computers. As a top manager in the firm, you are considering changes in the way the firm is run. Currently, the firm has after-tax operating...
-
Shown below and on the next page are comparative balance sheets for Schmitt Company. Additional information: 1. Net income for 2014 was $93,000. 2. Depreciation expense was $34,000. 3. Cash dividends...
-
For each of the following intangible assets, indicate the amountof amortization expense that should be recorded for the year 2017and the amount of accumulated amortization on the balance sheet asof 2...
-
You are discussing your 401(k) with Dan Ervin when he mentions that Sarah Brown, a representative from Bledsoe Financial Services, is visiting East Coast Yachts today. You decide that you should meet...
-
21. Refer to Figure 3-20. At the equilibrium price, consumer surplus is a. $480. b. $640. c. $1,120. d. $1,280.
-
Data Analysis for Strategic decision making Complete the data analysis (attach your tables or data representations as appendices to your paper as Appendices) Begin writing your proposal for how the...
-
Discuss the role of RNA interference (RNAi) in gene regulation. What are the potential applications of RNAi technology in medical research and therapeutic interventions ?
-
Prime Corporation acquired 100 percent ownership of Steak Products Company on January 1, 20X1, for $295,000. On that date, Steak reported retained earnings of $88,000 and had $119,000 of common stock...
-
Manufacturing overhead has an underallocated balance of $12,500; raw materials inventory balance is $145,900; work in process inventory is $123,000; finished goods inventory is $140,100; and cost of...
-
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in...
-
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for the last year: Sales $894,620,000 Less: Variable expenses 557,305,000...
-
MgO prevents premature evaporation of Al in a furnace by maintaining the aluminum as Al2O3. Another type of matrix modifier prevents loss of signal from the atom X that readily forms the molecular...
-
What is the objective of allocating indirect manufacturing overhead costs to the product?
-
How does the concept of predominant control as opposed to that of absolute control apply to responsibility accounting?
-
What are three approaches to establishing transfer prices? List the most desirable approach first and the least desirable last.
-
For the following problems, propose a verification and validation tests of the CFD solution. a) Flow in confluence of two rivers. b) Wind flow around a smokestack of a coal power station and the...
-
The terms real, intangible and monetary all relate to a particular accounting concept. What is it?
-
In each of the following situations, determine which type of the error (physical model, discretization, iteration, or programming) is most likely responsible for poor performance. In each case,...
Study smarter with the SolutionInn App