April 23, 2018 - April 24, 2018 |9:00 AM - 5:00 PM
1200 St Laurent Blvd, Unit 004A
Ottawa, ON
K1K 3B8
IDEA Data Analysis

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.

Fees: $1095 CAD per participant

Length: Two days

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

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 Data Profiling using Benford’s Law
•Advanced Extractions
•Introduction to Automation in IDEA
•Connecting Multiple Databases
•Case Study – Independent Study
•Advanced @Functions
•Case Study – Management Report
•Custom Functions

Cancellation Policy

CaseWare IDEA Inc. requires notice of cancellation no later than 10 business days before the training start date. If less than 10 business days’ notice is given, 50% of the training fee will be refunded up to three business days before the training start date. No refund is possible if notice of cancellation is received less than three business days before the training start date. There is no charge for course substitutions. CaseWare IDEA retains the right to cancel training courses when the minimum number of participants has not been reached. Full refunds will be made should such cancellation be required.