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

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