Loading Events

« All Events

  • This event has passed.

Building Analytics Reports in Google Sheets

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 course and VAN/EveryAction Administration are offered in combination with Data Strategy. Data Strategy applicants were given the option to enroll in either or both courses.


Participation

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.


Course Details

DATES

May 4–18, 2022

  • Wednesdays, 6:30 – 8:00 pm ET
  • Optional Office Hours: TBD

APPLICATION DEADLINE

Friday, April 22. Admissions decisions will be delivered by Monday, April 25.

FEES

$200 – $600 Sliding Scale Contribution

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 data@repower.org if you have any questions.


Applicants

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.


Technical Requirements

You will need a technological device capable of connecting to the Internet and downloading files. Windows, Macs and Unix computers all welcome.


FAQ

If you have any questions, please reach out to data@repower.org.


2022 Sponsors

Thank you to our sponsors, who are values-aligned organizations who help keep our training costs accessible!

Details

Start:
May 4
End:
May 18
Cost:
$200 – $600
Event Category:

We believe in a future of inclusive politics where decisions about our communities are made by our communities at all levels.

Help Build This Movement