Hands-on Workshops

In addition to our open hands-on classes, a limited number of longer hands-on workshops require preregistration and an additional fee. Register for these workshops when you complete your conference registration.

Optional hands-on classes cancellation policy
Cancellations must be sent via email to logistics@ire.org. All cancellations must be in writing. There is a $15 processing fee for each class until May 24. Refunds will not be given for cancellations after May 24 due to the limited seating in these classes.


Interviewing your data with SQL

Friday, June 14, 9 a.m. – 6 p.m.

Cost: $70

Skill level: Intermediate

Description:

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.

 

Intro to R

Friday, June 14, 2:30 – 6 p.m.

Cost: $35

Skill level: Intermediate

Description:

This class will introduce you to R, a free, powerful open-source programming language, that will add statistical heft to your reporting. By the end of this three-hour session, you will be able to take raw data, import it into R, and start your analysis. Topics will include basic data importing, working with directories, reading in data, installing packages, creating simple visualizations, and how to clean, explore and sort your data. We’ll also talk about how to find help when you’re stuck.

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

Workshop prerequisites: This session will be most helpful if you’re comfortable working with data in spreadsheets or SQL and you’re ready to take your skills to the next level.

 

Mastering Google Sheets: Web scraping, running scripts and other tricks

Friday session: June 14, 2:30-5 p.m. — Attendees must bring a laptop & charger (no tablets) to the training

** The Friday session of this class is full.

Saturday session: June 15, 3 – 5:15 p.m. — Laptops will be provided for the training
** The Saturday session of this class is full. 

Cost: $25

Skill level: Beginner

Description:

Google Sheets is more than just free spreadsheet software to organize and store data. In this hands-on session will start with pivot tables and conditional formatting but through examples, we’ll also learn how to scrape data in seconds without code, automate menial tasks with macros, write custom spreadsheet formulas as well as how to send emails, geocode addresses, translate text and more – all through the power of Google Sheets.

Preregistration is required and seating is limited.

Workshop prerequisites: You should be familiar with using spreadsheets and formulas.

 

Data analysis with Python

Saturday, June 15, 9 a.m. – 12:30 p.m.

Cost: $35

Skill level: Advanced

Description:

Learn how to use Jupyter notebooks with the popular Python library pandas to kickstart your data analysis workflow. In this session, you’ll write code to quickly sort, filter, group, clean and join large data sets — all within a browser-based notebook that doubles as your data diary.

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

Workshop prerequisites: This is programming for beginners. Some familiarity with basic Python syntax is helpful — you might first check out the Python 101 session offered separately — but not required.

 

Digging into data for stories: A crash course in Excel

Thursday & Friday session: This workshop is Thursday, June 13, 2:30 – 6 p.m. and Friday, June 14, 9 a.m. -12:30 p.m.

** The Thursday & Friday session of this class is full.

Saturday & Sunday session: This workshop is Saturday, June 15, 9:00 a.m. – 12:30 p.m. and Sunday, June 16, 9:00 a.m. – 12:30 p.m.

** The Saturday & Sunday session of this class is full.

Cost: $70

Skill level: Beginner

Description:
Get started with using data in your stories with IRE’s original mini-boot camp. In this 7-hour, hands-on workshop, IRE’s experienced trainers will start with the basics of navigating Excel and using formulas, then walk you through sorting, filtering and aggregating data with PivotTables to find story ideas.

You’ll come away with a solid base for using data analysis in your newsroom, including how to find and request data, identify and clean dirty data, find story ideas and bulletproof your work.

We’ll also provide you with our detailed boot camp materials to help keep you on track long after you leave the conference.

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

Workshop prerequisites: There are no prerequisites for this workshop and beginners are welcome. This workshop is good for those wanting to get started analyzing data for stories.

The Thursday & Friday session is Thursday, June 13, 2:30 – 6 p.m. and Friday, June 14, 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.

The Saturday & Sunday session is Saturday, June 15, 9:00 a.m. – 12:30 p.m. and Sunday, June 16, 9:00 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.