The course contains a number of comprehensive audit/testing scenarios of increasing complexity, each of which covers some of the more challenging real-life data issues that users may face. 

Pre-course requirements

Delegates should be fully conversant with the CIDA foundation level functionality covered in CI101 Introduction to IDEA Data Analysis. Intermediate Training builds rapidly on the basics as we move swiftly into more advanced testing scenarios.

Outlined agenda

Personnel Audit

• Handle difficult imports with greater confidence, speed and accuracy
• Create advanced extractions and summarizations
• Connect multiple databases to bring data together from different sources for analysis
• Apply advanced @Functions to perform complex calculations and testing
• Perform advanced data profiling using Benford’s Law

• Automate processes/tasks by working with Visual Script and IDEAScripts
• Access resources available from CaseWare for continued learning

Who should attend?

Delegates are expected to be self-starters who are confident at ‘having a go’ at solving more complex data relationships. However, the course is designed to ensure that no-one is left behind. At each stage of increasing complexity, solutions are provided to enable every delegate to keep on track and follow best practice.