• Skip to primary navigation
  • Skip to main content
  • Skip to footer
  • Skip to topheader navigation
  • Shop
  • Donate
re:power

re:power

Reclaiming Our Power for Radical Change

  • Learn
  • Support
  • Partner
  • About
    • About Us
    • People
    • Support Us
    • Reports & Financials
    • Careers
  • Classroom
    • Overview
    • Trainings & Events
    • Partnerships
    • Progressive Governance Academy
    • Data x Power
    • Resources
  • Newsroom
  • Contact Us
  • Legal
    • COVID-19 Protocol
    • Privacy Policy & Disclaimer
    • State Nonprofit Disclosures
    • Donor Privacy Policy
    • Donation FAQ
    • Site Credits
Home > Classroom > Trainings & Events > Building Analytics Reports in Google Sheets

Building Analytics Reports in Google Sheets

June 9, 2022

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

Apply by March 29

Type Training
Category Movement Technology
Cost Sliding scale* $200–$600 (full cost)
Dates April 12 –April 26
Location Online
Time Wednesdays 6:30-8:00 pm ET
Apply

*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 over the course of three weeks. We highly encourage you to participate in every session of the training series, as each session will be offered only one time and 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 every session will also be recorded and available afterwards.

We are also providing optional office hours on Thursdays, 5:00–6:00 pm ET

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

Questions? Please contact us at data@repower.org

Other Events

Post navigation

Movement TechnologyVAN/EveryAction Administration

VAN/EveryAction Administration

Movement Technology

Database Management Using SQL

Footer

Invest in re:power.

Powerful movements need powerful leaders and powerful resources. Invest in our work today.

Looking to update your info?

Update donor info

Amount

  • About
    • About Us
    • People
    • Support Us
    • Reports & Financials
    • Careers
  • Classroom
    • Overview
    • Trainings & Events
    • Partnerships
    • Progressive Governance Academy
    • Data x Power
    • Resources
  • Newsroom
  • Contact Us
  • Legal
    • COVID-19 Protocol
    • Privacy Policy & Disclaimer
    • State Nonprofit Disclosures
    • Donor Privacy Policy
    • Donation FAQ
    • Site Credits

Follow us

  • Shop
  • Donate

Newsletter Sign up

© 2023 Re:power

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT