Data Cleaning and Harvesting
During investigations, you will often find documents in different formats, making data analysis difficult and progress a challenge. Learning new Excel techniques for data cleaning is an essential step to transform this "chaos" into a clear and organized format. Along with the data harvesting techniques you will learn in this course, you will be able to quickly identify suspicious transactions that might indicate illicit activity.
Take your skills to the next level by learning how to:
- Prepare financial documents for data analysis
- Apply Excel functions to fix formatting errors
- Identify additional sources of financial data
- Use OCR software to digitise hard copies and export data
- Scrape data from websites.
This course is self-paced. You can start, take breaks, and continue at any time. It is structured in sessions that build on each other, so we recommend you start with Session 1.After completing the course, you will be eligible for a certificate of completion.
Note: If you are new to analysing financial data, we recommend you start with our course on Financial Analysis using Excel
Open-source Intelligence
Open-source intelligence (OSINT) is a central element of most corruption and money laundering investigations. The information and evidence you can gather from publicly available sources can make the difference between a successful investigation and a dead end. Through a simulated investigation, this course will help you learn the basics of how to prepare, conduct and report an OSINT undertaking.
- Introduction to OSINT and the intelligence cycle;
- Preparing your research environment;
- Searching the open web and deep web databases;
- Analysing domain records to find information about websites;
- Using cached and archived records to retrieve past versions of websites;
- Gathering information from social media sites;
- Exploiting the visual and meta information of images;
- Searching online communities, investigating dark web pages and bitcoin;
- Preparing a report of an OSINT investigation.
During the course you immerse yourself in a simulated investigation into the fishing vessel FV Malaga and its owner, the organisation Mossaman Commodities. You follow open-source leads about the misuse of company structures that reveal indicators of illegal fishing and the smuggling of endangered animal parts.
The course was developed by our eLearning team in collaboration with subject matter experts from ICAR and our Green Corruption programme, with primary funding from PMI Impact. Languages: English, Spanish, Portuguese, Latvian, Bulgarian, Serbian, Albanian, Ukrainian.
Cooperarea internațională în materie penală
Pentru majoritatea investigatorilor, Excel este instrumentul de alegere pentru analiza informațiilor financiare. Înacest curs, veți folosi Excel pentru a organiza și analiza volume mari de date, cum ar fi înregistrările bancare,facturile, înregistrările telefonice și tranzacțiile comerciale.
- Vă protejați datele de modificări accidentale
- Utilizați funcții simple pentru a găsi tranzacții care ies în evidențe
- Vă folosiți de puterea filtrelor pentru a găsi exact datele pe care le căutați
- Utilizați subtotaluri pentru a rezuma instantaneu datele dvs. financiare
- Creați rezumate interactive folosind PivotTables
De asemenea, veți obține o perspectivă asupra tiparelor tipice de utilizare ilegală a conturilorbancare, permițându-vă să explorați în continuare posibilitățile de analiză a datelor financiare.
Acest curs se desfășoară în ritm propriu. Puteți începe, lua pauză și continua oricând. Estestructurat în sesiuni care se bazează una pe cealaltă, așa că vă recomandăm să începeți cu Sesiunea 1. Dupăfinalizarea cu succes a cursului, veți fi eligibil pentru un certificat de absolvire. Limbi: Engleză, Spaniolă, Portugheză, Letonă, Bulgară, Ucraineană, Sârbă, Albaneză, Română.
Operational Analysis of Suspicious Transaction Reports
Analysing suspicious transactions for actitiesrelated to money laundering or the financing of terrorism is a corefunction of Financial Intelligence Units (FIUs).
In this course, you will learn to assess the risk of suspicious activity and analyse suspicious transaction reports(STRs).
This course was developed in co-operation with the Egmont Group ofFIUs and is based on the content of the Egmont Group’s on-site TacticalAnalysis training. It is aimed primarily at FIU analysts, but is usefulfor anyone analysing evidence as part of a financial investigation.
- Understand the core responsibilities of an FIU;
- Differentiate between information and intelligence;
- Assess the risk of suspicious activity;
- Conduct an analysis of an STR, including all steps of theintelligence cycle: creating a collection plan and hypothesis,collecting, analysing and evaluating information, and creating anddisseminating a report of your findings;
This course is self-paced. You can start, take breaks and continue atany time. It is structured in sessions that build on each other, so werecommend you start with Session 1. After successfully completing thecourse, you will be eligible for a certificate of completion.
Languages: English, Spanish, Portuguese, French, Ukrainian, Bulgarian.Analiză financiară folosind EXCEL
Pentru majoritatea investigatorilor, Excel este instrumentul de alegere pentru analiza informațiilor financiare. Înacest curs, veți folosi Excel pentru a organiza și analiza volume mari de date, cum ar fi înregistrările bancare,facturile, înregistrările telefonice și tranzacțiile comerciale.
- Vă protejați datele de modificări accidentale
- Utilizați funcții simple pentru a găsi tranzacții care ies în evidențe
- Vă folosiți de puterea filtrelor pentru a găsi exact datele pe care le căutați
- Utilizați subtotaluri pentru a rezuma instantaneu datele dvs. financiare
- Creați rezumate interactive folosind PivotTables
De asemenea, veți obține o perspectivă asupra tiparelor tipice de utilizare ilegală a conturilorbancare, permițându-vă să explorați în continuare posibilitățile de analiză a datelor financiare.
Acest curs se desfășoară în ritm propriu. Puteți începe, lua pauză și continua oricând. Estestructurat în sesiuni care se bazează una pe cealaltă, așa că vă recomandăm să începeți cu Sesiunea 1. Dupăfinalizarea cu succes a cursului, veți fi eligibil pentru un certificat de absolvire. Limbi: Engleză, Ucraineană, Portugheză, Albaneză, Sârbă, Spaniolă, Ucraineană, Bulgară- Trainer: Armen Oganesean
Visualise Cases and Flows of Money
Corruption and money laundering investigations often involve complex structures of persons, companies and otherentities. This is challenging to present to a supervisor or colleagues, or even in a courtroom. A graph or diagramdepicting the relationships between entities in the case and the flows of money between them can make it easier forothers to understand. In this course you will use the free software yEd software.
- Create clear and interpretable graph to present entities in a case you are investigating
- Visualise meaningful connections between these entities
- Depict the entities with custom pictures
- Use layout functions to make your graph ready for analysing in a few clicks
- Use Excel data to create graphs that make financial flows comprehensible
- Add meaningful details, such as thicker connection lines to represent greater amounts of money
- Make your graph versatile, for example by exporting it to PowerPoint
This course is self-paced. You can start, take breaks and continue at any time. It is structured in sessions thatbuild on each other, so we recommend you start with Session 1. After successfully completing the course, you will beeligible for a certificate of completion. Languages: English, Bulgarian, Ukrainian.
Illicit Enrichment: A Guide to Laws Targeting Unexplained Wealth
Illicit Enrichment by Andrew Dornbierer provides a comprehensive guide to illicit enrichment laws and their application to target unexplained wealth and recover proceeds of corruption and other crimes.
Guidelines for the efficient recovery of stolen assets
A set of international good practices toenhance the effectiveness and efficiency of the asset recovery process. Languages: English, French, Spanish.
Guide to the role of civil society organisations in asset recovery
A practical guide to how civil society organisations can play a role in the asset recovery process. Languages: English, Ukrainian, Arabic.
Illegal wildlife trade and financial crime
Part 1 of the learning series explores financial crimes and supply chain vulnerabilities that facilitate the illegal trade in wildlife and thereby increase companies’ legal, financial and reputational risks. It is aimed at companies, policy makers, practitioners and law enforcement.
Illegality in the exotic pet trade
Part 2 of the Wildlife crime – understanding risks, avenues for action learning series provides companies, policy makers, practitioners and law enforcement with information and background knowledge on crime and corruption in the exotic pet trade.
Forest crime and the illegal timber trade
Part 3 of the Wildlife crime – understanding risks, avenues for action learning series explores how corruption facilitates timber trafficking and the mingling of legal and illegal supply chains.
Informal networks and anti-corruption
Understand the role of informal social networks in enabling corruption, and why anti-corruption interventions should focus more on networks than on individuals.
Money laundering and sanctions evasion using the art market
This quick guide briefly explains the unique characteristics of the art market that make it vulnerable to money laundering and sanctions evasion. It also outlines steps that jurisdictions can take to prevent and combat abuse of the art trade for illicit purposes.
Money laundering through the gambling industry
This quick guide sets out how criminals abuse the gambling industry to launder illicit funds. It includes numerous recent case studies to illustrate different ways of laundering money in casinos, online gambling websites, bars and clubs, as well as physical and online sports betting services.
Court monitoring
This quick guide explains the role of national risk assessments in addressing money laundering and terrorist financing (ML/TF) risks. It explains how national risk assessments are conducted, challenges in terms of methodology and data availability, and how well countries are doing at performing them.
NRAs are a critical element of the Financial Action Task Force (FATF) standards on ML/TF. They also provide data in special reports of the Basel AML Index.
National risk assessments
This quick guide explains the role of national risk assessments in addressing money laundering and terrorist financing (ML/TF) risks. It explains how national risk assessments are conducted, challenges in terms of methodology and data availability, and how well countries are doing at performing them.
NRAs are a critical element of the Financial Action Task Force (FATF) standards on ML/TF. They also provide data in special reports of the Basel AML Index.
Tax investigations and illegal wildlife trade
What role could tax investigations play in detecting, investigating and prosecuting cases of illegal wildlife trade? Potentially a large one, with the right coordination and capacity.
This quick guide by Jovile Mungyereza, Financial Investigation Specialist in our Green Corruption programme and former Tax Investigations manager at the Uganda Revenue Authority, gives a brief introduction to the surprisingly under-researched and under-utilised possibility of using tax laws and investigations to target high-level wildlife traffickers.
TI Sri Lanka - Asset Tracing
Introduction to Asset Tracing and Recovery and the Role of Civil Society Organisations in Asset Recovery
- Trainer: Liza Young
Curso Planificación Estrategica Para El Sector Público CPESP6
El curso virtual asincrónico ofrecerá un análisis comprehensivo del rol de la planificación estratégica en el fortalecimiento de la Gestión Pública, a partir del estudio de las normas y disposiciones recientemente emitidas sobre la materia.
El participante aprenderá sobre la planificación en medio de la dinámica de la Administración Financiera del Sector Público (AF-SP), su rol e importancia para alcanzar los Resultados Prioritarios perseguidos por las Políticas Nacionales y aportar con efectividad en la Gestión de la Cadena de Valor Público. Beca completa gracias al Programa GFP Subnacional de la Cooperación Suiza - SECO. Enlace para inscripciones: https://forms.gle/mrUxtapZdjsmGrDv8
- Trainer: Limberg Chero
Survey: Continuing Education for Professionals with the Basel Institute on Governance
This survey aim to assess the needs and interests of professionals in anti-corruption, asset recovery, compliance, business integrity, good governance and related fields for advanced continuing education.
- Trainer: Jörg Schmidt
test
Testing some concepts
- Trainer: Harper Mitchell
- Trainer: Scarlet Wannenwetsch
- Trainer: Liza Young