Dataharvest 2024 - the European Investigative Journalism Conference

Imagine looking through millions of rows of import/export data to find categories of items that have changed suddenly, perhaps because of a conflict, sanctions, or for other reasons. You need SQL, and we will be exploring some more advanced concepts that can help spot the data which has changed suddenly. Participants will leave with a better understanding of when SQL outshines spreadsheets for analysis, and the power of window functions to compare row-level data with aggregation, such as sums, averages, and standard deviation. You will should also walk away with greater date processing skills in SQL. This is intermediate level SQL - familiarity with basic SQL concepts, such as GROUP BY, is required, though we will briefly review it If bringing your own laptop, you will need a SQL client that is compatible with a Sqlite database.