We may earn an affiliate commission when you visit our partners.
Course image
Google Cloud Training

Este es el segundo curso de la serie de cursos Data to Insights. Aquí, veremos cómo transferir nuevos conjuntos de datos externos a BigQuery y visualizarlos con Looker Studio. También analizaremos los conceptos intermedios de SQL, como las operaciones JOIN y UNION de varias tablas, que te permitirán analizar datos de varias fuentes.

Read more

Este es el segundo curso de la serie de cursos Data to Insights. Aquí, veremos cómo transferir nuevos conjuntos de datos externos a BigQuery y visualizarlos con Looker Studio. También analizaremos los conceptos intermedios de SQL, como las operaciones JOIN y UNION de varias tablas, que te permitirán analizar datos de varias fuentes.

Nota: Incluso si tienes experiencia en SQL, hay aspectos específicos de BigQuery (como la gestión del almacenamiento en caché de las consultas y los comodines de tablas) que pueden ser nuevos para ti.

Después de completar el curso, inscríbete en el curso Achieving Advanced Insights with BigQuery.

Enroll now

What's inside

Syllabus

Introducción al curso
Descripción general de lo que aprenderás en este curso
Almacenamiento y exportación de datos
Crear tablas permanentes y temporales nuevas a partir de los resultados de las consultas
Read more
Transfiere nuevos conjuntos de datos a BigQuery
Cargar y crear conjuntos de datos nuevos en BigQuery
Cómo unir y combinar conjuntos de datos
Comprender las diferencias entre las operaciones JOIN y UNION de SQL y cuándo usar cada una
Visualización de datos
Crear paneles y visualizaciones con Looker Studio
Resumen del curso
Resumen de los puntos de aprendizaje clave del curso

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Requiere conocimientos previos de SQL para aprovechar al máximo el curso
Proporciona una base sólida en conceptos intermedios de SQL, lo que mejora las habilidades de análisis de datos
Enseña cómo combinar y unir conjuntos de datos, ampliando las capacidades de análisis
Capacita a los alumnos para transferir nuevos conjuntos de datos a BigQuery, lo que amplía las fuentes de datos para el análisis
Brinda una introducción a la visualización de datos con Looker Studio

Save this course

Save Creating BigQuery Datasets, Visualizing Insights - Español to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Creating BigQuery Datasets, Visualizing Insights - Español with these activities:
Refrescar habilidades de visualización de datos
Refrescar tus habilidades de visualización de datos te ayudará a crear paneles y visualizaciones más efectivas en Looker Studio.
Show steps
  • Revisar tutoriales o cursos en línea sobre visualización de datos
  • Experimentar con diferentes herramientas de visualización de datos
  • Crear un proyecto de visualización de datos de muestra usando los conjuntos de datos de BigQuery
Crear una compilación de materiales
Crear una compilación de materiales te ayudará a organizar y revisar el material del curso de manera efectiva.
Show steps
  • Recopilar notas, diapositivas, tareas y exámenes
  • Organizar y clasificar los materiales
  • Revisar regularmente la compilación
Revisar los conceptos básicos de SQL
Repasar los conceptos básicos de SQL te ayudará a comprender mejor las operaciones de unión y combinación de varias tablas.
Browse courses on SQL
Show steps
  • Revisar tutoriales en línea sobre SQL básico
  • Resolver ejercicios de práctica de SQL
  • Crear un proyecto simple de SQL para practicar la unión y combinación de tablas
Six other activities
Expand to see all activities and additional details
Show all nine activities
Sesiones de estudio en grupo
Participar en sesiones de estudio en grupo te permitirá colaborar con otros estudiantes y reforzar los conceptos aprendidos.
Show steps
  • Formar un grupo de estudio con compañeros de clase
  • Reunirse regularmente para discutir el material del curso
  • Ayudarse mutuamente con problemas y preguntas
Ejercicios de unión y combinación de tablas
Practicar ejercicios de unión y combinación de tablas te ayudará a dominar estas operaciones y mejorar tus habilidades analíticas de datos.
Show steps
  • Resolver conjuntos de problemas de práctica que involucren uniones y combinaciones de tablas
  • Participar en concursos o desafíos en línea que se centren en SQL
  • Crear un proyecto de análisis de datos que requiera la unión y combinación de múltiples conjuntos de datos
Tutoriales sobre Looker Studio
Seguir tutoriales sobre Looker Studio te ayudará a comprender cómo visualizar datos de BigQuery de manera efectiva.
Show steps
  • Ver tutoriales en vídeo sobre cómo utilizar Looker Studio
  • Completar cursos en línea o talleres sobre Looker Studio
  • Crear paneles y visualizaciones de muestra utilizando Looker Studio
Crea un blog o vlog sobre análisis de datos
Crear un blog o vlog sobre análisis de datos te permitirá compartir tus conocimientos y reforzar tus habilidades de comunicación.
Show steps
  • Elegir un tema y formato para tu blog o vlog
  • Investigar y recopilar información sobre análisis de datos
  • Crear contenido valioso e informativo
  • Promocionar tu blog o vlog en las redes sociales y otras plataformas
Informe de análisis de datos
Crear un informe de análisis de datos te ayudará a aplicar los conocimientos adquiridos en el curso a un proyecto del mundo real.
Show steps
  • Identificar un problema o pregunta empresarial
  • Recopilar y preparar datos de BigQuery
  • Analizar datos y generar conocimientos
  • Crear un informe claro y conciso que presente los resultados
Concurso de análisis de datos
Participar en un concurso de análisis de datos te desafiará a aplicar tus habilidades y conocimientos en un entorno competitivo.
Show steps
  • Investigar y seleccionar un concurso relevante
  • Formar un equipo o participar individualmente
  • Recopilar y analizar datos
  • Desarrollar una solución y crear una presentación

Career center

Learners who complete Creating BigQuery Datasets, Visualizing Insights - Español will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts use their knowledge of data and computer science to analyze complex data sets in order to extract insights and help companies make better business decisions. This course will provide you with a solid foundation in the skills and knowledge you need to become a successful Data Analyst. You will learn how to collect, clean, and analyze data, as well as how to visualize data and communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as a Data Analyst.
Data Scientist
Data Scientists use their knowledge of statistics, mathematics, and computer science to build models that can predict future outcomes. This course will give you the skills and knowledge you need to become a successful Data Scientist. You will learn how to collect, clean, and analyze data, as well as how to build models and communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as a Data Scientist.
Data Engineer
Data Engineers build and maintain the infrastructure that supports data analysis and modeling. This course will provide you with the skills and knowledge you need to become a successful Data Engineer. You will learn how to design, build, and manage data warehouses and data lakes, as well as how to work with data analysts and data scientists to ensure that data is available and accessible for analysis.
Actuary
Actuaries use their knowledge of mathematics and statistics to assess and manage risk. This course will give you the skills and knowledge you need to become a successful Actuary. You will learn how to identify, assess, and manage risk, as well as how to communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as an Actuary.
Database Administrator
Database Administrators are responsible for the day-to-day operation and maintenance of databases. This course will give you the skills and knowledge you need to become a successful Database Administrator. You will learn how to install, configure, and manage databases, as well as how to troubleshoot and resolve database issues.
Statistician
Statisticians use their knowledge of statistics and mathematics to collect, analyze, and interpret data. This course will give you the skills and knowledge you need to become a successful Statistician. You will learn how to design and conduct surveys, analyze data, and communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as a Statistician.
Business Analyst
Business Analysts use their knowledge of business and technology to help companies solve problems and improve their performance. This course will give you the skills and knowledge you need to become a successful Business Analyst. You will learn how to analyze business problems, design solutions, and communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as a Business Analyst.
Data Visualization Specialist
Data Visualization Specialists use their knowledge of data visualization tools and techniques to create visualizations that communicate data insights effectively. This course will give you the skills and knowledge you need to become a successful Data Visualization Specialist. You will learn how to choose the right data visualization tools and techniques for your data, as well as how to create visualizations that are clear, concise, and visually appealing. This course will give you a competitive advantage in the job market and help you launch a successful career as a Data Visualization Specialist.
Market Researcher
Market Researchers collect and analyze data to help companies understand their customers and make better business decisions. This course will give you the skills and knowledge you need to become a successful Market Researcher. You will learn how to design and conduct surveys, analyze data, and communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as a Market Researcher.
User Experience (UX) Researcher
UX Researchers use their knowledge of human behavior and research methods to design and evaluate user experiences. This course will give you the skills and knowledge you need to become a successful UX Researcher. You will learn how to conduct user research, analyze data, and communicate your findings to others.
Financial Analyst
Financial Analysts use their knowledge of finance and accounting to analyze financial data and make investment recommendations. This course will give you the skills and knowledge you need to become a successful Financial Analyst. You will learn how to analyze financial statements, build financial models, and communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as a Financial Analyst.
Product Manager
Product Managers are responsible for the planning, development, and launch of new products. This course will give you the skills and knowledge you need to become a successful Product Manager. You will learn how to identify market opportunities, develop product strategies, and manage product development teams. This course will give you a competitive advantage in the job market and help you launch a successful career as a Product Manager.
Risk Analyst
Risk Analysts use their knowledge of statistics and mathematics to assess and manage risk. This course will give you the skills and knowledge you need to become a successful Risk Analyst. You will learn how to identify, assess, and manage risk, as well as how to communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as a Risk Analyst.
Software Engineer
Software Engineers design, develop, and maintain software applications. This course will give you the skills and knowledge you need to become a successful Software Engineer. You will learn how to design, develop, and test software applications, as well as how to work with other engineers on software development teams. This course will give you a competitive advantage in the job market and help you launch a successful career as a Software Engineer.
Insurance Analyst
Insurance Analysts use their knowledge of insurance and finance to analyze insurance risks and develop insurance products. This course will give you the skills and knowledge you need to become a successful Insurance Analyst. You will learn how to analyze insurance risks, develop insurance products, and communicate your findings to others. This course will give you a competitive advantage in the job market and help you launch a successful career as an Insurance Analyst.

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Creating BigQuery Datasets, Visualizing Insights - Español.
Covers the fundamentals of BigQuery, including data ingestion, querying, and visualization. It valuable reference for those who want to learn more about BigQuery.
Esta guía completa de SQL proporciona una base sólida en los conceptos básicos de SQL, incluidos JOIN y UNION. Es una lectura esencial para aquellos que buscan mejorar sus habilidades de SQL.
Si bien este libro no se enfoca específicamente en Big Data o SQL, proporciona una base sólida en Python para el análisis de datos. Python es un lenguaje de programación popular en el ecosistema de Big Data.
Esta guía práctica de visualización de datos con Tableau proporciona orientación sobre cómo crear visualizaciones efectivas. Si bien se centra en Tableau, ofrece información valiosa que se puede aplicar a Looker Studio.
Esta guía práctica de SQL proporciona instrucciones paso a paso sobre cómo usar SQL. Es un recurso útil para aquellos que buscan desarrollar sus habilidades de SQL desde cero.
Esta introducción práctica a la visualización de datos proporciona principios fundamentales y técnicas efectivas para crear visualizaciones impactantes. Es una lectura valiosa para aquellos que buscan mejorar sus habilidades de visualización de datos.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Creating BigQuery Datasets, Visualizing Insights - Español.
Introducción a SQL y bases de datos relacionales
Most relevant
Creación de Tablas de Base de Datos con SQL
Most relevant
Excel avanzado: importación y análisis de datos
Most relevant
Diseño de sistemas de información gerencial para intranet...
Most relevant
Excel: gestión de datos
Most relevant
Aspectos básicos: Datos, datos, en todas partes
Most relevant
Achieving Advanced Insights with BigQuery - Español
Most relevant
Preparar datos para la exploración
Most relevant
Bases de datos
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser