Required information Skip to question 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 companys 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 Open the Tableau Desktop application On the left hand side, under the Connect header and the To a file sub header, click on Microsoft Excel Choose the Excel file and click Open On the left hand side under Sheets, double click on Dunder Company Create a bar chart that summarizes each Salespersons cumulative sales by month during the 12 month period Click on the New Worksheet button at the bottom of your Worksheet Double click on the newly created Sheet 4 at the bottom and rename it Sales by Salesperson by Month On the left hand side under Dimensions (sometimes labeled as Tables) click on Order Month and drag it to the Columns area above the blank sheet, On the left hand side under Measures, click on Order Amount and drag it to the Rows area In the upper right hand corner of the screen, click on Show Me, then select the Circle Views option, which is four rows down in the middle column This will move the Order Month to the Color Marks carddrag it from the Marks card area back to columns On the left hand side under Dimensions (sometimes labeled as Tables) click on Salesperson and drag it into the Color Marks card A Warning window may pop up, if so, choose the option that states Add all members To improve viewing, locate the Standard dropdown option in the menu bar at the top of the screen Click on that dropdown and choose Entire View You can hover over the data points to get the Salesperson and the amount Required 4a Which Salesperson has the highest sales for January What is the amount 4b Which Salesperson has the 2nd highest sales for April What is the amount 4c Which Salesperson has the lowest sales for July What is the amount 4d Which Salesperson has the lowest sales for September What is the amount 4e Which Salesperson has the 2nd highest sales for December What is the amount

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 10, 2024

Required information Skip to question [The following information applies to the questions displayed below.] Dunder Company sells five types of lumber (Maple, Oak, Walnut, Pine,

Required information

Skip to question

[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 companys 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:

Open the Tableau Desktop application.
On the left-hand side, under the Connect header and the To a file sub-header, click on Microsoft Excel.
Choose the Excel file and click Open.
On the left-hand side under Sheets, double click on Dunder_Company.

Create a bar chart that summarizes each Salespersons cumulative sales by month during the 12-month period.

Click on the New Worksheet button at the bottom of your Worksheet:
Double-click on the newly created Sheet 4 at the bottom and rename it Sales by Salesperson by Month.
On the left-hand side under Dimensions (sometimes labeled as Tables) click on Order Month and drag it to the Columns area above the blank sheet,
On the left-hand side under Measures, click on Order Amount and drag it to the Rows area.
In the upper right-hand corner of the screen, click on Show Me, then select the Circle Views option, which is four rows down in the middle column
- This will move the Order Month to the Color Marks carddrag it from the Marks card area back to columns.
On the left-hand side under Dimensions (sometimes labeled as Tables) click on Salesperson and drag it into the Color Marks card.
- A Warning window may pop up, if so, choose the option that states Add all members.
To improve viewing, locate the Standard dropdown option in the menu bar at the top of the screen. Click on that dropdown and choose Entire View.
You can hover over the data points to get the Salesperson and the amount.

Required: 4a. Which Salesperson has the highest sales for January? What is the amount? 4b. Which Salesperson has the 2nd-highest sales for April? What is the amount? 4c. Which Salesperson has the lowest sales for July? What is the amount? 4d. Which Salesperson has the lowest sales for September? What is the amount? 4e. Which Salesperson has the 2nd-highest sales for December? What is the amount?