Course Outline
Introduction to BigQuery
- BigQuery architecture and key features
- Cost model and pricing structure
- Overview of query execution and storage mechanisms
Query Optimization and Cost Reduction
- Techniques for query tuning
- Implementation of partitioned and clustered tables
- Monitoring and analysing query performance
- Hands-on lab: optimising queries for cost efficiency
Data Ingestion and Transformation
- Loading data from external sources
- Utilising Dataflow and Dataprep for ETL processes
- Employing materialized views and scheduled queries
- Hands-on lab: constructing a reporting pipeline
Introduction to BigQuery ML
- Overview of machine learning capabilities within BigQuery
- Supported model types (e.g., linear regression, logistic regression, clustering)
- SQL syntax for defining ML models
- Hands-on lab: creating and training a model
Developing Predictive Models with BigQuery ML
- Training and evaluating model performance
- Applying ML.EVALUATE and ML.PREDICT functions
- Integrating predictions into reporting systems
- Hands-on lab: executing a predictive analytics workflow
Best Practices for Enterprise Analytics
- Governance and access control strategies
- Managing large datasets at scale
- Strategies for cost control
- Case studies of successful enterprise implementations
Summary and Future Directions
Requirements
- Foundational knowledge of SQL
- Familiarity with core data management concepts
- Practical experience with reporting or analytics tools
Target Audience
- Data analysts
- BI developers
- Data engineers
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
The final day which is the Machine Learning Topic
John Erick Baltazar - Globe Telecom
Course - Google BigQuery
It was a really good training course, well prepared and explained by the trainer with great hands on experience on GCP.
