BigQuery Data Challenge

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

  • event

    jueves

  • place

    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?

  1. Crea una cuenta en BigQuery
  2. Busca las 2 consultas publicadas a continuación
  3. Ejecuta 2 consultas y obtén tus resultados
  4. 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.

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


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

 

Representante de desarrolladores @Google. De Chile a San Francisco y al mundo.

En 2011, Felipe Hoffa se mudó de Chile a San Francisco para unirse a las filas de Google como Ingeniero de Software. Desde 2013, es Representante de Desarrolladores en big data, y tiene como objetivo inspirar a los desarrolladores de todo el mundo a que aprovechen las herramientas de Google Cloud Platform para analizar y entender sus datos en formas que antes nunca pudieron. Puedes ver videos de él en YouTube, así como sus publicaciones de blog y conferencias por todo el mundo.

Sigue a Felipe en @felipehoffa.


Eric Schmidt

Staff Developer Advocate

 

Eric lidera el equipo de Relaciones de Desarrolladores de análisis de datos en Google Cloud, donde trabaja con clientes y partners para potenciar los flujos de trabajo en los verticales de ventas minoristas, servicios financieros, y medios de comunicación y entretenimiento.

Sigue a Eric en @notthateric.


Shane Glass

Lead, Google Cloud Public Datasets Program

Google Cloud

Shane es Manager de programa de Relaciones de Desarrolladores de Google Cloud. Es líder del Programa de conjuntos de datos públicos de Google Cloud Public, que simplifica el acceso a conjuntos de datos públicos de alta demanda, lo que permite a los usuarios descubrir información valiosa nueva y acceder a ella en la nube con facilidad. Antes de llegar a Google, Shane trabajó como project manager en el proyecto Big Data de la NOAA. También colabora en la actualidad como oficial de asuntos públicos del Ejército de Reserva de los Estados Unidos. Ha obtenido su título universitario de la Universidad de Carolina del Sur y un Master en Análisis de Datos de la 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/

Mantén la velocidad con BigQuery

BigQuery en google.dev

Visita google.dev/topics/bigquery para más recursos de BigQuery.


Suscríbete en Reddit

Únete a la conversación de BigQuery en https://www.reddit.com/r/bigquery/.


BigQuery en google.qwiklabs.com

Aprende más con el quest de BigQuery para el análisis de datos.

Regístrate ahora

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