BigQuery Data Challenge

Test your data analysis skills with the pros

  • event

    Thursdays

  • place

    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


keyboard_arrow_up Saturday, November 10

  • 8:30 AM–09:30 AM
    Registrations
  • 9:30 AM–09:40 AM
    Introduction | Simon Donovan, Gaming Executive Lead, Google
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam | Costas Piliotis, Lead Data Analyst Kabam
  • 10:20 AM–10:40 AM
    Fast analytics at scale with Google BigQuery | Jen Tong, Staff Developer Advocate, Google
  • 10:40 AM–11:00 AM
    Coffee Break
  • 11:00 AM–11:20 AM
    Geospatial Games with Niantic | Phil Keslin, CTO Niantic
  • 11:20 AM–11:40 AM
    Realtime Gaming with Containers and gRPC | Mark Mandel, Developer Advocate, Google
  • 11:40 AM–12:40 PM
    Lunch
  • 12:40 PM–01:00 PM
    Start your engines: Real time shared experiences powered by App Engine & Compute Engine | Chris Sierra, Sales Engineer, Google
  • 1:00 PM–01:20 PM
    Pocket Gems: Scaling mobile games to a global audience using App Engine and Cloud Datastore | Gustavo Ambrozio, Software Engineer at Pocket Gems
  • 1:20 PM–01:40 PM
    Blue-sky Gaming concepts powered by Google Cloud Platform | Joseph Holley, Cloud Solutions Architect, Google
  • 1:40 PM–02:40 PM
    Panel Q&
  • 2:40 PM–03:40 PM
    Happy Hour

keyboard_arrow_up Sunday, November 11

  • 8:30 AM–09:30 AM
    Registrations
  • 9:30 AM–09:40 AM
    Introduction | Simon Donovan, Gaming Executive Lead, Google
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam | Costas Piliotis, Lead Data Analyst Kabam
  • 10:20 AM–10:40 AM
    Fast analytics at scale with Google BigQuery | Jen Tong, Staff Developer Advocate, Google
  • 10:40 AM–11:00 AM
    Coffee Break
  • 11:00 AM–11:20 AM
    Geospatial Games with Niantic | Phil Keslin, CTO Niantic
  • 11:20 AM–11:40 AM
    Realtime Gaming with Containers and gRPC | Mark Mandel, Developer Advocate, Google
  • 11:40 AM–12:40 PM
    Lunch
  • 12:40 PM–01:00 PM
    Start your engines: Real time shared experiences powered by App Engine & Compute Engine | Chris Sierra, Sales Engineer, Google
  • 1:00 PM–01:20 PM
    Pocket Gems: Scaling mobile games to a global audience using App Engine and Cloud Datastore | Gustavo Ambrozio, Software Engineer at Pocket Gems
  • 1:20 PM–01:40 PM
    Blue-sky Gaming concepts powered by Google Cloud Platform | Joseph Holley, Cloud Solutions Architect, Google
  • 1:40 PM–02:40 PM
    Panel Q&
  • 2:40 PM–03:40 PM
    Happy Hour

keyboard_arrow_up Monday, November 12

  • 8:30 AM–09:30 AM
    Registrations
  • 9:30 AM–09:40 AM
    Introduction | Simon Donovan, Gaming Executive Lead, Google
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam | Costas Piliotis, Lead Data Analyst Kabam
  • 10:20 AM–10:40 AM
    Fast analytics at scale with Google BigQuery | Jen Tong, Staff Developer Advocate, Google
  • 10:40 AM–11:00 AM
    Coffee Break
  • 11:00 AM–11:20 AM
    Geospatial Games with Niantic | Phil Keslin, CTO Niantic
  • 11:20 AM–11:40 AM
    Realtime Gaming with Containers and gRPC | Mark Mandel, Developer Advocate, Google
  • 11:40 AM–12:40 PM
    Lunch
  • 12:40 PM–01:00 PM
    Start your engines: Real time shared experiences powered by App Engine & Compute Engine | Chris Sierra, Sales Engineer, Google
  • 1:00 PM–01:20 PM
    Pocket Gems: Scaling mobile games to a global audience using App Engine and Cloud Datastore | Gustavo Ambrozio, Software Engineer at Pocket Gems
  • 1:20 PM–01:40 PM
    Blue-sky Gaming concepts powered by Google Cloud Platform | Joseph Holley, Cloud Solutions Architect, Google
  • 1:40 PM–02:40 PM
    Panel Q&
  • 2:40 PM–03:40 PM
    Happy Hour

keyboard_arrow_up Tuesday, November 13

  • 8:30 AM–09:30 AM
    Registrations
  • 9:30 AM–09:40 AM
    Introduction | Simon Donovan, Gaming Executive Lead, Google
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam | Costas Piliotis, Lead Data Analyst Kabam
  • 10:20 AM–10:40 AM
    Fast analytics at scale with Google BigQuery | Jen Tong, Staff Developer Advocate, Google
  • 10:40 AM–11:00 AM
    Coffee Break
  • 11:00 AM–11:20 AM
    Geospatial Games with Niantic | Phil Keslin, CTO Niantic
  • 11:20 AM–11:40 AM
    Realtime Gaming with Containers and gRPC | Mark Mandel, Developer Advocate, Google
  • 11:40 AM–12:40 PM
    Lunch
  • 12:40 PM–01:00 PM
    Start your engines: Real time shared experiences powered by App Engine & Compute Engine | Chris Sierra, Sales Engineer, Google
  • 1:00 PM–01:20 PM
    Pocket Gems: Scaling mobile games to a global audience using App Engine and Cloud Datastore | Gustavo Ambrozio, Software Engineer at Pocket Gems
  • 1:20 PM–01:40 PM
    Blue-sky Gaming concepts powered by Google Cloud Platform | Joseph Holley, Cloud Solutions Architect, Google
  • 1:40 PM–02:40 PM
    Panel Q&
  • 2:40 PM–03:40 PM
    Happy Hour

keyboard_arrow_up Wednesday, November 14

  • 8:30 AM–09:30 AM
    Registrations
  • 9:30 AM–09:40 AM
    Introduction | Simon Donovan, Gaming Executive Lead, Google
  • 9:40 AM–10:00 AM
    Pushing the limits of BigQuery with Kabam | Costas Piliotis, Lead Data Analyst Kabam
  • 10:20 AM–10:40 AM
    Fast analytics at scale with Google BigQuery | Jen Tong, Staff Developer Advocate, Google
  • 10:40 AM–11:00 AM
    Coffee Break
  • 11:00 AM–11:20 AM
    Geospatial Games with Niantic | Phil Keslin, CTO Niantic
  • 11:20 AM–11:40 AM
    Realtime Gaming with Containers and gRPC | Mark Mandel, Developer Advocate, Google
  • 11:40 AM–12:40 PM
    Lunch
  • 12:40 PM–01:00 PM
    Start your engines: Real time shared experiences powered by App Engine & Compute Engine | Chris Sierra, Sales Engineer, Google
  • 1:00 PM–01:20 PM
    Pocket Gems: Scaling mobile games to a global audience using App Engine and Cloud Datastore | Gustavo Ambrozio, Software Engineer at Pocket Gems
  • 1:20 PM–01:40 PM
    Blue-sky Gaming concepts powered by Google Cloud Platform | Joseph Holley, Cloud Solutions Architect, Google
  • 1:40 PM–02:40 PM
    Panel Q&
  • 2:40 PM–03:40 PM
    Happy Hour

BigQuery Challenge Winners

  • First Name Last Initial, City/State or Country, Win Date
  • Joan S., Los Angeles, CA 9/20/19
  • Sam G., Singapore, 10/1/19
  • Example
  • Example
  • Example
  • Example
  • Example
  • Example

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.


Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.


Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.


Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.


Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.


Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.


Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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.

Luiz Gustavo Martinez

Customer Engineer,

Santo Enterprises

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 Logo
Partner Logo
Partner Logo
Partner Logo
Partner Logo
Partner Logo
Partner Logo

Silver

Partner Logo
Partner Logo
Partner Logo
Partner Logo

Weekly Challenges

City Name

Event Title

City Name

Event Title

City Name

Event Title

keyboard_arrow_up Check back soon for the next challenge!

BigQuery Challenge Winners

  • First Name Last Initial, City/State or Country, Win Date
  • Joan S., Los Angeles, CA 9/20/19
  • Sam G., Singapore, 10/1/19
  • Example
  • Example
  • Example
  • Example
  • Example
  • Example

Get Involved with BigQuery

BigQuery on google.dev

Interested in learning more about BigQuery? Visit google.dev for training and support.

Subscribe on Reddit

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

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.

Submit your results

Learn more about Google Cloud

cloud_queue
About Google Cloud

Learn how you can build what’s next for your business with Google Cloud.

Find out

phonelink
Get top insights

Read the top stories and insights from Google Cloud.

See the blog

mail_outline
Questions?

A Google Cloud Sales specialist is ready to help.

Contact Sales