BigQuery Data Challenge

Pon a prueba tus habilidades de análisis de datos con los profesionales

jueves
Online

¿Puedes resolver el BigQuery Data Challenge?

Cada semana, Felipe Hoffa publicará un nuevo acertijo de datos para resolver. Empieza a consultar tan rápido como puedas y luego muéstranos tu trabajo.

¿Cómo funciona?

Crea una cuenta en BigQuery
Busca las 2 consultas publicadas a continuación
Ejecuta 2 consultas y obtén tus resultados
Envía tus resultados del desafío utilizando el formulario incluido más adelante

El ganador, elegido al azar entre todos los participantes que hayan respondido correctamente, obtendrá $500 en créditos de Cloud.

Choose your city

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

Desafío de esta semana

Consulta 1: Demuestra tus poderes

Como siempre, queremos que nos demuestres que ya eres todo un usuario de BigQuery. Para eso, ejecuta esta consulta e ingresa los resultados en el formulario de participación:

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

Visita https://stackoverflow.com/q/56122855/132438 para saber cómo funciona. Recuerda que los resultados compartidos en el formulario incluirán la dirección de correo electrónico que utilizaste para ejecutar la consulta en BigQuery.

Consulta 2: En busca de pandas

Pandas es una biblioteca de software muy popular en el lenguaje de programación Python para la manipulación y el análisis de datos. Queremos conocer qué versión de pandas y qué versión de Python conformaron la combinación más popular descargada durante enero de 2020.

SELECT COUNT(*) c, project, file.version, details.python
FROM `fh-bigquery.pypi.pypi_2020` 
WHERE DATE_TRUNC(DATE(timestamp), MONTH) = "2020-01-01"
AND project = 'pandas'
GROUP BY 2,3,4
ORDER BY 1 DESC
LIMIT 10

Para participar, completa el formulario semanal con la combinación más popular de versión pandas + versión Python.

Para obtener más información, haz clic en https://towardsdatascience.com/python-pypi-stats-in-bigquery-reclustered-d80e583e1bfe

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