Applications Are Now Closed. Sign up to be notified of future trainings, events, and other GenD news

About This Class

  • Over the last several years, Google has continued to build out its BigQuery SQL environment and its data visualization platform, Looker (formerly Google Data Studio). Many organizations both within progressive data and in the broader world of analytics and reporting are adopting BQ and Looker as key parts of their suite of data tools. We're excited to partner with Community Tech Alliance to offer an intermediate level training on these two versatile tools. Students will also receive access to significant one-on-one office hour time, have the option to complete a final project, and attend Generation Data career fairs.

What You’ll Learn / Gain

  • Key differences between BigQuery and other flavors of SQL

  • Working with cases and aggregate functions

  • Exploratory Data Analysis, Subqueries, and Rankings

  • Visualizing Mapping Data

  • Connecting BigQuery to Looker and Other Data Sources

  • Certificate of Completion

  • The course will be taught and coached by experienced instructors from Generation Data and Community Tech Alliance

Time Commitment / Schedule

  • BigQuery +Looker (BQL) will meet April 4 - May 4 Tuesdays and Thursdays from 6:30-8pm EST. There will generally be an hour of optional office hour time after each course session though this may very certain evenings. The final week of the course is reserved for optional final project work and presentations. Participants should expect to put in 12-25 hours total between formal training and independent work time depending on if they choose to do a final project. We’ll accept up to 25 students for this program on a rolling basis, so please apply early to increase your chances of being accepted.

What If I Have to Miss a Class or Two?

  • No worries. All sessions are recorded. You’ll have the opportunity to watch classes you miss, review slides and presentations, and get the support you need via office hours and our Slack community.

How Much Does It Cost?

  • It’s free!

Who Should Apply?

  • We’re particularly interested in

    • Individuals with advocacy and campaign field experience who like working with data / technology

    • Individuals with strong existing skill sets in areas including data analytics, computer programming, software development, statistics, and more

    • Preference will be given to applicants with existing SQL skills. There is a short SQL assessment as part of the application; for those who’ve taken our previous SQL assessment, we’ve significantly shortened it and made the questions much more tailored to the intermediate SQL level of the course

  • Black, Indigenous, other People of Color, women, queer, trans, those with disabilities and other individuals from underrepresented and marginalized communities are strongly encouraged to apply

    • Our students are 60% Black, Indigenous, and other People of Color, 60% female or non-binary, and 35% LGBTQIA+

Learning Accommodations

  • We’re continually trying to make our trainings as accessible as possible to all styles of learners and those who may have specific learning challenges. That said, we’re a small organization and don’t currently have any experts in learning accessibility design on staff. During the application process, we’ll provide space for you to let us know of any accommodations you may need, and we’ll let you know if we are able to accommodate you.

When’s the Application Deadline?

  • Friday, March 17

  • We will make all admissions decisions on a rolling basis and accept up to 25 students. The sooner you get you application in the better.

What Do I Need?

  • A Mac, Windows, or Linux laptop or a Chromebooks. All course materials will be provided

  • Access to a reliable internet connection with download speeds around 20Mbps

    • Not sure? https://www.speedtest.net/

Questions?

  • admissions@generationdata.org