Answer Happy

Complete the exercise detailed below and for each required item that is highlighted, submit a graph table as required. • For each submission ensure that your name/initials are part of the file or variable names and are visible. While there may be "cleaner ways to present your graphics, I prefer that you use submit screenshots your whole screen, including the date and time, is visible. • Where suggested formulae are provided, do not just copy and paste because the formulae will not work. Use that as a guide to input the formula using the Tableau commands For the calculated fields that require calculations, use the ‘ROUND” function and calculate to 2 decimal places. ROUND(-2) Don't feel that you have to use the specific guidance I have provided for how to create the graphics. If you have a better way, or one that you understand better, you can use that as long as you arrive at the right answers • For several of the requirements, I have provided you with the solution, or what the graphic should look like so that you can check if you are doing the right thing.

Exercise 2 - Accuracy of inventory compilation You wish to test the accuracy of the inventory compilation. You note that inventory cost is equal to QTY x Av COST, so you will recalculate the total cost of the inventory to compare it with what your client has stated, to check for accuracy of inventory compilation. 1. Create a table that shows any differences between the client's total cost and your own calculated total cost per product. Show only the products where a difference is found. (3pts) Hint: Create a calculated field for recalculated inventory cost and name it Your Name_RecalcTotal Cost). Create another calculated field where you find the difference between TotalCost and RecalcTotalCost and name it YourName_TotalCostDiff). Create a graphic using TotalCost, ReCalcTotalCost, TotalCost Diff and ProdCode Change the presentation of the graphic so that it is a table (Click 'show me' and select the first option which is a table).

Sort the column TotalcostDiff to display any products where there are differences – then Control click the ones you want to keep → keep only Add totals to the table so that the total amount of misstatement is visible. (Analytics → total → drag to grand total) https://help.tableau.com/current/pro/desktop/en- us/calculations_totals grandtotal_turnon.htm Totalcost RecalcTotalCost TotalCostDiff Prodcode 1320150103 39,451 37,151 2,300 661256507 1,954 1,803 150 421208904 50 50 Grand Total 41,455 38,954 2,500