IDEAS home Printed from https://ideas.repec.org/a/eee/joaced/v57y2021ics0748575121000312.html
   My bibliography  Save this article

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

Author

Listed:
  • Domino, Madeline A.
  • Schrag, Daniel
  • Webinger, Mariah
  • Troy, Carmelita

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.

Suggested Citation

  • Domino, Madeline A. & Schrag, Daniel & Webinger, Mariah & Troy, Carmelita, 2021. "Linking data analytics to real-world business issues: The power of the pivot table," Journal of Accounting Education, Elsevier, vol. 57(C).
    • Handle: RePEc:eee:joaced:v:57:y:2021:i:c:s0748575121000312
    DOI: 10.1016/j.jaccedu.2021.100744
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0748575121000312
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.jaccedu.2021.100744?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Ragland, Linda & Ramachandran, Usha, 2014. "Towards an understanding of excel functional skills needed for a career in public accounting: Perceptions from public accountants and accounting students," Journal of Accounting Education, Elsevier, vol. 32(2), pages 113-129.
    2. Lisa Perkhofer & Conny Walchshofer & Peter Hofer, 2020. "Does design matter when visualizing Big Data? An empirical study to investigate the effect of visualization type and interaction use," Journal of Management Control: Zeitschrift für Planung und Unternehmenssteuerung, Springer, vol. 31(1), pages 55-95, April.
    3. Angelo, Ben & Ayres, Douglas & Stanfield, Jason, 2018. "Power from the ground up: Using data analytics in capital budgeting," Journal of Accounting Education, Elsevier, vol. 42(C), pages 27-39.
    4. Sledgianowski, Deb & Gomaa, Mohamed & Tan, Christine, 2017. "Toward integration of Big Data, technology and information systems competencies into the accounting curriculum," Journal of Accounting Education, Elsevier, vol. 38(C), pages 81-93.
    5. Oecd, 2013. "Audit of Procurement," SIGMA Public Procurement Briefs 28, OECD Publishing.
    6. Usha Ramachandran Rackliffe & Linda Ragland, 2016. "Excel in the accounting curriculum: perceptions from accounting professors," Accounting Education, Taylor & Francis Journals, vol. 25(2), pages 139-166, April.
    7. Hoelscher, Jamie & Mortimer, Amanda, 2018. "Using Tableau to visualize data and drive decision-making," Journal of Accounting Education, Elsevier, vol. 44(C), pages 49-59.
    8. Willis, Veronda F., 2016. "A model for teaching technology: Using Excel in an accounting information systems course," Journal of Accounting Education, Elsevier, vol. 36(C), pages 87-99.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Lee, W. Eric & Perdana, Arif, 2023. "Effects of experiential service learning in improving community engagement perception, sustainability awareness, and data analytics competency," Journal of Accounting Education, Elsevier, vol. 62(C).

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Susanne Leitner-Hanetseder & Christoph Eisl & Carina Knoll & Othmar M. Lehner, 2021. "Need For Advanced It Skills For Accountants €“ What Does Accounting Education Literature Tell Us?," Business Education and Accreditation, The Institute for Business and Finance Research, vol. 13(1), pages 57-69.
    2. Parra, Fernando & Jacobs, Aimee & Trevino, Laura L., 2021. "Shippy Express: Augmenting accounting education with Google Sheets," Journal of Accounting Education, Elsevier, vol. 56(C).
    3. Ruhnke, Klaus, 2023. "Empirical research frameworks in a changing world: The case of audit data analytics," Journal of International Accounting, Auditing and Taxation, Elsevier, vol. 51(C).
    4. Apostolou, Barbara & Dorminey, Jack W. & Hassell, John M. & Rebele, James E., 2017. "Accounting education literature review (2016)," Journal of Accounting Education, Elsevier, vol. 39(C), pages 1-31.
    5. Janvrin, Diane J. & Weidenmier Watson, Marcia, 2017. "“Big Data”: A new twist to accounting," Journal of Accounting Education, Elsevier, vol. 38(C), pages 3-8.
    6. Hamood Mohammed Al-Hattami, 2021. "University Accounting Curriculum, IT, and Job Market Demands: Evidence From Yemen," SAGE Open, , vol. 11(2), pages 21582440211, April.
    7. Sarkar, Sumantra & Gray, Joy & Boss, Scott R. & Daly, Emmet, 2021. "Developing institutional skills for addressing big data: Experiences in implementation of AACSB Standard 5," Journal of Accounting Education, Elsevier, vol. 54(C).
    8. Maël Schnegg & Klaus Möller, 2022. "Strategies for data analytics projects in business performance forecasting: a field study," Journal of Management Control: Zeitschrift für Planung und Unternehmenssteuerung, Springer, vol. 33(2), pages 241-271, June.
    9. Lee, W. Eric & Perdana, Arif, 2023. "Effects of experiential service learning in improving community engagement perception, sustainability awareness, and data analytics competency," Journal of Accounting Education, Elsevier, vol. 62(C).
    10. Lee, Lorraine & Shifflett, Eileen & Downen, Tom, 2019. "Teaching excel shortcuts: A visualization and game-based approach," Journal of Accounting Education, Elsevier, vol. 48(C), pages 22-32.
    11. Khaldoon Al-Htaybat & Larissa von Alberti-Alhtaybat & Zaidoon Alhatabat, 2018. "Educating digital natives for the future: accounting educators’ evaluation of the accounting curriculum," Accounting Education, Taylor & Francis Journals, vol. 27(4), pages 333-357, July.
    12. Nwamgbebu Obinna P. & Oketa Chiamaka E. & Agba Chukwuka C. & Cynthia O. Nwambe, 2019. "Effect of Value for Money Auditing on Cost of Governance in Nigeria: Evidence from Local Government Councils in Ebonyi State, Nigeria," International Journal of Academic Research in Accounting, Finance and Management Sciences, Human Resource Management Academic Research Society, International Journal of Academic Research in Accounting, Finance and Management Sciences, vol. 9(1), pages 170-178, January.
    13. Strike Mbulawa, 2021. "Domestic Demand Or Trade Led Growth Hypothesis For Southern Africa Development Community (Sadc) Countries? A Search For A New Development Paradigm," Annals of University of Craiova - Economic Sciences Series, University of Craiova, Faculty of Economics and Business Administration, vol. 1(49), pages 55-72, August.
    14. Willis, Veronda F., 2016. "A model for teaching technology: Using Excel in an accounting information systems course," Journal of Accounting Education, Elsevier, vol. 36(C), pages 87-99.
    15. Blix, Leslie H. & Edmonds, Mark A. & Sorensen, Kate B., 2021. "How well do audit textbooks currently integrate data analytics," Journal of Accounting Education, Elsevier, vol. 55(C).
    16. Francis Aboagye‐Otchere & Cletus Agyenim‐Boateng & Abdulai Enusah & Theodora Ekua Aryee, 2021. "A Review of Big Data Research in Accounting," Intelligent Systems in Accounting, Finance and Management, John Wiley & Sons, Ltd., vol. 28(4), pages 268-283, October.
    17. Erica L. Gallindo & Hobson A. Cruz & Mário W. L. Moreira, 2021. "Critical Examination Using Business Intelligence on the Gender Gap in Information Technology in Brazil," Mathematics, MDPI, vol. 9(15), pages 1-9, August.
    18. Bradbard, David A. & Alvis, Charles & Morris, Richard, 2014. "Spreadsheet usage by management accountants: An exploratory study," Journal of Accounting Education, Elsevier, vol. 32(4), pages 24-30.
    19. Chiara Mio & Luciana Oranges Cezarino, 2023. "Competencies for Sustainable Development Goals Accounting: Educating public management for disclosure and reporting," MANAGEMENT CONTROL, FrancoAngeli Editore, vol. 2023(2 Suppl.), pages 133-160.
    20. Gross, Andrew & Hoelscher, Jamie & Reed, Brad J. & Sierra, Gregory E., 2020. "The new nuts and bolts of auditing: Technological innovation in inventorying inventory," Journal of Accounting Education, Elsevier, vol. 52(C).

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:joaced:v:57:y:2021:i:c:s0748575121000312. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: https://www.journals.elsevier.com/journal-of-accounting-education .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.