Building Analytics Reports in Google Sheets
April 7 – April 21, 2021
In this course you will learn to make an analytics dashboard and other visualizations in order to evaluate program efforts and share your evaluation with other team members in a way that’s easy to understand. This course is helpful for staff across departments: Data, organizing, digital, communications, and fundraising staff will all find that this course takes their work to the next level. You will be provided with sample data for all assignments.
- Week 1: Introduction to movement data and cleaning data with Vlookup and more
- Week 2: Creating analytics reports with Countif & Pivot Tables
- Week 3: Presenting analytics with column charts and more
Who is this course for?
Before taking this course, you should know what a row and column is and how to add numbers; we will send a review beforehand. If you already know how to use the Vlookup formula or Pivot Tables, you may be too advanced for this course.
Google Sheets is a great, free tool if you work on a scrappy team that does not have access to expensive data tools.
April 7–April 21, 2021
DAYS OF THE WEEK
Wednesdays, 6:30 – 8pm ET
Optional Office Hours:
- 2–3pm ET on Monday, April 12
- 2–3pm ET on Monday, April 19
March 28. Admissions decisions will be made on a rolling basis.
We believe people with more wealth, privilege, and access to money—and who benefit from systems of oppression—should pay more.
If you work at an organization with more than 60 employees, please ask your employer to cover the full cost of this training. If there’s anything that would help you make the request, please let us know.
We know that this might be a new way of looking at things. Please reach out to firstname.lastname@example.org if you have any questions.
Ideal applicants come from all walks of life—we welcome everyone from data practitioners looking to sharpen their skills, to complete beginners who are passionate about organizing. Here are some attributes shared by all our applicants:
Technical Aptitude: Whether you have experience working directly with data or not, we are interested in organizers who are able to pick up new technical skills quickly and proficiently. If you like spreadsheets and lists, or investigating innovative ways of organizing, you may be a good fit.
Organizing Insight: You don’t need to be a professional politico, but we’re looking for applicants with experience doing organizing work on the ground. That work can be tied to grassroots, electoral, and/or issue organizing. We seek to support organizers who are currently part of an organizing effort or are seeking to build one.
Dedication to Inclusive Politics and Intersectional Solutions: At re:power, we center race, class, gender and sexuality across all our trainings—it’s part of our practice of inclusive politics. We encourage organizers to be open to new ideas regarding inclusive politics, especially from their fellow organizers who will reflect our diverse communities.
You will need a technological device capable of connecting to the Internet, using Google Sheets, and downloading data. Windows machines, Macs and Unix boxes all welcome. We will be using Zoom and request that whenever possible, you turn on the video function.
If you have any questions, please reach out to email@example.com.