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 Thibodeaux leads the data journalism team at The Associated Press. The data team works with reporters and editors across AP, building software, analyzing and visualizing data, to tell stories in word and pixel. They also manage the data sharing network, which has helped news organizations across the U.S. localize important data stories. He lives in New Orleans with his family and a new dog, and like most New Orleanians, he loves to talk about the place.

Related Tipsheets

No tipsheets have yet been uploaded for this event.