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

Saturday, December 14, 2024
Webcast or Webinar, Online
2:00 PM - 3:52 PM (opens at 1:30 PM) EST
2Credits
Technical Business

Registration is Closed

Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.

Members
$79.00 Regular Price
Non-Members
$109.00 Regular Price
Course Type: Webcast
Course Code: 24/AC186942
Level: Intermediate
Vendor: ACPEN
Field of Study: Specialized Knowledge, Information Technology

Overview:

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. 

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 Topics:

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

Major Topics:

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

Designed For:

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

Prerequisites:

Introduction to Forensic Data Analytics