Tipsheets & Links

Session materials from panels, demos and hands-on classes at the 2016 IRE Conference. Are you an IRE 16 speaker with materials we don’t yet have on this list? Send them to tipsheets@ire.org.

WEDNESDAY

10 great business databases to mine for stories (Sponsored by the Donald W. Reynolds National Center for Business Journalism)

THURSDAY

Getting your stuff together

Follow the money to tax havens (Sponsored by Knight Foundation)

Investigative reporting on a shoestring

Tracking government spending

Show & Tell *Thursday – #1 (Sponsored by Napoli Management Group)

An insider’s guide to IRE16

Who can read your story? The digital divide (Sponsored by The Media Consortium)

Mapping Camp *pre-registered attendees only

Web scraping for anyone

Interactive data graphics in Tableau Public (Hosted by Tableau) *pre-registered attendees only

Investigative partnerships

Working with African newsrooms: From collaboration to coding (Sponsored by International Center for Journalists)

Excel 1: Getting started with spreadsheets

Broadcast: When things change dramatically

Watchdogging sports

Tracking down investigative threads

Deep dives: Issues you can explore in your community

Show & Tell *Thursday – #2 (Sponsored by Napoli Management Group)

Data viz storytelling

Advanced design and interaction in Tableau Public (Hosted by Tableau) *pre-registered attendees only

Do criminal and municipal courts treat defendants fairly? (Sponsored by Criminal Justice Journalists)

Following the money (Sponsored by Bloomberg)

Educators: Doing investigations with students

Looking out for your audience: From scams to ripoffs to wrongdoing

From lone wolf to team player: The evolution of the investigative reporter

Show & Tell *Thursday – #3 (Sponsored by Napoli Management Group)

Excel 2: Functions and pivot tables

The art of cultivating and protecting whistleblowers

Government data to drive your stories (Sponsored by Knight Foundation)

Finding and telling data stories with Tableau Public (Hosted by Tableau) *pre-registered attendees only

Uncovering stories on the health beat

50 apps in 30 minutes (+ 30 minutes of other cool stuff)

Getting data into Excel

Educators: Lightning talks

Investigating supply chains (Sponsored by Knight Foundation)

Broadcast deep dives 1 (Sponsored by Napoli Management Group)

Broadcast showcase: The changing network landscape

Investigating inequality

The fight for (information) freedom (Sponsored by The Press Club of New Orleans)

Designing Tableau visualizations for mobile (Hosted by Tableau) *pre-registered attendees only

Broadcast: Investigating your local school system

5 hacks to get started in data or tech (Sponsored by Knight Foundation)

Cleaning data with OpenRefine

Campus coverage: The cost of going to college

Outlook potentially negative: When PIOs fight back

Show & Tell *Thursday – #4 (Sponsored by Napoli Management Group)

Crime statistics (Sponsored by Criminal Justice Journalists)

Management: Just say no (or yes) – Vetting story ideas

Automate and turbocharge your social media (Sponsored by Knight Foundation)

Investigating in the wake of disaster (Sponsored by Dart Center for Journalism & Trauma)

Failures of enforcement

Covering 21st century policing in the social media age​ (Sponsored by Criminal Justice Journalists)​

Humanizing numbers

The business of freelancing: Securing grants (Sponsored by the Fund for Investigative Journalism and FIRE)

Show & Tell *Thursday – #5 (Sponsored by Napoli Management Group)

Unleash the data: Tools and tricks for taming PDFs

Campaign 2016: Backgrounding candidates and measuring effectiveness (Sponsored by Rockefeller Brothers Fund)

FRIDAY

Excel 1: Getting started with spreadsheets (repeat session)

The business of freelancing: Running a business (Sponsored by the Fund for Investigative Journalism and FIRE)

All about the analysis

Robots that report: How fact-checkers worldwide are experimenting with automation

Documenting ‘The Trump Effect’: Ethnic media track the impact of hate speech

Digging into data for stories: A crash course **pre-registered attendees only

Under pressure: Real life in real time with breaking news

Campaign 2016: Following the (dark) money (Sponsored by Rockefeller Brothers Fund)

Social media on the map

Finding the story: A data tour (Sponsored by Knight Foundation)

Broadcast: Visuals – Making the story sing

Show & Tell *Friday – #1 (Sponsored by Napoli Management Group)

Quick and easy analysis without importing: csvkit!

David 1, Goliath 0: Fighting and winning open records battles

Show & Tell *Friday – #2 (Sponsored by Napoli Management Group)

Rising waters: Investigating the impact of storms and the shrinking coast

Security: Bulletproofing the digital newsroom

Excel 2: Functions and pivot tables (repeat session)

Uncovering stories on the business beat (Sponsored by Bloomberg)

Rolling your own data

When Excel isn’t enough (Sponsored by Knight Foundation)

Broadcast: What keeps your lawyer awake at night?

DocumentCloud

Mobile is now: Transforming newsrooms for the age of the smartphone

Management: Keep it together – Building and guiding a projects team

Show & Tell *Friday – #3 (Sponsored by Napoli Management Group)

Political advertising: How to unlock new insights from a fresh treasure trove of data

Breaking news investigations

Revealing the cost of corporate welfare

Finding the story: Water

Broadcast: How to get people to talk

Seafood from slaves: The story behind an IRE Medal winner

Turning your investigation into: A podcast

Intro to SQL

Constructing the narrative: An unbelievable story of rape

Broadcast deep dives 2 (Sponsored by Napoli Management Group)

Mastering the investigative interview: Questioning the way you take on your targets

Research gumbo

Broadcast: Hoaxes, con men & frauds

After Ferguson: What’s next for reporting on policing in America?

Advanced OpenRefine

Web scraping without programming (Sponsored by Knight Foundation)

Involving your audience in your investigation

Management: Making newsroom partnerships work

Excel tricks

Show & Tell *Friday – #4 (Sponsored by Napoli Management Group)

Reporting on guns

Navigating legal minefields in the source-journalist relationship

How graph databases can help uncover wrongdoing (Sponsored by Knight Foundation)

Networking: Getting plugged into journalism around the world

Investigating child mistreatment

Digging deeper with SQL: Grouping and summing

Management: Culture change – Steering your newsroom into the multiplatform world

Broadcast: Rolling investigations

Turning your investigation into: A play

Joining data with SQL

Show & Tell *Friday – #5 (Sponsored by Napoli Management Group)

Showcase: From investigation to movie, behind the scenes of Spotlight

Fundamentals of Neo4j graph database for data analysis (Mac only)

SATURDAY

The Background Machine: An open-source crowdfunding tool for backgrounding political candidates (Sponsored by Knight Foundation)

Audio class with Reveal 1

Protecting kids: Accessing child welfare records

Coding for journalists (pre-registered attendees only)

Designing database applications to increase page views and ad revenues (Hosted by Caspio)

How to investigate the war on women’s health

Turning your investigation into: A book

Investigating billionaires

Finding the story: Cracking the political piggy bank

Broadcast: Feeding the beast

Show & Tell *Saturday – #1 (Sponsored by Napoli Management Group)

Jaw-droppingly cool online tools and apps that journalists love (Sponsored by TEGNA)

Show & Tell *Saturday – #2 (Sponsored by Napoli Management Group)

When, why and how to use unnamed sources (Sponsored by Knight Foundation)

Audio class with Reveal 2

Show & Tell *Saturday – #2 (Sponsored by Napoli Management Group)

Management: Why won’t you just do what I want? Fixing the reporter-editor relationship

Finding the story: Digging up secrets and story ideas in bankruptcy court records (Sponsored by Bloomberg)

Campaign 2016: Covering state and local elections (Sponsored by Rockefeller Brothers Fund)

Educators: Guiding students on controversial campus investigations

Broadcast: 60 stories in 60 minutes

Panama Papers: How the world’s largest collaborative investigation came together

Management: Keep it together – Building and guiding a projects team

When, why and how to use unnamed sources (Sponsored by Knight Foundation)

What costs nothing but isn’t free? The battle over zero-rating (Sponsored by The Media Consortium)

Crossing borders: Exploring issues of visa and migrant abuse

Digging Into nonprofits: Beyond 990s

Show & Tell *Saturday – #3 (Sponsored by Napoli Management Group)

Uncovering stories on the schools beat

Audio class with Reveal 3

Broadcast management: Good pitching and good coaching

Getting started with R

More with R

Finding the story: Lottery scandals

Sometimes it hurts: Covering traumatic events (Sponsored by Knight Foundation)

From tips, to stories, to paying the bills: A playbook for crowd-driven investigations (Sponsored by CUNY Graduate School of Journalism)

Investigating the military and veterans’ issues (Sponsored by Bloomberg)

Human rights investigations (Sponsored by Dart Center for Journalism & Trauma)

Sports investigations

Getting started with coding 1

Management: Creating a watchdog newsroom

The Grammar of Graphics: Making Plots in R using ggplot2

Best of broadcast

Broadcast deep dives 3 (Sponsored by Napoli Management Group)

Campus coverage: Policing the campus police

Under pressure: Real life in real time with breaking news (repeat session)

Uncovering stories on the criminal justice beat

Stupid offshore tricks (Sponsored by Knight Foundation)

Show & Tell *Saturday – #4 (Sponsored by Napoli Management Group)

Campus coverage: Investigating entrenched powers, from athletics to fraternities and more

Broadcast: Working on your own

Uncovering stories on the local government beat

Unleash the data: Tools and tricks for taming PDFs (repeat session)

When journalism and security research collide (Sponsored by Knight Foundation)

Longform investigative narrative: Telling stories on different platforms

Innovations in storytelling

Getting started with coding 2

Stats in Excel

Uncovering stories on the environmental beat

Innocence projects 

SUNDAY

Interrogating data with SQL pt. 1 with Troy Thibodeaux 

Interrogating data with SQL pt. 2 with Troy Thibodeaux

Coding for journalists (cont’d) **pre-registered attendees only (Sunday)

Finding the story: Bridges

Web scraping for anyone (repeat session)

Finding stuff online: A journalist’s guide to tracking down information

Brave new world: Monitoring activists, monitoring reporters (Sponsored by The Media Consortium)

Career roundtable

Year in investigations

Free options for mapping (Sponsored by Knight Foundation)

Hot emerging environmental topics to take home with you (Sponsored by Society of Environmental Journalists)

Using U.S. FOIA to get information on your own country

Getting data into Excel (repeat session)

The digital FOIA: how to get the government to give you the database you want (Sponsored by Knight Foundation)

Protecting your sources: Using encryption and other tech tools to keep your work safer