IDEA Data Analysis Level 2 (Two Days)This two-day course is ideal for those who have completed the IDEA Data Analysis Level 1 training or have a sound understanding of IDEA functionality. Participants learn more advanced topics, such as creating complex equations or criteria, automating tasks and connecting databases.

After completing this training, participants will be able to:

Expand their use of data analytics in Audit, Finance, and other industries.

Apply advanced data analytics techniques and best practices.

Automate data analytics.

Improve governance and controls, and reduce risk in their organization.

Course Outline

Advanced Imports
Advanced Extractions
Connecting Multiple Databases

Advanced @Functions
Custom functions
Advanced Data Profiling using Benford’s Law

Introduction to Automation in IDEA
Case Study – Independent Study
Case Study – Management Report

Prerequisites

Working knowledge of Microsoft® Windows® desktop environment Microsoft® Office® applications.

Familiarity with CI101 course topics.

Completion of CI101 is recommended.