KPMG Beginner Alteryx Case

This case study, developed by the KPMG Master of Data and Analytics Program Team, has been designed to give instructors a meaningful way to incorporate Alteryx Designer into an auditing or financial statement accounting classroom. Because greater understanding of data and analytics is commonly identified by experienced audit professionals as an area of importance for new staff auditors, the need for university faculty to incorporate data analytic tools, especially Alteryx, in their classes is at an all-time high. To expand the breadth of this case study offering, it has been designed to provide a meaningful learning experience for even those students with no prior Alteryx experience.
 
 The Beginner Alteryx case is based on common audit procedures completed by an engagement team on their client’s journal entry population and trial balance (i.e., completion and recalculation), as well as various analyses and summarizations of data to corroborate risk assessment. The data contains a journal entry population and prior period trial balance, with the need for the student to export their own clean journal entry detail and current period trial balance. The materials include a complete set of facilitator notes and a slide deck to assist with an introduction of Alteryx to the classroom.
 
 The primary target audience for these cases is an auditing or financial statement accounting class, at either the undergraduate or graduate level.
 
 Learning Objectives
 Through completion of this case study, students will be able to:
 1. Demonstrate how to use beginner Alteryx functionality, such as:
      a. In/out: Input data, output data, browse
      b. Preparation: Data cleansing, filter, formula, select
      c. Join: Join, union
 2. Identify the benefit of creating an Alteryx workflow to gain efficiency period over period
 
 This case has been designed to provide an approach to implementing Alteryx into the classroom, with a complete set of facilitator notes, a presentation slide deck, and associated speaker notes to help guide instructors through all aspects of the case. This will enable faculty to then assist students in the learning process, even if they have no prior experience using Alteryx. We are hopeful that this will save instructors time and make it more likely that these valuable skills will be brought into the classroom.