A Case Study Using Data Analytics to Detect Hail Damage Insurance Claim Fraud
Open Access
- 20 November 2023
- journal article
- research article
- Published by American Accounting Association in Journal of Forensic Accounting Research
- Vol. 8 (1) , 287-306
Abstract
Employers require that accounting students think critically and use data analytics tools to gain valuable insights for forensic, tax, auditing, and advisory services. This case provides students with a hands-on learning experience using data analytics and encourages critical thinking. Students are tasked with using Alteryx and Tableau to prepare and analyze a fictitious storm dataset and insurance claims dataset to identify claims that may be suspicious. They create visualizations and spreadsheets that support their recommendation for further analysis. The learning objectives are: (1) develop student knowledge and ability to conduct data preparation through the “Extract, Transform, and Load” (ETL) process; (2) expand student knowledge of data analytics and fraud investigation; (3) provide students with practice in fraud investigation skills, including critical thinking and problem solving; (4) develop skills specific to data analytics and data visualization in accounting; and (5) develop effective oral and written communication skills.Keywords
This publication has 15 references indexed in Scilit:
- Artificial Intelligence: Reshaping the Accounting Profession and the Disruption to Accounting EducationJournal of Emerging Technologies in Accounting, 2021
- Incorporating Data Analytics in a Technical Tax Setting: A Case Using Excel and Tableau to Examine a Firm's Schedule M-3 and Tax RiskIssues in Accounting Education, 2021
- Using Tableau to Analyze the Effects of Tax Code Changes: A Teaching Case for Tax and AIS CoursesIssues in Accounting Education, 2021
- S Corporations and IRC Section 199A: Incorporating Excel Into Tax-Planning ScenariosIssues in Accounting Education, 2020
- Using Data Analytics to Evaluate Policy Implications of Migration Patterns: Application for Analytics, AIS, and Tax ClassesIssues in Accounting Education, 2020
- A Case Study of Effective Tax Rates Using Data AnalyticsIssues in Accounting Education, 2020
- Tax Retirement Savings Decisions Using an Excel Spreadsheet ApproachIssues in Accounting Education, 2020
- Data Analytics in Tax Research: Analyzing Worker Agreements and Compensation Data to Distinguish Between Independent Contractors and Employees Using IRS FactorsIssues in Accounting Education, 2020
- Using Visualization Software in the Audit of Revenue Transactions to Identify AnomaliesIssues in Accounting Education, 2018
- Accounting education literature review (2013–2014)Journal of Accounting Education, 2015