What is BigQuery？
BigQuery is a fully managed enterprise data warehouse that helps you manage and analyze your data with built-in features like machine learning, geospatial analysis, and business intelligence. You can use SQL queries to answer your organization’s biggest and most of questions with zero infrastructure management. It is suitable for both real-time and batch processing.
Overall, BigQuery is a powerful tool for data analysts, data engineers, and data scientists who need to perform complex analytics and gain insights from large datasets.
What will you learn?
Welcome to “BigQuery in Action”! In this series, we’ll dive into practical demonstrations using BigQuery for data analysis, machine learning, and data engineering.
Through concise video tutorials, you’ll gain hands-on insights, empowering you to leverage BigQuery effectively. Let’s explore the impactful world of data solutions together!
Data Analysis
- Basic syntax of BigQuery
- Basic Command Line tools
- Query BigQuery data
- Query external data sources
- Analyse unstructured data
- Analyse geospatial data
- Use notebooks in BigQuery
Machine Learning
- Concepts of BigQuery ML
- Hands on project in Regression and classification
- Hands on project in Clustering
- Hands on project in Time-series forecasting
- Hands on project in NLP
Data Engineering
- Create and manage databases
- Create and manage tables and views
- migrate a data warehouse
- Load, Transform, and Export data
- Mange resources and access
- Monitor workloads
Prerequisite
- Basic understanding of SQL
- Basic understanding of machine learning
- A Google cloud platform’s account