Data analysis of leaked documents in investigative journalism

This thesis concerns the analysis and creation of an interactive database showcasing a network of offshore companies based on five extensive sets of leaked documents that have been processed and made publicly available by the International Consortium of Investigative Journalists (ICIJ) in support of Open Source Intelligence (OSINT) processes. While ICIJ has developed its own database using this data, the search for information about individual companies is carried out through a search box and the results are displayed as a list of links matching the search. This can be confusing when dealing with such a large amount of data, leading users to overlook important information. The aim of this project is to create an interactive database that will display all relevant information about individual companies in one window using filters on a map and a supplementary table. The project is divided into two parts: theoretical and practical. The theoretical part outlines the fundamental principles of investigative journalism, along with methodologies for data collection, classification, verification, and protection. The practical part describes the process of data preparation and cleaning, which is essential for the subsequent creation of an interactive database using a visualization tool called Tableau. The goal is to create a user-friendly dashboard that will be publicly available on the Tableau Public portal.