We may earn an affiliate commission when you visit our partners.
Google Cloud Training
Ce cours décrit les problématiques courantes auxquelles se confrontent les analystes de données et explique comment les résoudre à l'aide des outils de big data disponibles sur Google Cloud. Vous découvrirez quelques notions de SQL et apprendrez comment utiliser BigQuery et Dataprep pour analyser et transformer vos ensembles de données.
Il s'agit du premier cours de la série ""From Data to Insights with Google Cloud"". Après l'avoir terminé, inscrivez-vous au cours ""Creating New BigQuery Datasets and Visualizing Insights"".
Register for this course and see more details by visiting:
OpenCourser.com/course/0tl3jy/exploring
What's inside
Syllabus
Bienvenue dans le cours "From Data to Insights with Google Cloud – Exploring and Preparing Your Data"
Découvrir les cours, les contenus et les technologies abordés dans cette série dédiée aux analystes de données
Read more
Syllabus
Bienvenue dans le cours "From Data to Insights with Google Cloud – Exploring and Preparing Your Data"
Découvrir les cours, les contenus et les technologies abordés dans cette série dédiée aux analystes de données
Read more
Présentation des données sur Google Cloud
Comprendre les principes fondamentaux de Google Cloud et comment les exploiter dans l'analyse de big data
Présentation des outils de big data
Découvrir les principaux outils de big data disponibles sur Google Cloud que vous utiliserez pour analyser, préparer et visualiser les données
Explorer vos données avec SQL
Découvrir comment interroger vos données en utilisant les rudiments du langage SQL (Structured Query Language) et s'entraîner à écrire des requêtes dans BigQuery
Tarifs de BigQuery
Se familiariser avec la tarification de BigQuery et découvrir comment optimiser au mieux vos requêtes
Nettoyer et transformer vos données
Apprendre pourquoi il est important de créer des ensembles de données de haute qualité, et découvrir les outils qui vous aideront à transformer vos données
Résumé du cours
Synthèse des points essentiels abordés durant le cours
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Adapté aux analystes de données, ce cours les aide à résoudre les problèmes grâce aux outils de Big Data de Google Cloud et des notions de SQL
Explore les bases de Google Cloud et les outils Big Data qu'il propose, offrant ainsi une compréhension approfondie
Fournit un aperçu pratique de l'utilisation de BigQuery et Dataprep pour l'analyse et la transformation de données
Intègre des éléments fondamentaux de SQL pour l'interrogation de données dans BigQuery, renforçant les compétences pratiques
Aborde le nettoyage et la transformation des données, soulignant l'importance des ensembles de données de qualité
S'inscrit dans une série de cours (« From Data to Insights with Google Cloud »), offrant une approche complète de l'analyse et de la visualisation des données avec Google Cloud
Save this course
Save Exploring and Preparing Your Data with BigQuery - Français 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 - Français with these
activities:
Review SQL Basics
Show steps
Reinforces foundational knowledge of SQL, which is essential for data analysis in this course.
Browse courses on
SQL
Show steps
-
Review online tutorials or documentation on SQL basics.
-
Practice writing simple SQL queries using an online SQL editor.
Explore Google Cloud BigQuery
Show steps
Familiarizes students with the Google Cloud platform and its big data tools, which are used throughout the course.
Browse courses on
BigQuery
Show steps
-
Complete the interactive tutorials provided by Google Cloud on BigQuery.
-
Create a BigQuery account and explore the interface.
Join a Study Group
Show steps
Facilitates peer learning and collaboration, allowing students to share knowledge and support each other.
Browse courses on
Data Analysis
Show steps
-
Find or create a study group with other students in the course.
-
Schedule regular meetings to discuss course material, work on projects, and quiz each other.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Analyze Sample Datasets with SQL
Show steps
Provides hands-on practice using SQL to analyze data, a key skill for this course.
Browse courses on
BigQuery
Show steps
-
Access sample datasets provided by Google Cloud.
-
Write SQL queries to extract and analyze data from the datasets.
-
Interpret the results and draw insights from the data.
Attend a Webinar on Big Data Analytics
Show steps
Exposes students to real-world applications of big data analytics and provides insights from industry experts.
Browse courses on
Big Data Analytics
Show steps
-
Identify and register for relevant webinars on big data analytics.
-
Participate in the webinar and take notes on key concepts and trends.
Compile Resources on Big Data Analytics
Show steps
Encourages students to organize and consolidate their learning materials, improving their retention and recall.
Browse courses on
Big Data Analytics
Show steps
-
Gather articles, tutorials, and videos on big data analytics.
-
Organize the resources into categories or themes.
-
Create a shared document or online repository to store the compilation.
Develop a Data Analysis Plan
Show steps
Challenges students to apply the concepts learned in the course to a real-world scenario, reinforcing their understanding.
Browse courses on
Data Analysis
Show steps
-
Define the business problem or question to be addressed.
-
Identify the relevant data sources and gather data.
-
Create a plan for data analysis, including data cleaning, transformation, and visualization techniques.
Review SQL Basics
Show steps
Reinforces foundational knowledge of SQL, which is essential for data analysis in this course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review online tutorials or documentation on SQL basics.
- Practice writing simple SQL queries using an online SQL editor.
Explore Google Cloud BigQuery
Show steps
Familiarizes students with the Google Cloud platform and its big data tools, which are used throughout the course.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Complete the interactive tutorials provided by Google Cloud on BigQuery.
- Create a BigQuery account and explore the interface.
Join a Study Group
Show steps
Facilitates peer learning and collaboration, allowing students to share knowledge and support each other.
Browse courses on
Data Analysis
Show steps
Show steps
Show steps
- Find or create a study group with other students in the course.
- Schedule regular meetings to discuss course material, work on projects, and quiz each other.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Analyze Sample Datasets with SQL
Show steps
Provides hands-on practice using SQL to analyze data, a key skill for this course.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Access sample datasets provided by Google Cloud.
- Write SQL queries to extract and analyze data from the datasets.
- Interpret the results and draw insights from the data.
Attend a Webinar on Big Data Analytics
Show steps
Exposes students to real-world applications of big data analytics and provides insights from industry experts.
Browse courses on
Big Data Analytics
Show steps
Show steps
Show steps
- Identify and register for relevant webinars on big data analytics.
- Participate in the webinar and take notes on key concepts and trends.
Compile Resources on Big Data Analytics
Show steps
Encourages students to organize and consolidate their learning materials, improving their retention and recall.
Browse courses on
Big Data Analytics
Show steps
Show steps
Show steps
- Gather articles, tutorials, and videos on big data analytics.
- Organize the resources into categories or themes.
- Create a shared document or online repository to store the compilation.
Develop a Data Analysis Plan
Show steps
Challenges students to apply the concepts learned in the course to a real-world scenario, reinforcing their understanding.
Browse courses on
Data Analysis
Show steps
Show steps
Show steps
- Define the business problem or question to be addressed.
- Identify the relevant data sources and gather data.
- Create a plan for data analysis, including data cleaning, transformation, and visualization techniques.
Career center
Learners who complete Exploring and Preparing Your Data with BigQuery - Français will develop knowledge and skills
that may be useful to these careers:
Data Scientist
Data Scientist
Data Scientists use data to build predictive models that can help organizations make better decisions. They need to be familiar with SQL in order to analyze data stored in SQL-based databases, and they need to be familiar with big data tools in order to analyze large datasets. This course teaches the fundamentals of SQL and how to use BigQuery, a big data tool, to analyze large datasets.
Machine Learning Engineer
Machine Learning Engineer
Machine Learning Engineers build and maintain the systems that train and deploy machine learning models. They need to be familiar with SQL in order to manage data in SQL-based databases, and they need to be familiar with big data tools in order to manage large datasets. This course teaches the fundamentals of SQL and how to use BigQuery, a big data tool, to analyze large datasets.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain the systems that store and process data. They need to be familiar with SQL in order to manage data in SQL-based databases, and they need to be familiar with big data tools in order to manage large datasets. This course teaches the fundamentals of SQL and how to use BigQuery, a big data tool, to manage large datasets.
Data Analyst
Data Analyst
Data Analysts gather and analyze data to help organizations understand their customers, operations, and industry landscapes. They need to be familiar with structured query language (SQL) in order to analyze data stored in SQL-based databases. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software systems. They need to be familiar with SQL in order to manage data in SQL-based databases. This course teaches the fundamentals of SQL and how to use BigQuery, a big data tool, to analyze large datasets.
Database Administrator
Database Administrator
Database Administrators manage and maintain databases. They need to be familiar with SQL in order to manage data in SQL-based databases. This course teaches the fundamentals of SQL and how to use BigQuery, a big data tool, to analyze large datasets.
Web Developer
Web Developer
Web Developers design and develop websites. They need to be familiar with SQL in order to manage data in SQL-based databases. This course teaches the fundamentals of SQL and how to use BigQuery, a big data tool, to analyze large datasets.
Financial Analyst
Financial Analyst
Financial Analysts use data to help organizations make investment decisions. They need to be familiar with SQL in order to analyze data about companies and markets. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
Product Manager
Product Manager
Product Managers are responsible for the development and launch of new products. They need to be familiar with SQL in order to analyze data about their products and customers. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
Operations Manager
Operations Manager
Operations Managers are responsible for the day-to-day operations of an organization. They need to be familiar with SQL in order to analyze data about their operations. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
Marketing Manager
Marketing Manager
Marketing Managers are responsible for the development and implementation of marketing campaigns. They need to be familiar with SQL in order to analyze data about their campaigns and customers. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
Data Visualization Specialist
Data Visualization Specialist
Data Visualization Specialists create visualizations that help people understand data. They need to be familiar with SQL in order to extract data from databases. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
Project Manager
Project Manager
Project Managers are responsible for the planning and execution of projects. They need to be familiar with SQL in order to analyze data about their projects. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
Sales Manager
Sales Manager
Sales Managers are responsible for the development and implementation of sales strategies. They need to be familiar with SQL in order to analyze data about their sales and customers. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
Business Analyst
Business Analyst
Business Analysts use data to help organizations understand their customers, operations, and industry landscapes. They need to be familiar with SQL in order to analyze data stored in SQL-based databases. This course teaches the fundamentals of SQL and how to use BigQuery to analyze large datasets.
For more career information including salaries, visit:
OpenCourser.com/course/0tl3jy/exploring
Reading list
We've selected eight 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 - Français.
Comprehensive reference guide to Google BigQuery. It covers all aspects of BigQuery, from its architecture and data model to its query language and data manipulation functions.
Provides a comprehensive overview of SQL, the standard language for querying and manipulating data. It covers the basics of SQL, including data types, operators, and functions, and provides hands-on exercises to help you practice what you learn.
Un ouvrage complet sur Hadoop, le framework open source qui sous-tend BigQuery.
Provides a non-technical introduction to big data analytics. It covers the basics of big data, including the different types of big data, the challenges of big data analysis, and the different techniques that can be used to analyze big data.
Save
Provides a case study-based approach to learning about data analysis with big data. It covers the different types of big data, the challenges of big data analysis, and the different techniques that can be used to analyze big data.
Un livre classique sur la modélisation dimensionnelle, utile pour ceux qui souhaitent concevoir et construire des entrepôts de données efficaces.
Save
Un manuel complet sur le data mining, utile pour ceux qui souhaitent approfondir les techniques d'analyse de données avancées.
Save
Un ouvrage de référence approfondi sur l'apprentissage profond, utile pour ceux qui souhaitent explorer des applications plus avancées de l'analyse de données.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/0tl3jy/exploring
Share
Similar courses
Here are nine courses similar to
Exploring and Preparing Your Data with BigQuery - Français.
Exploring and Preparing Your Data with BigQuery - Español
OpenCourser.com/course/6i0oxu/exploring
Exploring and Preparing Your Data with BigQuery - Español
Most relevant
Achieving Advanced Insights with BigQuery - Français
OpenCourser.com/course/6pammp/achieving
Achieving Advanced Insights with BigQuery - Français
Most relevant
Creating BigQuery Datasets, Visualizing Insights - Français
OpenCourser.com/course/2u9lyf/creating
Creating BigQuery Datasets, Visualizing Insights -...
Most relevant
Gemini for Data Scientists and Analysts - Français
OpenCourser.com/course/pzgm2f/gemini
Gemini for Data Scientists and Analysts - Français
Most relevant
Building Resilient Streaming Analytics Systems on GCP en Français
OpenCourser.com/course/slcwtv/building
Building Resilient Streaming Analytics Systems on GCP en...
Most relevant
Google Cloud Customer Care Fundamentals - Français
OpenCourser.com/course/42a9l9/google
Google Cloud Customer Care Fundamentals - Français
Most relevant
Google Cloud Customer Care Fundamentals - Español
OpenCourser.com/course/y5z3sy/google
Google Cloud Customer Care Fundamentals - Español
Most relevant
Google Cloud Customer Care Fundamentals - 繁體中文
OpenCourser.com/course/6u1tke/google
Google Cloud Customer Care Fundamentals - 繁體中文
Most relevant
Leveraging Unstructured Data with Cloud Dataproc on Google Cloud Platform en Français
OpenCourser.com/course/5vvqj6/leveraging
Leveraging Unstructured Data with Cloud Dataproc on...
Most relevant
Effort
1 week of study, 5-7 hours/week
Level
Introductory
Via
Coursera
Institution
Google Cloud
Instructor
Google Cloud Training
Language
Français
Transcript
English
Good to know
Adapté aux analystes de données, ce cours les aide à résoudre les problèmes grâce aux outils de Big Data de Google Cloud et des notions de SQL
Explore les bases de Google Cloud et les outils Big Data qu'il propose, offrant ainsi une compréhension approfondie
Fournit un aperçu pratique de l'utilisation de BigQuery et Dataprep pour l'analyse et la transformation de données
Intègre des éléments fondamentaux de SQL pour l'interrogation de données dans BigQuery, renforçant les compétences pratiques
Aborde le nettoyage et la transformation des données, soulignant l'importance des ensembles de données de qualité
S'inscrit dans une série de cours (« From Data to Insights with Google Cloud »), offrant une approche complète de l'analyse et de la visualisation des données avec 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