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

  • Event: 2019 IRE Conference
  • Speakers: Meghan Hoyer of The Associated Press; Troy Thibodeaux of The Associated Press
  • Date/Time: Friday, Jun. 14 at 9:00am
  • Location: River Oaks B
  • 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, 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 prerequisite is a reasonable comfort level with using a spreadsheet. No previous SQL skills necessary.

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

Speaker Bios

  • Meghan Hoyer is data editor at The Associated Press, where she analyzes data and helps disseminate national data sets to reporters across the country, guiding them to find local stories in the numbers. She previously worked at USA TODAY and The Virginian-Pilot. @meghanhoyer

  • Troy leads the data journalism team at The Associated Press, a band of coders spread across the U.S. who love to dive into data and build tools for journalism. He's always looking for new ways to collaborate with fellow journalists at other news orgs, so hit him up with ideas. He's based in New Orleans, and like most New Orleanians, probably talks about it too much.

Related Tipsheets

No tipsheets have yet been uploaded for this event.