Building Analytics Reports in Google Sheets

Overview

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.

Who is this course 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.

Pre-requisites: 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.

Ideal applicants come from all walks of life, from seasoned organizers and campaigners looking to sharpen their skills, to beginners who are passionate about organizing and want to start their learning journey. Here are some attributes shared by all our applicants:

Technical Aptitude: Whether you have experience in organizing online or not, we are interested in organizers and campaign practitioners who want to rapidly develop their technical skills.
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 a campaign 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 want organizers to be open to new ideas regarding it and to the ideas and contributions from their fellow organizers who will reflect our diverse communities.

Lesson Plan

Week 1: Intro to Movement Data & Cleaning Data with Vlookup and more
Week 2: Creating Analytics Reports with Countif and Pivot Tables
Week 3: Presenting Analytics with Column Charts and more

Questions? Please contact us at data@repower.org

Applications Closed

Type	Training
Category	Movement Technology
Cost	$200–$800 (full cost)*
Dates	October 5 –October 19
Location	Online
Time	Wednesdays 6:30-8:00 pm ET

*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.

Additional Information

What do people do with their re:power data and analytics training?

re:power alumni have gone on to be national, regional and deputy data directors on presidential and national issue campaigns; engineers for grassroots organizations, non-profits, and tech companies; GIS and analytics directors for the White House and Federal Government; campaign managers, state directors, trainers and much more.

What’s the schedule? Can I come at different times each week?

We built this cohort with the busy schedules of activists in mind and will hold one session per week. We highly encourage you to participate in each session of the training series, as the material builds on the skills learned. Attending each session live provides the best opportunity to engage in the materials and discussion. Ultimately we understand the complex lives of organizers and people during the time of COVID, and so each session will also be recorded and available afterwards.

What are the expectations for attending this course?

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 4 hours a week for coursework—including attending live webinar sessions, homework, and biweekly office hours.

What equipment or software do I need to be able to attend the course?

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.

Will we receive copies of the materials I saw in class?

Yes. Copies of the slides, handouts and other supplementary materials will be available to all trainees. We thank you in advance for your feedback.

I have a disability/ need support or an accommodation.

We are dedicated to supporting all of our trainees in their learning. If you need an accommodation or additional support of any kind, please email data@repower.org with “Accommodation Request” in the subject line and we’ll do what we can.

Past requests for support have included, but were not limited to: early access to materials, different colored hand outs, an alternative method for completing quizzes, requesting facilitators speak directly into the camera and more.

Building Analytics Reports in Google Sheets

Overview

Who is this course for?

Lesson Plan

Applications Closed

Additional Information

Invest in re:power.

Follow us

Newsletter Sign up

Overview

Who is this course for?

Lesson Plan

Applications Closed

Additional Information

Footer

Invest in re:power.

Follow us

Newsletter Sign up