Skip to main content
Live Webcast Replay

Data Extraction, Transformation, Validation the Right Data Sources for Analysis


Total Credits: 2 including 1 Information Technology - Technical, 1 Specialized Knowledge - Technical

Average Rating:
Not yet rated
Categories:
ACPEN Industry Institute |  Accounting and Auditing |  Ethics |  Personal Development |  Professional Development |  Technology
Faculty:
Vincent M. Walden, CPA, CFE
Course Levels:
Intermediate
Duration:
2 Hours
License:
Product Setting: Expires 30 day(s) after program date.

Dates
Please Note: Programs with a ☾ insignia begin after 5pm or air on the weekend.


Description

In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins.  The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis. 

Basic Course Information

Learning Objectives
  • Understand various data sources available to accountants for use in forensic data analysis
  • Differences between structured vs. unstructured data
  • Various extract, transform and load tools an techniques available
  • How to select the right data sources for the job
  • Key risks and pitfalls to avoid

Major Subjects Understand various data types 
Structured vs. unstructured data
Completeness and validation testing
Selecting the right data sources for the job
Risks and pitfalls to avoid

Course Materials

Faculty

Vincent M. Walden, CPA, CFE's Profile

Vincent M. Walden, CPA, CFE Related Seminars and Products

CEO

Kona AI


Vincent Walden is CEO of Kona AI, a global, AI-driven technology company focused on anti-fraud, anti-corruption and compliance risks. He specializes in forensic data analytics, continuous controls monitoring, information governance and legal discovery services. With over 25 years of professional anti-fraud and forensic technology experience, his primary area of focus is in providing leading technology innovations on both proactive compliance programs and reactive investigations.


Prior to joining Kona AI, Mr. Walden was a Managing Director at Alvarez & Marsal’s (A&M) Disputes & Investigations practice for approximately three years.  Prior to A&M, Mr. Walden spent 14 years at Ernst & Young’s Forensic & Integrity Services Practice in Dallas, New York and Atlanta, where he served as a Partner for nine years leading a global team of forensic data analytics professionals and supporting white-collar investigations. Before EY, he worked at KPMG and Arthur Andersen. During his career, he also served as President and CFO of a privately-funded Internet company, which was subsequently sold to a Fortune 500 Company in 2001.


As an industry thought leader, Mr. Walden was recognized as “Certified Fraud Examiner of the Year” in 2022 and has been featured in many publications including Internal Auditor Magazine, Compliance Week, Forbes, The Wall Street Journal, Harvard Business Review and The Economist. Since 2018, he has been a regular columnist for FRAUD Magazine writing on anti-fraud innovation. As part of COSO’s Anti-Fraud Task Force, Mr. Walden co-authored its “Fraud Risk Management Guide”, which was released in September 2016 and was also part of the 2023 update. He also teaches Compliance Innovation as an Adjunct Professor at Fordham Law School in New York. 


Mr. Walden earned a bachelor’s degree in business administration from the University of Southern California. He completed the Harvard Leadership Program at Harvard Business School and is a Certified Public Accountant and a Certified Fraud Examiner. Mr. Walden also volunteered as the President of The Association of Certified Fraud Examiner’s Education and Research Foundation (2017-2021), which provides academic scholarships to students and anti-fraud research to qualified recipients. 


Dates

Thu, May 09, 2024 - 01:00pm to 02:52pm CDT
Tue, May 28, 2024 - 03:00pm to 04:52pm CDT
Thu, Jun 06, 2024 - 09:00am to 10:52am CDT
Fri, Jun 14, 2024 - 11:00am to 12:52pm CDT
Tue, Jun 25, 2024 - 05:00pm to 06:52pm CDT
Fri, Jul 12, 2024 - 03:00pm to 04:52pm CDT
Wed, Jul 24, 2024 - 09:00am to 10:52am CDT
Fri, Aug 02, 2024 - 11:00am to 12:52pm CDT
Sat, Aug 24, 2024 - 01:00pm to 02:52pm CDT
Wed, Sep 11, 2024 - 03:00pm to 04:52pm CDT
Mon, Sep 23, 2024 - 09:00am to 10:52am CDT
Thu, Oct 03, 2024 - 05:00pm to 06:52pm CDT
Tue, Oct 29, 2024 - 01:00pm to 02:52pm CDT
Sat, Nov 09, 2024 - 03:00pm to 04:52pm CST
Wed, Nov 20, 2024 - 09:00am to 10:52am CST
Sat, Dec 14, 2024 - 01:00pm to 02:52pm CST
Fri, Dec 27, 2024 - 03:00pm to 04:52pm CST
Wed, Jan 15, 2025 - 11:00am to 12:52pm CST
Tue, Jan 28, 2025 - 01:00pm to 02:52pm CST
Mon, Feb 03, 2025 - 03:00pm to 04:52pm CST
Sat, Feb 15, 2025 - 09:00am to 10:52am CST
Tue, Feb 25, 2025 - 06:00pm to 07:52pm CST
Mon, Mar 10, 2025 - 11:00am to 12:52pm CDT
Mon, Mar 24, 2025 - 01:00pm to 02:52pm CDT
Tue, Apr 01, 2025 - 03:00pm to 04:52pm CDT
Wed, Apr 16, 2025 - 09:00am to 10:52am CDT
Sat, May 10, 2025 - 11:00am to 12:52pm CDT
Fri, May 30, 2025 - 01:00pm to 02:52pm CDT
Mon, Jun 09, 2025 - 03:00pm to 04:52pm CDT
Mon, Jun 16, 2025 - 09:00am to 10:52am CDT
Thu, Jun 26, 2025 - 06:00pm to 07:52pm CDT

Additional Info

Basic Course Information

Prerequisites Introduction to Forensic Data Analytics
Advanced Preparation  None
Designed For

All accountants, internal audit, finance, investigators, compliance and risk professionals. 

 


Original Recording Date

05/22/2023

 


Yellow Book No
Course Developer Vincent Walden
Date Added to Catalog 05/22/2023

Additional Information

Complaint Resolution Policy

Please contact Anne Taylor for any complaints. anne.taylor@acpen.com, (972-377-8199). 


Official Registry Statement

Business Professionals' Network, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org


Instructional Delivery Method

Group Internet Based


Course Registration Requirements

Online Registration


Refund/Cancellation Policy

Please contact the ACPEN help desk 1-877-602-9877 or help@acpen.com if you wish to cancel your attendance for a previously purchased webcast and are requesting a refund or transfer. 


Promo Video

Reviews

5
4
3
2
1

Overall:   Not yet rated

Total Reviews: 3