An introductory audit data analytics case study: Using Microsoft Power BI and Benford’s Law to detect accounting irregularities

Erin Burrell Nickell, Jason Schwebke and Paul Goldwater

Journal of Accounting Education, 2023, vol. 64, issue C

Abstract: This case introduces you to the use of data analytics in accounting for purposes of identifying irregularities in a large data set of invoices using Microsoft Power BI. The goal of this case is two-fold. First, the case provides you a guided approach to navigating Power BI at the beginner level. Second, the case serves as an introduction to the use of data analytics in an auditing context for purposes of identifying irregularities in a large data set of invoices. You will evaluate the data set according to Benford’s Law and create an interactive “dashboard” visualization to present the results of your analysis to a supervisor. Additionally, you will document your findings in a written report according to professional auditing standards. We provide evidence of case efficacy in both a graduate-level fraud auditing course as well as an undergraduate accounting information systems (AIS) course with a data analytics focus. The case is suitable as an introductory data analytics assignment in any course with an auditing, fraud, forensics, AIS, or data analytics focus where students have little or no prior experience with Power BI. The case may also be used as an introduction to Benford’s Law as students are not required to have prior experience with Benford’s Law in order to complete the assignment.

Keywords: Benford’s Law; Power BI; Audit analytics (search for similar items in EconPapers)
Date: 2023
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (2)

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0748575123000271
Full text for ScienceDirect subscribers only

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:eee:joaced:v:64:y:2023:i:c:s0748575123000271

DOI: 10.1016/j.jaccedu.2023.100855

Access Statistics for this article

Journal of Accounting Education is currently edited by Natalie Tatiana Churyk

More articles in Journal of Accounting Education from Elsevier
Bibliographic data for series maintained by Catherine Liu ().