This case series focuses on a fictitious company, Fairview Inc., a software-as-a-service company, that utilizes a travel expense reimbursement process for its sales and information technology employees who travel to customer locations. The Audit Committee would like to change its audit approach of these expenses from sampling and manual data collection to utilizing audit analytics procedures on 100% of all data newly collected through automation. The CFO is considering alternatives for the current reimbursement calculation method and employee assignment method for customer calls to better to optimize resources. Students are asked to complete the analyses and share findings and recommendations. The case series includes four cases that can be completed independently:

Case 1: Extract, transform and load (ETL) — Students are asked to perform transformation procedures on the travel expense transaction data and sales and IT employee data so they can load it into a visualization tool for further analysis. The case solution is offered in Alteryx, and is accompanied with how-to videos.

Suitable courses: Cost or managerial accounting; Accounting information systems; Auditing; Data analytics

Link to download files (requires login)