Transaction Analytics: Understanding Transactions

Description

This class introduces transaction-level analytics and examines how individual business transactions can be summarized and compared. Transaction-level data are important because they allow accountants to examine patterns that may not be visible in aggregated financial information. This is part oone of a two-part sequence analyzing transactions.

Motivation

What can individual transactions tell us about a business?

Review

The ETL classes focused on obtaining and preparing data for analysis. This class begins using those prepared data to answer accounting questions by moving from data preparation to the analysis of business activity.

Class plan

• We will begin with a review of the ETL module.
• We will move to the remote labs and use a new software, Tableau for our two cases.

Materials

• Case

  Analytics mindset case studies FairviewInc Reimbursement calculation method

  Case 1

  View Online: Analytics mindset case studies FairviewInc Reimbursement calculation methodPDF: Analytics mindset case studies FairviewInc Reimbursement calculation methodWord: Analytics mindset case studies FairviewInc Reimbursement calculation method

• Case

  Analytics mindset case studies FairfieldInc Travel expense audit

  Case 2

  View Online: Analytics mindset case studies FairfieldInc Travel expense auditPDF: Analytics mindset case studies FairfieldInc Travel expense auditWord: Analytics mindset case studies FairfieldInc Travel expense audit

• Slides

  Class 06 Slides

  View slides: Class 06 Slides