Course Outline
Introduction to BigQuery
- BigQuery architecture and features
- Cost model and pricing structure
- Overview of query execution and storage
Optimizing Queries and Reducing Costs
- Query tuning techniques
- Partitioned and clustered tables
- Monitoring and analyzing query performance
- Hands-on lab: optimizing queries for cost efficiency
Data Ingestion and Transformation
- Loading data from external sources
- Using Dataflow and Dataprep for ETL
- Materialized views and scheduled queries
- Hands-on lab: building a reporting pipeline
Introduction to BigQuery ML
- Overview of machine learning in BigQuery
- Supported model types (linear regression, logistic regression, clustering, etc.)
- SQL syntax for ML models
- Hands-on lab: creating and training a model
Building Predictive Models with BigQuery ML
- Training and evaluating models
- Using ML.EVALUATE and ML.PREDICT
- Integrating predictions into reports
- Hands-on lab: predictive analytics workflow
Best Practices for Enterprise Analytics
- Governance and access control
- Managing large datasets at scale
- Cost control strategies
- Case studies of successful implementations
Summary and Next Steps
Requirements
- Basic knowledge of SQL
- Familiarity with data management concepts
- Experience with reporting or analytics tools
Audience
- Data analysts
- BI developers
- Data engineers
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised 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 £3200 + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
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.
Mircea
Course - Google Cloud Platform Basics and Management
Responses with solutions and practical use.
