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

Building Analytics Reports in Google Sheets

June 9, 2022

About the course

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

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

How much time should I expect to spend on the course?

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.

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.

Amount

  • About
    • About Us
    • People
    • Support Us
    • Reports & Financials
    • Careers
  • Classroom
    • Overview
    • Trainings & Events
    • Partnerships
    • Progressive Governance Academy
    • 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

© 2022 Re:power