Page

Tableau assignment 2 Assignment 2 Case Tableau Background: See Chapter 1. The forensic accounting analysis determined that two accounting personnel were identified as inappropriately receiving disbursements through the contract attorney payroll. Administrative personnel paid through the contract attorney payroll were identified as 1 in the variable column AEmp. Question. Which clients, if any, were invoiced for payroll disbursed to accounting personnel? 1. Ensure that all categorical variables are included in the Dimensions frame (blue square) 2. Ensure that all numerical variables are included in the Measures frame (red square) 3. If not, drag variable to the appropriate location

4. Note: The Fairmont Payroll and Sales File has a dichotomous variable labeled AEmp to denote administrative employees (that should not appear on the contract attorney payroll disbursements file) 5. Drag the dimension variable AEmp to the columns shelf 6. Drag the measures variable Invoices to the row shelf 7. To have Tableau automatically present the total for each bar in the chart, drag invoice from measures and drop into the Label box within Marks 8. Right-click on Sheet 1 and rename the worksheet to Customer Billing 9. Note: Client billings for accounting personnel payroll (AEmp = 1) total $483,549

10. Right click on the Customer Billing worksheet (near the bottom) and copy the sheet 11. Click on the Duplicate (Sheet 2) worksheet and rename to Acct Pers Client Billing 12. Right-click on the taller Emp = 0 Columns and click on Exclude 13. Drag the Client Dimension to the Columns shelf