Loading…
GIJC15 has ended
Welcome to GIJC15! We have more than 160 panels, workshops, and special events planned for the conference. Be sure to register so you can create a personalized schedule and better network with your colleagues. Unless marked Limited Capacity, sessions are open and you are free to come and go. 

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Data Hands-On [clear filter]
Thursday, October 8
 

11:00

Data Track: Basic Excel 1

Power through data with Excel and mine for impactful stories that only spreadsheets can disclose with a few clicks. This session will teach you the basics you need to turn tabular data into headlines and to edit your spreadsheet for user-friendly team work. Because every reporter needs to be able to check facts and figures.

For this session you need to bring your computer with a locally installed version of Microsoft Excel. If you dont have that, go to the Data-Pub and get it installed before you enter the session.


Moderators
avatar for Crina Boros

Crina Boros

Data-driven investigations, Freelance
Data-driven watchdog reporter based in London, international journalism trainer and offspring of the Centre for Investigative Journalism (CIJ). Published by Reuters, the BBC, ICIJ, openDemocracy, Greenpeace Unearthed, Euobserver & The Black Sea +. Shortlisted for the Paul Foot Award... Read More →
avatar for Yolanda Jinxin Ma

Yolanda Jinxin Ma

Co-founder & Editor, Data Journalism China
Yolanda Jinxin Ma is a frequent international speaker & trainer on data journalism. In the past few years she has trained 200+ journalists in China on data skills. She is currently working on innovation projects with the UN in Asia Pacific region. She was previously with Reuters on... Read More →

Thursday October 8, 2015 11:00 - 12:00
Birkebeiner 1 (Data Hands-On)

11:00

Data Track: Webscraping without Programming 1

This session is about extracting data from webpages without using any code. When data is stuck within webpages, you can't analyse or visualise it. By taking this session, you will learn how to extract data from thousands of pages and from pages that require clicks to see the data. We'll also build a Google sheet with live data inside it.


Speakers
avatar for Alex Gimson

Alex Gimson

Evangelist, Import.io
Alex Gimson is an evangelist at import. He has been part of the data scene for many years now starting off at a big data music company before moving over to import.io. NICAR 2015 Atlanta, the Internet of Things conference in London as well as various meetup groups around London and... Read More →


Thursday October 8, 2015 11:00 - 12:00
Weidemann 4 (Data Hands-On)

11:00

Data Track: Email Encryption 1
How do you secure your email? How does encryption work and how does it operate on your computer? This session will give you hands-on training with Mailvelope and other email clients. 

Speakers
avatar for Ola Haram

Ola Haram

Journalist, TV 2 Norway
Ola Haram is a journalist and crime reporter at TV 2, based in Oslo, Norway. He is on the board of the Norwegian Investigative Journalism Foundation (SKUP) and a member og ICIJ. He tweets as @haram... Read More →


Thursday October 8, 2015 11:00 - 12:00
Messanin (Data Hands-On)

12:30

Data Track: Basic Excel 2

Power through data with Excel and mine for impactful stories that only spreadsheets can disclose with a few clicks. This session will teach you the basics you need to turn tabular data into headlines and to edit your spreadsheet for user-friendly team work. Because every reporter needs to be able to check facts and figures.

For this session you need to bring your computer with a locally installed version of Microsoft Excel. If you dont have that, go to the Data-Pub and get it installed before you enter the session.


Moderators
avatar for Crina Boros

Crina Boros

Data-driven investigations, Freelance
Data-driven watchdog reporter based in London, international journalism trainer and offspring of the Centre for Investigative Journalism (CIJ). Published by Reuters, the BBC, ICIJ, openDemocracy, Greenpeace Unearthed, Euobserver & The Black Sea +. Shortlisted for the Paul Foot Award... Read More →
avatar for Yolanda Jinxin Ma

Yolanda Jinxin Ma

Co-founder & Editor, Data Journalism China
Yolanda Jinxin Ma is a frequent international speaker & trainer on data journalism. In the past few years she has trained 200+ journalists in China on data skills. She is currently working on innovation projects with the UN in Asia Pacific region. She was previously with Reuters on... Read More →

Thursday October 8, 2015 12:30 - 13:30
Birkebeiner 1 (Data Hands-On)

12:30

Data Track: Email Encryption 2
How do you secure your email? How does encryption work and how does it operate on your computer? This session will give you hands-on training with Mailvelope and other email clients. 

Speakers
avatar for Ola Haram

Ola Haram

Journalist, TV 2 Norway
Ola Haram is a journalist and crime reporter at TV 2, based in Oslo, Norway. He is on the board of the Norwegian Investigative Journalism Foundation (SKUP) and a member og ICIJ. He tweets as @haram... Read More →


Thursday October 8, 2015 12:30 - 13:30
Messanin (Data Hands-On)

12:30

Data Track: Webscraping without Programming 2

This session is about extracting data from webpages without using any code. Data is stuck within webpages making it unusable. You can't analyse and visualise it when it's stuck in a website. By taking this session, you will learn how to extract this data. Learn how to extract data from thousands of pages at a time, and to grab it from pages that require clicks to see it. We'll also build a Google sheet with live data inside it.


Speakers
avatar for Alex Gimson

Alex Gimson

Evangelist, Import.io
Alex Gimson is an evangelist at import. He has been part of the data scene for many years now starting off at a big data music company before moving over to import.io. NICAR 2015 Atlanta, the Internet of Things conference in London as well as various meetup groups around London and... Read More →


Thursday October 8, 2015 12:30 - 13:30
Weidemann 4 (Data Hands-On)

15:00

Data Track: Introduction to Access 1

Introduction to databases. Take the next step in data journalism and learn how to work with MS Access. You'll learn how to work with large data sets, to select, sort, and aggregate data. This class works best if you have some knowledge about Excel or similar programs.

For this session you need to bring your computer with a locally installed version of Microsoft Excel and Microsoft Access. If you dont have that, go to the Data-Pub and get it installed before you join us.

Mac does not support Access, so make sure you have a PC.


Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Journalism, Sveriges Television
Helena Bengtsson is Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster. She previously worked as Editor, Data Projects at the Guardian in London, UK between 2014-2017. In 2006 and 2007, she was database editor at the Center for Public Integrity... Read More →
avatar for Luuk Sengers

Luuk Sengers

Datajournalist, Mediatrainer, Story-Based Inquiry, Groene Amsterdammer
Luuk Sengers is an independent investigative journalist and teacher/trainer. He writes data driven stories about environment, climate and business for De Groene Amsterdammer. And he teaches investigative techniques, data journalism and interview skills to journalists, media, NGOs... Read More →


Thursday October 8, 2015 15:00 - 16:00
Birkebeiner 1 (Data Hands-On)

15:00

How To Create a Secure Leaks Platform
Moderators
avatar for Emilia Díaz-Struck

Emilia Díaz-Struck

Research Editor, ICIJ / Freelance
Emilia Díaz-Struck is the lead researcher for ICIJ's cross-border investigations. She is a professor of journalism at the Central University of Venezuela, and also co-founded Venezuelan news website Armando.info. Emilia has been a contributor for the Washington Post, and has also... Read More →

Speakers
avatar for Alessia Cerantola

Alessia Cerantola

Board member and reporter, Investigative Reporting Project Italy
Alessia Cerantola is a freelance journalist, board member and reporter of IRPI (Investigative Reporting Project Italy). Her favorite areas of interest are East Asia and freedom of the press related issues. In 2013 she was a Transatlantic Media Fellow of the Center for Strategic and... Read More →
avatar for Micah Lee

Micah Lee

SecureDrop developer, The Intercept
Micah Lee is a technologist with a focus on operational security, source protection, privacy, and cryptography. He is a founder and board member of Freedom of the Press Foundation and the author of the “Encryption Works” handbook.An avid GNU/Linux user, he has been writing co... Read More →


Thursday October 8, 2015 15:00 - 16:00
Messanin (Data Hands-On)

16:30

Data Track: Basic Coding for Journalists

You can take your journalism many steps further if you learn to code. You can build web scrapers, you can clean and analyze data, and you can build visualizations. If programming doesn't scare you, you'll find that by adding a bit code to many online services, you'll get a much better result.

It's not hard to code. It can actually be quite fun.

In this session you'll get an introduction to the fundamentals of programming. If you plan to go to later sessions on programming web scrapers, and if you have no prior knowledge of programming, you might want to start with this session.

The trainer of the session, Tommy Kaas, is a journalist, who taught himself to code to create web scrapers.

Bring your own laptop to the session.


Speakers
avatar for Adriana Homolova

Adriana Homolova

data journalist, KRO-NCRV
Data journalist @ Pointer / KRO-NCRVSleeps long hours and writes scrapers for fun.Listens to Boney M and so should you! https://www.youtube.com/watch?v=oR6eKmqSEa0
avatar for Tommy Kaas

Tommy Kaas

Editor, Kaas & Mulvad
Tommy Kaas is editor of Kaas & Mulvad (founded 2007), who specializes in finding news and patterns in complex data and presenting the results online. Tommy has many years of experience from a number of Danish media and from training Data Journalism, including as lecturer at the Journalism... Read More →


Thursday October 8, 2015 16:30 - 17:30
Messanin (Data Hands-On)

16:30

Data Track: DocumentCloud, analyzing huge text amounts

Here's how to organize your document trail. We see more and more situations in which journalists get lots of electronic documents and need tools for analyzing, sharing, and publishing. DocumentCloud is a good first step into this world. And with just an hour of practical training, you'll be up and running with this free tool.


Speakers
avatar for Rob Gebeloff

Rob Gebeloff

Data projects editor, New York Times
Robert Gebeloff has specialized in data journalism for nearly twenty years and has been a data projects editor at The New York Times since 2008. Recent projects include a look at the environmental impacts of the U.S. domestic oil boom, stories about obscure, specialized financial... Read More →
avatar for Nils Mulvad

Nils Mulvad

Investigative Reporting Denmark
Nils Mulvad is a co-founder of the Global Network for  Investigative Journalism and other international networks such as  Farmsubsidy.org. He was CEO for the Danish International Center for  Analytical Reporting 2001-2006, European journalist of the year in 2006,  and he also... Read More →


Thursday October 8, 2015 16:30 - 17:30
Weidemann 4 (Data Hands-On)

16:30

Data Track: Introduction to Access 2

Please note that this session is based on Access 1.
Introduction to databases. Take the next step in data journalism and learn how to work with MS Access. You'll learn how to work with large data sets, to select, sort, and aggregate data. This class works best if you have some knowledge about Excel or similar programs.

For this session you need to bring your computer with a locally installed version of Microsoft Excel and Microsoft Access. If you dont have that, go to the Data-Pub and get it installed before you join us.

Mac does not support Access, so make sure you have a PC. 


Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Journalism, Sveriges Television
Helena Bengtsson is Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster. She previously worked as Editor, Data Projects at the Guardian in London, UK between 2014-2017. In 2006 and 2007, she was database editor at the Center for Public Integrity... Read More →
avatar for Luuk Sengers

Luuk Sengers

Datajournalist, Mediatrainer, Story-Based Inquiry, Groene Amsterdammer
Luuk Sengers is an independent investigative journalist and teacher/trainer. He writes data driven stories about environment, climate and business for De Groene Amsterdammer. And he teaches investigative techniques, data journalism and interview skills to journalists, media, NGOs... Read More →


Thursday October 8, 2015 16:30 - 17:30
Birkebeiner 1 (Data Hands-On)
 
Friday, October 9
 

09:00

Data Track: Cleaning Dirty Data
Are your data ready for precision journalism?

Data doesn’t come in clean. Misspellings, duplicates, missing items, macros, hidden fields or records, and spaces can result in confusing, erroneous results or even make the analysis impossible. We’ll use real data sets to teach you how to track problems, how to clean dirty data, and how to format it for a confident analysis.

To participate in this class, you must be familiar with spreadsheets and have some experience with SQL. Help with downloading in the Data Pub Thursday 4.30 p.m.

Speakers
avatar for Crina Boros

Crina Boros

Data-driven investigations, Freelance
Data-driven watchdog reporter based in London, international journalism trainer and offspring of the Centre for Investigative Journalism (CIJ). Published by Reuters, the BBC, ICIJ, openDemocracy, Greenpeace Unearthed, Euobserver & The Black Sea +. Shortlisted for the Paul Foot Award... Read More →
avatar for Rob Gebeloff

Rob Gebeloff

Data projects editor, New York Times
Robert Gebeloff has specialized in data journalism for nearly twenty years and has been a data projects editor at The New York Times since 2008. Recent projects include a look at the environmental impacts of the U.S. domestic oil boom, stories about obscure, specialized financial... Read More →


Friday October 9, 2015 09:00 - 10:00
Weidemann 4 (Data Hands-On)

09:00

Data Track: Encryption of Your Laptop and USB Sticks 1
Speakers
avatar for Ola Haram

Ola Haram

Journalist, TV 2 Norway
Ola Haram is a journalist and crime reporter at TV 2, based in Oslo, Norway. He is on the board of the Norwegian Investigative Journalism Foundation (SKUP) and a member og ICIJ. He tweets as @haram... Read More →
avatar for Runa Sandvik

Runa Sandvik

Privacy and security researcher, Freelance
Runa A. Sandvik is a privacy and security researcher, working at the intersection of technology, law and policy. She regularly teaches digital security to journalists and helps media organizations improve their security posture. She is also a technical advisor to both the Freedom... Read More →


Friday October 9, 2015 09:00 - 10:00
Messanin (Data Hands-On)

09:00

Data Track: Pivot Tables in Excel

Learn how to summarize data in minutes rather than hours on your spreadsheet with pivot tables. This session will be most useful if you're already familiar with the basics of Excel or another spreadsheet program.


Speakers
avatar for Anuska Delic

Anuska Delic

founder & editor-in-chief, Oštro
An award-winning investigative and data journalist from Slovenia. A rookie in the exciting, yet rocky world of non-profit independent media in the European Union.In 2018 she left the main daily newspaper in Slovenia and established Oštro, Center for investigative journalism in the... Read More →
avatar for Megan Luther

Megan Luther

Training director, Investigative Reporters and Editors
Megan Luther joined IRE as training director in February 2012. Megan has worked in radio, TV and most recently, newspapers. Before she joined IRE, Megan was a government reporter for the Argus Leader in South Dakota and a computer-assisted reporting specialist for The Atlanta Journal-Constitution... Read More →


Friday October 9, 2015 09:00 - 10:00
Birkebeiner 1 (Data Hands-On)

10:30

Data Track: Encryption of your Laptop and USB Sticks 2
Speakers
avatar for Ola Haram

Ola Haram

Journalist, TV 2 Norway
Ola Haram is a journalist and crime reporter at TV 2, based in Oslo, Norway. He is on the board of the Norwegian Investigative Journalism Foundation (SKUP) and a member og ICIJ. He tweets as @haram... Read More →
avatar for Runa Sandvik

Runa Sandvik

Privacy and security researcher, Freelance
Runa A. Sandvik is a privacy and security researcher, working at the intersection of technology, law and policy. She regularly teaches digital security to journalists and helps media organizations improve their security posture. She is also a technical advisor to both the Freedom... Read More →


Friday October 9, 2015 10:30 - 11:30
Messanin (Data Hands-On)

10:30

Data Track: Investigative Dashboard 1 -- Follow the Money Worldwide
For decades corrupt politicians, shady businessmen, and big corporations have used offshore tax heavens to hide ownership and shift profits, depriving local economies of millions in tax revenues. In the past, following money across borders and trying to discover who was behind offshores was difficult and expensive. But reporters have worked hard reporting this issue and have frequently found clever ways to pierce the veil of secrecy.

Join us for this two-part, hands on-session and learn how to investigate complex business structures and access offshore records from your home computer. In part one we will talk investigations and how-to. In part two we will showcase different databases and investigate on the spot. Bring your questions with you.

Moderators
avatar for Nils Hanson

Nils Hanson

Investigative, Swedish Television
Nils Hanson was between 2003-2018 the editor-in-chief of Mission Investigate at the public service TV company Swedish Television (SVT). The investigative TV show is aired prime time one hour a week, 39 times a year. The program, produced by 35 people in the newsroom, makes stories... Read More →

Speakers
avatar for Miranda Patrucic

Miranda Patrucic

Regional Editor, OCCRP Sarajevo
Miranda Patrucic is an investigative reporter based in Sarajevo. She is regional editor for Organised Crime and Corruption Reporting Project (OCCRP ), focusing on Central Asia, the Balkans and the Caucasus. Highlights of her work include exposing billions in telecom bribes in Uzbekistan... Read More →


Friday October 9, 2015 10:30 - 11:30
Weidemann 3 (Presentations/Panels)

10:30

Data Track: Lookup Functions/Advanced Functions in Excel

Learn about advanced tricks in Excel that will blow your mind and give you control over your data like never before. We'll conquer common data-cleaning issues and much more.


Speakers
avatar for Anuska Delic

Anuska Delic

founder & editor-in-chief, Oštro
An award-winning investigative and data journalist from Slovenia. A rookie in the exciting, yet rocky world of non-profit independent media in the European Union.In 2018 she left the main daily newspaper in Slovenia and established Oštro, Center for investigative journalism in the... Read More →
avatar for Megan Luther

Megan Luther

Training director, Investigative Reporters and Editors
Megan Luther joined IRE as training director in February 2012. Megan has worked in radio, TV and most recently, newspapers. Before she joined IRE, Megan was a government reporter for the Argus Leader in South Dakota and a computer-assisted reporting specialist for The Atlanta Journal-Constitution... Read More →


Friday October 9, 2015 10:30 - 11:30
Birkebeiner 1 (Data Hands-On)

10:30

Data Track: Tableau 1, Beginners Session
Interactive data graphics in Tableau Public: Learn how to create beautiful, interactive data visualizations on short deadlines. No programming required. You'll learn everything you need to build data visualizations and publish them to your website with a simple embed code. You will learn how to connect to Excel files and other data, create maps and charts, make them interactive, and publish them on your site.

Tableau Public is a free tool for journalists. No previous experience with Tableau is necessary to take this class. Please bring your own laptop with Tableau Public already installed. (Please visit https://public.tableau.com/s/ to download the free Tableau Public Desktop application.)

Speakers
avatar for Florian Ramseger

Florian Ramseger

Marketing Specialist, Tableau
Florian Ramseger is a Marketing Specialist at Tableau, where he helps people see and understand their data using Tableau Public. He has a background in economics, statistics and data visualization. Prior to joining Tableau he has worked for international organizations and in acad... Read More →
avatar for Sophie Sparkes

Sophie Sparkes

Data Analyst, Tableau
Sophie Sparkes is a Data Analyst at Tableau with the Tableau Public team. Every day she helps European journalists and bloggers visualize their data to tell insightful stories. She has a background in analytics and government. You can see some of her personal data visualization work... Read More →


Friday October 9, 2015 10:30 - 11:30
Weidemann 4 (Data Hands-On)

12:00

Data Track: Advanced Access
Here we continue to work with MS Access, learning how to upload spreadsheets and text files into your database. We'll look at different methods to match tables with each other to find out which items are in common between two tables. This class works best if you have basic knowledge of Access.

For this session you need to bring your computer with a locally installed version of Microsoft Excel and Microsoft Access. If you dont have that, go to the Data-Pub and get it installed before you join us.

Speakers
avatar for Helena Bengtsson

Helena Bengtsson

Editor, Data Journalism, Sveriges Television
Helena Bengtsson is Editor for Data Journalism at Sveriges Television, Sweden’s national television broadcaster. She previously worked as Editor, Data Projects at the Guardian in London, UK between 2014-2017. In 2006 and 2007, she was database editor at the Center for Public Integrity... Read More →
avatar for Luuk Sengers

Luuk Sengers

Datajournalist, Mediatrainer, Story-Based Inquiry, Groene Amsterdammer
Luuk Sengers is an independent investigative journalist and teacher/trainer. He writes data driven stories about environment, climate and business for De Groene Amsterdammer. And he teaches investigative techniques, data journalism and interview skills to journalists, media, NGOs... Read More →


Friday October 9, 2015 12:00 - 13:00
Birkebeiner 1 (Data Hands-On)

12:00

Data Track: Investigative Dashboard 2 -- Follow the Money Worldwide
For decades corrupt politicians, shady businessmen and big corporations have used offshore tax heavens to hide ownership and shift profits depriving local economies of millions in tax revenues. In the past, following money across borders and trying to discover who was behind offshores was difficult and expensive. But reporters have worked hard reporting this issue and have frequently found clever ways to pierce the veil of secrecy.

Join us for a two-part hands on session and learn how to investigate complex business structures and access offshore records from your home computer. In part one we will talk investigations and how to. In part two we will showcase different databases and investigate on the stop. Bring your questions with you.

Speakers
avatar for Miranda Patrucic

Miranda Patrucic

Regional Editor, OCCRP Sarajevo
Miranda Patrucic is an investigative reporter based in Sarajevo. She is regional editor for Organised Crime and Corruption Reporting Project (OCCRP ), focusing on Central Asia, the Balkans and the Caucasus. Highlights of her work include exposing billions in telecom bribes in Uzbekistan... Read More →
avatar for Paul Radu

Paul Radu

Exec Director, OCCRP Bucharest
Paul Radu (@IDashboard) is the executive director of the Organized Crime and Corruption Reporting  Project and a co-creator of the Investigative Dashboard concept, of Visual investigative Scenarios visualization software and of RISE Project, a platform for investigative reporters... Read More →


Friday October 9, 2015 12:00 - 13:00
Weidemann 3 (Presentations/Panels)

12:00

Data Track: Tableau 2, Advanced session
Advanced design and interaction in Tableau Public: Analyzing data and coming up interactive visualizations is easy in Tableau, but sometimes getting everything looking polished isn’t. In this session you will learn how to break away from the default formatting in Tableau Public to create interactive data graphics that match your style guides and engage your readers. You will learn how to change colours, shapes, borders, fonts, and other basic formatting, and to incorporate images, logos, and other graphic elements. You will learn how to take advantage of advanced interaction techniques to incorporate multimedia and utilize design and layout best practices to make sure that your visualization looks polished and professional.

Tableau Public is a free tool for journalists. Some familiarity with the product is recommended; a beginner session earlier in the day should prepare you enough for this session. Please bring your own laptop with Tableau Public already installed. (Please visit https://public.tableau.com/s/ to download the free Tableau Public Desktop application.)

Speakers
avatar for Florian Ramseger

Florian Ramseger

Marketing Specialist, Tableau
Florian Ramseger is a Marketing Specialist at Tableau, where he helps people see and understand their data using Tableau Public. He has a background in economics, statistics and data visualization. Prior to joining Tableau he has worked for international organizations and in acad... Read More →
avatar for Sophie Sparkes

Sophie Sparkes

Data Analyst, Tableau
Sophie Sparkes is a Data Analyst at Tableau with the Tableau Public team. Every day she helps European journalists and bloggers visualize their data to tell insightful stories. She has a background in analytics and government. You can see some of her personal data visualization work... Read More →


Friday October 9, 2015 12:00 - 13:00
Weidemann 4 (Data Hands-On)

14:30

Data Track: Basic Math for Managing Data

This session will look at basic calculations for overview analysis of data, showing ways to quickly find stories through ratios, rates, percentage change, and summarizing data with pivot tables.


Speakers
avatar for Brant Houston

Brant Houston

Knight Chair in Investigative Reporting, University of Illinois
Brant Houston is the Knight Chair in Investigative Reporting at the University of Illinois where he teaches and works on projects and research involving the use of data analysis in journalism. He is co-founder of the Global Investigative Journalism Network and the Institute for Nonprofit... Read More →


Friday October 9, 2015 14:30 - 15:30
Weidemann 4 (Data Hands-On)

14:30

Data Track: Security Apps for Text and Voice

How can you secure your smartphone communications? This session will teach you how to establish encrypted mobile voice and text communication. We cover the following apps: TextSecure, RedPhone and Signal (Whisper). Android and iOS.


Speakers
avatar for Ola Haram

Ola Haram

Journalist, TV 2 Norway
Ola Haram is a journalist and crime reporter at TV 2, based in Oslo, Norway. He is on the board of the Norwegian Investigative Journalism Foundation (SKUP) and a member og ICIJ. He tweets as @haram... Read More →
avatar for Runa Sandvik

Runa Sandvik

Privacy and security researcher, Freelance
Runa A. Sandvik is a privacy and security researcher, working at the intersection of technology, law and policy. She regularly teaches digital security to journalists and helps media organizations improve their security posture. She is also a technical advisor to both the Freedom... Read More →


Friday October 9, 2015 14:30 - 15:30
Messanin (Data Hands-On)

14:30

Data Track: Stats for Stories 1 - Descriptive Statistics

Get help with software downloading in the Data Pub Thursday 3.00-4.30 p.m.

You're comfortable doing data analysis in spreadsheets for your stories and managing databases. But now you would like to take your data journalism and analytical skills to the next level. This session introduces using statistics for stories. It will cover a more systematic way of thinking about your approach to data and then applying your new understanding through descriptive statistics with an emphasis on storytelling. Familiarity with spreadsheets is necessary but no experience with statistics is assumed.

Attendees shoud download software before the session: PSPP stats program. It is very similar to SPSS and even runs the SPSS syntax. Also PSPP has a Mac OS X version and a current Windows version.

Both can be found through links here: http://www.gnu.org/software/pspp/get.html
You can get installation help at the Data Pub Thursday between 3 p.m. and 4.30 p.m. 


Speakers
avatar for David Donald

David Donald

Data Editor, Investigative Reporting Workshop
David Donald is Data Editor at the Investigative Reporting Workshop at American University and Data Journalist in Residence at AU's School of Communication. Previously, he has been Data Editor at the Center for Public Integrity and Training Director at Investigative Reporters and... Read More →
avatar for Andrew Lehren

Andrew Lehren

Reporter, New York Times
Andy Lehren is an NBC News investigative reporter who specializes in data journalism. He previously worked as an investigative reporter for the NY Times, where he mined the Snowden files; probed Wikileaks diplomatic cables, including for the best-selling book “Open Secrets... Read More →


Friday October 9, 2015 14:30 - 15:30
Birkebeiner 1 (Data Hands-On)

16:00

Data Track: Cleaning Data with Open Refine

Open Refine is the best tool to clean really dirty data -- the kind of data in which the same name might be spelled in 30 different ways. It has built-in cleaning tools for analysts and journalists. 


Speakers
avatar for Rob Gebeloff

Rob Gebeloff

Data projects editor, New York Times
Robert Gebeloff has specialized in data journalism for nearly twenty years and has been a data projects editor at The New York Times since 2008. Recent projects include a look at the environmental impacts of the U.S. domestic oil boom, stories about obscure, specialized financial... Read More →
avatar for Nils Mulvad

Nils Mulvad

Investigative Reporting Denmark
Nils Mulvad is a co-founder of the Global Network for  Investigative Journalism and other international networks such as  Farmsubsidy.org. He was CEO for the Danish International Center for  Analytical Reporting 2001-2006, European journalist of the year in 2006,  and he also... Read More →


Friday October 9, 2015 16:00 - 17:00
Weidemann 4 (Data Hands-On)

16:00

Data Track: Python for Scraping 1

An introduction to webscraping with Python: This two-part, hands-on workshop will teach basic newsroom programming concepts using the Python language. We'll cover how to deconstruct a common reporting task -- gathering a table of data from a public website -- and assemble a solution from useful Python libraries that you can use again and again.

Prerequisites: Attendees should be familiar with HTML and the command line and be comfortable with databases and SQL. If you've ever written a string function in Excel ("=left(A2,5)"), you'll be fine.

Python has to be installed at your laptop before the training. Somebody can help you at the “Data Pub” on Thursday.

 


Speakers
avatar for Tommy Kaas

Tommy Kaas

Editor, Kaas & Mulvad
Tommy Kaas is editor of Kaas & Mulvad (founded 2007), who specializes in finding news and patterns in complex data and presenting the results online. Tommy has many years of experience from a number of Danish media and from training Data Journalism, including as lecturer at the Journalism... Read More →
avatar for Tom Meagher

Tom Meagher

Deputy Managing Editor, The Marshall Project
Tom Meagher is the deputy managing editor of the Marshall Project, a nonprofit, non-partisan news organization covering crime and justice in America. A veteran reporter and editor, he previously led an interactive team for the Digital First Media newspaper chain and was the data editor... Read More →


Friday October 9, 2015 16:00 - 17:00
Messanin (Data Hands-On)

16:00

Data Track: Stats for Stories 2 - Statistical Significance

Get help with software downloading in the Data Pub Thursday 3.00-4.30 p.m.

This session builds on skills learned in Stats for Stories 1. Now that you have a familiar way to thinking statistically about your data, this session introduces the notion of statistical significance and how to use it to back up findings from cross tabulations. In a sense, it helps answer the questions: Is what I'm finding in my data worth reporting?


Speakers
avatar for David Donald

David Donald

Data Editor, Investigative Reporting Workshop
David Donald is Data Editor at the Investigative Reporting Workshop at American University and Data Journalist in Residence at AU's School of Communication. Previously, he has been Data Editor at the Center for Public Integrity and Training Director at Investigative Reporters and... Read More →
avatar for Andrew Lehren

Andrew Lehren

Reporter, New York Times
Andy Lehren is an NBC News investigative reporter who specializes in data journalism. He previously worked as an investigative reporter for the NY Times, where he mined the Snowden files; probed Wikileaks diplomatic cables, including for the best-selling book “Open Secrets... Read More →


Friday October 9, 2015 16:00 - 17:00
Birkebeiner 1 (Data Hands-On)

17:30

Data Track: Python for Scraping 2

An introduction to webscraping with Python: This two-part, hands-on workshop will teach basic newsroom programming concepts using the Python language. We'll cover how to deconstruct a common reporting task -- gathering a table of data from a public website -- and assemble a solution from useful Python libraries that you can use again and again.

Prerequisites: Attendees should be familiar with HTML and the command line and be comfortable with databases and SQL. If you've ever written a string function in Excel ("=left(A2,5)"), you'll be fine.

Python has to be installed at your laptop before the training. Somebody can help you at the “Data Pub” on Thursday.

 


Speakers
avatar for Tommy Kaas

Tommy Kaas

Editor, Kaas & Mulvad
Tommy Kaas is editor of Kaas & Mulvad (founded 2007), who specializes in finding news and patterns in complex data and presenting the results online. Tommy has many years of experience from a number of Danish media and from training Data Journalism, including as lecturer at the Journalism... Read More →
avatar for Tom Meagher

Tom Meagher

Deputy Managing Editor, The Marshall Project
Tom Meagher is the deputy managing editor of the Marshall Project, a nonprofit, non-partisan news organization covering crime and justice in America. A veteran reporter and editor, he previously led an interactive team for the Digital First Media newspaper chain and was the data editor... Read More →


Friday October 9, 2015 17:30 - 18:30
Messanin (Data Hands-On)

17:30

Data Track: Stats for Stories 3 - Regression Analysis

Get help with software downloading in the Data Pub Thursday 3.00-4.30 p.m.

This final stats session, again building on skills learned in Stats for Stories 1 and 2, introduces one of the most powerful statistical procedures in the investigative reporter's toolkit. We'll cover regression analysis and the power it can add to your storytelling.


Speakers
avatar for David Donald

David Donald

Data Editor, Investigative Reporting Workshop
David Donald is Data Editor at the Investigative Reporting Workshop at American University and Data Journalist in Residence at AU's School of Communication. Previously, he has been Data Editor at the Center for Public Integrity and Training Director at Investigative Reporters and... Read More →
avatar for Andrew Lehren

Andrew Lehren

Reporter, New York Times
Andy Lehren is an NBC News investigative reporter who specializes in data journalism. He previously worked as an investigative reporter for the NY Times, where he mined the Snowden files; probed Wikileaks diplomatic cables, including for the best-selling book “Open Secrets... Read More →


Friday October 9, 2015 17:30 - 18:30
Birkebeiner 1 (Data Hands-On)
 
Saturday, October 10
 

09:00

Data Track: Chat Encryption 1

Here's how to securely communicate with sources and colleagues around the world. This session will teach you how to establish encrypted chat. We will create a DuckDuckGo account, install Pidgin (PC) or Audium (Mac) and the Off The Record (OTR) plugin. Finally, we will exchange fingerprints and talk about general security surrounding the use of encrypted chat. Mac and PC.


Speakers
avatar for Smari McCarthy

Smari McCarthy

Chief technologist, OCCRP
Smári McCarthy is chief technologist at the Organized Crime and Corruption Reporting Project. He lives at the intersection between politics and technology, working and writing on free software, information security, privacy, free speech, transparency and other related issues. He... Read More →


Saturday October 10, 2015 09:00 - 10:00
Messanin (Data Hands-On)

09:00

Data Track: Mapping with CartoDB 1

In the two CartoDB sessions you'll learn how to create interactive maps for the web with a free tool. CartoDB is an online application, and you won't have to install anything on your computer.

In this first session you'll be introduced to CartoDB. We will geocode addresses and create maps with points. You'll learn the basic map operations. We'll style the map and the info windows and make the map ready for publishing.

Bring your laptop to the session

Speakers
avatar for Tommy Kaas

Tommy Kaas

Editor, Kaas & Mulvad
Tommy Kaas is editor of Kaas & Mulvad (founded 2007), who specializes in finding news and patterns in complex data and presenting the results online. Tommy has many years of experience from a number of Danish media and from training Data Journalism, including as lecturer at the Journalism... Read More →


Saturday October 10, 2015 09:00 - 10:00
Weidemann 4 (Data Hands-On)

09:00

Data Track: Structured Query Language (SQL) for Reporters 1

Get help with software downloading in the Data Pub Thursday 4.30-6.00 p.m.
All data journalists can benefit from learning Structured Query Language or SQL, the language behind database managers. Whether you're hunting for evidence in large databases, needing to mash data tables together, or building an interactive database for your news organization, SQL is a tool for making these data skills possible. This course introduces SQL with an emphasis on how it can help reporters manage data for deeper investigative dives into that data.

These sessions introduce the SQL model and cover the basics of writing SQL queries. Familiarity with spreadsheets is helpful but no experience with SQL or databases is assumed.

Attendees should install software before the session, and they can get installation help at the Data Pub Thursday between 4.30 p.m. and 6 p.m.

Microsoft Access is the way to start and it’s only available on Windows.
If not Access, the Windows users should either install SQL Server Express 2014 found here:https://www.microsoft.com/en-us/download/details.aspx?id=42299.

They should select ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe for the correct 32-bit installer or ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe for the correct 64-bit installer. If they’re not sure which to use, then have them install the 32-bit by default. The software is free but not open source.
Or they can go open source (and free) by installing PostgreSQL from herehttp://www.postgresql.org/download/.  From that page, there are both 32-bit and 64-bit installers. Once PostgreSQL is installed, they should next install Navicat on top of that found here: http://www.navicat.com/download/navicat-for-postgresql. They’ll have to use the 14-day trial version unless they want to purchase it outright.

For Mac users, we’re recommending PostgreSQL for Mac followed by Navicat on top of that. PostreSQL is found here http://www.enterprisedb.com/products-services-training/pgdownload#osx  and Navicat here: http://www.navicat.com/download/navicat-for-postgresql.

You can get installation help at the Data Pub Thursday between 3 p.m. and 4.30 p.m. 


Speakers
avatar for David Donald

David Donald

Data Editor, Investigative Reporting Workshop
David Donald is Data Editor at the Investigative Reporting Workshop at American University and Data Journalist in Residence at AU's School of Communication. Previously, he has been Data Editor at the Center for Public Integrity and Training Director at Investigative Reporters and... Read More →
avatar for Luuk Sengers

Luuk Sengers

Datajournalist, Mediatrainer, Story-Based Inquiry, Groene Amsterdammer
Luuk Sengers is an independent investigative journalist and teacher/trainer. He writes data driven stories about environment, climate and business for De Groene Amsterdammer. And he teaches investigative techniques, data journalism and interview skills to journalists, media, NGOs... Read More →


Saturday October 10, 2015 09:00 - 10:00
Birkebeiner 1 (Data Hands-On)

10:30

Data Track: Chat Encryption 2

Here's how to securely communicate with sources and colleagues around the world. This session will teach you how to establish encrypted chat. We will create a DuckDuckGo account, install Pidgin (PC) or Audium (Mac) and the Off The Record (OTR) plugin. Finally, we will exchange fingerprints and talk about general security surrounding the use of encrypted chat. Mac and PC..


Speakers
avatar for Smari McCarthy

Smari McCarthy

Chief technologist, OCCRP
Smári McCarthy is chief technologist at the Organized Crime and Corruption Reporting Project. He lives at the intersection between politics and technology, working and writing on free software, information security, privacy, free speech, transparency and other related issues. He... Read More →


Saturday October 10, 2015 10:30 - 11:30
Messanin (Data Hands-On)

10:30

Data Track: Mapping with CartoDB 2

In this second of two sessions you'll learn to use more features in CartoDB. You will see how to create a cloropleth map like this, and we will style the polygons so the different colors reflect different values in the dataset, we are visualizing. We will merge datasets inside CartoDB, a technique which will make it easy to upload datasets, and based on those create cloropleth maps. We'll also create visualizations using several maps. To join this session you must attend session 1 or have a basic knowledge of CartoDB.

Bring your own laptop to the session.


Speakers
avatar for Tommy Kaas

Tommy Kaas

Editor, Kaas & Mulvad
Tommy Kaas is editor of Kaas & Mulvad (founded 2007), who specializes in finding news and patterns in complex data and presenting the results online. Tommy has many years of experience from a number of Danish media and from training Data Journalism, including as lecturer at the Journalism... Read More →


Saturday October 10, 2015 10:30 - 11:30
Weidemann 4 (Data Hands-On)

10:30

Data Track: Structured Query Language (SQL) for Reporters 2

Get help with software downloading in the Data Pub Thursday 4.30-6.00 p.m.

This session builds on skills learned in Structured Query Language for Reporters 1. Now that you've written your first SQL queries, expand you analytical power by learning to summarize and aggregate your data through SQL queries. We'll emphasize how SQL commands help you find evidence for your investigations in larger databases.


Speakers
avatar for David Donald

David Donald

Data Editor, Investigative Reporting Workshop
David Donald is Data Editor at the Investigative Reporting Workshop at American University and Data Journalist in Residence at AU's School of Communication. Previously, he has been Data Editor at the Center for Public Integrity and Training Director at Investigative Reporters and... Read More →
avatar for Luuk Sengers

Luuk Sengers

Datajournalist, Mediatrainer, Story-Based Inquiry, Groene Amsterdammer
Luuk Sengers is an independent investigative journalist and teacher/trainer. He writes data driven stories about environment, climate and business for De Groene Amsterdammer. And he teaches investigative techniques, data journalism and interview skills to journalists, media, NGOs... Read More →


Saturday October 10, 2015 10:30 - 11:30
Birkebeiner 1 (Data Hands-On)

12:00

Data Track: Mapping with Arc 1

Get help with Sofware downloading Friday 4.00-5.00 p.m. in the Data Pub.

This class will introduce you to analyzing data for stories by using mapping software. More than just a pretty picture, mapping software can help you uncover stories that others miss.

The sessions will use ArcGIS Online. You will get free licenses so you can use the software when you return to your home country.

This class is divided into two parts. Each session is one-hour long. You are not expected to have any mapping skills beforehand, but if you know how to use a spreadsheet, that would be helpful. 


Speakers
avatar for Jennifer LaFleur

Jennifer LaFleur

Senior Editor, Center of Investigative Reporting
Jennifer LaFleur is senior editor for data journalism at The Center for Investigative Reporting. Previously, she was the director of computer-assisted reporting at ProPublica and has held similar roles at The Dallas Morning News, the San Jose Mercury News and the St. Louis... Read More →
avatar for Andrew Lehren

Andrew Lehren

Reporter, New York Times
Andy Lehren is an NBC News investigative reporter who specializes in data journalism. He previously worked as an investigative reporter for the NY Times, where he mined the Snowden files; probed Wikileaks diplomatic cables, including for the best-selling book “Open Secrets... Read More →


Saturday October 10, 2015 12:00 - 13:00
Weidemann 4 (Data Hands-On)

12:00

Data Track: Simple Visualizations with Datawrapper
Do you crave a visualization tool that won't take much of your time on a busy election night? Or while publishing a breaking story? Datawrapper is a simple yet effective tool for creating interactive charts. It’s easy to learn even for the up-and-coming data journalist. In this hands-on session, you will import data into Datawrapper, refine the design of the charts, and then embedd them.

Participants should create a free account at datawrapper.de prior to the session.

Speakers
avatar for Anuska Delic

Anuska Delic

founder & editor-in-chief, Oštro
An award-winning investigative and data journalist from Slovenia. A rookie in the exciting, yet rocky world of non-profit independent media in the European Union.In 2018 she left the main daily newspaper in Slovenia and established Oštro, Center for investigative journalism in the... Read More →


Saturday October 10, 2015 12:00 - 13:00
Messanin (Data Hands-On)

12:00

Data Track: Structured Query Language (SQL) for Reporters 3

Get help with software downloading in the Data Pub Thursday 4.30-6.00 p.m.

This final SQL session, again building on skills learned in Structure Query Language for Reporters 1 and 2, shows how to write SQL queries that join separate data tables and databases together for more powerful investigative analysis.

 


Speakers
avatar for David Donald

David Donald

Data Editor, Investigative Reporting Workshop
David Donald is Data Editor at the Investigative Reporting Workshop at American University and Data Journalist in Residence at AU's School of Communication. Previously, he has been Data Editor at the Center for Public Integrity and Training Director at Investigative Reporters and... Read More →
avatar for Luuk Sengers

Luuk Sengers

Datajournalist, Mediatrainer, Story-Based Inquiry, Groene Amsterdammer
Luuk Sengers is an independent investigative journalist and teacher/trainer. He writes data driven stories about environment, climate and business for De Groene Amsterdammer. And he teaches investigative techniques, data journalism and interview skills to journalists, media, NGOs... Read More →


Saturday October 10, 2015 12:00 - 13:00
Birkebeiner 1 (Data Hands-On)

14:30

Data Track: Creating Timelines 1

Displaying a series of events can be as simple as drawing a straight line. But if you want to get fancier, there are a bunch of other options to display chronologies and storylines. In this workshop, we'll take a tour of current timelines in the wild and walk you through three open-source tools to help you make your own: ProPublica's TimelineSetter, Zach Wise's TimelineJS, and WNYC's Vertical Timeline.


Moderators
avatar for Megan Luther

Megan Luther

Training director, Investigative Reporters and Editors
Megan Luther joined IRE as training director in February 2012. Megan has worked in radio, TV and most recently, newspapers. Before she joined IRE, Megan was a government reporter for the Argus Leader in South Dakota and a computer-assisted reporting specialist for The Atlanta Journal-Constitution... Read More →

Speakers
avatar for Lena Groeger

Lena Groeger

Investigative journalist & Developer, ProPublica
Lena Groeger is an investigative journalist and developer at ProPublica, where she makes interactive graphics and writes about design’s real world consequences. She is on the board of the Society for News Design, and has taught classes on design and data visualization at NYU... Read More →


Saturday October 10, 2015 14:30 - 15:30
Birkebeiner 1 (Data Hands-On)

14:30

Data Track: Mapping with Arc 2

Get help with Sofware downloading Friday 4.00-5.00 p.m. in the Data Pub.
This class will introduce you to analyzing data for stories by using mapping software. More than just a pretty picture, mapping software can help you uncover stories that others miss.

The sessions will use ArcGIS Online. You will get free licenses so you can use the software when you return to your home country.

This class is divided into two parts. Each session is one-hour long. You are not expected to have any mapping skills beforehand, but if you know how to use a spreadsheet, that would be helpful. 


Speakers
avatar for Jennifer LaFleur

Jennifer LaFleur

Senior Editor, Center of Investigative Reporting
Jennifer LaFleur is senior editor for data journalism at The Center for Investigative Reporting. Previously, she was the director of computer-assisted reporting at ProPublica and has held similar roles at The Dallas Morning News, the San Jose Mercury News and the St. Louis... Read More →
avatar for Andrew Lehren

Andrew Lehren

Reporter, New York Times
Andy Lehren is an NBC News investigative reporter who specializes in data journalism. He previously worked as an investigative reporter for the NY Times, where he mined the Snowden files; probed Wikileaks diplomatic cables, including for the best-selling book “Open Secrets... Read More →


Saturday October 10, 2015 14:30 - 15:30
Weidemann 4 (Data Hands-On)

14:30

Data Track: Python for Scraping 3

An introduction to webscraping with Python: This two-part, hands-on workshop will teach basic newsroom programming concepts using the Python language. We'll cover how to deconstruct a common reporting task -- gathering a table of data from a public website -- and assemble a solution from useful Python libraries that you can use again and again.

Prerequisites: Attendees should be familiar with HTML and the command line and be comfortable with databases and SQL. If you've ever written a string function in Excel ("=left(A2,5)"), you'll be fine.

Python has to be installed at your laptop before the training. Somebody can help you at the “Data Pub” on Thursday.

 


Speakers
avatar for Adriana Homolova

Adriana Homolova

data journalist, KRO-NCRV
Data journalist @ Pointer / KRO-NCRVSleeps long hours and writes scrapers for fun.Listens to Boney M and so should you! https://www.youtube.com/watch?v=oR6eKmqSEa0
avatar for Tom Meagher

Tom Meagher

Deputy Managing Editor, The Marshall Project
Tom Meagher is the deputy managing editor of the Marshall Project, a nonprofit, non-partisan news organization covering crime and justice in America. A veteran reporter and editor, he previously led an interactive team for the Digital First Media newspaper chain and was the data editor... Read More →


Saturday October 10, 2015 14:30 - 15:30
Messanin (Data Hands-On)

16:00

Data Track: Creating Timelines 2

Displaying a series of events can be as simple as drawing a straight line. But if you want to get fancier, there are a bunch of other options to display chronologies and storylines. In this workshop, we'll take a tour of current timelines in the wild and walk you through three open-source tools to help you make your own: ProPublica's TimelineSetter, Zach Wise's TimelineJS, and WNYC's Vertical Timeline.


Speakers
avatar for Lena Groeger

Lena Groeger

Investigative journalist & Developer, ProPublica
Lena Groeger is an investigative journalist and developer at ProPublica, where she makes interactive graphics and writes about design’s real world consequences. She is on the board of the Society for News Design, and has taught classes on design and data visualization at NYU... Read More →


Saturday October 10, 2015 16:00 - 17:00
Birkebeiner 1 (Data Hands-On)

16:00

Data Track: Python for Scraping 4

An introduction to webscraping with Python: This two-part, hands-on workshop will teach basic newsroom programming concepts using the Python language. We'll cover how to deconstruct a common reporting task -- gathering a table of data from a public website -- and assemble a solution from useful Python libraries that you can use again and again.

Prerequisites: Attendees should be familiar with HTML and the command line and be comfortable with databases and SQL. If you've ever written a string function in Excel ("=left(A2,5)"), you'll be fine.

Python has to be installed at your laptop before the training. Somebody can help you at the “Data Pub” on Thursday.

 


Speakers
avatar for Adriana Homolova

Adriana Homolova

data journalist, KRO-NCRV
Data journalist @ Pointer / KRO-NCRVSleeps long hours and writes scrapers for fun.Listens to Boney M and so should you! https://www.youtube.com/watch?v=oR6eKmqSEa0
avatar for Tom Meagher

Tom Meagher

Deputy Managing Editor, The Marshall Project
Tom Meagher is the deputy managing editor of the Marshall Project, a nonprofit, non-partisan news organization covering crime and justice in America. A veteran reporter and editor, he previously led an interactive team for the Digital First Media newspaper chain and was the data editor... Read More →


Saturday October 10, 2015 16:00 - 17:00
Messanin (Data Hands-On)

17:30

Data Track: PDF Cracking with CometDocs

Importing PDFs and getting structured data out of the files is a challenge. We'll train you to use CometDocs and structuring in Excel. CometDocs is for now the best tool to extract the kind of strange characters we face when converting from different languages. It is free for all members of IRE.


Speakers
avatar for Anuska Delic

Anuska Delic

founder & editor-in-chief, Oštro
An award-winning investigative and data journalist from Slovenia. A rookie in the exciting, yet rocky world of non-profit independent media in the European Union.In 2018 she left the main daily newspaper in Slovenia and established Oštro, Center for investigative journalism in the... Read More →
avatar for Nils Mulvad

Nils Mulvad

Investigative Reporting Denmark
Nils Mulvad is a co-founder of the Global Network for  Investigative Journalism and other international networks such as  Farmsubsidy.org. He was CEO for the Danish International Center for  Analytical Reporting 2001-2006, European journalist of the year in 2006,  and he also... Read More →


Saturday October 10, 2015 17:30 - 18:30
Birkebeiner 1 (Data Hands-On)

17:30

Data Track: Python for Scraping 5

An introduction to webscraping with Python: This two-part, hands-on workshop will teach basic newsroom programming concepts using the Python language. We'll cover how to deconstruct a common reporting task -- gathering a table of data from a public website -- and assemble a solution from useful Python libraries that you can use again and again.

Prerequisites: Attendees should be familiar with HTML and the command line and be comfortable with databases and SQL. If you've ever written a string function in Excel ("=left(A2,5)"), you'll be fine.

Python has to be installed at your laptop before the training. Somebody can help you at the “Data Pub” on Thursday.


Speakers
avatar for Adriana Homolova

Adriana Homolova

data journalist, KRO-NCRV
Data journalist @ Pointer / KRO-NCRVSleeps long hours and writes scrapers for fun.Listens to Boney M and so should you! https://www.youtube.com/watch?v=oR6eKmqSEa0
avatar for Tom Meagher

Tom Meagher

Deputy Managing Editor, The Marshall Project
Tom Meagher is the deputy managing editor of the Marshall Project, a nonprofit, non-partisan news organization covering crime and justice in America. A veteran reporter and editor, he previously led an interactive team for the Digital First Media newspaper chain and was the data editor... Read More →


Saturday October 10, 2015 17:30 - 18:30
Messanin (Data Hands-On)

17:30

Going Creepy: Fishing for Geotags in Social Media

In this practical session you will learn to use the geolocation OSINT tool cree.py, created by Greek software developer Ioannis Kakavas. Learn how to trace people's movements throughout the day through social media.


Moderators
avatar for Minna Knus-Galan

Minna Knus-Galan

Investigative reporter, YLE, Finnish Broadcasting Company
Minna works for the investigative TV program MOT. She has done programs on tax havens (latest PanamaPapers), Bangladesh garment factories, corruption in development aid, elderly care, medicine, mining industry... Journalist of the Year 2014, 2014 Anders Chydenius – Freedom of Information... Read More →

Speakers
avatar for Ioannis Kakavas

Ioannis Kakavas

Identity and Access Management Engineer, GRNET S.A.
Infosec enthusiast, M.Sc Information and Communication Systems Security, Dipl. Ing Electrical&Computer Engineering, author of cree.py geolocation aggregator. My belongings fit in one suitcase.


Saturday October 10, 2015 17:30 - 18:30
Weidemann 4 (Data Hands-On)