Test your data analysis skills with the pros

BigQuery Data Challenge

Thursday
Online

Can you solve the BigQuery Data Challenge?

Each month, Felipe Hoffa will issue a new data puzzle to solve. Get querying as quickly as possible, then show off your work.

How it works:

  1. Create an account in BigQuery (see step by step instructions here)
  2. Find the 2 queries posted below
  3. Run 2 queries to get your results
  4. Submit your challenge results through the submissions form below

A winner will be randomly selected from the pool of correct responses to win $500 in Cloud credits!

This month’s challenge


Agenda

Track 1

Track 2

  • 8:30 AM–09:30 AM
    Registrations
    Registrations
  • 9:30 AM–09:40 AM
    Opening Keynote: Lorem ipsum dolor sit
    Firstname Lastname, Position, Company XYZ
    Opening Keynote: Lorem ipsum dolor sit
    Firstname Lastname, Position, Company XYZ
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam
    Firstname Lastname, Position, Company XYZ
    Pushing the limits of BigQuery with Kabam
    Firstname Lastname, Position, Company XYZ

Track 1

Track 2

Track 3

  • 8:30 AM–09:30 AM
    Registrations
    Registrations
    Registrations
  • 9:30 AM–09:40 AM
    Opening Keynote: Lorem ipsum dolor sit
    Firstname Lastname, Position, Company XYZ
    Opening Keynote: Lorem ipsum dolor sit
    Firstname Lastname, Position, Company XYZ
    Opening Keynote: Lorem ipsum dolor sit
    Firstname Lastname, Position, Company XYZ
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam
    Firstname Lastname, Position, Company XYZ
    Pushing the limits of BigQuery with Kabam
    Firstname Lastname, Position, Company XYZ
    Pushing the limits of BigQuery with Kabam
    Firstname Lastname, Position, Company XYZ

ALL DAY TRACKS

Day 1 Agenda

  • 8:30 AM–09:30 AM
    Registrations
  • 9:30 AM–09:40 AM
    Opening Keynote: Lorem ipsum dolor sit
    Firstname Lastname, Position, Company XYZ
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam
    Firstname Lastname, Position, Company XYZ
  • 10:00 AM–10:40 AM
    Fast analytics at scale with Google BigQuery
    Speaker: Name, Title, Organization
  • 10:40 AM–11:00 AM
    Break
  • 11:00 AM–11:20 AM
    Session Title
    Speaker: Name, Title, Organization
  • 11:20 AM–11:40 AM
    Session Title
    Speaker: Name, Title, Organization
  • 11:40 AM–12:40 PM
    Lunch
  • 12:40 PM–01:00 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:00 PM–01:20 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:20 PM–01:40 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:40 PM–02:40 PM
    Closing keynote: Lorem ipsum dolor sit
    Speaker: Name, Title, Organization
  • 2:40 PM–03:40 PM
    Happy hour

Day 2 Agenda

  • 8:30 AM–09:30 AM
    Registrations
  • 9:30 AM–09:40 AM
    Opening Keynote: Lorem ipsum dolor sit
    Firstname Lastname, Position, Company XYZ
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam
    Firstname Lastname, Position, Company XYZ
  • 10:00 AM–10:40 AM
    Fast analytics at scale with Google BigQuery
    Speaker: Name, Title, Organization
  • 10:40 AM–11:00 AM
    Break
  • 11:00 AM–11:20 AM
    Session Title
    Speaker: Name, Title, Organization
  • 11:20 AM–11:40 AM
    Session Title
    Speaker: Name, Title, Organization
  • 11:40 AM–12:40 PM
    Lunch
  • 12:40 PM–01:00 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:00 PM–01:20 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:20 PM–01:40 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:40 PM–02:40 PM
    Closing keynote: Lorem ipsum dolor sit
    Speaker: Name, Title, Organization
  • 2:40 PM–03:40 PM
    Happy hour

Day 3 Agenda

  • 8:30 AM–09:30 AM
    Registrations
  • 9:30 AM–09:40 AM
    Opening Keynote: Lorem ipsum dolor sit
    Firstname Lastname, Position, Company XYZ
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam
    Firstname Lastname, Position, Company XYZ
  • 10:00 AM–10:40 AM
    Fast analytics at scale with Google BigQuery
    Speaker: Name, Title, Organization
  • 10:40 AM–11:00 AM
    Break
  • 11:00 AM–11:20 AM
    Session Title
    Speaker: Name, Title, Organization
  • 11:20 AM–11:40 AM
    Session Title
    Speaker: Name, Title, Organization
  • 11:40 AM–12:40 PM
    Lunch
  • 12:40 PM–01:00 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:00 PM–01:20 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:20 PM–01:40 PM
    Session Title
    Speaker: Name, Title, Organization
  • 1:40 PM–02:40 PM
    Closing keynote: Lorem ipsum dolor sit
    Speaker: Name, Title, Organization
  • 2:40 PM–03:40 PM
    Happy hour

Hosts

Felipe Hoffa

Developer Advocate

 

Developer Advocate @Google. From Chile to San Francisco to the world.

In 2011 Felipe Hoffa moved from Chile to San Francisco to join Google as a Software Engineer. Since 2013 he's been a Developer Advocate on big data - to inspire developers around the world to leverage the Google Cloud Platform tools to analyze and understand their data in ways they could never before. You can find him in several YouTube videos, blog posts, and conferences around the world.

Follow Felipe at @felipehoffa.


Eric Schmidt

Staff Developer Advocate

 

Eric leads the data analytics Developer Relations team within Google Cloud where he works with customers and partners on enabling workflows in the vertical domains of retailing, financial services and media and entertainment.

Follow Eric at @notthateric.


Shane Glass

Lead,

Google Cloud Public Datasets Program

Shane is a program manager with Google Cloud's Developer Relations, where he leads the Google Cloud Public Datasets Program to facilitate access to high-demand public datasets in order to make it easy for users to access and uncover new insights in the cloud. Before joining Google, Shane was the project manager of NOAA’s Big Data Project. He also currently serves as a public affairs officer in the US Army Reserve. He received his Bachelor’s Degree from the University of South Carolina and his Master's in Data Analytics from UMUC.


Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Firstname Lastname

Customer Engineer,

Google Cloud

Lorem ipsum dolor sit amet consectetur adipisicing elit. Voluptates tempore reiciendis ipsa beatae. Inventore officia amet, earum aliquid velit hic! Dicta minima repellat minus sapiente laborum, nesciunt ad voluptate perferendis.

Our partners

Platinum

Partner
Partner
Partner
Partner
Partner
Partner
Partner

Silver

Partner
Partner
Partner
Partner

Three-promo module. 40 characters max = two lines max on mobile.

h3 headline 30 characters max

Donec rutrum congue leo eget malu suada. Praesent sapien massa, creallis sollicitudin malesuada euse consecturuer.

h3 headline 30 characters max

Donec rutrum congue leo eget malu suada. Praesent sapien massa, creallis sollicitudin malesuada euse consecturuer.

h3 headline 30 characters max

Donec rutrum congue leo eget malu suada. Praesent sapien massa, creallis sollicitudin malesuada euse consecturuer.

Two-promo module. 40 characters max = two lines max on mobile.

h3 headline 30 characters max

Donec rutrum congue leo eget malu suada. Praesent sapien massa, creallis sollicitudin malesuada euse consecturuer.

h3 headline 30 characters max

Donec rutrum congue leo eget malu suada. Praesent sapien massa, creallis sollicitudin malesuada euse consecturuer.

Keep up to speed on BigQuery

BigQuery on google.dev

Visit google.dev/topics/bigquery for more BigQuery resources.


Subscribe on Reddit

Join the BigQuery conversation at
https://www.reddit.com/r/bigquery/.


BigQuery on google.qwiklabs.com

Learn more with the BigQuery for Data Analysis quest.

Choose your city

Country one

Country two

Country three

Submit your results

Register