Applying Excel and SQL Server in journalism were in the focus of the hands-on workshops organised by the Center for Independent Journalism on 12 and 13 December 2016. The training sessions targeted journalists frequently dealing with large databases, primarily investigative reporters. On the first day the participants worked with Excel and Google Fusion Tables. They learned the basic calculating, sorting and filtering functions in order to find patterns in data. Furthermore, they practiced creating pivot tables and joining different tables for understanding the bigger picture.
On the second day SQL Servers were introduced. This software is based on basic coding and it is capable of providing more complex analyses in much bigger databases. SQL is also a useful tool to join tables and to discover more comprehensive stories.
Crina Boros, an award-winning, London-based investigative journalist and CAR trainer led the workshops on both days. She specialises in data analysis and access to information for cross-border and accountability-driven reporting. Her stories were published by the BBC, Thomson Reuters, the Greenpeace – Energy Desk, The Black Sea and OffshoreAlert. She has trained data journalists in several countries. She also held a course for beginners at the summer data journalism camp of the Center for Independent Journalism and the University of Pécs in July 2016.
More photos about the workshops (by Ilona Móricz and Eszter Kiss):