Regulators, donors and boards now expect organisations to show that anti-bribery and ethics programmes work in practice, not just that policies exist. Paper controls are easy to defend and hard to verify. Transaction data, supplier master files, payroll records and declarations registers can show whether the controls actually bite, and they allow compliance staff to target scarce investigative time where the risk is highest.

This training course builds an analytics workflow around integrity risk. Participants begin by mapping bribery, facilitation payment and conflict of interest risks to the data that could reveal them. They then clean and join datasets, run exception tests for unusual payments, round amounts, split purchases, dormant vendors and approval anomalies, and match vendor addresses, bank accounts and phone numbers against staff records. Later sessions cover gifts and hospitality trends, sampling, scoring approaches, handling false positives, and presenting results with care for fairness and confidentiality.

Every topic is taught on practice datasets using spreadsheets and visualisation tools, with an optional introduction to Python for larger files. Participants complete the programme with a testing plan and monitoring dashboard concept that can be adapted to their own institution.

By the end of the course, participants will be able to:

• Map bribery and conflict of interest risks to data sources that can reveal them.
• Clean, combine and validate payment, vendor, payroll and declaration data.
• Run red-flag tests for split payments, duplicates, round sums and unusual approvals.
• Match vendors, employees and declared interests to uncover undisclosed relationships.
• Analyse gifts, hospitality and expense data for patterns that warrant inquiry.
• Design risk scores and dashboards that prioritise cases for review.
• Report analytic findings fairly, protecting confidentiality and due process.

The course is intended for professionals who monitor integrity and investigate irregularity, including:

• Compliance and ethics officers
• Internal auditors and audit data analysts
• Forensic accountants and fraud investigators
• Procurement integrity and supplier risk managers
• Anti-corruption commission and oversight agency staff
• Risk managers in banks and insurers
• NGO and development partner compliance and safeguarding staff
• Legal and human resources staff handling conflict of interest cases

Participants leave with:

• A library of red-flag tests they can run on their own payment and vendor data.
• A vendor-to-employee matching method for surfacing undeclared conflicts.
• A draft integrity risk scoring model with documented assumptions.
• A dashboard design for monthly ethics and anti-bribery monitoring.
• A template for reporting analytic exceptions without prejudging individuals.
• A repeatable continuous monitoring plan for their organisation.

The programme is hands-on and works on anonymised datasets modelled on real integrity cases. It uses:

• Guided labs in Excel, Power BI and introductory Python
• Practice datasets of payments, vendors, payroll and declarations
• Case discussions of bribery and conflict of interest schemes
• Small-group exercises in interpreting and challenging exceptions
• A closing workshop to draft each participant's monitoring plan

On attending the sessions and completing the lab exercises, each participant receives a CPD-accredited Certificate of Completion from Vision Reach Global Consultancy.