You should start and save a new Tableau file for each Chapter. Roger Company's files can...

  
 

Transcribed Image Text:

You should start and save a new Tableau file for each Chapter. Roger Company's files can be downloaded from Connect in Excel format (Click here). For Chapter 5, you will import the Roger Company shipping file. See Chapter 4 for instructions on how to import Excel files to Tableau. In this question, we will use Tableau's forecast function to forecast sales in 2018 Q4, and then compare forecasted sales to actual values as a final/review analytical procedure. Roger Company management has acknowledged that monthly sales are volatile. • After importing the shipping file, open a new worksheet (tab) and call it Q4 Forecast. To perform a forecast, first right-click on Invoice Date in the Dimension pane and convert to a Continuous value. • Add Invoice Total to the Rows line, and Invoice Date to the Columns line. Expand the invoice date until sales are shown by month. Add Invoice Date from Dimensions to the Filter pane, select Range of Dates, and set the date filter to include all invoices through the end of September, 2018, then click apply (Note: if September does not appear in the forecast, you can set the end date as October 1, 2018). • To add the forecast, click on the 'Analytics' tab next to the 'Data' tab towards the top-left corner of Tableau. • Under Model, drag and drop Forecast on the line chart. • Left-click on the flat forecast line, and press edit to change Forecast options. • We only want to forecast 2018 Q4, so change to forecast exactly three months, ignoring 0 months. • Change the Forecast Model from Automatic to Custom, and add in Additive trend. Click OK. Required: 1. This now provides a forecast, based on 2017 and 2018 data, for sales in Q4 2018. a) What are forecasted sales for October 2018? b) What are forecasted sales for November 2018? c) What are forecasted sales for December 2018? 2. To obtain actual values, create a new worksheet (tab), add Invoice Total to the Rows line, and add Invoice Date to the Columns line, expanding until months are shown. d) What are actual sales for October 2018? e) What are actual sales for November 2018? f) What are actual sales for December 2018? Complete this question by entering your answers in the tabs below. Complete this question by entering your answers in the tabs below. Required 1 Required 2 a) What are forecasted sales for October 2018? b) What are forecasted sales for November 2018? c) What are forecasted sales for December 2018? Forecasted sales for 2018 October November December Required 1 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 d) What are actual sales for October 2018? e) What are actual sales for November 2018? f) What are actual sales for December 2018 Actual sales for 2018 October November December < Required 1 Required 2 > You should start and save a new Tableau file for each Chapter. Roger Company's files can be downloaded from Connect in Excel format (Click here). For Chapter 5, you will import the Roger Company shipping file. See Chapter 4 for instructions on how to import Excel files to Tableau. In this question, we will use Tableau's forecast function to forecast sales in 2018 Q4, and then compare forecasted sales to actual values as a final/review analytical procedure. Roger Company management has acknowledged that monthly sales are volatile. • After importing the shipping file, open a new worksheet (tab) and call it Q4 Forecast. To perform a forecast, first right-click on Invoice Date in the Dimension pane and convert to a Continuous value. • Add Invoice Total to the Rows line, and Invoice Date to the Columns line. Expand the invoice date until sales are shown by month. Add Invoice Date from Dimensions to the Filter pane, select Range of Dates, and set the date filter to include all invoices through the end of September, 2018, then click apply (Note: if September does not appear in the forecast, you can set the end date as October 1, 2018). • To add the forecast, click on the 'Analytics' tab next to the 'Data' tab towards the top-left corner of Tableau. • Under Model, drag and drop Forecast on the line chart. • Left-click on the flat forecast line, and press edit to change Forecast options. • We only want to forecast 2018 Q4, so change to forecast exactly three months, ignoring 0 months. • Change the Forecast Model from Automatic to Custom, and add in Additive trend. Click OK. Required: 1. This now provides a forecast, based on 2017 and 2018 data, for sales in Q4 2018. a) What are forecasted sales for October 2018? b) What are forecasted sales for November 2018? c) What are forecasted sales for December 2018? 2. To obtain actual values, create a new worksheet (tab), add Invoice Total to the Rows line, and add Invoice Date to the Columns line, expanding until months are shown. d) What are actual sales for October 2018? e) What are actual sales for November 2018? f) What are actual sales for December 2018? Complete this question by entering your answers in the tabs below. Complete this question by entering your answers in the tabs below. Required 1 Required 2 a) What are forecasted sales for October 2018? b) What are forecasted sales for November 2018? c) What are forecasted sales for December 2018? Forecasted sales for 2018 October November December Required 1 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 d) What are actual sales for October 2018? e) What are actual sales for November 2018? f) What are actual sales for December 2018 Actual sales for 2018 October November December < Required 1 Required 2 >

Answer rating: 100% (QA)

You havent provided an Import file that contains the total bill forecasted or actual But ... View the full answer