- This event has passed.
Building Analytics Reports in Google Sheets
May 4 – May 18, 2022
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
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.
May 4–18, 2022
- Wednesdays, 6:30 – 8:00 pm ET
- Optional Office Hours: TBD
Friday, April 22. Admissions decisions will be delivered by Monday, April 25.
You’ll make a sliding scale contribution of $200 – $600, if you choose to take this course alone.
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.
Thank you to our sponsors, who are values-aligned organizations who help keep our training costs accessible!