Building Analytics Reports in Google Sheets
July 21 – August 4, 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
We encourage applicants to first take our Data Strategy course which will be offered June 29–July 15. If you choose to take Data Strategy, you need only apply once—on that application, there is a place to indicate that you’d like to also take Building Analytics Reports in Google Sheets. Click here to go to Data Strategy.
This is an interactive course. We ask participants to write in the chat box, share verbally, and participate in breakout groups. We encourage, but do not require, participants to turn on video during breakout discussions.
Participants should set aside about 5 hours a week for coursework—including attending live webinar sessions, optional homework, and office hours.
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.
July 21, July 28, Aug 4
- Wednesdays, 6:30 – 8 pm ET
- Optional Office Hours: TBD
July 5. Admissions decisions will be delivered by July 10.
You’ll make a sliding scale contribution of $200 – $600, if you choose to take this course alone.
If you choose to take Data Strategy first, then you will only need to fill out the Data Strategy application. On that application, there is a place to indicate that you’d like to also take an engineering course (i.e. VAN/EveryAction Administration and Building Analytics Reports in Google Sheets).
If accepted into Data Strategy, you’ll make a sliding scale contribution of $200–600. For each engineering course, you’ll make an additional $200 contribution.
Questions? Please reach out to email@example.com.
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 and downloading files. Windows, Macs and Unix computers all welcome.
If you have any questions, please reach out to email@example.com.