We may earn an affiliate commission when you visit our partners.
Course image
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.

Read more

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.

Enroll now

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
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

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

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
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
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
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
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
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
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
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
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
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
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
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.

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.

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.
Provides a practical introduction to data analytics. It covers topics such as data collection, data cleaning, data analysis, and data visualization.
Provides a comprehensive overview of data science with R. It covers topics such as data exploration, data analysis, and data visualization.
Provides a comprehensive overview of data analytics with MongoDB. It covers topics such as MongoDB architecture, MongoDB data types, and MongoDB aggregation framework.

Share

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

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...
Most relevant
Achieving Advanced Insights with BigQuery - Português
Most relevant
Understanding Your Google Cloud Costs em Português
Most relevant
Smart Analytics, Machine Learning, and AI on GCP em...
Most relevant
Creating BigQuery Datasets, Visualizing Insights -...
Most relevant
Getting Started with Application Development - Português
Most relevant
Fazer perguntas para tomar decisões com base em dados
Most relevant
Gemini for Data Scientists and Analysts-Português...
Most relevant
Fundamentos: dados, dados, em todos os lugares
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