CI102 Intermediate Use of IDEA Data Analysis

Course Overview

This 2 day training course, combined with ‘CI101 Introduction to IDEA Data Analysis’ , is designed to incorporate all IDEA Data Analysis functionality required to pass the new CaseWare certification examination.

Delegates gain experience in using CaseWare IDEA 10 to solve problems beyond the basics of ‘who spent what’ and calculation cross-checks, enabling them to offer value added CAAT audits to their organisations.

The course comprises 3 comprehensive audit / testing scenarios over two days with a significant amount of ‘best practice’ input from our tutors. CAAT training requires data of sufficient breadth and complexity to emulate the connections that exist within ‘live’ data. We have spent significant time building multiple datasets that are more reflective of the real world. This new Intermediate Course allows delegates to explore data complexity and relationships for themselves and training includes industry standard CAAT tests such as those outlined by David Coderre, author of ‘Internal Audit’ and ‘Computer Aided Fraud – Prevention and Detection’.

The strength of this CIDA intermediate level course lies in the application of both basic and advanced analytical techniques to enable delegates to utilise IDEA 10 to solve their own complex problems.

Our aim is to guide delegates to the scenario solutions whilst equipping them with the ability to create their own value added testing scenarios on their return to the office.

The course is recognised by the CPD Institute and has a value of 7 hours.

Delegate Requirements

Delegates should be fully conversant with the CIDA foundation level functionality covered in ”CI101 Introduction to IDEA Data Analysis’, e.g. Summarisation, Stratification, basic Database Connectivity (Joins) and basic Data Manipulation (Equation Editor) – see Foundation Course Contents for further detail. Intermediate Training builds rapidly on the basics as we move swiftly into more advanced testing scenarios.

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.

Training Scenarios

Personnel Audit of a mid-sized consultancy firm

  • Analysis of Leavers
  • Conflicts of Interest
  • Diversity
  • Equal Pay
  • Unusual Salaries

Stock Control

  • Re-Ordering Analysis
  • Statistical Analysis of System Performance
  • Valuation Analysis

Local Authority benefits Fraud

  • Multiple Benefit Claims
  • Statistical analysis of claims

IDEA Functionality Covered

In addition to our analytical investigations above, we introduce some advanced statistical analyses. These exceed the CaseWare certification examination requirement and include a comprehensive introduction to the tests known as the ‘Nigrini Cycle. This course also introduces advanced sampling techniques.


See all

Download Course Guide


Public courses

Delegate fee: £895 + VAT (includes refreshments, buffet lunch and training material).

To book a Scheduled Training Course please select from the available dates above.

In-house training

Minimum number 4, maximum number 8 per course.

Price (per person) on request – capped trainer travel expenses will be charged.

To book or discuss in-house training, please call
+44 (0)1892 512348 or email

Both trainers clearly had a good knowledge of the IDEA Data Analysis Software and practical application. They were also able to adjust the training content and timing as they went along to better met the needs of the delegates.

Paul Williams
Essex County Council

“Although I was relatively new to IDEA (having only completed in-house beginner’s training), James presented the course material so effectively that by the end of the course, I felt comfortable completing the exercises without peeking at the solutions (too often). This was the best software training course I have attended; it was very well presented and facilitated and the exercises were interesting, challenging and effective in their aims. Highly recommended – I am looking forward to putting my skills to use!”

Cat Pennels-Cronje
Veritau Ltd

“The course was an excellent way to reinforce the work I had done using IDEA and to pick up more advanced techniques. The Trainer was approachable, knowledgeable and delivered the content with enthusiasm.”

Michael McCarthy
Mersey Internal Audit Agency, NHS

“This course taught not just about the software, but some rules of thumb, RE. using the software, and around data manipulation for certain business questions. All good.”

Darren O’Brien
IS Auditor / Saga PLC

“The trainer was very knowledgeable, answering all questions. Made the session very enjoyable and paced it well.”

Mark Stevenson

“Excellent course, very fast paced but a lot of knowledge imparted. Excellent presenter, clear, articulate, knowledgeable, and personable. Excellent value for money.”

Marcus Dewsbury
Senior Internal Auditor / YBS Group
1 2