IDEA Level 2 Course


IDEA Data Analysis Level 2 / 50%

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
IDEA Data Analysis Level 2


  • Working knowledge of Microsoft® Windows® desktop environment
  • Microsoft® Office® applications.
  • Familiarity with CI101 course topics.
  • Completion of CI101 is recommended.