> Formations > BigQuery for Data Analysts
Course : BigQuery for Data AnalystsOfficial course, preparation for Google Cloud certifications
Practical course - 2d
- 14h00 - Ref. GQA
|
Download in PDF format
Share this course by email
 | Understand the role and value of BigQuery and its main analysis capabilities. |
| Import, explore and transform data in BigQuery using SQL. |
| Use external sources and develop transformation pipelines with Dataform. |
| Visualize data via Connected Sheets and Looker Studio. |
| Make the most of BigQuery Studio's advanced integrations and features. |
Intended audience
Data analysts wishing to master BigQuery for their data analysis needs.
Prerequisites
Completion of the course "Introduction to Data Analytics on Google Cloud" or equivalent knowledge.
Certification
This course prepares you for Google Cloud certifications.
Comment passer votre examen ?
Comment passer votre examen ?
Practical details
Teaching methods
Training in French. Official course material in digital format and in English. Good understanding of written English.
Course schedule
1 Discover BigQuery for data analysts
- Analyze data on Google Cloud.
- Learn how to transform data into useful information with BigQuery.
- Real-life use cases from companies transformed by analytics on Google Cloud.
2 Explore and prepare your data with BigQuery
- Common data mining techniques.
- Analyze large datasets with BigQuery.
- Describe the basic principles of queries.
- Analyze the use of functions.
- Enrich queries with UNION and JOIN.
Hands-on work
Exploring an e-commerce dataset with SQL in Google BigQuery. Troubleshoot common SQL errors with BigQuery. Troubleshoot and resolve data join pitfalls.
3 Clean and transform your data
- Analyze the five principles of dataset integrity.
- Clean up and transform data with SQL.
- Overview of other data cleansing and transformation options.
4 Ingestion and storage of new BigQuery datasets
- Describe permanent and temporary data tables.
- Analyze the ingestion of new data sets.
- Study external data sources.
Hands-on work
Creation of new permanent tables Ingestion and interrogation of new data sets.
5 Visualize your BigQuery insights
- Introduction to data visualization.
- The fundamentals of effective visualization.
- Exploit your data with Connected Sheets.
- Avoid common visualization errors.
- Create dynamic dashboards with Looker Studio.
- Analyze your data in a Notebook environment.
Hands-on work
Connected Sheet quick start. Explore and create reports with Looker Studio.
6 Create scalable data pipelines in BigQuery with Dataform
- Analyze the big picture.
- Discover Dataform.
- Getting started with Dataform.
Hands-on work
Create and run a SQL workflow in Dataform.
7 Discover BigQuery Studio
- Introducing BigQuery Studio.
- Use Duet AI in BigQuery to explain and generate SQL queries.
- Discover new ergonomic features and integrations with Dataform and Dataplex.
Hands-on work
Analyze data using Duet AI. Generate personalized email content with BigQuery and Gemini continuous queries.
PARTICIPANTS
Data analysts wishing to master BigQuery for their data analysis needs.
PREREQUISITES
Completion of the course "Introduction to Data Analytics on Google Cloud" or equivalent knowledge.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Data analysts wishing to master BigQuery for their data analysis needs.
PREREQUISITES
Completion of the course "Introduction to Data Analytics on Google Cloud" or equivalent knowledge.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
ASSESSMENT TERMS
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
TEACHING AIDS AND TECHNICAL RESOURCES
The teaching resources used are the publisher's official materials and practical exercises.
The teaching resources used are the publisher's official materials and practical exercises.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
Dernières places
Date garantie en présentiel ou à distance
Session garantie