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

Detecting dirty data using SQL: Rigorous house insurance case

Author

Listed:
  • Lawson, James G.
  • Street, Daniel A.

Abstract

Proficiency with data analytics is an increasingly important skill within in the accounting profession. However, successful data analysis requires clean source data (i.e., source data without errors) in order to draw reliable conclusions. Although users often assume clean source data, this assumption is frequently incorrect. Therefore, identifying and remediating “dirty data” is a prerequisite to effective data analysis. You, an accountant working at a firm that specializes in data analytics, have been hired by Rigorous House Insurance to analyze the company’s claim insurance data. In addition to investigating specific issues mentioned by the company’s controller, you are tasked with identifying any other data integrity issues that you encounter and providing preventative information system internal control suggestions to the client to mitigate these issues in the future.

Suggested Citation

  • Lawson, James G. & Street, Daniel A., 2021. "Detecting dirty data using SQL: Rigorous house insurance case," Journal of Accounting Education, Elsevier, vol. 55(C).
    • Handle: RePEc:eee:joaced:v:55:y:2021:i:c:s0748575121000014
    DOI: 10.1016/j.jaccedu.2021.100714
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0748575121000014
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.jaccedu.2021.100714?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. Panos Vassiliadis, 2009. "A Survey of Extract–Transform–Load Technology," International Journal of Data Warehousing and Mining (IJDWM), IGI Global, vol. 5(3), pages 1-27, July.
    2. Fay, Rebecca & Negangard, Eric M., 2017. "Manual journal entry testing: Data analytics and the risk of fraud," Journal of Accounting Education, Elsevier, vol. 38(C), pages 37-49.
    3. Janvrin, Diane J. & Raschke, Robyn L. & Dilla, William N., 2014. "Making sense of complex data using interactive data visualization," Journal of Accounting Education, Elsevier, vol. 32(4), pages 31-48.
    4. 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.
    5. Igou, Amy & Coe, Martin, 2016. "Vistabeans coffee shop data analytics teaching case," Journal of Accounting Education, Elsevier, vol. 36(C), pages 75-86.
    6. Dzuranin, Ann C. & Jones, Janet R. & Olvera, Renee M., 2018. "Infusing data analytics into the accounting curriculum: A framework and insights from faculty," Journal of Accounting Education, Elsevier, vol. 43(C), pages 24-39.
    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. 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.

    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. Ballou, Brian & Heitger, Dan L. & Stoel, Dale, 2018. "Data-driven decision-making and its impact on accounting undergraduate curriculum," Journal of Accounting Education, Elsevier, vol. 44(C), pages 14-24.
    2. 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.
    3. 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.
    4. 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).
    5. Felski, Elizabeth, 2023. "Audit technologies used in practice and ways to implement these technologies into audit courses," Journal of Accounting Education, Elsevier, vol. 62(C).
    6. 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.
    7. 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).
    8. 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.
    9. Mohamed Saeudy & Ali Meftah Gerged & Khaldoon Albitar, 2022. "Accounting Perspectives on The Business Value of Big Data During and Beyond The COVID-19 Pandemic," Journal of Accounting and Management Information Systems, Faculty of Accounting and Management Information Systems, The Bucharest University of Economic Studies, vol. 21(2), pages 174-199, June.
    10. 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).
    11. Carla Carvalho & Ana Carlos Almeida, 2022. "The Adequacy of Accounting Education in the Development of Transversal Skills Needed to Meet Market Demands," Sustainability, MDPI, vol. 14(10), pages 1-18, May.
    12. Ewa Banasik & Christine Jubb, 2021. "Are Accounting Programs Future‐ready? Employability Skills," Australian Accounting Review, CPA Australia, vol. 31(3), pages 256-267, September.
    13. Zhan, Yuanzhu & Tan, Kim Hua, 2020. "An analytic infrastructure for harvesting big data to enhance supply chain performance," European Journal of Operational Research, Elsevier, vol. 281(3), pages 559-574.
    14. David Gil & Magnus Johnsson & Higinio Mora & Julian Szymanski, 2019. "Advances in Architectures, Big Data, and Machine Learning Techniques for Complex Internet of Things Systems," Complexity, Hindawi, vol. 2019, pages 1-3, March.
    15. 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.
    16. Booker, Danielle D. & Pelzer, Josette R.E. & Richardson, Jeremy R., 2023. "Integrating data analytics into the auditing curriculum: Insights and perceptions from early-career auditors," Journal of Accounting Education, Elsevier, vol. 64(C).
    17. Johannes Schneider & Stefan Seidel & Marcus Basalla & Jan Brocke, 2023. "Reuse, Reduce, Support: Design Principles for Green Data Mining," Business & Information Systems Engineering: The International Journal of WIRTSCHAFTSINFORMATIK, Springer;Gesellschaft für Informatik e.V. (GI), vol. 65(1), pages 65-83, February.
    18. Klein, T.M. & Celio, E. & Grêt-Regamey, A., 2015. "Ecosystem services visualization and communication: A demand analysis approach for designing information and conceptualizing decision support systems," Ecosystem Services, Elsevier, vol. 13(C), pages 173-183.
    19. Apostolou, Barbara & Dorminey, Jack W. & Hassell, John M. & Hickey, Anna, 2019. "Accounting education literature review (2018)," Journal of Accounting Education, Elsevier, vol. 47(C), pages 1-27.
    20. Igou, Amy & Coe, Martin, 2016. "Vistabeans coffee shop data analytics teaching case," Journal of Accounting Education, Elsevier, vol. 36(C), pages 75-86.

    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:55:y:2021:i:c:s0748575121000014. 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.