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 and Microsoft® Office® applications.
• Familiarity with CI101 course topics.
• Completion of CI101 is recommended.