A Case Study in Managing the Analytics ‘‘Iceberg’’: Data Cleaning and Management using Alteryx

Ann O’Brien, Dan N. Stone

Research output: Contribution to journalArticlepeer-review

4 Scopus citations

Abstract

This case introduces accounting students to data management using a ‘‘no code’’ approach. Many tools can be used for extract, transform, load (ETL) processes. Herein, we introduce ETL using Alteryx Designer, a market-leading tool for managing and manipulating data. In the case, students learn basic data cleaning and joining skills, explore key data management concepts including workflows and metadata, and learn how to create and document workflows in Alteryx. Undergraduate or graduate accounting students who have basic database knowledge (e.g., in an introduction to accounting systems class) and data processing skills will benefit from the case. Evidence from use suggests that the case is relevant, challenging, and useful for the goal of teaching introductory and intermediate-level ETL skills, using Alteryx. The case is easy to implement and an important resource for teaching data management and Alteryx Designer.

Original languageEnglish
Pages (from-to)221-245
Number of pages25
JournalJournal of Emerging Technologies in Accounting
Volume18
Issue number2
DOIs
StatePublished - Sep 1 2021

Bibliographical note

Publisher Copyright:
© 2021, American Accounting Association. All rights reserved.

Keywords

  • Alteryx
  • Data analytics
  • Data management
  • Extract, transform, load (ETL)
  • Workflows, ETL

ASJC Scopus subject areas

  • Accounting
  • Computer Science Applications

Fingerprint

Dive into the research topics of 'A Case Study in Managing the Analytics ‘‘Iceberg’’: Data Cleaning and Management using Alteryx'. Together they form a unique fingerprint.

Cite this