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 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
