Loading…
The European Investigative Journalism and Dataharvest Conference organised by Journalismfund.eu, is the most relevant networking event for investigative and data journalists in Europe. Dataharvest EIJC17 will take place on Friday 19, Saturday 20 and Sunday morning 21 May 2017, with a pre-conference Hack Day on Thursday 18 May.

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

Data Lab [clear filter]
Thursday, May 18
 

09:59

Pre-Dataharvest Train the Trainers
What is the best way to train data journalism skills? How do you plan a workshop that shares your knowledge and empowers reporters? When do you slow down and when do you accelerate your training pace? How do you deal with disruptive trainees or a mix of skill levels across the classroom? How do you charge someone with enthusiasm for learning while preparing them for hard work after a three-session jumpstart into a new coding language? And how can trainers keep a class engaged over a two-day bootcamp? Data Harvest is proud to host its first Train the Trainers course for data journalism teachers. Some of the world's best DDJ veteran educators will introduce their methods and share their wisdom accumulated while training worldwide over the past 20 years. The workshop brings together Helena Bengtsson, Jodi Upton, Brant Houston, Luuk Sengers, Nils Mulvad and Jonathan Stoneman. Participants will immerse in open discussions, hands-on demonstrations with live critique, and take home a unique workshop report collecting all presentations, tip sheets and used data. Check out the programme here: https://docs.google.com/spreadsheets/d/1s3fIyC3UE-2hdsQss29OlFeuOSZ1DWmlUCLmPT1fFAY/edit?usp=sharing

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 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 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 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)
A former BBC journalist, in 2011 I started training journalists how to find their way in data - acquiring it, analysing it, telling stories with it. I am never happier than when I am sitting in front of a few gigabytes of rows and columns looking for patterns and stories. I like teaching... Read More →
avatar for Jodi Upton

Jodi Upton

Knight Chair, Data and Explanatory Journalism, Syracuse University
Jodi Upton is a Knight Chair in Data and Explanatory Journalism Professor at the Newhouse School. Before that she was a senior database editor at USA Today. She and her team worked on data-driven coverage of topics including veterans' administration hospitals, new economy jobs... Read More →


Thursday May 18, 2017 09:59 - 18:00
C2.15
 
Friday, May 19
 

12:00

Easy scraping with Import.io I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Easy scraping with Import.io - Workshop I/II:
Basic scraping using New Extractor
How to use URL-building for the extractor
You can use Import.io for free for 500 queries pr. Month. If you need more, Dataharvest has made a special agrement with Import.io for a discount for journalists. We will cover reporting needs and software options. Only 25 people allowed in, first come first serve.

Speakers
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 May 19, 2017 12:00 - 13:00
Z1/16

12:00

Excel I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Excel 1 - This is for the beginner who wants to know how to use spreadsheets for journalism. You will learn how to sort and filter data, which actually is the methods used for about 80% of all data journalism. (Quote from Aron that I can't find right now) We will talk about how to make and structure your own spreadsheets and how to tackle spreadsheets from statistical agencies. By the end of this session you will feel much more comfortable the next time a spreadsheet lands in your inbox. Only 25 people allowed in, first come first serve.

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 →


Friday May 19, 2017 12:00 - 13:00
Z1/14

12:00

SQL for journalists I
Limited Capacity filling up

SQL for journalists 1/3: What to do when Excel is not enough to crunch your data and hardcore coding is not your style? SQL is like Excel, but on steroids! The first of 3 workshops will introduce you to the lingua franca of programming and a popular relational database. We'll cover what it does; creating a database, importing a spreadsheet; and main SELECT STATEMENTS - Crina Boros Note: Familiarity with Excel is recommended for those wishing to attend. Only 25 people allowed in, first come first serve.

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 →


Friday May 19, 2017 12:00 - 13:00
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

Easy scraping with Import.io II
Limited Capacity filling up

Easy scraping with Import.io - Workshop II/II:
Using Chrome Inspect to find hidden URL's
Building URL's in spreadsheet
Using one extractor as URL-input to another extractor
Export data to csv. Only 25 people allowed in, first come first serve.

Speakers
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 May 19, 2017 14:00 - 15:00
Z1/16

14:00

Excel II
Limited Capacity filling up

Excel 2: For this class you either have to have been in the previous class - or feel a little bit more comfortable with spreadsheets than an absolute beginner. In this session we will talk about functions and how they are used for doing stories. How do you split a name into first, last and other stuff? How do you work with dates? By the end of this session you will know how to manipulate data so that you can use it. Only 25 people allowed in, first come first serve.

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 →


Friday May 19, 2017 14:00 - 15:00
Z1/14

14:00

SQL for journalists II
Limited Capacity filling up

SQL for journalists 2/3: We'll expand on the power of the Golden Query by introducing functions, filters and analysing data using code for reporting. We'll also start joining tables - Crina Boros Note: Familiarity with SQL Select Statements is necessary, and with Excel recommended for those wishing to attend. Only 25 people allowed in, first come first serve.

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 →


Friday May 19, 2017 14:00 - 15:00
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

Excel III
Limited Capacity filling up

Excel 3 - Just as the previous class you have to be somewhat comfortable with spreadsheets. This is a treat, knowing how to use pivot tables is the one tool that will give you power to analyse large datasets. With this method you will be able to analyse a budget - or a salary list, find interesting facts and sum up money or count occurrences. How many times did each politician go to Brussels? How much was the cost for each of them? Which department spends the most money? By the end of this session you will be able to handle big and complicated datasets. Only 25 people allowed in, first come first serve.

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 →


Friday May 19, 2017 15:15 - 16:15
Z1/14

15:15

SQL for journalists III
Limited Capacity filling up

SQL for journalists 3/3: Building on SQL 1 & 2, we'll make tables talk to each other, clean dirty data and update tables - Crina Boros Note: Familiarity with SQL Select Statements is necessary, and with Excel recommended for those wishing to attend. Only 25 people allowed in, first come first serve.

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 →


Friday May 19, 2017 15:15 - 16:15
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

Numbed by numbers
Limited Capacity seats available

Numbed by numbers? You went into journalism to avoid maths, and now your screen's full of numbers? My session's for you! 1630 Friday #EIJC17

Speakers
avatar for Jonathan Stoneman

Jonathan Stoneman

Data journalism trainer, Freelance (UK)
A former BBC journalist, in 2011 I started training journalists how to find their way in data - acquiring it, analysing it, telling stories with it. I am never happier than when I am sitting in front of a few gigabytes of rows and columns looking for patterns and stories. I like teaching... Read More →


Friday May 19, 2017 16:30 - 17:30
Z1/14

16:30

Open Refine
Limited Capacity filling up

Make your data life easier with Open Refine - Learn how to clean data with Open Refine and how to make the program work for you in dirty data situations. Only 25 people allowed in, first come first serve. This workshop will be trained in a computer lab. However, if you liked to use your own laptop, you would need to install Open Refine prior to the class and test that it is working. The programme can be found here: http://openrefine.org/download.html.

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 →


Friday May 19, 2017 16:30 - 17:30
Z1/16

16:30

SQL for journalists IV
Limited Capacity filling up

SQL IV: You now know how to write basic queries and join tables. In this class, will extend your power ever further by incorporating string functions and some advanced mathematical techniques for analyzing data. Only 25 people allowed in, first come first serve.

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 19, 2017 16:30 - 17:30
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM
 
Saturday, May 20
 

09:30

Access I
Limited Capacity seats available

If you like Excel, try Access next. It offers a few more options than Excel and some prefer it for it’s clean interface. In the first session we will hit the filter buttons from different angles. Also for virgins that have never touched Excel. Only 25 people allowed in, first come first serve.

Speakers
avatar for Winny de Jong

Winny de Jong

Datajournalist, OneWorld
Winny de Jong is data journalist. According to some she is a ‘workaholic’, and a ’strategist’, who gives ‘EPIC presentations’. Winny usually speaks about the importance of data literacy, how to develop ideas, and her data journalistic workflow. She has presented before... 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 20, 2017 09:30 - 10:30
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

Introduction to R for journalists I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

R1/3 - R? Programming? Stats? Terrified? Don't be! We're going to start from the beginning with R and RStudio. In the first class, R I, we'll talk about the origins of R, what it can be used for, take a tour around the RStudio GUI and import data into RStudio. - Caelainn Barr (Advanced). Only 25 people allowed in, first come first serve.

Speakers
avatar for Caelainn Barr

Caelainn Barr

Data Projects Editor, The Guardian
Caelainn Barr is the data projects editor at the Guardian. When working for the Bureau of Investigative Journalism, she used data analysis to uncover the misuse of expenses by the European Commission and human rights abuses in Ethiopia. She has also worked at the Wall Street Journal... Read More →


Saturday May 20, 2017 09:30 - 10:30
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

09:30

QGIS I - Introduction to GIS with QGIS
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

INTRO TO GIS WITH QGIS --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. (Beginners). Only 25 people allowed in, first come first serve.

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 20, 2017 09:30 - 10:30
C3.15

10:45

Access II
Limited Capacity seats available

You think pivot tables in Excel are the answer to your dreams? Try the group-by function in Access and get hooked! Only 25 people allowed in, first come first serve.

Speakers
avatar for Winny de Jong

Winny de Jong

Datajournalist, OneWorld
Winny de Jong is data journalist. According to some she is a ‘workaholic’, and a ’strategist’, who gives ‘EPIC presentations’. Winny usually speaks about the importance of data literacy, how to develop ideas, and her data journalistic workflow. She has presented before... 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 20, 2017 10:45 - 11:45
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Introduction to R for journalists II
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

R2/3 - In R II we'll get down to some data wrangling and learn how to clean, join and carry out some basic functions in R. These sessions will work best if you come to classes I-III as we will be building on knowledge and datasets from class to class. (Advanced). Only 25 people allowed in, first come first serve.

Speakers
avatar for Caelainn Barr

Caelainn Barr

Data Projects Editor, The Guardian
Caelainn Barr is the data projects editor at the Guardian. When working for the Bureau of Investigative Journalism, she used data analysis to uncover the misuse of expenses by the European Commission and human rights abuses in Ethiopia. She has also worked at the Wall Street Journal... Read More →


Saturday May 20, 2017 10:45 - 11:45
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

QGIS II - The art of the spatial join
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

QGIS II - THE ART OF THE SPATIAL JOIN: 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 location. In this class, you'll learn an important reporting technique that can only be performed with mapping software. (Intermediate, and attending the Intro to GIS session is strongly recommended.) Only 25 people allowed in, first come first serve.

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 20, 2017 10:45 - 11:45
C3.15

12:00

Access III
Limited Capacity seats available

In this session we will join data from different tables. Here is where Access definitely rules over Excel. Only 25 people allowed in, first come first serve.

Speakers
avatar for Winny de Jong

Winny de Jong

Datajournalist, OneWorld
Winny de Jong is data journalist. According to some she is a ‘workaholic’, and a ’strategist’, who gives ‘EPIC presentations’. Winny usually speaks about the importance of data literacy, how to develop ideas, and her data journalistic workflow. She has presented before... 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 20, 2017 12:00 - 13:00
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Introduction to R for journalists III
Limited Capacity filling up

R3/3 - In the third and final class, R III, we'll explore some of the statistical packages in R, use ggplot2 for visual analysis and dip into using R to pull data from APIs. These sessions will work best if you come to classes I-III as we will be building on knowledge and datasets from class to class. (Advanced). Only 25 people allowed in, first come first serve.

Speakers
avatar for Caelainn Barr

Caelainn Barr

Data Projects Editor, The Guardian
Caelainn Barr is the data projects editor at the Guardian. When working for the Bureau of Investigative Journalism, she used data analysis to uncover the misuse of expenses by the European Commission and human rights abuses in Ethiopia. She has also worked at the Wall Street Journal... Read More →


Saturday May 20, 2017 12:00 - 13:00
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:00

Make parsing great again - with Regex
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

MAKE PARSING GREAT AGAIN - WITH REGEX: In the real world, raw data is often messy. Regex is a tool that helps you dive into a pile of text and pull out meaningful information. In this class, you'll learn how to turn unstructured data -- Donald Trump's Twitter feed - into a clean text file, ready to import into your favorite database manager. (Intermediate / Advanced. Only 25 people allowed in, first come first serve.

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 20, 2017 12:00 - 13:00
C3.15

14:00

Creating beautiful online maps in minutes
Limited Capacity filling up

BEAUTIFUL ONLINE MAPS IN MINUTES: There are a bevy of tools available to turn data into maps. In this session, you'll learn how to illustrate your story with an interactive map using the free Leaflet javascript library. The class will show how to initiate a fresh map, how to load data, and how to change the characteristics of the map based on the underlying data. (Intermediate / Advanced). Only 25 people allowed in, first come first serve.

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 20, 2017 14:00 - 15:00
C3.15

14:00

Python I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Python I - Introduction to Python: We'll start by setting up Python and learn to install new packages. We'll
learn how to use python in the console and to write and execute small scripts. We'll discuss basic concepts such as variables, if and for.
Requirements: None. However, if you have never programmed bevore, this will only be a very quick walk-through the most basic concepts. Only 25 people allowed in, first come first serve.

Speakers
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a... Read More →


Saturday May 20, 2017 14:00 - 15:00
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

14:00

STATS I
Limited Capacity seats available

Introduction to statistics - Picking the right tool depends on what your data looks like. We cover: categorical and continuous data, descriptive statistics, normal distribution, polls, margins of error and other basics. Then we'll work on the first and simplest test, correlation. In this series we'll use data from sports, student test scores and spending, among others; each class will build on the next. Familiarity with Excel navigation and formulas; beginner statistics. NOTE: We'll be using the Analysis ToolPak in Excel on PCs provided by the venue. You can use your own computer, HOWEVER, be aware that many versions of Excel for Mac do not have the full ToolPak capability. Check your computer before you attend the class by doing the following:

Start Excel for Mac.
Click Tools, and then click Add-Ins.
Click the Data Analysis ToolPak. Then, click OK.
Locate Data Analysis ToolPak on the Data tab.
If it does not install, you can't use ToolPak. Only 25 people allowed in, first come first serve.

Speakers
avatar for Jodi Upton

Jodi Upton

Knight Chair, Data and Explanatory Journalism, Syracuse University
Jodi Upton is a Knight Chair in Data and Explanatory Journalism Professor at the Newhouse School. Before that she was a senior database editor at USA Today. She and her team worked on data-driven coverage of topics including veterans' administration hospitals, new economy jobs... Read More →


Saturday May 20, 2017 14:00 - 15:00
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

Intro to the command line I
Limited Capacity filling up

Intro to the command line: Add to your data tool box by harnessing the mighty power of the command line, the little black box full of potential. We'll teach you how to navigate your operating system, mouse free, manage files and folders, sanity check your data and manipulate csvs. The possibilities are endless the future is bright! - Only 25 people allowed in, first come first serve. NOTE: It's a bring your own laptop session (Mac or Linux based) or else just watch along.

Speakers
avatar for Karrie Kehoe

Karrie Kehoe

Data Journalist, International Consortium of Investigative Journalists
Karrie Kehoe wrangles data at the International Consortium of Investigative Journalists (ICIJ) . She has worked at the Irish broadcaster RTE, The Times, The Sunday Times, and the Thomson Reuters Foundation. Karrie has used data analysis to investigate compensation payments in Afg... Read More →


Saturday May 20, 2017 15:15 - 16:15
C3.15

15:15

Python II
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Python II - This is an introduction to handling data with python. Thus, we'll read data from csv, manipulate/clean a dataset and draw a basic plot. Finally, we'll explore useful python libraries.
Requirements: Ideally, you would have attended Python1 tutorial or already have these skills. Otherwise, you should at least have installed Python3 and Pip and have a basic familiarity to programing. Only 25 people allowed in, first come first serve.

Speakers
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a... Read More →


Saturday May 20, 2017 15:15 - 16:15
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

15:15

STATS II
Limited Capacity seats available

Statistics II. As data gets more complicated, we use different tools. We cover: two tools to look at differences between groups, such as gender and graduation rates, or race/ethnicity and voting. (t-test and ANOVA). Familiarity with Excel navigation and formulas; intermediate statistics. NOTE: We'll be using the Analysis ToolPak in Excel on PCs provided by the venue. You can use your own computer, HOWEVER, be aware that many versions of Excel for Mac do not have the full ToolPak capability. Check your computer before you attend the class by doing the following:

Start Excel for Mac.
Click Tools, and then click Add-Ins.
Click the Data Analysis ToolPak. Then, click OK.
Locate Data Analysis ToolPak on the Data tab.
If it does not install, you can't use ToolPak. Only 25 people allowed in, first come first serve.

Speakers
avatar for Jodi Upton

Jodi Upton

Knight Chair, Data and Explanatory Journalism, Syracuse University
Jodi Upton is a Knight Chair in Data and Explanatory Journalism Professor at the Newhouse School. Before that she was a senior database editor at USA Today. She and her team worked on data-driven coverage of topics including veterans' administration hospitals, new economy jobs... Read More →


Saturday May 20, 2017 15:15 - 16:15
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

Command line tools II
Limited Capacity seats available

Command line tools: So you know what a unix command is? Time to kick it up a notch and super charge your data wrangling using powerful tools like csvkit and csvcat. We'll teach you how to merge, explore, filter and analyse large data sets from the command line. No prior programming knowledge required. Only 25 people allowed in, first come first serve. NOTE: It's a bring your own laptop session (Mac or Linux based) or else just watch along.

Speakers
avatar for Karrie Kehoe

Karrie Kehoe

Data Journalist, International Consortium of Investigative Journalists
Karrie Kehoe wrangles data at the International Consortium of Investigative Journalists (ICIJ) . She has worked at the Irish broadcaster RTE, The Times, The Sunday Times, and the Thomson Reuters Foundation. Karrie has used data analysis to investigate compensation payments in Afg... Read More →


Saturday May 20, 2017 16:30 - 17:30
C3.15

16:30

Python III
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Python III - Scraping with Python: Basic scraping
In this tutorial, we will be learn how to scrape (static) websites from the internet.
Requirements: Basic familiarity to Python (at least from Participation in the Python2 Tutorial), a distribution of Python3 and Pip on your computer. Only 25 people allowed in, first come first serve.

Speakers
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a... Read More →


Saturday May 20, 2017 16:30 - 17:30
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

16:30

STATS III
Limited Capacity seats available

Statistics III. When many variables may explain something - such as performance in sports or on tests -- a different tool is needed: linear or multiple regression. We cover how to set up and run a regression and how to interpret the results. Familiarity with Excel navigation and formulas; intermediate and advanced statistics. NOTE: We'll be using the Analysis ToolPak in Excel on PCs provided by the venue. You can use your own computer, HOWEVER, be aware that many versions of Excel for Mac do not have the full ToolPak capability. Check your computer before you attend the class by doing the following:

Start Excel for Mac.
Click Tools, and then click Add-Ins.
Click the Data Analysis ToolPak. Then, click OK.
Locate Data Analysis ToolPak on the Data tab.
If it does not install, you can't use ToolPak. Only 25 people allowed in, first come first serve.

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 →


Saturday May 20, 2017 16:30 - 17:30
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

17:40

Open Refine
Speakers
avatar for Ruben Verborgh

Ruben Verborgh

Semantic Hypermedia Researcher, UGent
I’m a researcher in semantic hypermedia at IDLab, a group of Ghent University/imec, and a postdoctoral fellow of the Research Foundation Flanders. I love to discuss about the Semantic Web, hypermedia clients, Web APIs, Linked Data, Web architecture, and much more. If you like t... Read More →


Saturday May 20, 2017 17:40 - 18:40
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

17:40

Python IV
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Python IV - Scraping with Python: Advanced scraping
We'll see how we can scrape websites, despite lazy loading and load text from (machine-readable) PDF files.
Requirements: Basic familiarity to Python and Scraping (at least from Participation in the Python2 and 3 Tutorial), a distribution of Python3 and Pip on your computer. - Only 25 people allowed in, first come first serve.

Speakers
avatar for Elena Erdmann

Elena Erdmann

Elena is a phd student in Machine Learning at TU Dortmund. Her research interest include automated text analysis and digital humanities. She is excited about data journalism and the way technology is used in the newsroom. Last year, she gathered some experience in journalism as a... Read More →


Saturday May 20, 2017 17:40 - 18:40
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

17:40

Text mining
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Text mining.

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 →


Saturday May 20, 2017 17:40 - 18:40
C3.15
 
Sunday, May 21
 

09:30

Graph Databases I
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

"Graph Databases: 1 In data journalism, we tend to use relational databases - data in table form - using tools such as Excel or SQL to do our analysis and find stories. Graph databases are different, but are incredibly useful to find connections or patterns within our data that would be difficult, if not impossible, to spot using a relational database. Often we are interested in the relationships between people, organisations and other networks such as the recent Panama Papers investigations.
The session will provide a hands-on introduction to Neo4j, the most commonly used graph software. We will build a graph database of public procurement deals listed in the Europe-wide TED database and match them with corporate information to enable us to see at a glance who is behind them. - Leila Haddou, Max Harlow, Adrian Blanco
Only 25 people allowed in, first come first serve.

Speakers
avatar for Adrian Blanco

Adrian Blanco

Data Journalist, El Confidencial
Adrian Blanco is a Spanish data journalist currently working at El Confidencial.Data stuff, visualizations, reporting and a bit of coding. He runs Journocoders Madrid.He was part of the project "The right to be forgotten", funded by Journalismfund.eu... Read More →
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 is a newsroom developer 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 skills for use in their re... Read More →


Sunday May 21, 2017 09:30 - 10:30
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Graph Databases II
Limited Capacity filling up

Graph Databases 2: Having built our database in part one, this session will focus on the querying the data. We will cover how to do basic and fuzzy searches, and how you can build up to more complicated queries to find stories. - Only 25 people allowed in, first come first serve.

Speakers
avatar for Adrian Blanco

Adrian Blanco

Data Journalist, El Confidencial
Adrian Blanco is a Spanish data journalist currently working at El Confidencial.Data stuff, visualizations, reporting and a bit of coding. He runs Journocoders Madrid.He was part of the project "The right to be forgotten", funded by Journalismfund.eu... Read More →
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 is a newsroom developer 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 skills for use in their re... Read More →


Sunday May 21, 2017 10:45 - 11:45
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

10:45

Python V
Limited Capacity filling up

Python 5 - Advanced workshop: Linking, normalising and de-duplicating large data in Python and SQL to generate leads. And CorpInt, a toolkit for building corporate network graphs from data in Python.

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 21, 2017 10:45 - 11:45
C3.04 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM

12:45

Building virtual reality charts
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Building VR charts: An introduction to how 3D graphics and virtual reality can be used to tell stories. We will be learning how to build a virtual reality chart similar to the 3D Nasdaq rollercoaster experience produced by the Wall Street Journal in 2015, but the underlying technology is the same as what was used to create completely different interactives, such as the Guardian’s solitary confinement simulation 6x9. (Original tutorial: http://www.storybench.org/how-to-make-a-simple-virtual-reality-data-visualization/) - Leila Haddou, Max Harlow, Adrian Blanco -Only 25 people allowed in, first come first serve.

Speakers
avatar for Adrian Blanco

Adrian Blanco

Data Journalist, El Confidencial
Adrian Blanco is a Spanish data journalist currently working at El Confidencial.Data stuff, visualizations, reporting and a bit of coding. He runs Journocoders Madrid.He was part of the project "The right to be forgotten", funded by Journalismfund.eu... Read More →
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 is a newsroom developer 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 skills for use in their re... Read More →


Sunday May 21, 2017 12:45 - 13:45
C3.11 Thomas More journalism school at the Campus De Ham, Raghenoplein 21, 2800 Mechelen & Campus De Vest, Zandpoortvest 60, 2800 Mechelen, BELGIUM