D Asplyengtiblea Roturnonimetment famplata (2) tome Insert Draw Pagelayout Formulas Data Review View Autemate Developer 9 Tel me C11: :mx Calleway cemeany +1 Cose 1000 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.] Calloway Company is a merchandiser that has nrovided the follewing operating results for this year. For next year the company is considering three investment alternatives with the following estimated incremental sales, variable expenses, fixed expenses, and operating assets: You have been asked to create some data visualizations that depict the projected margin, turnover, and return on investment (ROl) for the three investment alternatives relative to this year's performance. Downioad the Excel file, which you will use to create the Tableau visualization that aid your explanation. 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. Since the only worksheet in the Excel File is "Calloway Company" it will default as a selection with no further import steps needed reate a formula that calculates this year's margin and the estimated margin for each of the three investment alternatives. Then epare a horizontal bar chart that compares the four margins for the four scenarios: Begin by creating a new calculated field Click on "Analysis" from the menu dropdowns at the top and choose "Create a calculated field" - Replace the current calculated field name "Calculationt" with "Margin" - Type in the following formula: - [Net operating income)(Sales] - This formula is stating that you want the value of the Net operating income divided by the Sales Double click on "new sheet" at the bottom of the workbook and change the name of the newly created "Sheet 1" to "Margin Analysis" - On the left-hand side under "Dimensions" (sometimes labeled as Tables), double-click on "Option" - On the lefthand side under "Measures", double click on the newly created measure of "Margin" - In the upper right-hand corner, click on "Show Me" and choose the "Horizontal bars" option in the ist column third row down. - On the left-hand side under "Dimensions" (sometimes labeled as Tables), click on "Option" and drag and drop it onto the "Colors" Marks card (":). io This will allow the options to stand out better - Click on the Label button ( I ) at the top of the screen" to show the margin values - 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," - Your visualization should appear as follows: 1 1+1= Morgin Anolysin Required: Wote that for all questions below you may select more than one answer. Single click the box with the quention mark to prodice a check mark for a correct answer and double click the bos with the question mark to empty the box for a wrong answer. Amy boxes left with a question mark will be automatically graded as incorrect.) 1a. Whict of the following investment eltematives for next year earns the highest margin? INote that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) 16. Which of the following investment alternatives for next year earns the highest margin? 2 Option 1 Option 2 3 option 3 7b. Which of the following investment alternatives for next year earns the lowest margin? Opeon 1 Option 2 Opton 3 1c. Which of the following statements is true? Twa of ve sure eptions sem a byher magm than mis peat D Asplyengtiblea Roturnonimetment famplata (2) tome Insert Draw Pagelayout Formulas Data Review View Autemate Developer 9 Tel me C11: :mx Calleway cemeany +1 Cose 1000 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.] Calloway Company is a merchandiser that has nrovided the follewing operating results for this year. For next year the company is considering three investment alternatives with the following estimated incremental sales, variable expenses, fixed expenses, and operating assets: You have been asked to create some data visualizations that depict the projected margin, turnover, and return on investment (ROl) for the three investment alternatives relative to this year's performance. Downioad the Excel file, which you will use to create the Tableau visualization that aid your explanation. 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. Since the only worksheet in the Excel File is "Calloway Company" it will default as a selection with no further import steps needed reate a formula that calculates this year's margin and the estimated margin for each of the three investment alternatives. Then epare a horizontal bar chart that compares the four margins for the four scenarios: Begin by creating a new calculated field Click on "Analysis" from the menu dropdowns at the top and choose "Create a calculated field" - Replace the current calculated field name "Calculationt" with "Margin" - Type in the following formula: - [Net operating income)(Sales] - This formula is stating that you want the value of the Net operating income divided by the Sales Double click on "new sheet" at the bottom of the workbook and change the name of the newly created "Sheet 1" to "Margin Analysis" - On the left-hand side under "Dimensions" (sometimes labeled as Tables), double-click on "Option" - On the lefthand side under "Measures", double click on the newly created measure of "Margin" - In the upper right-hand corner, click on "Show Me" and choose the "Horizontal bars" option in the ist column third row down. - On the left-hand side under "Dimensions" (sometimes labeled as Tables), click on "Option" and drag and drop it onto the "Colors" Marks card (":). io This will allow the options to stand out better - Click on the Label button ( I ) at the top of the screen" to show the margin values - 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," - Your visualization should appear as follows: 1 1+1= Morgin Anolysin Required: Wote that for all questions below you may select more than one answer. Single click the box with the quention mark to prodice a check mark for a correct answer and double click the bos with the question mark to empty the box for a wrong answer. Amy boxes left with a question mark will be automatically graded as incorrect.) 1a. Whict of the following investment eltematives for next year earns the highest margin? INote that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) 16. Which of the following investment alternatives for next year earns the highest margin? 2 Option 1 Option 2 3 option 3 7b. Which of the following investment alternatives for next year earns the lowest margin? Opeon 1 Option 2 Opton 3 1c. Which of the following statements is true? Twa of ve sure eptions sem a byher magm than mis peat