Class 13

Accounting & Finance Function 1 (Alteryx SparkED)

Wednesday, November 5, 2025

Class Overview

Why is this important?

In today’s data-centric environment, auditors and compliance professionals are expected to manage increasingly complex datasets and regulatory requirements. This class focuses on providing an overview of the suspect vendors, Purchase Order Splitting and Sales and Use Tax Allocation cases to provide students with critical skills in building Alteryx workflows. By exploring these cases, students gain hands-on experience in transaction analysis and tax allocation, using Alteryx to streamline data workflows and enhance regulatory accuracy. This work reinforces the importance of data-driven decision-making in maintaining financial and operational integrity.

What will we do?

This class introduces students to the Alteryx SparkEd Cases using the GL Claen Up Case as an introduction. Through these cases over the next three classes, students will develop skills in identifying and addressing complex transactional issues within data workflows. The Purchase Order Splitting case emphasizes the detection and prevention of transaction manipulation through split purchases, an issue critical in maintaining procurement compliance and financial integrity. In Sales and Use Tax Allocation, students will apply Alteryx to accurately allocate tax liabilities across various jurisdictions, reinforcing skills in tax compliance and regulatory reporting. These exercises are designed to solidify students' ability to leverage data analytics in managing audit and compliance challenges.

How this relates to other classes:

This class revisits foundational compliance concepts introduced in the P-Card case, in this case examining the OFAC Suspect Vendors case and in the analysis of purchase order splitting and tax allocation SparkEd Cases. , students reinforce their ability to detect irregularities and maintain compliance across complex data workflows. This exercise consolidates students' understanding of using analytics for regulatory tasks, setting the stage for more advanced data handling in future classes.

Materials and Preparation

Class Materials
  • Case: SparkEd_Audit_PO_Splitting
  • Case: SparkEd_GL_Cleanup
  • Case: SparkEd_International_group_taxes
  • Case: SparkEd_Organizing_Financial_Report_Data
  • Case: SparkEd_Sales_and_use_tax_allocation
  • Case: SparkEd_Suspect_vendors
  • Slides: PowerPoint or PDF
  • Data:
  • Analytics Tools: Alteryx including the multi-row formula tool., Git and GitHub for file delivery.
  • Suggested Pre-Class Preparation
    1. There is no formal required preparation for this class
    2. The Alteryx SparkEd Cases are largely written as reference cases with brief overviews. Feel free to review these cases in advance.
    3. The goal for this class is to work on Cases 2 and 3, cases 4-6 are provided for those students who are able to complete 2 and 3.
  • Class Plan
    1. We will start with an introduction to the Alteryx SparkEd Cases.
    2. This will be followed by an overview of Cases 2 and 3 at a high-level, with a focus on the multi-row tool.
    3. The remaining class time will be used to work in small teams to work on Cases 2 and 3.
    4. Students who finish Case 2 and 3 can examine Case 4.