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, and primarily works with the enterprise team on long-term projects. Previously she was the NICAR Data Library director at IRE. @eklucas 

  • Megan Luther is an investigative producer with InvestigateTV, Gray Television's national investigative team. Previously, she was IRE's Senior Training Director. Other former titles include reporter, data analyst and overnight DJ. Megan, mother of two under six, currently works remotely in South Dakota. @MeganLuther

Related Tipsheets

No tipsheets have yet been uploaded for this event.