Loading…
EIJC & Dataharvest is an annual, four-day conference, organised by Journalismfund.eu, which brings together journalism heavyweights, data specialists and coding whiz-kids to exchange skills and story ideas. EIJC18 & Dataharvest will take place on Thursday 24, Friday 25, Saturday 26 and Sunday morning 27 May 2018. Like last year, place to be is the charming city of Mechelen, 20 minutes outside of Brussels and very easily accessible! Address is Zandpoortvest 60, 2800 Mechelen at Thomas More University College - Campus De Vest. 

The conference hashtag is #EIJC18. Follow us on Twitter and Facebook  for the latest news and updates.
Register & pay here.

Journalismfund.eu vzw is an independent non-profit organisation under Belgian law that aims to promote quality in-depth and cross-border journalism by giving working grants to journalists, by providing networking opportunities and by organising training sessions.

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

Data Journalism [clear filter]
Thursday, May 24
 

9:30am CEST

Hack Day - European tenders exposed
Join us in a special 2018 EIJC Hack Day: all tender edition! Public spending is THE way our governments spend our tax money. We need to know how the money is spent, which companies get it, and how corruption in the spending looks like. For all that, journalists need to understand how to look at tender data.  We therefore would like to welcome journalists, techies and non-techies and everything in between to nerd out on 7 million big and small tenders from the 28 EU member states, Norway, the EU Institutions, Iceland, Switzerland and Georgia.  Are you a journalist? Learn what questions you can ask tender data. Use your local knowledge to find stories hidden in between the table rows. Leave the day with a potential story and share it with the conference on Saturday.  Are you technical but not a journalist? Help journalists tell their story, visualise the data, interrogate the data. Or make your own story, look for trends across countries and sectors, join the data with other data sets, visualise them.  You can explore tender data collected and cleaned by the Digiwhist project in an interactive tender dashboard (https://opentender.eu/start), look for patterns in the data with Elvis (http://tenders.exposed/) or import and explore the raw tables and build your own analysis.  Experts on the tender data will be there to guide you through the data, corruption indicators and answer any questions you might have about tenders.  We are looking forward to welcome you at the 2018 EIJC Hack Day public spending data extravaganza! Learn more

Speakers
avatar for Adriana Homolova

Adriana Homolova

Proud coordinator of the DH data training 📊, Freelance data journalist
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously, he... Read More →
avatar for Victor Nitu

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


Thursday May 24, 2018 9:30am - 12:00pm CEST
C207

10:00am CEST

Data journalism Teachers and Trainers
The data journalism Teachers & Trainers’ Day embraces offers for those working with mid-career training as well as those teaching journalism students. Meet some of the most experienced data journalism trainers and lecturers from Europe and the US to learn from and network with. This year the day will both address practical questions for the seminar room such as ‘how to divide time between lectures and exercises’, ‘how to create efficient exercises’ or ‘how to collaborate with newsrooms’. But it will also address more structural questions such as ‘how to share and learn from syllabi’ or ‘how data journalism trainers and lecturers in Europe exchange best practice’. Find the programme here

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 John Bones

John Bones

Managing Director, SKUP
John Bones is Managing Director at SKUP, the Norwegian Foundation for Investigative Reporting. For many years, Bones was the datajournalism specialist at VG, the most read daily newspaper in Norway, and previously was editor and politics editor. Started his career at Adresseavisen... Read More →
avatar for Anuška Delic

Anuška 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 Jan Dyberg

Jan Dyberg

Assistant Professor, Danish School of Media and Journalism (DMJX)
Assistant Professor at Danish School of Media and Journalism (DMJX) since 2000. Main teaching areas: News stories, investigative journalism, datajournalism, interview techniques. I'm the main responsible for the teaching in data journalism at the school for both students and at post-graduate... Read More →
avatar for Sandra Foresti

Sandra Foresti

JMG, Göteborgs universitet
Lärare på journalistutbildningen vid JMG, Göteborgs universitet. Undervisar med fokus på undersökande journalistik, research och datajournalistik. Bakgrund som journalist på bland annat TV4, SVT och SR.
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 →
avatar for Felix Irmer

Felix Irmer

Researching #ddj, Leipzig University
avatar for Nicolas Kayser-Bril

Nicolas Kayser-Bril

Data-driven journalist, trainer & author.Interested in pandas, D3, scraping, climate and the history of cooking.
avatar for Jennifer LaFleur

Jennifer LaFleur

Data Editor, The Investigative Reporting Workshop
Jennifer LaFleur is data editor for The Investigative Reporting Workshop at American University, where she also teaches data journalism. Previously, she was senior editor for data journalism for Reveal. Before joining Reveal, she was the director of computer-assisted reporting at... 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 →
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Thursday May 24, 2018 10:00am - 12:15pm CEST
C221 Zandpoortvest 60, 2800 Mechelen

1:00pm CEST

Hack Day - European tenders exposed
Join us in a special 2018 EIJC Hack Day: all tender edition! Public spending is THE way our governments spend our tax money. We need to know how the money is spent, which companies get it, and how corruption in the spending looks like. For all that, journalists need to understand how to look at tender data. We therefore would like to welcome journalists, techies and non-techies and everything in between to nerd out on 7 million big and small tenders from the 28 EU member states, Norway, the EU Institutions, Iceland, Switzerland and Georgia. Are you a journalist? Learn what questions you can ask tender data. Use your local knowledge to find stories hidden in between the table rows. Leave the day with a potential story and share it with the conference on Saturday. Are you technical but not a journalist? Help journalists tell their story, visualise the data, interrogate the data. Or make your own story, look for trends across countries and sectors, join the data with other data sets, visualise them. You can explore tender data collected and cleaned by the Digiwhist project in an interactive tender dashboard (https://opentender.eu/start), look for patterns in the data with Elvis (http://tenders.exposed/) or import and explore the raw tables and build your own analysis. Experts on the tender data will be there to guide you through the data, corruption indicators and answer any questions you might have about tenders. We are looking forward to welcome you at the 2018 EIJC Hack Day public spending data extravaganza! Learn more

Speakers
avatar for Crina Boros

Crina Boros

Investigative Reporter | Data Journalism Visiting Lecturer
A data-driven watchdog reporter based in London, I've also been training data journalism across the map. An IRE member and offspring of the Centre for Investigative Journalism (CIJ), I've published with Reuters, the BBC, ICIJ, openDemocracy, Greenpeace Unearthed, Euobserver, The Black... Read More →
avatar for Adriana Homolova

Adriana Homolova

Proud coordinator of the DH data training 📊, Freelance data journalist
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously, he... Read More →
avatar for Victor Nitu

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


Thursday May 24, 2018 1:00pm - 4:30pm CEST
C207

1:00pm CEST

Data journalism Teachers and Trainers
The data journalism Teachers & Trainers’ Day embraces offers for those working with mid-career training as well as those teaching journalism students. Meet some of the most experienced data journalism trainers and lecturers from Europe and the US to learn from and network with. This year the day will both address practical questions for the seminar room such as ‘how to divide time between lectures and exercises’, ‘how to create efficient exercises’ or ‘how to collaborate with newsrooms’. But it will also address more structural questions such as ‘how to share and learn from syllabi’ or ‘how data journalism trainers and lecturers in Europe exchange best practice’. Find the programme here

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 John Bones

John Bones

Managing Director, SKUP
John Bones is Managing Director at SKUP, the Norwegian Foundation for Investigative Reporting. For many years, Bones was the datajournalism specialist at VG, the most read daily newspaper in Norway, and previously was editor and politics editor. Started his career at Adresseavisen... Read More →
avatar for Crina Boros

Crina Boros

Investigative Reporter | Data Journalism Visiting Lecturer
A data-driven watchdog reporter based in London, I've also been training data journalism across the map. An IRE member and offspring of the Centre for Investigative Journalism (CIJ), I've published with Reuters, the BBC, ICIJ, openDemocracy, Greenpeace Unearthed, Euobserver, The Black... Read More →
avatar for Anuška Delic

Anuška 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 Jan Dyberg

Jan Dyberg

Assistant Professor, Danish School of Media and Journalism (DMJX)
Assistant Professor at Danish School of Media and Journalism (DMJX) since 2000. Main teaching areas: News stories, investigative journalism, datajournalism, interview techniques. I'm the main responsible for the teaching in data journalism at the school for both students and at post-graduate... Read More →
avatar for Sandra Foresti

Sandra Foresti

JMG, Göteborgs universitet
Lärare på journalistutbildningen vid JMG, Göteborgs universitet. Undervisar med fokus på undersökande journalistik, research och datajournalistik. Bakgrund som journalist på bland annat TV4, SVT och SR.
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 →
avatar for Felix Irmer

Felix Irmer

Researching #ddj, Leipzig University
avatar for Nicolas Kayser-Bril

Nicolas Kayser-Bril

Data-driven journalist, trainer & author.Interested in pandas, D3, scraping, climate and the history of cooking.
avatar for Jennifer LaFleur

Jennifer LaFleur

Data Editor, The Investigative Reporting Workshop
Jennifer LaFleur is data editor for The Investigative Reporting Workshop at American University, where she also teaches data journalism. Previously, she was senior editor for data journalism for Reveal. Before joining Reveal, she was the director of computer-assisted reporting at... 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 →
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Thursday May 24, 2018 1:00pm - 5:45pm CEST
C221 Zandpoortvest 60, 2800 Mechelen
 
Friday, May 25
 

11:00am CEST

Python training I
CAR training: What is code, why learn it, uses for ddj, since lots of journalists still fear programming, code, Python, math and all the likes. We'll also run through the setup.

Speakers
avatar for Winny de Jong

Winny de Jong

Datajournalist, NOS
Winny de Jong works as a data journalist at the Dutch national broadcast, NOS. Her weekly data journalism newsletter has been called "the data highlight of the week" and "exceptionally helpful". You can subscribe through http://bit.ly/ddjnews. She speaks about creativity and how to... Read More →


Friday May 25, 2018 11:00am - 12:00pm CEST
C206

1:00pm CEST

Excel I
CAR training: Intro to Excel and data-driven journalism with spreadsheet functions.
Using mean, median, percentage change, rates, ratio.

Speakers
avatar for John Bones

John Bones

Managing Director, SKUP
John Bones is Managing Director at SKUP, the Norwegian Foundation for Investigative Reporting. For many years, Bones was the datajournalism specialist at VG, the most read daily newspaper in Norway, and previously was editor and politics editor. Started his career at Adresseavisen... Read More →
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 May 25, 2018 1:00pm - 2:15pm CEST
C126

1:00pm CEST

Get ready for the data buffet - research strategies using open data
Data Buffet: Public data can be a precious help on the way to a good story if you know how to deal with it. There are many public datasets from governments within Europe like the EU Open Data Portal or the German Genesis/regionalstatistik.de. But these datasets are rarely used by data journalists for their stories. One key reason: These platforms provide only the raw datasets without any context - they are made by bureaucrats for bureaucrats. In this workshop, we will discuss from a journalistic perspective (no data or tech skills required!) the research strategies and actual examples of subjects that you could cover as a journalist when digging into these open datasets, add the context and write pitches of great stories that can be made out of these and taken home to your newsroom.

Speakers
avatar for Simon Wörpel

Simon Wörpel

data journalist, Correctiv
Simon works as data journalist and newsroom developer at CORRECTIV, an investigative not for profit newsroom. he is specialized in data wrangling and documents processing and works on tools that empower computer assisted investigative reporting like the https://cumex-files.com & https://grand-theft-europe.com... Read More →


Friday May 25, 2018 1:00pm - 2:15pm CEST
C123

1:00pm CEST

How to use the Offshore Leaks database and other corporate registries
Data Buffet: The Offshore Leaks database gathers information on 680,000 offshore companies in many secrecy jurisdictions, including some that had not been exposed until the Paradise Papers. How can journalists use this database to start their investigations? What resources can they use to further research those companies? Pierre Romera and Cecile S. Gallego from the International Consortium of Investigative Journalists (ICIJ) will share tips and tricks to explore the database.

Speakers
avatar for Pierre Romera

Pierre Romera

Chief Technology Officer, International Consortium of Investigative Journalists (ICIJ)
Pierre Romera has been Chief Technology Officer at the International Consortium of Investigative Journalists (ICIJ) since 2017. He manages a team of programmers working on the platforms that enabled more than 300 journalists to collaborate on the Paradise Papers and Panama Papers... Read More →
avatar for Cécile Schillis-Gallego

Cécile Schillis-Gallego

Data journalist and researcher, ICIJ
Cécile Schilis-Gallego is a data journalist and researcher for ICIJ. She graduated in 2014 from Columbia Journalism School (US) and Sciences Po Journalism School (France) with a master's degree in investigative reporting. She is a 2014-2015 Brown Institute Magic Grantee, working on a investigative data project aiming at making financial statements of public companies more transparent and more accessible to journalists. She previously contributed to the French webzine Slate.fr... Read More →


Friday May 25, 2018 1:00pm - 2:15pm CEST
C125

1:00pm CEST

Python training II
CAR training: PYTHON 2 - What can I use Python for? What is a library? What is a variable? How can I put conditions in my code? Learning the basics. TRAINER: Adriana Homolova

Speakers
avatar for Winny de Jong

Winny de Jong

Datajournalist, NOS
Winny de Jong works as a data journalist at the Dutch national broadcast, NOS. Her weekly data journalism newsletter has been called "the data highlight of the week" and "exceptionally helpful". You can subscribe through http://bit.ly/ddjnews. She speaks about creativity and how to... Read More →


Friday May 25, 2018 1:00pm - 2:15pm CEST
C206

1:00pm CEST

Statistics for journalists I
CAR training: How can a number describe a situation? Or a person? Descriptive statistics to the rescue - an introduction.

Speakers
avatar for Jennifer LaFleur

Jennifer LaFleur

Data Editor, The Investigative Reporting Workshop
Jennifer LaFleur is data editor for The Investigative Reporting Workshop at American University, where she also teaches data journalism. Previously, she was senior editor for data journalism for Reveal. Before joining Reveal, she was the director of computer-assisted reporting at... Read More →


Friday May 25, 2018 1:00pm - 2:15pm CEST
C304

1:00pm CEST

What we dug out at the Hack Day
Come and get acquainted with public spending stories we found in the tender data during this years Hack Day!

Moderators
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →

Speakers
avatar for Adriana Homolova

Adriana Homolova

Proud coordinator of the DH data training 📊, Freelance data journalist
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously, he... Read More →
avatar for Victor Nitu

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →


Friday May 25, 2018 1:00pm - 2:15pm CEST
Auditorium 2 (Aula 2) Zandpoortvest 60, 2800 Mechelen

2:45pm CEST

Excel II
CAR training: Data management with Excel: Sorting, Filtering, and Visualising to find stories. Also simple cleaning of data.


Speakers
avatar for John Bones

John Bones

Managing Director, SKUP
John Bones is Managing Director at SKUP, the Norwegian Foundation for Investigative Reporting. For many years, Bones was the datajournalism specialist at VG, the most read daily newspaper in Norway, and previously was editor and politics editor. Started his career at Adresseavisen... Read More →
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 May 25, 2018 2:45pm - 4:00pm CEST
C126

2:45pm CEST

Fast and free: Maarten Lambrechts' favourite data tools for freelancers and small newsrooms
Smaller newsrooms don't always have the means to hire coders or buy expensive software to work with data. In this session Maarten Lambrechts shows some easy to use (no coding required), fast and free tools to gather, transform, analyse and visualise data. Think Import.io, Open Refine, Carto, Chartbuilder and Datawrapper.

Speakers
avatar for Maarten Lambrechts

Maarten Lambrechts

Data journalist & visualisation consultant, Self employed
Maarten Lambrechts is a freelance data journalist and datavisualisation expert. After working some years as a data journalist at Belgian newspaper De Tijd, he now works as a freelancer. He designs and develops data visualisations, builds tools to visualise data and gives trainings... Read More →


Friday May 25, 2018 2:45pm - 4:00pm CEST
C127

2:45pm CEST

Python training III
CAR training: Happy looping: How do we repeat task again and again? This workshop is all about for and while loops, lists and dictionaries. In other words: Enhancing the basics with more fun stuff.

Speakers
avatar for Mathias Born

Mathias Born

Data Journalist, Tamedia
Data Journalist working for Tamedia in Switzerland.


Friday May 25, 2018 2:45pm - 4:00pm CEST
C206

2:45pm CEST

Statistics for journalists II
CAR training: Can we draw links between factors like povery and school tests results? We take a look at correlations.

Speakers
avatar for Jennifer LaFleur

Jennifer LaFleur

Data Editor, The Investigative Reporting Workshop
Jennifer LaFleur is data editor for The Investigative Reporting Workshop at American University, where she also teaches data journalism. Previously, she was senior editor for data journalism for Reveal. Before joining Reveal, she was the director of computer-assisted reporting at... Read More →


Friday May 25, 2018 2:45pm - 4:00pm CEST
C304

2:45pm CEST

Touching Elvis - European tenders hands-on
DATA BUFFET: A lot of our tax money is spent through government tenders. Here, private parties get hired to provide services for the country. Dive with us into 7 million public tenders in Europe. The newly released open source tool Elvis helps you create public spending network in specific EU country, time and sector. Explore relationships between government and companies and ask questions like "Who is dominating the IT market in Netherlands?", "Which companies earn most money from highway building in Slovakia?" or “How many tenders has IBM won across Europe?”

Speakers
avatar for Adriana Homolova

Adriana Homolova

Proud coordinator of the DH data training 📊, Freelance data journalist
avatar for Victor Nitu

Victor Nitu

Software Developer, Datopian
Victor Nițu is currently a software developer at Datopian, an open data solutions provider spun off from Open Knowledge.Victor is also one of the developers of Elvis, a public tenders visualisation platform that aims to visually expose patterns of corruption in the EU and beyond.In... Read More →


Friday May 25, 2018 2:45pm - 4:00pm CEST
C201 Zandpoortvest 60, 2800 Mechelen

4:30pm CEST

European public tender data - understand and get the raw data
Data Buffet: Public spending on local, national and EU level has to follow European legislation in the field - including certain transparency rules. Meet Aija Bilzena from the European Commission and Bence Toth from the DigiWhist platform compiling all data. Here you can get an understanding of data source, data quality, legal basis and so forth.

Moderators
avatar for Adriana Homolova

Adriana Homolova

Proud coordinator of the DH data training 📊, Freelance data journalist

Speakers
avatar for Aija Bilzena

Aija Bilzena

Head of sector, Publications Office of the European Union
I joined the Publications Office of the European Union in 2002, worked in consolidation of EU law, in EUR-Lex and in the TED team since 2013. I am responsible for the reception (TED eSenders, XML schema), production (Supplement to the Official Journal) and dissemination of procurement... Read More →
avatar for Bence Tóth

Bence Tóth

Researcher, Government Transparency Institute
Bence Toth is a senior researcher at the Government Transparency Institute and a PhD Candidate at the School of Slavonic and East European Studies (UCL - SSEES). He has been working on "The Digital Whistleblower. Fiscal Transparency, Risk Assessment and Impact of Good Governance Policies... Read More →



Friday May 25, 2018 4:30pm - 5:45pm CEST
C201 Zandpoortvest 60, 2800 Mechelen

4:30pm CEST

Excel III
CAR training: Pivot magic: Mine and interview data deeper with Pivot Tables.
See the power of aggregating and summarising data.

Speakers
avatar for John Bones

John Bones

Managing Director, SKUP
John Bones is Managing Director at SKUP, the Norwegian Foundation for Investigative Reporting. For many years, Bones was the datajournalism specialist at VG, the most read daily newspaper in Norway, and previously was editor and politics editor. Started his career at Adresseavisen... Read More →
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 May 25, 2018 4:30pm - 5:45pm CEST
C126

4:30pm CEST

Farming and pollution: What merged data sets could tell
Combine Farm Subsidy data and Pollutant Release and Transfer Registry (PRTR) data to find subsidised polluters all over the EU. Based upon experience from Germany, Stefan Wehrmeyer - formerly Correctiv, now Open Knowledge Foundation - presents his mapping model.

Speakers
avatar for Mark Lee Hunter

Mark Lee Hunter

Story-based Inquiry
Mark is the only person to have won awards from Investigative Reporters and Editors Inc., the world’s leading organization in the field, for both his investigative reports and his research on journalism. He has also won the H.L. Mencken Free Press Award, the Sigma Delta Chi Award... 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 →
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


Friday May 25, 2018 4:30pm - 5:45pm CEST
C127

4:30pm CEST

OpenRefine
CAR training: OpenRefine - Getting started with one of the most powerful data cleaning tools you will ever need. Plus some surprising tricks it can do for you. TRAINER: Jonathan Stoneman

Speakers
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Friday May 25, 2018 4:30pm - 5:45pm CEST
C304

4:30pm CEST

Python training IV
CAR training: Loading data: from a file (csv or json); and through an API.

Speakers
avatar for Rob Gebeloff

Rob Gebeloff

Robert Gebeloff is a New Yorks Times reporter specializing in data analysis. He works on in-depth stories where numbers help augment traditional reporting.


Friday May 25, 2018 4:30pm - 5:45pm CEST
C206

4:30pm CEST

Researching the "Deep Web" - Finding and Using Databases
Search engines cover only a small part of the Internet, the Surface Web. The much larger part of the network is the so-called deep Internet (Deep Web/Hidden Web): millions of closed forums and databases. But you can't use them before you find them. Strategies helpful for this will be shown in this training. Also, some basic databases will be shown.

Speakers
avatar for Albrecht Ude

Albrecht Ude

Recherche-Trainer, Netzwerk Recherche
Albrecht Ude is based in Berlin (Germany) and Friesland, works as freelancing journalist, researcher and research-trainer (online-researches, source checking, fact checking and security issues).writes for several newspapers and magazines, print and online. focusses on structured internet... Read More →


Friday May 25, 2018 4:30pm - 5:45pm CEST
C113 Zandpoortvest 60, 2800 Mechelen
 
Saturday, May 26
 

9:00am CEST

EU open data - get an overview what is available on the two open data portals
The EU has started to publish datasets by the European institutions and on national level. Two portals – one for the institutions (EU Open Data Portal) and one for the member states (European Data Portal) – provide an overview of available datasets including information on metadata and links to the original datasets. Representatives from both portals will guide you through the available material and search options. Furthermore, there will be a presentation by the winning application from the first EU Datathon 2017, a Hackathon that aimed at using and linking datasets from EU institutions. The event is moderated by Simon Jockers, a data journalist and web developer with German investigative journalism non-profit CORRECTIV.
Furthermore, there will be a presentation by the winning application from the first EU Datathon 2017. The event is moderated by data story developer Simon Jockers of Correctiv. Come and see are there datasets you can use in your newsroom upon return.

Speakers
avatar for Corina Buruiana

Corina Buruiana

Promotion and development, Publications Office of the EU, European Commission
I'm part of the team behind the EU Open Data Portal - helping with its promotion and development, within the EU institutions and beyond.


Saturday May 26, 2018 9:00am - 10:15am CEST
C201 Zandpoortvest 60, 2800 Mechelen

9:00am CEST

Everything You Need to Know to Become A World Class Data Journalist -- In One Fabulous Session
How often do people say: "I want to become a data journalist. What do I need to learn?" This talk will lay out a complete, detailed blueprint that will turn any beginner into a CAR virtuoso in no time, or perhaps, in twenty years time, depending on their skill level.

Speakers
avatar for Rob Gebeloff

Rob Gebeloff

Robert Gebeloff is a New Yorks Times reporter specializing in data analysis. He works on in-depth stories where numbers help augment traditional reporting.


Saturday May 26, 2018 9:00am - 10:15am CEST
Auditorium 2 (Aula 2) Zandpoortvest 60, 2800 Mechelen

9:00am CEST

Finding needles in haystacks with fuzzy matching
CAR training: Fuzzy matching is a process for linking up names that are similar, but not quite the same. It has become an increasingly important part of data-led investigations as a way to identify connections between public figures, key people, and companies that are relevant to a story. This class will cover how fuzzy matching typically fits into the investigative process, with some story examples. We will show you how to run some of the different types of fuzzy match on some real datasets, including the pros and cons of each.

Speakers
avatar for Max Harlow

Max Harlow

Financial Times
Max Harlow works with the visual and data journalism team at the Financial Times in London. He has previously worked on investigations at the Guardian and at the Bureau of Investigative Journalism. He co-runs Journocoders, a group for journalists who want to develop technical ski... Read More →


Saturday May 26, 2018 9:00am - 10:15am CEST
C304

9:00am CEST

Health care to French women dropping – documented with persistent data journalism
Difficulties to find a gynaecologist? And an affordable one? And to find out which methods are applied in your hospital when you are to give birth? Le Monde data journalist Laura Motet set out to investigate these daily health questions and found answers through persistent requests, source work, scraping and data analysis. Learn how to ask this type of data questions and how to obtain, compile and analyse the data.

Speakers
avatar for Laura Motet

Laura Motet

(Data-)Journalist, Le Monde
I'm a (data-)journalist working at the French newspaper Le Monde. When investigating topics, I like to use osint methods and Python scraping.


Saturday May 26, 2018 9:00am - 10:15am CEST
C227

9:00am CEST

Journo's choice, coder's choice
How much tech is too much tech? When we dig into data-driven investigations we must choose the right approach: should we scrape a whole web site? Build a database? Or just spend the afternoon in Excel to find some insight? In this session Helena (the pragmatist) and Friedrich (the techmatist) will go through some cases they’ve worked on and show different approaches - some more technical, some more journalistic. Traditionally, they will end up shouting at each other in disagreement on how to do things.

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 Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously, he... Read More →


Saturday May 26, 2018 9:00am - 10:15am CEST
C221 Zandpoortvest 60, 2800 Mechelen

9:00am CEST

Python training V
CAR training: Scraping websites and services using requests to save off the HTML files locally and then BeautifulSoup to extract the relevant information. And, finally, pickle, to efficiently store the dictioanaries you've created. We'll attempt at scraping all https://daphnecaruanagalizia.com work from her website and further examples anybody wants to bring along.

Speakers
avatar for Barnaby Skinner

Barnaby Skinner

Head of Data Journalism, Tamedia
Studying History in Basel, I focused on the Industrial Revolution and its various social and economic impacts. As a journalist, I have shifted my attention to the Digital Revolution. I think and write in both German and English and I manage the datajournalistic endeavours at the leading... Read More →


Saturday May 26, 2018 9:00am - 10:15am CEST
C206

9:00am CEST

R I - what can R do for journalists? Intro to R
CAR training: R I - everybody talks about this programming language - what can it do for journalists? Intro to R. R1 Getting started: So many data journalists use R - but what is it, what can it do for journalists? Intro to various key concepts, RStudio, packages, and simple plots.

Speakers
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 →
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Saturday May 26, 2018 9:00am - 10:15am CEST
C126

9:00am CEST

Want to compare European data? Don’t struggle alone!
Ever struggled with European data’s non-comparability? Bring your experiences to the round table, let's compile a list of interesting examples and find ways to more intra-European comparability.

Speakers
avatar for Marcel Pauly

Marcel Pauly

Head of data-driven journalism, DER SPIEGEL
Marcel Pauly arbeitet als Datenjournalist in Hamburg. Er studierte Publizistik, Politikwissenschaft und Germanistik in Mainz und besuchte die Henri-Nannen-Journalistenschule in Hamburg. An der Columbia Journalism School in New York absolvierte er das Lede Program, eine Weiterbildung... Read More →


Saturday May 26, 2018 9:00am - 10:15am CEST
C223

10:45am CEST

Intro to mapping with QGIS - Rob Gebeloff
CAR training: Intro to mapping with QGIS - with Rob Gebeloff from the New York Times. Learn how to uncover interesting patterns in your data with mapping software. This session will introduce QGIS, the free mapping app used in newsrooms throughout the world. Level: Beginners

Speakers
avatar for Rob Gebeloff

Rob Gebeloff

Robert Gebeloff is a New Yorks Times reporter specializing in data analysis. He works on in-depth stories where numbers help augment traditional reporting.


Saturday May 26, 2018 10:45am - 12:00pm CEST
C304

10:45am CEST

Python training VI - scraping with Pandas I
CAR training: PYTHON 6 - Data analysis with Pandas part 1: Have data that are a bit too big for Excel? Or would you just like to keep a better track of what you did to your data? Come and learn Pandas: the furriest Python library built especially for everything you need to work with data. We will show you how you can load, filter, analyse, visualize and export datasets and data visualizations with just a couple of commands. Some programming knowledge is handy, but not required. TRAINERS: Adriana Homolva, Stefan Wehrmeyer

Speakers
avatar for Adriana Homolova

Adriana Homolova

Proud coordinator of the DH data training 📊, Freelance data journalist
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


Saturday May 26, 2018 10:45am - 12:00pm CEST
C206

10:45am CEST

R II - Get, clean and analyse data with the programming language R
CAR training: The tidyverse: how to use ready-made R packages which help you create a reproducible workflow.

Speakers
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 →
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Saturday May 26, 2018 10:45am - 12:00pm CEST
C126

1:00pm CEST

Crowdsourcing on the go - the Journalism++ Task Force Project
Complex investigations require tedious data-wrangling work that could be best solved by a distributed team, or even by the general public. Taskforce is a new tool designed to simplify crowdsourcing efforts, made specifically for journalistic investigations. It's aimed at involving your newsroom or your readership in this effort, with a user-friendly messaging-based interface that anyone can easily get into. In this workshop, we'll go through this tool, try it out, and find ways in which it could help your own investigations.

Speakers
avatar for Ricardo Lafuente

Ricardo Lafuente

Editor & Data Architect, J++
Designer with a passion for code, data, civic tech and free/open source software.Interested in information design, crowdsourcing tools, novel uses of messaging and Python everything.


Saturday May 26, 2018 1:00pm - 2:15pm CEST
C125

1:00pm CEST

Intermediate mapping with QGIS - with Rob Gebeloff
CAR training: We often join data tables together to gain new insights for an analysis. With maps, we can join data together based not on a common ID field, but based on common geography. In this class, you'll learn an important reporting technique that can only be performed with mapping software. Level: intermediate, and attending the Intro to GIS session is strongly recommended.

Speakers
avatar for Rob Gebeloff

Rob Gebeloff

Robert Gebeloff is a New Yorks Times reporter specializing in data analysis. He works on in-depth stories where numbers help augment traditional reporting.


Saturday May 26, 2018 1:00pm - 2:15pm CEST
C304

1:00pm CEST

Python training VII - scraping with Pandas II
CAR training: PYTHON 7. Data analysis with Pandas part 2: Have data that are a bit too big for Excel? Or would you just like to keep a better track of what you did to your data? Come and learn Pandas: the furriest Python library built especially for everything you need to work with data. We will show you how you can load, filter, analyse, visualize and export datasets and data visualizations with just a couple of commands. Some programming knowledge is handy, but not required. TRAINERS: Adriana Homolva, Stefan Wehrmeyer

Speakers
avatar for Adriana Homolova

Adriana Homolova

Proud coordinator of the DH data training 📊, Freelance data journalist
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →


Saturday May 26, 2018 1:00pm - 2:15pm CEST
C206

1:00pm CEST

R III - Visualising with R
CAR training: Getting to grips with visualisation in R. Session ends with a look at how to make further progress in R, sources of training, advice, and reading.

Speakers
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 →
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Saturday May 26, 2018 1:00pm - 2:15pm CEST
C126

2:45pm CEST

Exploring Networks with Graph Databases / Neo4J I
CAR training: Graph databases are incredibly useful to find connections or patterns within our data. This session will provide a hands-on introduction to Neo4j, showing examples of its use for investigative stories including the Panama and Paradise Papers, and teach you how to build a graph database of noteworthy individuals and match them with corporate data to see, at a glance, the networks involved.

Speakers
avatar for Leila Haddou

Leila Haddou

Data Journalism Editor, The Times and the Sunday Times
Leila Haddou is the data journalism editor for The Times and the Sunday Times in London. She has previously worked on investigations for the Financial Times and The Guardian. She has an avid interest in how technology can be used by journalists to assist with data-led reporting.@... Read More →
avatar for Max Harlow

Max Harlow

Financial Times
Max Harlow works with the visual and data journalism team at the Financial Times in London. He has previously worked on investigations at the Guardian and at the Bureau of Investigative Journalism. He co-runs Journocoders, a group for journalists who want to develop technical ski... Read More →


Saturday May 26, 2018 2:45pm - 4:00pm CEST
C304

2:45pm CEST

Python training VIII
CAR training: We'll use the Python libraries and modules pickle, os and pandas to read and analyse tens of thousands of files from the Swiss supreme court and turn them into structured data for our computers to work with.

Speakers
avatar for Barnaby Skinner

Barnaby Skinner

Head of Data Journalism, Tamedia
Studying History in Basel, I focused on the Industrial Revolution and its various social and economic impacts. As a journalist, I have shifted my attention to the Digital Revolution. I think and write in both German and English and I manage the datajournalistic endeavours at the leading... Read More →


Saturday May 26, 2018 2:45pm - 4:00pm CEST
C206

2:45pm CEST

Scraping the sharing economy
Airbnb, Uber and Deliveroo are changing the way we live and work, but the statistics they publish can't be trusted and you can't send them a freedom of information request. Lucky for us, these platforms only work by putting information online for people to see, and what can be seen can be scraped and studied. This talk will discuss the making of Airbnb Unlocked, the international investigation into Airbnb by De Tijd (Belgium), Trouw (Netherlands), Le Monde (France) and Süddeutsche Zeitung (Germany). We will talk about how to keep large scraping projects manageable, how to cover your tracks, how to analyze huge amounts of data and how and why to collaborate with other newsrooms. We'll keep things mostly non-technical – anyone can attend and learn something. NOTE: There is also a round table on covering the 'sharing economy'.

Speakers
avatar for Stijn Debrouwere

Stijn Debrouwere

datajournalist, De Tijd
Stijn Debrouwere is a statistician and data scientist at Belgian newspaper De Tijd. He's worked for The Guardian, Fusion and many other news organizations. In 2013, he was a Knight-Mozilla OpenNews fellow. He blogs about computer code and the future of journalism... Read More →


Saturday May 26, 2018 2:45pm - 4:00pm CEST
C227

2:45pm CEST

SQL I: Handling large data with basic coding
CAR training: When you've reached the limits of Excel, it's time to move on to a more powerful database management program. These two hands-on classes walk journalists through the basics of coding with SQL. Lessons include filtering, sorting and joining and other techniques for large relational databases.

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 →


Saturday May 26, 2018 2:45pm - 4:00pm CEST
C126

4:30pm CEST

Euros for docs and follow the grant: Making funding transparent in science and medicine
Scientists and medical doctors are often sponsored by industry, in some cases leading to bias. This sponsoring is hardly transparent for journalists and citizens alike. Here we present and discuss two approaches to address that problem.

Pharmaceutical companies are regularly sponsoring medical doctors, and thereby potentially influencing their decisions. As part of a self-regulatory initiative, the European pharmaceutical companies are now publishing the donations they have given medical doctors. These publications are voluntary and incomplete. Still, by mining them, important insights into the influencing of doctors by pharmaceutical industry can be gained.

Another approach uses scientific papers as data source. In many journals, scientists are required to state any industry funding they have received. "Follow the grant" is an ongoing project to build a database of these statements of conflicts of interest and funding. Its aim is to help journalists, experts and citizens to systematically look for who is sponsoring research.

Speakers
avatar for Hristio Boytchev

Hristio Boytchev

Science and health reporter, Berlin
Investigative science journalist based in Berlin. Formerly at Correctiv. Focus on data and medical journalism.
avatar for Stefan Wehrmeyer

Stefan Wehrmeyer

Open Knowledge Foundation
Stefan Wehrmeyer ist investigativer Softwareentwickler. Er startete 2011 das Informationsfreiheits-Portal FragDenStaat.de und arbeitete von 2014-2017 beim gemeinnützigen Recherchezentrum correctiv.org an datenjournalistischen Projekten. Momentan kämpft er für mehr Informationsfreiheit... Read More →
avatar for Simon Wörpel

Simon Wörpel

data journalist, Correctiv
Simon works as data journalist and newsroom developer at CORRECTIV, an investigative not for profit newsroom. he is specialized in data wrangling and documents processing and works on tools that empower computer assisted investigative reporting like the https://cumex-files.com & https://grand-theft-europe.com... Read More →


Saturday May 26, 2018 4:30pm - 5:45pm CEST
C228

4:30pm CEST

Exploring Networks with Graph Databases / Neo4J II
CAR training: You will learn to analyse your newly built graph database using Cypher, Neo4j's custom query language. It is advisable (though not obligatory) to have completed part one to get the most out of this session.

Speakers
avatar for Leila Haddou

Leila Haddou

Data Journalism Editor, The Times and the Sunday Times
Leila Haddou is the data journalism editor for The Times and the Sunday Times in London. She has previously worked on investigations for the Financial Times and The Guardian. She has an avid interest in how technology can be used by journalists to assist with data-led reporting.@... Read More →
avatar for Max Harlow

Max Harlow

Financial Times
Max Harlow works with the visual and data journalism team at the Financial Times in London. He has previously worked on investigations at the Guardian and at the Bureau of Investigative Journalism. He co-runs Journocoders, a group for journalists who want to develop technical ski... Read More →


Saturday May 26, 2018 4:30pm - 5:45pm CEST
C304

4:30pm CEST

Free data from PDFs and pictures - tools to scrape data locked in analysis-unfriendly file formats
CAR training: Free data from PDFs and pictures - tools to scrape data locked in analysis-unfriendly file formats.

Speakers
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Saturday May 26, 2018 4:30pm - 5:45pm CEST
C314

4:30pm CEST

Latest trends in data journalism - learnings from projects shortlisted for the GEN Data Journalism Awards 2018
What has the international data journalism community been up to this past year? What are the latest trends, technologies, and topics hitting data teams these days? Marianne Bouchart, manager of the Data Journalism Awards competition, will try and answer these questions by analysing some of the best projects of the past year, coming from Europe and beyond.

Speakers
avatar for Marianne Bouchart

Marianne Bouchart

Data Journalism Awards
Marianne Bouchart is the founder and director of HEI-DA, a nonprofit organisation promoting news innovation, the future of data journalism and open data. She runs data journalism programmes in various regions around the world as well as HEI-DA's Sensor Journalism Toolkit project and... Read More →


Saturday May 26, 2018 4:30pm - 5:45pm CEST
C201 Zandpoortvest 60, 2800 Mechelen

4:30pm CEST

Python training IX
CAR training: What do our collegues expect from us? Maps! Well then -- let's put some data on maps. In this workshop we are generating a static map for the print edition and an interactive map for the website -- directly from Python/ Pandas.

Speakers
avatar for Mathias Born

Mathias Born

Data Journalist, Tamedia
Data Journalist working for Tamedia in Switzerland.


Saturday May 26, 2018 4:30pm - 5:45pm CEST
C206

4:30pm CEST

SQL II: How not to be wrong
CAR training: Learning how to use data techniques is only half the battle; false conclusions and data traps lurk everywhere. This session covers some basic steps to check your data and results, as well as some cautionary tales of what can happen when journalists are not methodical in their work.

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 →


Saturday May 26, 2018 4:30pm - 5:45pm CEST
C126
 
Sunday, May 27
 

9:30am CEST

Don't fear the robots: five reasons we should welcome our new automated newsroom tools
Is automation in journalism something to fear? Is a robot going to take your job? Possibly, but there are reasons to be cheerful. With some news organisations now breaking live automated stories, these advances in technology provide real opportunities for investigations. This talk will explain the ways automation is already being used in newsrooms, why we don’t believe the coming wave of automation is a threat, and how we can embrace this new technology to improve the quality of investigative reporting at a time of shrinking newsroom resources. We’ll highlight what we think are the five main opportunities.

Speakers
avatar for Leila Haddou

Leila Haddou

Data Journalism Editor, The Times and the Sunday Times
Leila Haddou is the data journalism editor for The Times and the Sunday Times in London. She has previously worked on investigations for the Financial Times and The Guardian. She has an avid interest in how technology can be used by journalists to assist with data-led reporting.@... Read More →
avatar for Max Harlow

Max Harlow

Financial Times
Max Harlow works with the visual and data journalism team at the Financial Times in London. He has previously worked on investigations at the Guardian and at the Bureau of Investigative Journalism. He co-runs Journocoders, a group for journalists who want to develop technical ski... Read More →


Sunday May 27, 2018 9:30am - 10:45am CEST
C201 Zandpoortvest 60, 2800 Mechelen

9:30am CEST

Finding the needle in the document pile with the new ALEPH software
ALEPH is a new open source software, developed by OCCRP data wizz Friedrich Lindenberg to do searches in unstructured data and documents. ALEPH does the indexing, searching and analysing for you. It has to be installed on a server and will be demonstrated on data.occrp.org, but others such as Süddeutsche Zeitung also use it in-house. In this presentation Friedrich will focus on the use of the tool. For interested programmers, here is the Github - https://github.com/alephdata/aleph, for further questions please contact Friedrich after the session.

Speakers
avatar for Friedrich Lindenberg

Friedrich Lindenberg

Tech Coordinator, OCCRP
Friedrich Lindenberg is a coder and data journalist working on web technology for new narrative and investigative techniques. He was an 2014 ICFJ Knight International Journalism Fellow with Code for Africa, and a 2013 Knight-Mozilla OpenNews Fellow at Spiegel Online. Previously, he... Read More →


Sunday May 27, 2018 9:30am - 10:45am CEST
C229 Zandpoortvest 60, 2800 Mechelen

9:30am CEST

Hands-on data storytelling with Flourish I
CAR training: Hands-on data storytelling with Flourish (1 of 2)
Flourish is an award-winning data visualisation platform that is free for newsrooms, thanks to support from Google’s News Initiative. It lets journalists string together data-driven slides into interactive presentations that can be shared and embedded on websites. Available templates include animated maps, network diagrams, Sankey charts, quizzes, and more. Plus Javascript developers can create their own templates using the freely available SDK. This workshop is lead by Michael Kowalski, a platform developer at Flourish who has previously run projects at the Guardian and Newscorp. He will introduce the Flourish platform and take participants through the process of creating and distributing data-driven stories. No previous experience of data visualisation is required.

Speakers

Sunday May 27, 2018 9:30am - 10:45am CEST
C126

9:30am CEST

Scrape and analyse tweets with Knime
CAR training: "Scrape and analyze tweets with Knime - Are you a tech savvy journalist? Do you understand what APIs and databases are but not how come you still need programming to use them?
Learn how to gather and analyze tweets using only logic and KNIME Analytics Platform - an open source software that helps you realize your data analysis fantasies without code. From Twitter to pretty visualization photo via a workflow that makes sense and looks neat. TRAINER: Georgiana Bere "

Speakers
avatar for Georgiana Bere

Georgiana Bere

Data engineer, https://tenders.exposed
Data savvy programmer and open data supporter. I believe data contains wisdom and I help people get to it.


Sunday May 27, 2018 9:30am - 10:45am CEST
C206

9:30am CEST

Scraping with Outwit
CAR training: Scraping with Outwit - OutWit Hub is a Web scraping software application designed to automatically extract information from online or local resources. It recognizes and grabs links, images, documents, contacts, recurring vocabulary and phrases, rss feeds and converts structured and unstructured data into formatted tables which can be exported to spreadsheets or databases.

Speakers
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Sunday May 27, 2018 9:30am - 10:45am CEST
C304

11:15am CEST

Discrimination in the housing market - making the data test
People with foreign names are discriminated against in the German market for rental housing. If you have a foreign name and you are looking for an apartment, it is significantly less likely for you to be invited to an apartment viewing than an applicant with a German sounding name. We found statistical evidence for this kind of discrimination, sending out more than 20,000 applications and evaluation approximately 8,000 responses to apartment advertisements, using fictional German and non-German candidate profiles with identical income, age and other information. In this session we would like to talk about the methodology behind this massive project: The difficulties of web scraping online platforms, sending out thousands of e-mails and reviewing and classifying more than 8,000 responses.

Speakers
avatar for Steffen Kühne

Steffen Kühne

Interactive News Developer, Bayerischer Rundfunk
Data journalist and interactive developer, specialized in data analysis, visualization and storytelling.



Sunday May 27, 2018 11:15am - 12:30pm CEST
C125

11:15am CEST

Hands-on data storytelling with Flourish II
CAR training: "Hands-on data storytelling with Flourish (2 of 2)
Flourish is an award-winning data visualisation platform that is free for newsrooms, thanks to support from Google’s News Initiative. It lets journalists string together data-driven slides into interactive presentations that can be shared and embedded on websites. Available templates include animated maps, network diagrams, Sankey charts, quizzes, and more. Plus Javascript developers can create their own templates using the freely available SDK. This workshop is lead by Michael Kowalski, a platform developer at Flourish who has previously run projects at the Guardian and Newscorp. He will introduce the Flourish platform and take participants through the process of creating and distributing data-driven stories. No previous experience of data visualisation is required. "

Speakers

Sunday May 27, 2018 11:15am - 12:30pm CEST
C126

11:15am CEST

How to impress your colleagues via command line magic
CAR training: There are many great and complex tools out there for the daily work of data journalists. But one of the most powerful tool is also most underestimated: The command line of your computer. From simple data analysis to complex document processing – with a few tricks you could do most of the work just within your terminal. And it's even faster and more efficient than big software. In this workshop with real world examples we will discuss helpful commands, how to build a data processing pipeline out of them, how to get useful insights out of your document collections and even how to speed up work via multiprocessing. Bring your own computer, everybody is welcome: Beginners, experts and even windows users.

Speakers
avatar for Simon Wörpel

Simon Wörpel

data journalist, Correctiv
Simon works as data journalist and newsroom developer at CORRECTIV, an investigative not for profit newsroom. he is specialized in data wrangling and documents processing and works on tools that empower computer assisted investigative reporting like the https://cumex-files.com & https://grand-theft-europe.com... Read More →


Sunday May 27, 2018 11:15am - 12:30pm CEST
C206

11:15am CEST

Lightning Talks presented by Adriana Homolova and Jonathan Stoneman
Get inspiration galore in the EIJC & Dataharvest Lightning Talks - prepared and presented by two sparkling journalists!

Speakers
avatar for Adriana Homolova

Adriana Homolova

Proud coordinator of the DH data training 📊, Freelance data journalist
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)


Sunday May 27, 2018 11:15am - 12:30pm CEST
Auditorium 2 (Aula 2) Zandpoortvest 60, 2800 Mechelen