Question: Chapter 4 The remaining Tableau assignments will use files related to a fictitious audit client called Roger Company. You should start and save a new

 Chapter 4 The remaining Tableau assignments will use files related to

a fictitious audit client called Roger Company. You should start and save

Chapter 4 The remaining Tableau assignments will use files related to a fictitious audit client called Roger Company. You should start and save a new Tableau file for each Chapter. Roger Company is a mid-size company that handles the distribution of various home and garden products. You are part of the engagement team assigned to audit Roger Company's financial statements. This year, you are auditing financial statements from the calendar year 2018. Roger Company's files can be downloaded from Connect in Excel format. Download all files and save in a place where you can find them later. For Chapter 4, you will import the Roger Company shipping file, which acts as its sales ledger. To import the file, open Tableau to create a new workbook, then connect to an Excel file. Browse and find the shipping file, then press Open. Click on Sheet 1 to begin your analysis.1 You have data on Roger Company's sales for all of 2018 (the year under audit) and portions of 2017 and 2019. Sales have been intermittent, with some months having very few sales, while others have a high sales volume. 1. As a risk assessment procedure, plot a monthly revenue trend to get an overall feel for the sales trend for 2018 only. I Drag and drop Invoice Total (in Measures section) to the Rows line. ' Drag Invoice Date (in Dimensions section) to the Columns line. This presents revenue by year. 0 Press the \"+\" sign next to YEAR in the Columns line, then press \"+\" next to QUARTER. ' Remove YEAR and QUARTER from the Columns row. This nowr displays total sales (note the \"SUM\" next to Invoice Total in the Rows line) by month for the entire sample period. ' To only include 2018's data, drag Invoice Date to the Filter panel. I Double-click on Year, check 2018, and press Apply. 0 Save tab as 2018 Revenue Trend. What three months had the highest sales in 2018

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!