Hi! Thank you so much in advance for the help!
Required information To complete this exercise, you will need to download and install Tableau on your computer. Tableau provides free instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableau's short training videos can be found here. [The following information applies to the questions displayed below.] Dunder Company sells five types of lumber (Maple, Oak, Walnut, Pine, and Cedar) within 10 states located in the southeastern quadrant of the United States. Its 27 sales representatives completed 1,000 sales transactions during the most recent 12 -month period. The company's CFO would like your assistance in creating some Tableau visualizations that enable her to better understand the sales representatives' performance. Download the Excel file, which you will use to create the Tableau visualizations requested by the CFO. Upload the Excel file into Tableau by doing the following: 1. Open the Tableau Desktop application. 2. On the left-hand side, under the "Connect" header and the "To a file" sub-header, click on "Microsoft Excel." 3. Choose the Excel file and click "Open." 4. On the left-hand side under "Sheets," double click on "Dunder_Company." Create a box-and-whisker chart that summarizes each Salesperson's cumulative sales by type of lumber during the 12-month period. Box-and-whisker visualizations allow us to see the minimum and maximum values as well as the median value by breaking the data into four quartiles. The lowest 25% of values fall between the minimum line (whisker) and the bottom of the box, while the middle 50% fall within the "box", and finally the highest 25% fall between the top of the box and the maximum line (whisker). This visualization approach allows us to see the range of the data as well as which data points fall closest to our median. - Click on the "New Worksheet" button at the bottom of your Worksheet: - Double-click on the newly created "Sheet 3" at the bottom and rename it "Sales by Salesperson by Product." - On the left-hand side under "Dimensions" (sometimes labeled as Tables) click on "Order Prod" and drag it to the "Columns" area above the blank sheet. - On the left-hand side under "Dimensions" (sometimes labeled as Tables) click on "Salesperson" and drag it to the "Rows" area. - On the left-hand side under "Measures," double-click on "Order Amount." - In the upper right-hand corner of the screen, click on "Show Me," then select the "Box and Whisker Plot" option, seven rows down in the far-right column. - On the left-hand side under "Dimensions" (sometimes labeled as Tables) click on "Salesperson" and drag it to the "Color" Marks card. - You can hover over the data points to get the Salesperson and the amount. Required: 3a. Which Salesperson has the highest annual sales for Cedar? What is the amount? 3b. Which Salesperson has the highest annual sales for Walnut? What is the amount? 3c. Which Salesperson has the lowest annual sales for Maple? What is the amount? 3d. Which Salesperson has the lowest annual sales for Pine? What is the amount? 3e. Which Salesperson has the 2nd highest annual sales for Oak? What is the amount? Required information To complete this exercise, you will need to download and install Tableau on your computer. Tableau provides free instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableau's short training videos can be found here. [The following information applies to the questions displayed below.] Dunder Company sells five types of lumber (Maple, Oak, Walnut, Pine, and Cedar) within 10 states located in the southeastern quadrant of the United States. Its 27 sales representatives completed 1,000 sales transactions during the most recent 12 -month period. The company's CFO would like your assistance in creating some Tableau visualizations that enable her to better understand the sales representatives' performance. Download the Excel file, which you will use to create the Tableau visualizations requested by the CFO. Upload the Excel file into Tableau by doing the following: 1. Open the Tableau Desktop application. 2. On the left-hand side, under the "Connect" header and the "To a file" sub-header, click on "Microsoft Excel." 3. Choose the Excel file and click "Open." 4. On the left-hand side under "Sheets," double click on "Dunder_Company." Create a box-and-whisker chart that summarizes each Salesperson's cumulative sales by type of lumber during the 12-month period. Box-and-whisker visualizations allow us to see the minimum and maximum values as well as the median value by breaking the data into four quartiles. The lowest 25% of values fall between the minimum line (whisker) and the bottom of the box, while the middle 50% fall within the "box", and finally the highest 25% fall between the top of the box and the maximum line (whisker). This visualization approach allows us to see the range of the data as well as which data points fall closest to our median. - Click on the "New Worksheet" button at the bottom of your Worksheet: - Double-click on the newly created "Sheet 3" at the bottom and rename it "Sales by Salesperson by Product." - On the left-hand side under "Dimensions" (sometimes labeled as Tables) click on "Order Prod" and drag it to the "Columns" area above the blank sheet. - On the left-hand side under "Dimensions" (sometimes labeled as Tables) click on "Salesperson" and drag it to the "Rows" area. - On the left-hand side under "Measures," double-click on "Order Amount." - In the upper right-hand corner of the screen, click on "Show Me," then select the "Box and Whisker Plot" option, seven rows down in the far-right column. - On the left-hand side under "Dimensions" (sometimes labeled as Tables) click on "Salesperson" and drag it to the "Color" Marks card. - You can hover over the data points to get the Salesperson and the amount. Required: 3a. Which Salesperson has the highest annual sales for Cedar? What is the amount? 3b. Which Salesperson has the highest annual sales for Walnut? What is the amount? 3c. Which Salesperson has the lowest annual sales for Maple? What is the amount? 3d. Which Salesperson has the lowest annual sales for Pine? What is the amount? 3e. Which Salesperson has the 2nd highest annual sales for Oak? What is the amount
