Tipsheets & Links

Presentations, tipsheets and other materials from panels, demos and hands-on classes at the 2020 NICAR Conference will be added to this page.

Speakers: Send your materials to [email protected].

 

THURSDAY

Welcome first timers! How to make the most of NICAR20

PyCAR

Upping your Excel game

Interviewing your data with SQL

Master class: Editing the data story

Hello world! Choose your data adventure

Excel 1: Getting started with spreadsheets

Data dive: The 2019 Philip Meyer winners

Regular expressions for the rest of us

Finding needles in haystacks with fuzzy matching

Introduction to VisiData

Tracking money spent on candidates up and down the ballot in 2020

How I learn to tell stories with data

How the internet works (so you can scrape the web!)

Negotiating for data at scale

Finding the story: Census data

“Scrollytelling” with MapBox

Excel 2: Formulas & sorting

GitHub for journalists

Mining data into TV gold

Finding the story: Using natural language processing in social media research

How to negotiate for data and records

Covering the Coronavirus: Reporting on local emergency preparedness

How to make charts less bad

My own worst enemy: Overcoming impostor syndrome

Newsroom web scraping with JavaScript

Covering immigration with data

Newsroom open-source tool showcase

Data cleaning with OpenRefine 1: The basics

Create interactive demographic maps in minutes with ArcGIS Online

Investigating natural disasters: What to do before, during and after

Data and docs for your arsenal

Excel 3: Filtering & pivot tables

Python: Let’s scrape a website

Google Sheets: Scraping without coding

Polling best practices ahead of 2020

Datasette: An ecosystem of tools for exploring data and collaborating on data projects

Making graphics with R

Data cleaning with OpenRefine 2: More advanced uses

Intro to R

Introduction to web development

First Observable notebook: Prototyping with polish

Master class: Statistics for journalists

Free and easy data viz

Excel: Advanced pivot tables

R 1: Intro to R and RStudio

Python 1: The fundamentals

Finding the story: Using DNS search for investigative journalism

Campaign finance questions people ask, plus yours!

Using open crime and policing data

Year in CAR: Local innovation

Diverse newsrooms can produce better journalism: Let’s make it happen

Finding and researching international connections

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

R 2: Data analysis and plotting

Python 2: Intro to data analysis using Pandas

PDF 1: How to extract text and tables from PDFs like a boss

Uncloaked: Flight tracking for investigating people, planes and patterns

Tracking dark money in the 2020 elections

Investigating bias: From housing to policing

DataKit: Workflow automation for the newsroom and classroom

A demo of the Big Local News platform

International year in CAR

“Scrollytelling” with Mapbox (repeat)

R 3: Gathering and cleaning data

Python 3: Data cleaning and visualization

Finding the story: Campaign finance

Countdown to the big count: Getting ready for Census 2020

The wrong things we all do

Encryption and journalism: From idea to publication

Advanced data journalism through a browser

Covering housing from A-Z: Localizing affordable housing stories and data

DataKit install party

Workbench: Reproducible data work without coding

Introduction to Google Data Studio

FRIDAY

PyCAR

First Python notebook: Data analysis on deadline

Digging into data for stories: A crash course in Excel

Master class: Election 2020 data

Victims, villains and heroes: Turning data into characters

Excel: Basic stats

JavaScript 1: Fundamentals and syntax

Finding the story: Business data

Data dive #2: Senior care, access to clean water, the probation trap

Navigating data.census.gov

Getting started with Tableau Public

Encryption tools for journalists

Exploring the radio spectrum for news

Code buddies: Get help on your project

Free, powerful tools for analyzing document dumps

Master Class: Writing the investigative narrative  (Friday morning)

Census: Numbers in the news

JavaScript 2: Hello, D3!

Google Sheets: Custom formulas and automating tasks with the script editor

Advanced Tableau

Scraping in R

Data Blitz

Beyond the horserace of election results graphics

Build your own collaborative documentation site: An introduction to Library

Interviewing your data

Finding the story: Data-driven disaster coverage

Everything we know about covering guns, in one hour

JavaScript 3: Making a map in D3

Hitchhikers guide to APIs

Finding the story: Using DNS search for investigative journalism (repeat)

Making interactive maps with R

Investigating sexual assault, for newsrooms big and small

Data on the wildfire beat

Digital sleuthing with Bellingcat

FOIA from the flip side

Excel tricks you’ve never used

Breaking through coding plateaus

ArcGIS: From spreadsheets to StoryMaps

Write better Python code

Master class: Writing the investigative narrative (Friday afternoon)

Career paths in data journalism

Excel 1: Getting started with spreadsheets (repeat)

SQL 1: Exploring data

Stats 1: An introduction

Google Sheets: Scraping without coding (repeat)

Finding the story: Census data (repeat)

An automated election twitterbot using R and Python

Quick-turn data stories

Avant garde data viz

Covering disparities in education with data

State of newsroom diversity reports

Covering undercovered communities

Excel 2: Formulas & sorting (repeat)

SQL 2: Grouping and summing data

Stats 2: Linear regression

PDF 2: Using OCR to extract data from PDFs

Power BI 1: Create interactive data visualizations

Data visualization & storytelling with Flourish

Being a better ally

Day-turn investigations

Machine learning for the rest of us

Beyond pictures: Turning satellite imagery into data

Excel 3: Filtering & pivot tables (repeat)

SQL 3: Joining tables

Stats 3: Logistic regression

PDF 3: Batch pdf processing

Geocoding using online tools

Power BI 2: Clean, join and visualize data

SATURDAY

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

Digging into data for stories: A crash course in Excel

Exploring the tidyverse in R

First graphics app: Node.js in the newsroom

Web scraping with Python

Master class: Finding and telling stories with earth imagery

Educators meetup

Advanced SQL: Update queries, sub-queries and more

Command line for reporters (Mac)

Enriched census data from IPUMS

Mobile, data and desktop reporting tools for your newsroom

QGIS 1: Mapmaking for beginners

How researchers and journalists work together and why it sometimes falls apart

FOIA on the fly

Practical machine learning for investigations with fast.ai  (Saturday morning)

Finding and using international data

MySQL

Voter file data, from toplines to deep dives to breaches

Exploring networks with graph databases

Dear diary: Best practices for keeping a data diary

QGIS 2: Analyzing geographic data

Unpacking AI’s influence in society

Introducing and implementing security protocols in your newsroom

Building and telling a bulletproof data story

Reasoning for data visualization

Text mining in R with tidytext

Beyond formulas: A statistical world view

Making graphics with R (repeat)

Art of the interview

Finding data for local investigations

Using the Public Accountability Project to boost your reporting

Interactive data viz with D3

Research gumbo: Redux

Excel: Importing data

SQL 1: Exploring data (repeat)

R 1: Intro to R and RStudio (repeat)

Practical machine learning for investigations with fast.ai  (Saturday afternoon)

Using csvkit to wrangle data without Excel

Tracking 2020 digital ads: Learn the secrets of new political ad databases

The life of a data story: Going from data to narrative

Being scrappy: Doing data journalism as a team of one

Finding the story in property records

Career roundtable: Making big moves

Excel tricks you’ve never used (repeat)

Excel CARwash: Cleaning dirty data

SQL 2: Grouping and summing data (repeat)

R 2: Data analysis and plotting (repeat)

How to build a live data-driven application that never crashes

How to make data findings come to life on radio

Digital security hygiene and threat modeling for journalists

Leading the data team, or how to get the best from your newsroom’s brightest people

How to squeeze court records to get the most juice

Census Reporting 2.0

Finding the story: Campaign finance (repeat)

Excel: Using string functions to manipulate data

SQL 3: Joining tables (repeat)

R 3: Gathering and cleaning data (repeat)

Exploratory dataviz: A tool for collaborative data reporting

Work-life balance

Bringing data journalism to your student newsroom

News automation is booming: How newsrooms are embracing automation

Using IRS nonprofit data and decoding 990s

Collaborate tool

Community-powered data collection: Enlisting your audience to help power investigations

Geocoding using programming

SUNDAY

Storyboarding and perfecting your pitch

JavaScript 2: Hello D3! (repeat)

Stats 1: An introduction (repeat)

Python 1: The fundamentals (repeat)

PDF 1: Using free online tools (repeat)

TL;DR: What to remember when you forget everything else

Master class: Getting ready to cover Census 2020

Finding the story: Using natural language processing in social media research (repeat)

Stats 2: Linear regression (repeat)

Python 2: Intro to data analysis using Pandas (repeat)

Python: Let’s scrape a website (repeat)

Turning your stack of documents into structured data

Where’d I put that file?

PDF 2: Using OCR to extract data from PDFs (repeat)

Advanced SQL: Update queries, sub-queries and more (repeat)

SQL CARwash: Cleaning dirty data

Python 3: Data cleaning and visualization (repeat)

GitHub for journalists (repeat)

Finding the story: Scripting your census analysis

PDF 3: Batch pdf processing (repeat)

Mapping in Python

How and why to Dockerize your project