Linking data analytics to real-world business issues: The power of the pivot table

Madeline A. Domino, Daniel Schrag, Mariah Webinger and Carmelita Troy

Journal of Accounting Education, 2021, vol. 57, issue C

Abstract: One challenge facing accounting graduates and practitioners is acquiring sufficient data analytic skills. Using a moderately large and complex dataset from a privately owned company, the case illustrates how data analytics can help illuminate and resolve business issues. Special emphasis is placed on using pivot tables, which enable users to summarize and group large datasets into condensed reports quickly and in a variety of ways. Upon completing the case, you will be able to (a) identify appropriate parameters and criteria needed to address the concerns of senior managers, (b) create appropriate pivot tables using Microsoft Excel, (c) prepare written memorandums that summarize managers’ concerns, explain the usefulness of the findings, and make recommendations based on critical thinking to enhance their understanding of business issues. Optional instructions for data visualization using Tableau are included. The case is appropriate for undergraduate and graduate accounting information systems, business analytics courses, and professional training.

Keywords: Data analytics; Pivot tables; Critical thinking; Large dataset; Data Visualization (search for similar items in EconPapers)
Date: 2021
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://www.sciencedirect.com/science/article/pii/S0748575121000312
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:57:y:2021:i:c:s0748575121000312

DOI: 10.1016/j.jaccedu.2021.100744

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 ().