We may earn an affiliate commission when you visit our partners.
Google Cloud Training
Neste curso, conhecemos os desafios mais comuns enfrentados pelos analistas de dados e como resolvê-los com as ferramentas de big data no Google Cloud. Ao longo do caminho, você vai aprender um pouco de SQL e se familiarizar com o uso do BigQuery e do Dataprep para analisar e transformar seus conjuntos de dados.
Este é o primeiro curso da série From Data to Insights with Google Cloud. Depois de concluir este curso, inscreva-se no curso Creating New BigQuery Datasets and Visualizing Insights.
Register for this course and see more details by visiting:
OpenCourser.com/course/fm6vvt/exploring
What's inside
Syllabus
Introdução ao curso From Data to Insights with Google Cloud - Exploring and Preparing Your Data
Conheça os cursos, os conteúdos e as tecnologias que fazem parte desta série de cursos de análise de dados.
Read more
Syllabus
Introdução ao curso From Data to Insights with Google Cloud - Exploring and Preparing Your Data
Conheça os cursos, os conteúdos e as tecnologias que fazem parte desta série de cursos de análise de dados.
Read more
Introdução à análise de dados no Google Cloud
Aprenda os princípios de base do Google Cloud e como usá-los na análise de Big Data
Aspectos gerais das ferramentas de Big Data
Conheça as ferramentas principais de Big Data no Google Cloud que você vai usar para analisar, preparar e consultar dados
Análise dos seus dados com SQL
Saiba como consultar seus dados usando o básico do SQL (Structured Query Language) e pratique a criação de consultas no BigQuery
Preços do BigQuery
Saiba como os preços funcionam no BigQuery e aprenda a otimizar suas consultas
Como limpar e transformar seus dados
Entenda a importância de criar conjuntos de dados de qualidade e conheça as ferramentas que vão ajudar você a transformar seus dados
Resumo do curso
Resumo dos pontos principais de aprendizado do curso
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Este curso é ideal para iniciantes que desejam aprender os fundamentos da análise de dados no Google Cloud
Aborda os desafios comuns enfrentados por analistas de dados e oferece soluções usando ferramentas de big data do Google Cloud
Explora o uso do BigQuery e do Dataprep para analisar e transformar conjuntos de dados
Oferece uma introdução ao SQL, capacitando os alunos a consultar seus dados de forma eficaz
Aborda aspectos importantes da preparação de dados, enfatizando a criação de conjuntos de dados de alta qualidade
Faz parte de uma série de cursos abrangentes sobre análise de dados com o Google Cloud
Save this course
Save Exploring and Preparing Your Data with BigQuery - 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 Exploring and Preparing Your Data with BigQuery - Português with these
activities:
Curate a collection of data science resources
Show steps
Enhance your learning experience by compiling a personalized collection of valuable resources.
Browse courses on
Data Science Tools
Show steps
-
Gather articles, tutorials, books, and other materials related to data science.
-
Organize the resources into a structured format (e.g., a Notion page, a shared document).
Review data science fundamentals
Show steps
Solidify foundational data science knowledge to jumpstart your journey in this course.
Browse courses on
Data Science Fundamentals
Show steps
-
Revise key concepts such as data types, data structures, and statistical methods.
-
Refresh your understanding of data preprocessing and exploratory data analysis.
Introdução ao BigQuery
Show steps
Examine a documentação do BigQuery para se familiarizar com seus recursos e funcionalidades.
Browse courses on
BigQuery
Show steps
-
Acesse a documentação do BigQuery
-
Leia os tutoriais introdutórios
-
Pratique consultas SQL no BigQuery
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Discussão em Fórum
Show steps
Troque ideias e aprenda com colegas por meio de discussões em fórum.
Browse courses on
BigQuery
Show steps
-
Junte-se a um fórum de análise de dados
-
Participe de discussões sobre tópicos relacionados ao curso
-
Compartilhe seus conhecimentos e aprenda com outras perspectivas
Explore Dataprep for data transformation
Show steps
Enhance your data manipulation skills by following hands-on tutorials on Dataprep.
Browse courses on
Data Transformation
Show steps
-
Learn to clean and standardize data using Dataprep's intuitive interface.
-
Explore different data manipulation techniques such as merging, splitting, and pivoting.
Exercícios de SQL
Show steps
Pratique consultas SQL para reforçar seu conhecimento e confiança.
Browse courses on
SQL
Show steps
-
Encontre conjuntos de dados públicos no BigQuery
-
Crie consultas para extrair e analisar dados
-
Desafie-se com problemas de consulta mais complexos
Practice SQL queries in BigQuery
Show steps
Gain proficiency in SQL by working through practice exercises in BigQuery.
Browse courses on
BigQuery
Show steps
-
Create a sample dataset in BigQuery.
-
Write SQL queries to filter, group, and aggregate data.
-
Practice joining tables and using subqueries.
Discuss best practices in data analysis
Show steps
Engage with peers to share knowledge, exchange ideas, and learn from diverse perspectives.
Show steps
-
Join a study group or discussion forum specific to data analysis.
-
Actively participate in discussions, ask questions, and share your own insights.
Projeto de Análise de Dados
Show steps
Aplique as habilidades adquiridas para analisar dados e criar insights valiosos.
Browse courses on
BigQuery
Show steps
-
Identifique um conjunto de dados interessante
-
Projete e execute consultas no BigQuery
-
Analise os resultados e extraia insights
-
Crie visualizações ou relatórios para apresentar suas descobertas
Build a data visualization dashboard
Show steps
Apply your newfound skills to create an interactive dashboard that communicates insights from your data.
Browse courses on
Data Visualization
Show steps
-
Choose a dataset and define the key metrics you want to visualize.
-
Select appropriate visualization types (e.g., charts, graphs) to effectively convey the data.
-
Use tools like Google Data Studio or Tableau to build the dashboard.
Contribute to open-source data science projects
Show steps
Gain practical experience and contribute to the data science community by participating in open-source projects.
Browse courses on
Data Science Projects
Show steps
-
Identify open-source data science projects on platforms like GitHub.
-
Choose a project that aligns with your interests and skills.
Curate a collection of data science resources
Show steps
Enhance your learning experience by compiling a personalized collection of valuable resources.
Browse courses on
Data Science Tools
Show steps
Show steps
Show steps
- Gather articles, tutorials, books, and other materials related to data science.
- Organize the resources into a structured format (e.g., a Notion page, a shared document).
Review data science fundamentals
Show steps
Solidify foundational data science knowledge to jumpstart your journey in this course.
Browse courses on
Data Science Fundamentals
Show steps
Show steps
Show steps
- Revise key concepts such as data types, data structures, and statistical methods.
- Refresh your understanding of data preprocessing and exploratory data analysis.
Introdução ao BigQuery
Show steps
Examine a documentação do BigQuery para se familiarizar com seus recursos e funcionalidades.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Acesse a documentação do BigQuery
- Leia os tutoriais introdutórios
- Pratique consultas SQL no BigQuery
Eight other activities
Expand to see all activities and additional details
Show all 11 activities
Discussão em Fórum
Show steps
Troque ideias e aprenda com colegas por meio de discussões em fórum.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Junte-se a um fórum de análise de dados
- Participe de discussões sobre tópicos relacionados ao curso
- Compartilhe seus conhecimentos e aprenda com outras perspectivas
Explore Dataprep for data transformation
Show steps
Enhance your data manipulation skills by following hands-on tutorials on Dataprep.
Browse courses on
Data Transformation
Show steps
Show steps
Show steps
- Learn to clean and standardize data using Dataprep's intuitive interface.
- Explore different data manipulation techniques such as merging, splitting, and pivoting.
Exercícios de SQL
Show steps
Pratique consultas SQL para reforçar seu conhecimento e confiança.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Encontre conjuntos de dados públicos no BigQuery
- Crie consultas para extrair e analisar dados
- Desafie-se com problemas de consulta mais complexos
Practice SQL queries in BigQuery
Show steps
Gain proficiency in SQL by working through practice exercises in BigQuery.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Create a sample dataset in BigQuery.
- Write SQL queries to filter, group, and aggregate data.
- Practice joining tables and using subqueries.
Discuss best practices in data analysis
Show steps
Engage with peers to share knowledge, exchange ideas, and learn from diverse perspectives.
Show steps
Show steps
Show steps
- Join a study group or discussion forum specific to data analysis.
- Actively participate in discussions, ask questions, and share your own insights.
Projeto de Análise de Dados
Show steps
Aplique as habilidades adquiridas para analisar dados e criar insights valiosos.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Identifique um conjunto de dados interessante
- Projete e execute consultas no BigQuery
- Analise os resultados e extraia insights
- Crie visualizações ou relatórios para apresentar suas descobertas
Build a data visualization dashboard
Show steps
Apply your newfound skills to create an interactive dashboard that communicates insights from your data.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Choose a dataset and define the key metrics you want to visualize.
- Select appropriate visualization types (e.g., charts, graphs) to effectively convey the data.
- Use tools like Google Data Studio or Tableau to build the dashboard.
Contribute to open-source data science projects
Show steps
Gain practical experience and contribute to the data science community by participating in open-source projects.
Browse courses on
Data Science Projects
Show steps
Show steps
Show steps
- Identify open-source data science projects on platforms like GitHub.
- Choose a project that aligns with your interests and skills.
Career center
Learners who complete Exploring and Preparing Your Data with BigQuery - Português will develop knowledge and skills
that may be useful to these careers:
Statistician
Statistician
The Statistician uses data to understand and interpret trends. The focus of this course on SQL and data analysis provides a strong conceptual foundation for beginning to pursue a career in this role.
Data Scientist
Data Scientist
The Data Scientist uses data to develop new insights. This course would be of particular value to this role, by providing foundational skills that help build analytical capabilities, particularly due to the focus on preparing and exploring data.
Data Analyst
Data Analyst
The Data Analyst uses data to identify insights and trends. This foundational course can help build a foundation in the general principles of data analysis, and would be particularly relevant to this role due to the focus on querying and transforming data.
Database Administrator
Database Administrator
The Database Administrator manages and maintains databases. This course would be of high value to this role, due to the heavy emphasis on SQL, data analysis, and data preparation.
Business Analyst
Business Analyst
The Business Analyst uses data to understand business needs and processes. Particularly due to the focus on data preparation and exploration, this course can help build a foundation in data analysis that is relevant to this role.
Market Researcher
Market Researcher
The Market Researcher analyzes data to understand market trends and customer behavior. This course can help build a foundational understanding of data analysis, query, and exploration.
Data Visualization Analyst
Data Visualization Analyst
The Data Visualization Analyst creates visual representations of data that illustrate trends and insights. This course can be a valuable introduction to the basics of data analysis and storytelling.
Data Integration Specialist
Data Integration Specialist
The Data Integration Specialist integrates different data sources into a single system. This course may be useful in this role, by providing a foundation in data analysis and principles of querying.
Information Security Analyst
Information Security Analyst
The Information Security Analyst analyzes and manages risks to the security of an organization's data. While this course may not be directly relevant, an understanding of data analysis may be helpful in this role, and the focus on data preparation could provide foundational skills.
Financial Analyst
Financial Analyst
The Financial Analyst analyzes financial data to understand trends and make investment decisions. This course may provide foundational skills in data analysis and query that could be helpful for this role.
Data Engineer
Data Engineer
The Data Engineer manages and builds data pipelines and systems. This course may be useful to this role by providing grounding in data query and analysis, and some important principles of data engineering.
Actuary
Actuary
The Actuary analyzes and manages risks to financial assets. This course may be useful, as it provides a basic understanding of data analysis and querying.
Data Quality Analyst
Data Quality Analyst
The Data Quality Analyst ensures that data is accurate, consistent, and reliable. This course may be useful, as understanding the principles of data preparation and cleaning will be essential.
Biostatistician
Biostatistician
The Biostatistician uses statistics to analyze biological data. This course may be useful by providing a basic foundation in data analysis and the use of SQL.
Software Engineer
Software Engineer
The Software Engineer designs, develops, and maintains software systems. This course may provide a basic foundation in data analysis and preparation, which could be relevant to this role.
For more career information including salaries, visit:
OpenCourser.com/course/fm6vvt/exploring
Reading list
We've selected seven 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
Exploring and Preparing Your Data with BigQuery - Português.
Este livro serve como um guia prático para a linguagem SQL (Structured Query Language), usada para consultar e manipular dados em bancos de dados relacionais, como o BigQuery.
Esta obra fornece uma introdução abrangente à linguagem de programação Python para análise de dados, incluindo o uso de bibliotecas como Pandas, NumPy e Matplotlib.
Provides a practical introduction to data science for business professionals. It covers topics such as data mining, data analysis, and data visualization.
Save
Este livro oferece uma introdução prática à visualização de dados, cobrindo princípios de design, melhores práticas e ferramentas como o Tableau e o Power BI.
Provides a practical introduction to data analytics. It covers topics such as data collection, data cleaning, data analysis, and data visualization.
Save
Provides a comprehensive overview of data science with R. It covers topics such as data exploration, data analysis, and data visualization.
Save
Provides a comprehensive overview of data analytics with MongoDB. It covers topics such as MongoDB architecture, MongoDB data types, and MongoDB aggregation framework.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/fm6vvt/exploring
Share
Similar courses
Here are nine courses similar to
Exploring and Preparing Your Data with BigQuery - Português.
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
Achieving Advanced Insights with BigQuery - Português
OpenCourser.com/course/ejlmw4/achieving
Achieving Advanced Insights with BigQuery - Português
Most relevant
Understanding Your Google Cloud Costs em Português
OpenCourser.com/course/f7pcda/understanding
Understanding Your Google Cloud Costs em Português
Most relevant
Smart Analytics, Machine Learning, and AI on GCP em Português Brasileiro
OpenCourser.com/course/o7i0fx/smart
Smart Analytics, Machine Learning, and AI on GCP em...
Most relevant
Creating BigQuery Datasets, Visualizing Insights - Português
OpenCourser.com/course/fvltzl/creating
Creating BigQuery Datasets, Visualizing Insights -...
Most relevant
Getting Started with Application Development - Português
OpenCourser.com/course/fh18xi/getting
Getting Started with Application Development - Português
Most relevant
Fazer perguntas para tomar decisões com base em dados
OpenCourser.com/course/okb10u/fazer
Fazer perguntas para tomar decisões com base em dados
Most relevant
Gemini for Data Scientists and Analysts-Português Brasileiro
OpenCourser.com/course/ukq5id/gemini
Gemini for Data Scientists and Analysts-Português...
Most relevant
Fundamentos: dados, dados, em todos os lugares
OpenCourser.com/course/ozxyr2/fundamentos
Fundamentos: dados, dados, em todos os lugares
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
Good to know
Este curso é ideal para iniciantes que desejam aprender os fundamentos da análise de dados no Google Cloud
Aborda os desafios comuns enfrentados por analistas de dados e oferece soluções usando ferramentas de big data do Google Cloud
Explora o uso do BigQuery e do Dataprep para analisar e transformar conjuntos de dados
Oferece uma introdução ao SQL, capacitando os alunos a consultar seus dados de forma eficaz
Aborda aspectos importantes da preparação de dados, enfatizando a criação de conjuntos de dados de alta qualidade
Faz parte de uma série de cursos abrangentes sobre análise de dados com o Google Cloud
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