BigQuery Data Challenge

Test your data analysis skills with the pros

Thursdays
Online

Can you solve the BigQuery Data Challenge?

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

How it works:

Create an account in BigQuery (see step by step instructions here)
Find the 2 queries posted below
Run 2 queries to get your results
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!

Choose your city

San Francisco 3/23 Los Angeles 3/26 New York 3/28

This week's challenge

Query 1: Prove your powers

As usual, we want you to prove that you have successfully become a BigQuery user. For that, run this query and input the results on the participation form:

SELECT enc_user_ts 
FROM `fh-bigquery.public_dump.encrypting_user_view`

To learn how this works, check out https://stackoverflow.com/q/56122855/132438. Note that the results you share on the form will include the account email address you used to run the query in BigQuery.

Query 2: Wiki's most popular baby

Wikipedia is full of babies - what baby page got the largest number of pageviews during the last week of December 2019?

SELECT title, SUM(views) views
FROM `bigquery-public-data.wikipedia.pageviews_2019` 
WHERE wiki LIKE 'en%'
AND title LIKE 'Baby%'
AND DATE(datehour) BETWEEN '2019-12-25' AND '2019-12-31'
GROUP BY 1
ORDER BY 2 DESC
LIMIT 100

To participate in this week’s challenge, look at the results and find the page starting with "Baby" that got the largest number of pageviews. Fill out the participation form with this result.

To learn more about this, check https://medium.com/@hoffa/the-top-2019-wikipedia-pages-d3b96335b6ae

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

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

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

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

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