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

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

Enroll now

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

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

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

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

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

Share

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

Similar courses

Here are nine courses similar to Creating BigQuery Datasets, Visualizing Insights - Français.
Achieving Advanced Insights with BigQuery - Français
Most relevant
Gestion de l’analyse des données
Most relevant
Exploring and Preparing Your Data with BigQuery - Español
Most relevant
Exploring and Preparing Your Data with BigQuery - Français
Most relevant
Launching into Machine Learning en Français
Most relevant
Cours intensif sur la science des données
Most relevant
Machine Learning in the Enterprise - Français
Most relevant
Préparer les données pour l'exploration
Most relevant
Fondamentaux de la science des données
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