Required information [The following information applies to the questions displayed below.] NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Create the String Data sheet and work through the different ways of visualizing proportions and counts. 2. Create the Geographic Data sheet and work through symbol and filled maps for quantity purchased. Ask the Question: How do data types affect the way I can analyze data in Tableau? Master the Data: This lab is a continuation of Lab 3-2. Make sure to work through the Master the Data steps in Lab 3-2 before proceeding to this lab to ensure that you have imported the data from Lab 3-2 and changed all the data types appropriately according to Steps 1 and 2. Software needed Tableau Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) . Data: 3-3 Alt Data.twbx or you may use your solution file forLab 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 19.99 Malt - Barley Purchase_Employee_ID Supplier_ID Quantity_Purchased Raw_Material_Purchase_Price raw_materials_description supplier_st 1700 3792 1009 13792 1009 3700 na 3803 1999 43808 1009 14.99 Mall - Wheat 19.99 Malt-Barley 19.99 Malt-Barley 9. Hops 19.99 Malt-Barley 19.99 Malt-Barley 9.99 Malt-Barley 9 Hops 20510 05.12 20519 20515 20516 1.99 Malt - Barley 20518 05. 20520 20577 20523 2009 20525 20525 43823 1009 43827 1009 4 3839 1009 3844 1008 3848 1008 178 in 42861 1009 43865 2009 28691009 9.99 Malt - Barley 0.99 Malt-Barley 14.99 Malt Wheat 9.99 Malt - Harley 19.99 Malt Barley 44.99 Malt Wheet 29 Hops 13.99 Malt-Barley 9.99 Malt - Barley 9.99 Malt-Barley 20528 2092 20330 Sara 20532 24 2 48892 1998 13885 1008 10 43994 1008 43897 1008 Asancos 43909 1009 439131009 *** 4407408 11070 100g 43932 1009 43932 1008 43935 1009 439291009 40930 20537 oran 29 Hops 44.99 Malt-Wheat 44.99 Malt - Wheat 44.99 Malt Wheat 19.99 Malt-Barley 29 Hops *** wait when 9.99 Malt-Barley 29 Hops 29 Hops 4.99 M. When 14.99 Malt Wheat 44.99 Malt Wheat 20540 20541 20547 20543 Required: 1. From which state were the most products purchased? O Arkansas O Minnesota Washington 2. How many products were purchased from Arkansas? O 134 O 135 0 979 O 107 3. Which product had the largest proportion of purchase orders? O Malt-Wheat O Malt-Barley O Hops 4. How many purchase orders were generated grand total (count, across all states and products)? 152 098 O 52 O 344 5. Switch the measure in the Geographic Data from Quantity_Purchased to Raw_Material_Purchase_Price. Which state had the lowest purchase price? Washington Arkansas Minnesota