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

• Analysis of Leavers
• Conflict of Interest
• Diversity
• Equal Pay
• Unusual Salaries and statistical outliers

Stock Control

• Re-ordering analysis
• Statistical analysis of performance
• Valuation analysis

Local Authority Benefit Fraud

• Multiple claims
• Advanced duplicate detection and text searching

Statistical Analysis and Sampling

• Benford’s Law
• Correlation
• Monetary unit sampling

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.