Helena Bengtsson

Editor and Project Manager, Data Journalism, SVT

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 in Washington, D.C. She has been awarded the Stora Journalistpriset (The Swedish Grand Prize for Journalism) in Sweden twice, in 2010 for Valpejl.se and in 2016 for innovator of the year. @HelenaBengtsson

Helena is speaking at

Data
3:15 pm - 4:30 pm
Rialto (Lower Lobby)

Speakers

  • Helena Bengtsson (Speaker) Editor and Project Manager, Data Journalism, SVT
  • Jodi Upton (Speaker) Senior Database Editor and Database Editor, Sports, USA TODAY

Description

When you’ve done all you can with spreadsheets but either your data is too big or you need to join tables, SQL (Structured Query Language) is for you. It is one of the basic tools of data analysis and used for many investigative stories throughout the world - and we will get you started on the basic commands of this powerful relational database tool, including SELECT, FROM, WHERE, GROUP BY, ORDER BY and joining tables. SQL is especially useful for large, complex projects. You don’t need any coding experience, but prior spreadsheet work is preferred. In the first SQL class, we will cover the basic use of SQL to filter data and summarize. In the second class, we will focus on the joining tables (files) by a common field (column).
 
For this session, you'll need to download DB Browser ahead of time - or you should have permission to download and install programs on your computer.

You can download the program here: http://sqlitebrowser.org/ 

NOTE: For best results, be sure to bring a laptop if you want to follow along.

Data
9:00 am - 10:15 am
Rialto (Lower Lobby)

Speakers

  • Helena Bengtsson (Speaker) Editor and Project Manager, Data Journalism, SVT
  • Jodi Upton (Speaker) Senior Database Editor and Database Editor, Sports, USA TODAY

Description

When you’ve done all you can with spreadsheets but either your data is too big or you need to join tables, SQL (Structured Query Language) is for you. It is one of the basic tools of data analysis and used for many investigative stories throughout the world - and we will get you started on the basic commands of this powerful relational database tool, including SELECT, FROM, WHERE, GROUP BY, ORDER BY and joining tables. SQL is especially useful for large, complex projects. You don’t need any coding experience, but prior spreadsheet work is preferred. In the first SQL class, we will cover the basic use of SQL to filter data and summarize. In the second class, we will focus on the joining tables (files) by a common field (column).
 
For this session, you'll need to download DB Browser ahead of time - or you should have permission to download and install programs on your computer.

You can download the program here: http://sqlitebrowser.org/ 

NOTE: For best results, be sure to bring a laptop if you want to follow along.

Data
10:45 am - 12:00 pm
Seasons (Lobby Floor)

Speakers

  • Brant Houston (Speaker) Knight Chair in Investigative and Enterprise Reporting, University of Illinois at Urbana-Champaign
  • Helena Bengtsson (Speaker) Editor and Project Manager, Data Journalism, SVT

Description

Sometimes the database you want does not exist. Sometimes the data exist, but you can't access it. In either case, you can create your database.

This session will review the principles of efficiently building a database and ensuring it is what you need and is accurate.  The speakers will also show how to create spreadsheets from documents, what to think about when you enter your own data, how to use surveys and call-arounds to create a database and how to find stories buried in text or other unstructured material.

NOTE: For best results, be sure to bring a laptop if you want to follow along.

Add to my calendar

Google

Create your personal schedule through the official app, Whova!

Get Started