Course Outline
BigQuery Fundamentals
- Architecture and key features of BigQuery
- Cost models and pricing frameworks
- Overview of query execution and storage mechanisms
Query Optimisation and Cost Reduction
- Techniques for tuning queries
- Utilising partitioned and clustered tables
- Monitoring and analysing query performance metrics
- Hands-on lab: optimising queries for cost efficiency
Data Ingestion and Transformation
- Importing data from external sources
- Leveraging Dataflow and Dataprep for ETL processes
- Implementing 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
- Utilising ML.EVALUATE and ML.PREDICT functions
- Integrating predictions into business reports
- Hands-on lab: executing a predictive analytics workflow
Enterprise Analytics Best Practices
- Governance and access control strategies
- Managing large datasets at scale
- Strategies for cost control
- Case studies highlighting successful implementations
Summary and Recommended Next Steps
Requirements
- Fundamental SQL proficiency
- Awareness of data management principles
- Prior experience with reporting or analytics platforms
Intended 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 3200 € + 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.
