Guide to Political Data
I wrote this up for staff on Jon Ossoff for Senate’s Community Mobilizer program and figured I would save it here. The audience is (mostly) people who know about field and want to get into data. This mostly serves as a reference to other quality guides.
- Spreadsheets – I avoid them when I can, but they’re often unavoidable. You’ll save yourself some headaches if you know the basics: vlookup, importrange, filter, query.
- SQL – on a campaign, you’ll probably work in the DNC Phoenix platform (on Google’s BigQuery) or in Civis Platform. I’m more familiar with the former, but I’ve heard Civis has some powerful features that Phoenix doesn’t have. I built the dashboard using Google Data Studio, which hooks into BigQuery data.
- Data Communication – How do you communicate data effectively? How do you make data actionable? What metrics are useful, not just interesting or cool? How do you use design principles (color, layout) to guide users towards the most actionable information?
- I think this is what makes the difference between a good and great political data practitioner: anyone can learn the “harder” skills like spreadsheets and SQL!
- Coming from field, much of this will probably come second-nature to you :)
- … from there, sky’s the limit. Start by learning the basics of a programming language, R or Python. Learn about modeling (learn how turnout and support scores are built) and dive more deeply into data visualization (how do you tell a compelling story with data?).
Political Data Bootcamps & Courses
- https://changethegame.io/ (VAN, Google Sheets, SQL)
- https://arena.run/academy (has a data track)
- WFP SQL Training Slides
General Data Skills
There are many options to learn SQL/R/Python – choose one and stick with it!
- Progressive Data Jobs Resources (job boards, other courses):
- Overviews of Political Data / Tech
- HGL Political Tech Landscape
- Joining politics as a techie –