We may earn an affiliate commission when you visit our partners.
Google Cloud Training
Este é o segundo curso da série "Data to Insights". Vamos aprender a fazer a ingestão de novos conjuntos de dados externos no BigQuery e visualizá-los no Looker Studio. Também vamos analisar conceitos intermediários de SQL, como as operações JOIN e UNION em várias tabelas, para analisar dados de diversas fontes.
Observação: Mesmo que você tenha experiência em SQL, há aspectos específicos do BigQuery (como usar o cache de consultas e os caracteres curinga de tabela) que podem ser novidade para você.
Depois de terminar este curso, faça sua inscrição no "Achieving Advanced Insights with BigQuery".
Register for this course and see more details by visiting:
OpenCourser.com/course/fvltzl/creating
What's inside
Syllabus
Introdução ao curso
Informações gerais sobre o conteúdo do curso
Como armazenar e exportar dados
Usar os resultados da consulta para criar tabelas permanentes e temporárias
Read more
Syllabus
Introdução ao curso
Informações gerais sobre o conteúdo do curso
Como armazenar e exportar dados
Usar os resultados da consulta para criar tabelas permanentes e temporárias
Read more
Como fazer a ingestão de novos conjuntos de dados no BigQuery
Carregar e criar conjuntos de dados no BigQuery
Como mesclar conjuntos de dados
Entender as diferenças entre as operações JOIN e UNION do SQL e quando usar cada uma
Visualização de dados
Criar painéis e visualizações com o Looker Studio
Resumo do curso
Resumo dos principais pontos de aprendizado do curso
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
É apropriado para profissionais que desejam aprimorar suas habilidades de análise de dados com SQL e visualização de dados
Desenvolve habilidades práticas em BigQuery e Looker Studio, que são ferramentas amplamente usadas no mercado
Explora conceitos avançados de SQL, como JOIN e UNION, que são cruciais para análise de dados complexos
Requer conhecimento prévio de SQL e conceitos básicos de análise de dados
Aborda a ingestão e visualização de dados de várias fontes, o que é relevante para profissionais que trabalham com grandes conjuntos de dados
Save this course
Save Creating BigQuery Datasets, Visualizing Insights - Português to your list so you can find it easily later:
Save
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 - Português with these
activities:
Organize your course materials for easy reference
Show steps
Consolidate your notes, assignments, and other course materials for efficient learning.
Show steps
-
Create a dedicated folder or notebook for your course materials
-
File and organize your materials by topic or lesson
-
Review your materials regularly to reinforce your learning
Review SQL basics
Show steps
Review the basics of SQL to solidify your understanding before starting the course.
Browse courses on
SQL
Show steps
-
Read through your notes or a SQL tutorial
-
Complete 10-20 practice problems
-
Take a short quiz to test your understanding
Review SQL
Show steps
reinforces foundational SQL skills necessary to fully participate in this course and the assignments
Browse courses on
SQL
Show steps
-
Review SQL fundamentals such as data types, operators and basic syntax
-
Practice writing simple queries to select, filter and group data
-
Complete online tutorials or exercises to reinforce understanding
14 other activities
Expand to see all activities and additional details
Show all 17 activities
Help other students by answering questions and providing support
Show steps
Offer support to fellow students who may be struggling with the course content.
Show steps
-
Join a study group or online forum
-
Offer assistance to others who have questions
-
Provide feedback and constructive criticism to help others improve their understanding
Explore BigQuery Documentation
Show steps
familiarizes students with the BigQuery platform and its key features, which will be essential for completing course assignments
Browse courses on
BigQuery
Show steps
-
Navigate the BigQuery documentation website
-
Read through tutorials and articles on BigQuery concepts and functionalities
-
Follow along with code examples to gain practical experience
Review SQL basics
Show steps
Ensure that you have a firm grasp of SQL basics before beginning this course.
Show steps
-
Review online tutorials or documentation on SQL basics.
-
Practice writing simple SQL queries.
Join a study group
Show steps
facilitates collaboration and knowledge sharing among students, enhancing understanding and retention
Show steps
-
Find or create a study group with other students enrolled in the course
-
Meet regularly to discuss course material, assignments and projects
-
Share notes, resources and insights
Join a study group or online forum
Show steps
Connect with other learners to discuss course material, share insights, and ask questions.
Show steps
-
Find a study group or online forum dedicated to the course topics.
-
Participate actively in discussions and ask questions for clarification.
Explore online tutorials on BigQuery
Show steps
Supplement your understanding of BigQuery by following guided tutorials.
Show steps
-
Search for online tutorials or documentation on BigQuery.
-
Follow the tutorials to learn about different features and capabilities of BigQuery.
Practice writing SQL queries
Show steps
Reinforce your understanding of SQL by writing queries to retrieve data from different tables.
Browse courses on
SQL Queries
Show steps
-
Find a dataset or use the sample data provided by the course
-
Write queries to answer specific questions about the data
-
Review your queries to identify areas for improvement
Follow tutorials to learn more about SQL and BigQuery
Show steps
Expand your knowledge and skills by following tutorials on SQL and BigQuery.
Browse courses on
SQL
Show steps
-
Find tutorials from reputable sources
-
Work through the tutorials step-by-step
-
Experiment with the concepts you learn in the tutorials
Create mock datasets and tables
Show steps
provides hands-on experience in creating and managing BigQuery resources, which will be crucial for course assignments and projects
Browse courses on
BigQuery
Show steps
-
Design a mock dataset and tables based on a specific scenario or use case
-
Create the dataset and tables in your BigQuery sandbox
-
Populate the tables with sample data
-
Run queries to retrieve and analyze the data
Attend a workshop on BigQuery
Show steps
Attend a workshop to learn more about BigQuery and how to use it effectively for data analysis.
Browse courses on
BigQuery
Show steps
-
Research and find an appropriate workshop
-
Register and attend the workshop
-
Take notes and ask questions during the workshop
-
Apply what you learned in the workshop to your own projects
Develop a data visualization dashboard
Show steps
encourages students to apply their knowledge of BigQuery and Looker Studio to create meaningful data visualizations that enhance understanding of course concepts
Browse courses on
BigQuery
Show steps
-
Identify a dataset and metrics to visualize
-
Design the dashboard layout and choose appropriate visualizations
-
Create the dashboard in Looker Studio and connect it to the BigQuery dataset
-
Configure visualizations, filters and interactions
-
Share the dashboard with peers or instructors for feedback
Create a data visualization project
Show steps
Apply your data analysis skills by creating a data visualization project using Looker Studio.
Browse courses on
Data Visualization
Show steps
-
Choose a dataset that you are interested in analyzing.
-
Use Looker Studio to import the dataset and create visualizations.
-
Tell a story with your data by using visualizations to highlight insights and trends.
Create a data analysis project using BigQuery and Looker Studio
Show steps
Apply your skills by creating a data analysis project that leverages BigQuery and Looker Studio.
Browse courses on
BigQuery
Show steps
-
Define the scope and goals of your project
-
Gather and prepare your data using BigQuery
-
Visualize and analyze your data using Looker Studio
-
Communicate your insights and findings
Build a personal data analysis project
Show steps
Apply your learning by starting a personal data analysis project and working towards its completion.
Show steps
-
Identify a problem or question that you want to explore using data.
-
Gather relevant data from online sources or create your own dataset.
-
Analyze the data using SQL and other data analysis techniques.
-
Present your findings in a clear and concise manner.
Organize your course materials for easy reference
Show steps
Consolidate your notes, assignments, and other course materials for efficient learning.
Show steps
Show steps
Show steps
- Create a dedicated folder or notebook for your course materials
- File and organize your materials by topic or lesson
- Review your materials regularly to reinforce your learning
Review SQL basics
Show steps
Review the basics of SQL to solidify your understanding before starting the course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Read through your notes or a SQL tutorial
- Complete 10-20 practice problems
- Take a short quiz to test your understanding
Review SQL
Show steps
reinforces foundational SQL skills necessary to fully participate in this course and the assignments
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review SQL fundamentals such as data types, operators and basic syntax
- Practice writing simple queries to select, filter and group data
- Complete online tutorials or exercises to reinforce understanding
14 other activities
Expand to see all activities and additional details
Show all 17 activities
Help other students by answering questions and providing support
Show steps
Offer support to fellow students who may be struggling with the course content.
Show steps
Show steps
Show steps
- Join a study group or online forum
- Offer assistance to others who have questions
- Provide feedback and constructive criticism to help others improve their understanding
Explore BigQuery Documentation
Show steps
familiarizes students with the BigQuery platform and its key features, which will be essential for completing course assignments
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Navigate the BigQuery documentation website
- Read through tutorials and articles on BigQuery concepts and functionalities
- Follow along with code examples to gain practical experience
Review SQL basics
Show steps
Ensure that you have a firm grasp of SQL basics before beginning this course.
Show steps
Show steps
Show steps
- Review online tutorials or documentation on SQL basics.
- Practice writing simple SQL queries.
Join a study group
Show steps
facilitates collaboration and knowledge sharing among students, enhancing understanding and retention
Show steps
Show steps
Show steps
- Find or create a study group with other students enrolled in the course
- Meet regularly to discuss course material, assignments and projects
- Share notes, resources and insights
Join a study group or online forum
Show steps
Connect with other learners to discuss course material, share insights, and ask questions.
Show steps
Show steps
Show steps
- Find a study group or online forum dedicated to the course topics.
- Participate actively in discussions and ask questions for clarification.
Explore online tutorials on BigQuery
Show steps
Supplement your understanding of BigQuery by following guided tutorials.
Show steps
Show steps
Show steps
- Search for online tutorials or documentation on BigQuery.
- Follow the tutorials to learn about different features and capabilities of BigQuery.
Practice writing SQL queries
Show steps
Reinforce your understanding of SQL by writing queries to retrieve data from different tables.
Browse courses on
SQL Queries
Show steps
Show steps
Show steps
- Find a dataset or use the sample data provided by the course
- Write queries to answer specific questions about the data
- Review your queries to identify areas for improvement
Follow tutorials to learn more about SQL and BigQuery
Show steps
Expand your knowledge and skills by following tutorials on SQL and BigQuery.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Find tutorials from reputable sources
- Work through the tutorials step-by-step
- Experiment with the concepts you learn in the tutorials
Create mock datasets and tables
Show steps
provides hands-on experience in creating and managing BigQuery resources, which will be crucial for course assignments and projects
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Design a mock dataset and tables based on a specific scenario or use case
- Create the dataset and tables in your BigQuery sandbox
- Populate the tables with sample data
- Run queries to retrieve and analyze the data
Attend a workshop on BigQuery
Show steps
Attend a workshop to learn more about BigQuery and how to use it effectively for data analysis.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Research and find an appropriate workshop
- Register and attend the workshop
- Take notes and ask questions during the workshop
- Apply what you learned in the workshop to your own projects
Develop a data visualization dashboard
Show steps
encourages students to apply their knowledge of BigQuery and Looker Studio to create meaningful data visualizations that enhance understanding of course concepts
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Identify a dataset and metrics to visualize
- Design the dashboard layout and choose appropriate visualizations
- Create the dashboard in Looker Studio and connect it to the BigQuery dataset
- Configure visualizations, filters and interactions
- Share the dashboard with peers or instructors for feedback
Create a data visualization project
Show steps
Apply your data analysis skills by creating a data visualization project using Looker Studio.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Choose a dataset that you are interested in analyzing.
- Use Looker Studio to import the dataset and create visualizations.
- Tell a story with your data by using visualizations to highlight insights and trends.
Create a data analysis project using BigQuery and Looker Studio
Show steps
Apply your skills by creating a data analysis project that leverages BigQuery and Looker Studio.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Define the scope and goals of your project
- Gather and prepare your data using BigQuery
- Visualize and analyze your data using Looker Studio
- Communicate your insights and findings
Build a personal data analysis project
Show steps
Apply your learning by starting a personal data analysis project and working towards its completion.
Show steps
Show steps
Show steps
- Identify a problem or question that you want to explore using data.
- Gather relevant data from online sources or create your own dataset.
- Analyze the data using SQL and other data analysis techniques.
- Present your findings in a clear and concise manner.
Career center
Learners who complete Creating BigQuery Datasets, Visualizing Insights - Português will develop knowledge and skills
that may be useful to these careers:
Data Architect
Data Architect
A Data Architect is in charge of the design, implementation, and management of data systems and strategies for an organization. They use the organization's specific data needs to develop and oversee the systems and policies that ensure that data quality, efficiency, and security are maintained. Creating BigQuery Datasets, Visualizing Insights - Português can help someone seeking the role of a Data Architect by expanding their understanding of how to store and export data, use results from queries to create tables, ingest new datasets, and merge datasets. Those interested in becoming a Data Architect may also find the information about using SQL JOIN and UNION operations to analyze data from diverse sources especially relevant to their role.
Business Analyst
Business Analyst
A Business Analyst is a professional who analyzes an organization's business processes and data to identify areas where improvements can be made. Creating BigQuery Datasets, Visualizing Insights - Português can help Business Analysts by expanding their knowledge of leveraging SQL to analyze data. They may also find the information about visualizing data with Looker Studio especially pertinent to their role, as it can help Business Analysts to present their findings in a clear and concise way.
Data Scientist
Data Scientist
A Data Scientist is a professional who uses data to develop models and insights that can be used to make better decisions. They use statistical analysis, machine learning, and other techniques to identify patterns and trends in data, which can then be used to develop predictive models and other insights. Creating BigQuery Datasets, Visualizing Insights - Português can help someone seeking a role as a Data Scientist by building their understanding of how to use BigQuery to store and analyze large datasets. They may also find the information about creating visualizations with Looker Studio helpful for communicating their findings to others.
Database Administrator
Database Administrator
A Database Administrator is a professional who is responsible for the maintenance and performance of an organization's databases. They ensure that the databases are available, secure, and running efficiently. Creating BigQuery Datasets, Visualizing Insights - Português can help Database Administrators by expanding their understanding of how to use BigQuery, which is a cloud-based database service, to store and analyze data. They may also find the information about creating visualizations with Looker Studio helpful for presenting their findings to others.
Data Analyst
Data Analyst
A Data Analyst is a professional who uses data to identify trends and patterns that can be used to make better decisions. They use statistical analysis, machine learning, and other techniques to identify patterns and trends in data, which can then be used to develop predictive models and other insights. Creating BigQuery Datasets, Visualizing Insights - Português may be useful for someone seeking a role as a Data Analyst, as it provides knowledge about how to use BigQuery to store and analyze large datasets.
Software Engineer
Software Engineer
A Software Engineer is a professional who designs, develops, and maintains software applications. They use their knowledge of programming languages and software development principles to create software that meets the needs of users. Creating BigQuery Datasets, Visualizing Insights - Português may be useful for someone looking for a career as a Software Engineer, as it can help them learn how to use BigQuery as a data storage and analysis solution.
Data Engineer
Data Engineer
A Data Engineer is a professional who designs, builds, and maintains data pipelines and infrastructure. They use their knowledge of data engineering principles and tools to create systems that can collect, store, and process data in a timely and efficient manner. Creating BigQuery Datasets, Visualizing Insights - Português may be useful for someone interested in becoming a Data Engineer as it can provide them with knowledge about how to use BigQuery to store and analyze large datasets.
Systems Analyst
Systems Analyst
A Systems Analyst is a professional who analyzes and designs computer systems. They use their knowledge of systems analysis and design principles to create systems that meet the needs of users. Creating BigQuery Datasets, Visualizing Insights - Português can be of use for Systems Analysts by expanding their understanding of how to integrate BigQuery's offerings for data storage, analysis, and visualization into their systems.
Project Manager
Project Manager
A Project Manager is a professional who plans, executes, and closes projects. They use their knowledge of project management principles and tools to ensure that projects are completed on time, within budget, and to the required quality standards. Creating BigQuery Datasets, Visualizing Insights - Português may be useful for Project Managers by expanding their knowledge of how to use BigQuery's data storage, analysis, and visualization offerings to support project planning and execution.
Consultant
Consultant
A Consultant is a professional who provides advice and guidance to organizations on a specific area of expertise. They use their knowledge and experience to help organizations solve problems and improve their performance. Creating BigQuery Datasets, Visualizing Insights - Português may be of use for Consultants by expanding their knowledge about how to use BigQuery to provide data-driven insights to their clients.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst is a professional who collects and analyzes data to provide insights that can be used to improve business decisions. They use their knowledge of data analysis techniques and tools to identify trends and patterns in data, which can then be used to develop recommendations for improving business processes. Creating BigQuery Datasets, Visualizing Insights - Português may be useful for someone looking to enter the field of Business Intelligence as it expands their knowledge of how to use BigQuery for data analysis and visualization.
Statistician
Statistician
A Statistician is a professional who collects and analyzes data to draw conclusions about a population. They use their knowledge of statistical methods and principles to design experiments, collect data, and analyze results. Creating BigQuery Datasets, Visualizing Insights - Português may be useful for Statisticians by expanding their knowledge of how to use BigQuery to manage and analyze large datasets.
Data Miner
Data Miner
A Data Miner is a professional who extracts knowledge from large datasets. They use their knowledge of data mining techniques and tools to identify patterns and trends in data, which can then be used to develop predictive models and other insights. Creating BigQuery Datasets, Visualizing Insights - Português may be useful for someone looking for a career as a Data Miner as it can help them learn how to use BigQuery to store and analyze large datasets.
Database Developer
Database Developer
A Database Developer is a professional who designs and develops databases. They use their knowledge of database design principles and tools to create databases that meet the needs of users. Creating BigQuery Datasets, Visualizing Insights - Português can help someone seeking a career as a Database Developer by expanding their understanding of how to use BigQuery for data storage and analysis.
Information Architect
Information Architect
An Information Architect is a professional who designs and manages the structure and organization of information systems. They use their knowledge of information architecture principles and tools to create systems that are easy to use and understand. Creating BigQuery Datasets, Visualizing Insights - Português may be useful for someone looking to become an Information Architect as it can help them learn how to use BigQuery for data storage and analysis.
For more career information including salaries, visit:
OpenCourser.com/course/fvltzl/creating
Reading list
We've selected ten 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 - Português.
Save
Provides a comprehensive overview of data visualization, including its principles and techniques. It valuable resource for anyone who wants to learn more about data visualization and how to use it effectively.
Save
Este livro oferece uma visão abrangente da arquitetura e dos princípios de sistemas de big data, incluindo o Google BigQuery. Ele é uma leitura valiosa para aqueles que buscam uma compreensão profunda da infraestrutura de big data.
Provides a comprehensive overview of data analytics, including its principles and techniques. It valuable resource for anyone who wants to learn more about data analytics and how to use it effectively.
Provides a comprehensive overview of data science, including its principles and techniques. It valuable resource for anyone who wants to learn more about data science and how to use it effectively.
Provides a comprehensive overview of artificial intelligence, including its principles and techniques. It valuable resource for anyone who wants to learn more about artificial intelligence and how to use it effectively.
Provides a comprehensive overview of data science, including its principles and techniques. It valuable resource for anyone who wants to learn more about data science and how to use it effectively.
Este livro fornece uma coleção abrangente de exemplos e melhores práticas para criar painéis eficazes. Ele é um recurso valioso para aqueles que buscam melhorar suas habilidades de comunicação de dados.
Este livro aborda os fundamentos da ciência de dados, incluindo técnicas de análise de dados e aprendizado de máquina. Ele fornece uma base sólida para aqueles que buscam se aprofundar na análise de dados.
Este guia completo aborda todos os aspectos do SQL, incluindo operações de consulta avançadas. Ele é uma boa referência para aprimorar suas habilidades de SQL e se preparar para exames de certificação.
Save
Este livro oferece uma introdução rápida e simplificada ao SQL, cobrindo os conceitos básicos de consulta de dados. É uma boa opção para iniciantes que buscam uma rápida visão geral da linguagem.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/fvltzl/creating
Share
Similar courses
Here are nine courses similar to
Creating BigQuery Datasets, Visualizing Insights - Português.
Achieving Advanced Insights with BigQuery - Português
OpenCourser.com/course/ejlmw4/achieving
Achieving Advanced Insights with BigQuery - Português
Most relevant
Exploring and Preparing Your Data with BigQuery - Português
OpenCourser.com/course/fm6vvt/exploring
Exploring and Preparing Your Data with BigQuery -...
Most relevant
Machine Learning in the Enterprise - Português Brasileiro
OpenCourser.com/course/td51cf/machine
Machine Learning in the Enterprise - Português Brasileiro
Most relevant
O sucesso por meio das avaliações: análise e medição de marketing
OpenCourser.com/course/a80xre/o
O sucesso por meio das avaliações: análise e medição de...
Most relevant
Segurança de TI: defesa contra as artes negras digitais
OpenCourser.com/course/1olvkl/seguranca
Segurança de TI: defesa contra as artes negras digitais
Most relevant
Análise de dados com programação em R
OpenCourser.com/course/i8fs3b/analise
Análise de dados com programação em R
Most relevant
Building Batch Data Pipelines on GCP em Português Brasileiro
OpenCourser.com/course/dhcmop/building
Building Batch Data Pipelines on GCP em Português...
Most relevant
Ferramentas para Ciência de Dados: Introdução ao R
OpenCourser.com/course/v22yaa/ferramentas
Ferramentas para Ciência de Dados: Introdução ao R
Most relevant
Redes Ecológicas
OpenCourser.com/course/1vhx4k/redes
Redes Ecológicas
Most relevant
Effort
1 week of study, 5-7 hours/week
Level
Introductory
Via
Coursera
Institution
Google Cloud
Instructor
Google Cloud Training
Language
Português
Transcript
English
Good to know
É apropriado para profissionais que desejam aprimorar suas habilidades de análise de dados com SQL e visualização de dados
Desenvolve habilidades práticas em BigQuery e Looker Studio, que são ferramentas amplamente usadas no mercado
Explora conceitos avançados de SQL, como JOIN e UNION, que são cruciais para análise de dados complexos
Requer conhecimento prévio de SQL e conceitos básicos de análise de dados
Aborda a ingestão e visualização de dados de várias fontes, o que é relevante para profissionais que trabalham com grandes conjuntos de dados
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