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

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. 

Highlights

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

Prerequisites

Introduction to Forensic Data Analytics

Designed For

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

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

Preparation

 None

Notice

This course is offered by a 3rd party vendor and will not be accessible in the My CPE Tracker section of the ISCPA website. Course access information will be emailed directly to you by Accounting Continuing Professional Education Network (ACPEN).