This assignment is for a case study. I appreciate the help in advance..

Conduct your analyses by preparing visualizations in Tableau. Your analyses should answer each of the following questions and your report should address the following requirements. Make sure that you clearly explain your process and how you amive at your conclusions. 1. How much money was spent on reimbursing employees for travel expenses? How much money do you estimate was spent for misreported reimbursements? 2. How much money was spent reimbursing each office for travel expenses? How much money do you estimate was spent for misreported reimbursements for each office? What is your best estimate of the correct amount of travel expenses that should have been reported for each office? 3. How much money was reimbursed to each employee? How much of the money that was reimbursed do you estimate was caused by misreporting for each employee? Separate employees by office and then sort to show the employee with the greatest misreported amount at the top of each office section. 4. For each employee that misreported an amount greater than $200, examine their misreporting behavior over time and provide a possible explanation for their behavior and any other evidence that might be relevant to their misreporting behavior. As a hint, although there is no time stamp in the flle, the transaction Line ID is assigned so that larger numbers are assigned later in time. 5. What else can you leam? Create at least one additional visualization that adds information relevant to your examination. Apply the analytics mindset (AMPS framework) to guide you: explicitly consider and discuss each step. 6. Prepare a report for the Audit Committee explaining your analytical procedures and findings. In your report, you should describe the objectives of the procedures, the analyses you performed, your findings, and your recommendations. Whenever possible, quantify your findings and recommendations and use visualizations to convey meaning. Conduct your analyses by preparing visualizations in Tableau. Your analyses should answer each of the following questions and your report should address the following requirements. Make sure that you clearly explain your process and how you amive at your conclusions. 1. How much money was spent on reimbursing employees for travel expenses? How much money do you estimate was spent for misreported reimbursements? 2. How much money was spent reimbursing each office for travel expenses? How much money do you estimate was spent for misreported reimbursements for each office? What is your best estimate of the correct amount of travel expenses that should have been reported for each office? 3. How much money was reimbursed to each employee? How much of the money that was reimbursed do you estimate was caused by misreporting for each employee? Separate employees by office and then sort to show the employee with the greatest misreported amount at the top of each office section. 4. For each employee that misreported an amount greater than $200, examine their misreporting behavior over time and provide a possible explanation for their behavior and any other evidence that might be relevant to their misreporting behavior. As a hint, although there is no time stamp in the flle, the transaction Line ID is assigned so that larger numbers are assigned later in time. 5. What else can you leam? Create at least one additional visualization that adds information relevant to your examination. Apply the analytics mindset (AMPS framework) to guide you: explicitly consider and discuss each step. 6. Prepare a report for the Audit Committee explaining your analytical procedures and findings. In your report, you should describe the objectives of the procedures, the analyses you performed, your findings, and your recommendations. Whenever possible, quantify your findings and recommendations and use visualizations to convey meaning