Challenge: BigQuery SQL
Explore how to design and implement BigQuery tables to generate monthly financial reports. Learn to create source tables, insert and transform data, and answer key business questions using SQL in a data modeling context.
We'll cover the following...
We'll cover the following...
Problem statement
In this challenge, we will design a BigQuery table that generates monthly financial reports. The steps include creating source tables, inserting data, transforming data, and writing the results into the final table.
Note: We need to enable billing for the GCP project because of DML queries that we will run in this challenge. Please refer to Appendix for instructions on enabling billing in the GCP project. ...