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
Collective Action Against Corruption
Collective Action is a powerful anti-corruption approach that brings businesses, civil society, and international stakeholders together to address shared corruption challenges and promote integrity and fair competition. This fully interactive course equips participants with the practical skills needed to conceptualise, establish, and implement Collective Action initiatives in diverse settings.
In this course, you will take on the role of Martha, a young entrepreneur in the fictional country of “Wakandaa.” Faced with a window of opportunity as the new government pledges to crack down on corruption, you will identify key stakeholders from the private sector, civil society, and the international community to join you in creating a Collective Action initiative. Together, you will explore the unique corruption challenges and work to promote fair business opportunities.
You will learn to:
- Identify and engage relevant stakeholders from the private sector, government, and civil society
- Understand the principles of Collective Action and how to apply them in anti-corruption efforts
- Navigate common challenges, such as managing conflicting stakeholder expectations and building trust
- Adapt to changing political and economic landscapes in the fight against corruption
- Develop and implement strategies for improving business integrity and fair competition
By the end of the course, you will have hands-on tools to build and lead successful Collective Action initiatives, addressing corruption challenges through collaboration and mutual trust.
This course is ideal for:
- Private sector professionals, including compliance officers, auditors, and risk managers
- Government representatives involved in anti-corruption or procurement initiatives
- Civil society and international organisations focused on transparency, accountability, and economic development
Intelijen Sumber informasi Terbuka
Intelijen Sumber informasi Terbuka/Open-Source Intelligence (OSINT) adalah inti sebagian besar penyelidikan korupsi dan pencucian uang. Informasi dan bukti yang Anda kumpulkan dari sumber yang tersedia untuk umum dapat menentukan apakah penyelidikan anda akan berhasil atau menemui jalan buntu. Melalui simulasi investigasi, kursus ini akan membantu Anda mempelajari dasar-dasar untuk mempersiapkan, melakukan, dan membuat laporan penyelidikan menggunakan OSINT.
- Pengantar OSINT dan siklus intelijen;
- Mempersiapkan lingkungan penelitian Anda;
- Melakukan pencarian di database open web dan deep web;
- Menganalisis catatan DNS untuk menemukan informasi tentang situs web;
- Menggunakan catatan cache dan arsip untuk mengakses versi situs web sebelumnya;
- Mengumpulkan informasi dari situs media sosial;
- Memanfaatkan informasi visual maupun meta dari foto;
- Melakukan pencarian komunitas daring, menyelidiki halaman dark web dan bitcoin;
- Menyiapkan laporan penyelidikan menggunakan OSINT.
Selama kursus ini Anda akan melakukan simulasi investigasi tentang kapal penangkap ikan FV Malaga dan pemiliknya, organisasi yang bernama Mossaman Commodities. Anda mengikuti petunjuk sumber terbuka tentang penyalahgunaan struktur perusahaan yang mengindikasikan penangkapan ikan ilegal dan penyelundupan bagian tubuh hewan yang terancam punah.
Kursus ini dikembangkan oleh tim eLearning kami bekerja sama dengan pakar dari ICAR dan program Green Corruption kami, dengan pendanaan utama dari PMI Impact. Bahasa: Inggris, Spanyol, Portugis, Latvia Bulgaria, Serbia, Albania, Ukraina.
International Cooperation and Mutual Legal Assistance in Criminal Matters
For most investigators, Excel is the tool of choice to analyse financial information. In thiscourse, you will useExcel to organise and analyse large volumes of data such as banking records, invoices, phonerecords and commercialtransactions.
- Protect your data from accidental changes
- Use simple functions to find transactions that stand out
- Unlock the power of filters to find exactly the data you are searching for
- Use subtotals to summarise your financial data instantly
- Create interactive summaries using PivotTables
You will also gain insight into typical patterns of illegal use of bank accounts, allowing you tofurther explorepossibilities to analyse financial data.
This course is self-paced. You can start, take breaks and continue at any time. It is structuredin sessions thatbuild on each other, so we recommend you start with Session 1. After successfully completing thecourse, you will beeligible for a certificate of completion Languages: English, Spanish, Portuguese, Latvian , Bulgarian, Ukrainian,Serbian, Albanian, Romanian.
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.Financial Analysis using Excel
For most investigators, Excel is the tool of choice to analyse financial information. In this course, you will use Excel to organise and analyse large volumes of data such as banking records, invoices, phone records and commercial transactions.
- Protect your data from accidental changes
- Use simple functions to find transactions that stand out
- Unlock the power of filters to find exactly the data you are searching for
- Use subtotals to summarise your financial data instantly
- Create interactive summaries using PivotTables
You will also gain insight into typical patterns of illegal use of bank accounts, allowing you to further explore possibilities to analyse financial data.
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 successfully completing the course, you will be eligible for a certificate of completion. Languages: English, Ukrainian, Portuguese, Albanian, Serbian, Spanish, Ukrainian, Bulgarian.