Data Analytics Training Program

The Shidler College of Business’ School of Accountancy, in collaboration with the Department of Information Technology Management, offers its Data Analytics Training Program in January of 2019. The four-day training is open to both professionals and students.

American Accounting Association, American Institute of Certified Public Accountants (AICPA), and the Big Four accounting firms have all emphasized the importance of utilizing data analytics and have provided input and guidance regarding Shidler's data analytics programs.

Shidler students who take the class for credit, (Acc 649 for graduate students and ACC 399 for undergraduate students), must pay the relevant university tuition and fees and are not required to pay the registration fee. To receive credit, students are required to attend all sessions and must obtain a score of at least 70% in the test conducted at the end of the class. Students who fail the test or do not attend all sessions, will be assigned "no credit" grade.

Data Analytics Session

January 5–6 and January 12–13, 2019
1:00 p.m. – 4:30 p.m.
BusAd Room A101

Instructor: Michael Keiffer, CPA, CIA, CISA, CTA, ACDA

Participants will gain an overview of data analytics techniques and an introduction to data visualization. This is a “hands on” class, a fifteen-hour program.

Required Course Materials

  • Participants must bring their own laptops
  • Both ACL and IDEA mut be downloaded to the laptops prior to attending class (we will provide the software for those who do not have access to these softwares). The ACL software will be "authorized" during the first day of class (January 5th).

A Certificate of Completion (for those who will attend all sessions) and Continuing Professional Education (CPEs) will be issued to participants.

Registration

  • Group Rate: Reserve 10 seats as a group and receive an additional seat free-of-charge.
  • Registration deadline: December 21, 2018 (or when the capacity is met)

Detailed Schedule

January 5th, 2019 -

Topics –

  • What is Data Analytics?
  • Keys to Effective Data Analytics
  • Different Types of Source Data Files
  • Challenges to Obtaining Data Files
  • Different Data Analytic Tools
  • Advantages of Different Data Analytic Tools
  • Applications of Data Analysis
  • Introduction of ACL and IDEA

January 6th, 2019 –

Topics –

  • Creating Projects in ACL
  • Building Tables in ACL to Read Different Data Types
  • Data Validation Techniques Using ACL
  • Overview of Basic ACL Commands (Total, Statistics, Count, Verify)
  • Overview of Advanced ACL Commands (Extract with Append, Join, Relations)
  • Use of Expressions/Formulas in ACL

January 12th, 2019 –

Topics -

  • Review of ACL Concepts
  • Payroll Analysis Case Study Using ACL
  • Creating Projects in IDEA
  • Building Databases in IDEA to Read Different Data Types
  • Data Validation Techniques using IDEA
  • Overview of Basic Commands in IDEA

January 13th, 2019 –

Topics -

  • Overview of Advanced Commands in IDEA
  • Use of Expressions/Formulas in IDEA
  • Purchasing Card Case Study Using IDEA
  • Automating Different Data Analytics Procedures using ACL and IDEA
  • Use of Data Analytics as a Fraud Detection Tool
  • Other Applications of Data Analysis in Business
  • Final Review/Closing Comments

About the Instructor: 

Michael is an independent data analysis consultant with extensive experience with using ACL (Audit Command Language), IDEA and Arbutus Analyzer. Michael has over 19 years of extensive experience with using ACL as a data-mining tool, data analysis consulting and training experience, and with a focus on using ACL as fraud detection and compliance tool for various financial institutions. Among his career accomplishments are:

  • ACL Master Trainer and Consultant for ACL Services, Ltd., in Vancouver, BC.
  • Performed ACL training and consulting for numerous clients in the United States, Canada, Europe, Asia, and the Middle East.
  • Featured speaker at several national conventions and conferences, including the ACL Annual Users Conference.
  • Successfully conducted audits for several departments at clients in the role of Supervising Senior Auditor.
  • Supervising Senior Auditor at a variety of financial institutions conducting audits in operational areas including Tier II system review audits, bank online services, bank retail operations, lending reviews (both retail and commercial), trust operations and administration, and ACH operations.
  • Extensive background in fraud investigations and fraud detection.
  • Extensive experience with SAP, both consulting and training.

Past Data Analytics Sessions