BigQuery Data Challenge

Teste suas habilidades em análise de dados com os profissionais

Quartas-feiras
Online

Você consegue resolver o BigQuery Data Challenge?

Toda semana, o Felipe Hoffa lançará um novo problema de dados para ser resolvido. Faça as consultas o mais rápido possível e, depois, mostre seu trabalho.

Como funciona:

Crie uma conta no BigQuery.
Encontre os dois desafios publicadas abaixo.
Execute os desafios para obter seus resultados.
Envie os resultados pelo formulário abaixo.

Selecionaremos um vencedor aleatoriamente do grupo de respostas corretas que ganhará $ 500 em créditos no Cloud!

Choose your city

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

Desafio da semana

Query 1: Mostre seu poder

Como sempre, queremos que você demonstre que se tornou usuário do BigQuery. Para isso, execute esta consulta e insira os resultados no formulário de participação:

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

Para saber como funciona, consulte https://stackoverflow.com/q/56122855/132438. Note que os resultados que você compartilhar no formulário incluem o endereço da conta de e-mail que usou para fazer a consulta no BigQuery.

Consulta 2: Bicicletas na cidade

Qual foi o destino mais comum de passeios de bicicletas públicas em Nova York entre as mulheres em maio de 2018?

Para descobrir, execute esta consulta e insira os resultados no formulário de participação semanal:

SELECT end_station_name , COUNT(*) c
FROM `bigquery-public-data.new_york_citibike.citibike_trips` 
WHERE DATETIME_TRUNC(stoptime, MONTH) = '2018-05-01'
AND gender='female'
GROUP BY 1
ORDER BY c DESC
LIMIT 20

Para saber mais detalhes sobre este conjunto de dados, acesse https://console.cloud.google.com/marketplace/details/city-of-new-york/nyc-citi-bike

Dica: fica em Tribeca.

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