Vancouver meetup

Saturday, May 25, 2019


Data, public records & women of color in journalism

We're excited to host our third meetup for women journalists to practice data reporting, talk about the industry and learn from each other. For two years, Northwest News Nerds has given women from predominantly small and medium newsrooms a space to learn how to use data and programming in their own reporting, while building a support network of fellow women in the industry.

SATURDAY PROGRAM — 9:30 a.m. to 6 p.m.

May 25, 2019: Northwest News Nerds meetup in Vancouver

9:30 a.m. to 6 p.m., The Columbian, 701 W. 8th St., Vancouver.

Optional no-host gathering at Uptown Barrel Room, 2011 Main St., Vancouver, to follow. Bring your data so we can workshop! Or eat mozzarella sticks. Whatever you want.

The day will be divided into two types of sessions: split blocks of hard skills, like Excel formulas and skills, coding and designing data visualizations, and full-group blocks of bigger picture skills, like finding data and developing a data story.

***Schedule is subject to change***

9:30 to 10 a.m.: Check in and get connected to WiFi. Organizers will be on hand to help download any software you may have missed.

10 to 10:30 a.m.: Introductions and a presentation on how to get into a data-driven frame of mind so you can make the most of the day.

10:45 to 11:45 a.m.: Skills block I

  • Getting started with Excel, including basic formulas and sorting with Katie Gillespie.


  • Data exploration in Python with Melissa Lewis.

11:45 a.m. to 1 p.m.: Lunch and panel talk on being a woman of color in the newsroom.

1 to 2 p.m.: Lecture I

  • Finding data using the United States Census, public records law and other handy hubs for Washington and Oregon. Rachel Alexander will lead.

2:15 to 3:15 p.m.: Skills block II

  • Advanced filtering and pivot tables with Katie Gillespie.


  • The art of the join with Rachel Alexander.

3:30 to 4:30 p.m.: Lecture II

  • Building a database story from the beginning: We’ll generate a story idea, “interview” our data, break into small groups and generate story ideas. By the end of the hour, we’ll all have a nutgraf based on our story idea and an outline of where to go next.

4:45 to 5:45 p.m.: Skills block III

  • Cleaning data with string functions in Excel with Rachel Alexander.


  • Basic data visualization using Tableau and (briefly) other free tools with Katie Gillespie.

5:45 to 6 p.m.: Wrap up.


$23 for the full day for professional journalists, and $12.39 for students (including ticketing fees). Your registration includes lunch.

We want this event to be accessible regardless of income. Professional journalists who cannot get reimbursed by an employer for attending and for whom the cost is prohibitive are welcome to register as students.

We are offering a limited number of scholarships to cover travel expenses and lodging, if needed, for students traveling to attend the event. If you’d like more information, contact us at northwestnewsnerds@gmail.com.

Sign up

Any woman or non-binary person working in journalism or related fields is welcome to attend. Register here by May 10, 2019.

Space is limited - registration is first-come, first-served.


The meetup will run from 10 a.m. to 6 p.m. Saturday at The Columbian in Vancouver, Wash., 701 W 8th St.

The venue is walking distance from a number of downtown hotels, and several blocks away from public transportation options. Free parking is available in The Columbian's lot due east of the building.

The venue is wheelchair accessible.

If you have questions, please contact Katie Gillespie and Rachel Alexander at northwestnewsnerds@gmail.com