We may earn an affiliate commission when you visit our partners.
Google Cloud Training
"Ceci est le deuxième cours de la série ""Data to Insights"". Ici, nous verrons comment ingérer de nouveaux ensembles de données externes dans BigQuery et les visualiser avec Looker Studio. Nous aborderons également des concepts SQL intermédiaires, tels que les jointures et les unions de plusieurs tables, qui vous permettront d'analyser les données de différentes sources.
Remarque : Même si vous avez des connaissances en SQL, certaines spécificités de BigQuery (comme la gestion du cache de requêtes et des caractères génériques de table) peuvent ne pas vous être familières.
Read more
"Ceci est le deuxième cours de la série ""Data to Insights"". Ici, nous verrons comment ingérer de nouveaux ensembles de données externes dans BigQuery et les visualiser avec Looker Studio. Nous aborderons également des concepts SQL intermédiaires, tels que les jointures et les unions de plusieurs tables, qui vous permettront d'analyser les données de différentes sources.
Remarque : Même si vous avez des connaissances en SQL, certaines spécificités de BigQuery (comme la gestion du cache de requêtes et des caractères génériques de table) peuvent ne pas vous être familières.
Read more
"Ceci est le deuxième cours de la série ""Data to Insights"". Ici, nous verrons comment ingérer de nouveaux ensembles de données externes dans BigQuery et les visualiser avec Looker Studio. Nous aborderons également des concepts SQL intermédiaires, tels que les jointures et les unions de plusieurs tables, qui vous permettront d'analyser les données de différentes sources.
Remarque : Même si vous avez des connaissances en SQL, certaines spécificités de BigQuery (comme la gestion du cache de requêtes et des caractères génériques de table) peuvent ne pas vous être familières.
Une fois que vous aurez terminé ce cours, inscrivez-vous au cours ""Achieving Advanced Insights with BigQuery""."
Register for this course and see more details by visiting:
OpenCourser.com/course/2u9lyf/creating
What's inside
Syllabus
Présentation du cours
Présentation des points abordés dans ce cours
Stocker et exporter des données
Créer des tables permanentes et temporaires à partir des résultats de vos requêtes
Read more
Syllabus
Présentation du cours
Présentation des points abordés dans ce cours
Stocker et exporter des données
Créer des tables permanentes et temporaires à partir des résultats de vos requêtes
Read more
Ingérer de nouveaux ensembles de données dans BigQuery
Charger et créer des ensembles de données dans BigQuery
Associer et fusionner des ensembles de données
Comprendre les différences entre les jointures et les unions SQL, et savoir quand les utiliser
Visualisation des données
Créer des tableaux de bord et des visualisations avec Looker Studio
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
Développe des compétences SQL intermédiaires, notamment les jointures et les unions, essentielles pour l'analyse de données multisources
Renforce les connaissances en SQL pour l'analyse approfondie des données dans BigQuery
Enseigné par des experts de Google Cloud Training, reconnus pour leur expertise en matière de données
Fournit des exemples pratiques par le biais de la visualisation de données avec Looker Studio
Approfondit les notions de stockage et d'exportation de données, ainsi que la création de tables permanentes et temporaires
Nécessite une compréhension préalable de SQL pour suivre efficacement le cours
Save this course
Save Creating BigQuery Datasets, Visualizing Insights - 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 Creating BigQuery Datasets, Visualizing Insights - Français with these
activities:
Review SQL Functions
Show steps
Review the functions covered in this course to strengthen your grasp of SQL.
Show steps
-
Go through your notes on SQL functions.
-
Read through any references or supplemental materials on SQL functions.
Compile a Glossary of SQL and BigQuery Terms
Show steps
Improve your retention by creating a comprehensive glossary of key terms.
Show steps
-
Review course materials and identify important SQL and BigQuery terms.
-
Create a document or spreadsheet to organize and define these terms.
Practice Intermediate SQL Queries
Show steps
Reinforce your understanding of intermediate SQL queries by practicing on a dataset.
Show steps
-
Find an online SQL practice platform or dataset.
-
Complete a set of intermediate-level SQL queries on the platform or dataset.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Explore BigQuery's Join and Union Features
Show steps
Enhance your understanding of BigQuery's join and union features through guided tutorials.
Show steps
-
Identify documentation or tutorials on BigQuery's join and union features.
-
Follow the tutorials to implement and test these features using sample datasets.
Join a Study Group for BigQuery and SQL
Show steps
Engage in peer discussions to clarify concepts and reinforce your understanding.
Show steps
-
Find or create a study group with peers who are also taking the course.
-
Meet regularly to discuss course topics, ask questions, and work on assignments together.
Attend a BigQuery or SQL Workshop
Show steps
Gain hands-on experience and learn from industry experts.
Show steps
-
Search for upcoming workshops or conferences related to BigQuery or SQL.
-
Register for and participate in a workshop to enhance your practical skills.
Build a Dashboard in Looker Studio
Show steps
Solidify your knowledge of Looker Studio by creating a dashboard based on a dataset.
Show steps
-
Choose a relevant dataset and import it into Looker Studio.
-
Design and build a dashboard that visualizes key insights from the dataset.
Contribute to the BigQuery Community
Show steps
Deepen your knowledge and connect with the broader BigQuery community.
Show steps
-
Explore open-source projects related to BigQuery.
-
Identify an area where you can contribute, such as documentation, bug fixes, or feature enhancements.
Review SQL Functions
Show steps
Review the functions covered in this course to strengthen your grasp of SQL.
Show steps
Show steps
Show steps
- Go through your notes on SQL functions.
- Read through any references or supplemental materials on SQL functions.
Compile a Glossary of SQL and BigQuery Terms
Show steps
Improve your retention by creating a comprehensive glossary of key terms.
Show steps
Show steps
Show steps
- Review course materials and identify important SQL and BigQuery terms.
- Create a document or spreadsheet to organize and define these terms.
Practice Intermediate SQL Queries
Show steps
Reinforce your understanding of intermediate SQL queries by practicing on a dataset.
Show steps
Show steps
Show steps
- Find an online SQL practice platform or dataset.
- Complete a set of intermediate-level SQL queries on the platform or dataset.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Explore BigQuery's Join and Union Features
Show steps
Enhance your understanding of BigQuery's join and union features through guided tutorials.
Show steps
Show steps
Show steps
- Identify documentation or tutorials on BigQuery's join and union features.
- Follow the tutorials to implement and test these features using sample datasets.
Join a Study Group for BigQuery and SQL
Show steps
Engage in peer discussions to clarify concepts and reinforce your understanding.
Show steps
Show steps
Show steps
- Find or create a study group with peers who are also taking the course.
- Meet regularly to discuss course topics, ask questions, and work on assignments together.
Attend a BigQuery or SQL Workshop
Show steps
Gain hands-on experience and learn from industry experts.
Show steps
Show steps
Show steps
- Search for upcoming workshops or conferences related to BigQuery or SQL.
- Register for and participate in a workshop to enhance your practical skills.
Build a Dashboard in Looker Studio
Show steps
Solidify your knowledge of Looker Studio by creating a dashboard based on a dataset.
Show steps
Show steps
Show steps
- Choose a relevant dataset and import it into Looker Studio.
- Design and build a dashboard that visualizes key insights from the dataset.
Contribute to the BigQuery Community
Show steps
Deepen your knowledge and connect with the broader BigQuery community.
Show steps
Show steps
Show steps
- Explore open-source projects related to BigQuery.
- Identify an area where you can contribute, such as documentation, bug fixes, or feature enhancements.
Career center
Learners who complete Creating BigQuery Datasets, Visualizing Insights - Français will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
A Data Analyst collects and interprets data to help organizations make informed decisions. This course can help you develop the skills needed to become a Data Analyst, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Business Analyst
Business Analyst
A Business Analyst helps organizations improve their performance by identifying and solving business problems. This course can help you develop the skills needed to become a Business Analyst, including data analysis, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Data Scientist
Data Scientist
A Data Scientist uses data to solve business problems and make predictions. This course can help you develop the skills needed to become a Data Scientist, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Machine Learning Engineer
Machine Learning Engineer
A Machine Learning Engineer builds and deploys machine learning models. This course can help you develop the skills needed to become a Machine Learning Engineer, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Data Engineer
Data Engineer
A Data Engineer designs and builds data pipelines. This course can help you develop the skills needed to become a Data Engineer, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software systems. This course can help you develop the skills needed to become a Software Engineer, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Database Administrator
Database Administrator
A Database Administrator manages and maintains databases. This course can help you develop the skills needed to become a Database Administrator, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Data Architect
Data Architect
A Data Architect designs and builds data architectures. This course can help you develop the skills needed to become a Data Architect, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Project Manager
Project Manager
A Project Manager plans and executes projects. This course may be useful in developing the skills needed to become a Project Manager, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Product Manager
Product Manager
A Product Manager develops and manages products. This course may be useful in developing the skills needed to become a Product Manager, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Marketing Manager
Marketing Manager
A Marketing Manager develops and executes marketing campaigns. This course may be useful in developing the skills needed to become a Marketing Manager, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Sales Manager
Sales Manager
A Sales Manager develops and executes sales strategies. This course may be useful in developing the skills needed to become a Sales Manager, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Customer Success Manager
Customer Success Manager
A Customer Success Manager develops and executes customer success strategies. This course may be useful in developing the skills needed to become a Customer Success Manager, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Technical Writer
Technical Writer
A Technical Writer creates and maintains technical documentation. This course may be useful in developing the skills needed to become a Technical Writer, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
Data Journalist
Data Journalist
A Data Journalist uses data to tell stories. This course may be useful in developing the skills needed to become a Data Journalist, including data ingestion, data visualization, and SQL. The course will also help you understand how to use BigQuery, a powerful cloud-based data warehouse.
For more career information including salaries, visit:
OpenCourser.com/course/2u9lyf/creating
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
Creating BigQuery Datasets, Visualizing Insights - Français.
Save
Ce livre fournit une introduction complète à SQL, en mettant l'accent sur son utilisation pour la science des données. Il est particulièrement utile pour les utilisateurs qui souhaitent apprendre les concepts de base de SQL et comment les appliquer à l'analyse et à la visualisation des données.
Save
Ce livre fournit une introduction pratique à la visualisation des données. Il est particulièrement utile pour les utilisateurs qui souhaitent apprendre les principes de base de la visualisation des données et comment les appliquer pour communiquer efficacement des informations.
Save
Ce livre fournit une introduction complète au data mining. Il est particulièrement utile pour les utilisateurs qui souhaitent apprendre les concepts de base du data mining et comment les appliquer pour extraire des informations utiles à partir de données.
Ce livre fournit un guide pratique de SQL. Il est particulièrement utile pour les utilisateurs qui souhaitent apprendre les concepts de base de SQL et comment les appliquer pour gérer et interroger des bases de données.
Ce livre fournit une introduction complète au nettoyage et à la manipulation des données avec Python. Il est particulièrement utile pour les utilisateurs qui souhaitent apprendre les concepts de base du nettoyage des données et comment les appliquer à l'aide de Python.
Ce livre fournit un guide complet de Hadoop. Il est particulièrement utile pour les utilisateurs qui souhaitent approfondir leurs connaissances de Hadoop et explorer ses fonctionnalités avancées pour l'analyse des données volumineuses.
Ce livre fournit un guide complet de Spark. Il est particulièrement utile pour les utilisateurs qui souhaitent approfondir leurs connaissances de Spark et explorer ses fonctionnalités avancées pour l'analyse des données volumineuses.
Ce livre fournit une introduction complète à l'apprentissage profond avec Python. Il est particulièrement utile pour les utilisateurs qui souhaitent apprendre les concepts de base de l'apprentissage profond et comment les appliquer à l'aide de Python.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/2u9lyf/creating
Share
Similar courses
Here are nine courses similar to
Creating BigQuery Datasets, Visualizing Insights - Français.
Achieving Advanced Insights with BigQuery - Français
OpenCourser.com/course/6pammp/achieving
Achieving Advanced Insights with BigQuery - Français
Most relevant
Gestion de l’analyse des données
OpenCourser.com/course/pj3ezi/gestion
Gestion de l’analyse des données
Most relevant
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
Exploring and Preparing Your Data with BigQuery - Français
OpenCourser.com/course/0tl3jy/exploring
Exploring and Preparing Your Data with BigQuery - Français
Most relevant
Launching into Machine Learning en Français
OpenCourser.com/course/y2nzg6/launching
Launching into Machine Learning en Français
Most relevant
Cours intensif sur la science des données
OpenCourser.com/course/h2mix4/cours
Cours intensif sur la science des données
Most relevant
Machine Learning in the Enterprise - Français
OpenCourser.com/course/64vw83/machine
Machine Learning in the Enterprise - Français
Most relevant
Préparer les données pour l'exploration
OpenCourser.com/course/re3euq/preparer
Préparer les données pour l'exploration
Most relevant
Fondamentaux de la science des données
OpenCourser.com/course/d79qbg/fondamentaux
Fondamentaux de la science des données
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
Good to know
Développe des compétences SQL intermédiaires, notamment les jointures et les unions, essentielles pour l'analyse de données multisources
Renforce les connaissances en SQL pour l'analyse approfondie des données dans BigQuery
Enseigné par des experts de Google Cloud Training, reconnus pour leur expertise en matière de données
Fournit des exemples pratiques par le biais de la visualisation de données avec Looker Studio
Approfondit les notions de stockage et d'exportation de données, ainsi que la création de tables permanentes et temporaires
Nécessite une compréhension préalable de SQL pour suivre efficacement le cours
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