Interviewing your data with SQL **pre-registered attendees only

  • Event: 2019 CAR Conference
  • Speakers: Elizabeth Lucas of Kaiser Health News; Megan Luther of InvestigateTV
  • Date/Time: Thursday, Mar. 7 at 2:15pm
  • Location: Salon 4
  • Audio file: No audio file available.

Skill level: Intermediate

If you flip over pivot tables, but wish you had more data tools, this session is for you. Structured Query Language, or SQL, can help you use powerful filtering functions, find patterns in millions of records and join multiple data tables. 

This class will be taught by two experienced data reporters and former IRE trainers, and materials will include the IRE Computer-Assisted Reporting boot camp binder, full of exercises, cheat sheets and tips to help you boost your data analysis and storytelling skills. We will use a free database manager that can be easily installed and used on any computer.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: The only prerequisites are a reasonable comfort level with using a spreadsheet. No previous SQL skills necessary.

This class takes place on Thursday, March 7 from 2:15-5:45 p.m. and continues Friday, March 8, 9 a.m. - 12:30 p.m. (Registration for this session reserves your seat for both days of this workshop and attendees are expected to attend both sessions to complete the workshop.)

NOTE: Registration is required for this session. Click here to sign up.

Speaker Bios

  • Liz Lucas is the data editor at Kaiser Health News (KHN) and a member of the investigative team. Previously she worked at IRE as the NICAR Data Library director and trainer. She lives in St Louis. @eklucas

  • Megan Luther is an investigative producer with InvestigateTV, Gray Television's national investigative team. Previously, she was IRE's Senior Training Director and a data analyst for The Atlanta Journal-Constitution. Megan, mother of two, works remotely in South Dakota. @MeganLuther

Related Tipsheets

No tipsheets have yet been uploaded for this event.