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

Read more

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

Enroll now

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

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

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

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

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

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 - Français.
Exploring and Preparing Your Data with BigQuery - Español
Most relevant
Achieving Advanced Insights with BigQuery - Français
Most relevant
Creating BigQuery Datasets, Visualizing Insights -...
Most relevant
Gemini for Data Scientists and Analysts - Français
Most relevant
Building Resilient Streaming Analytics Systems on GCP en...
Most relevant
Google Cloud Customer Care Fundamentals - Français
Most relevant
Google Cloud Customer Care Fundamentals - Español
Most relevant
Google Cloud Customer Care Fundamentals - 繁體中文
Most relevant
Leveraging Unstructured Data with Cloud Dataproc on...
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