Reading Time: 3Minutes Read Google BigQuery, Google’s data warehouse solution, has many functions and capabilities. In Part 1 of a series of posts, we look at the definition of analytic functions, how they differ from aggregate functions, and the various uses they have in everyday scenarios.
Reading Time: 4Minutes Read In this series of blog posts, I’ll describe the difficulties we encountered when we created a data warehouse on BigQuery. This first post is about tracking changes in dimensions. Definitions If you are already familiar with terms used in data warehousing, you can skip this part. Dimension: “A dimension is a structure that categorizes facts […]