Analytic functions in Google BigQuery – Part 1: Basics
Reading Time: 3 Minutes 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. Data Warehouse in BigQuery — Tracking Changes In Dimensions
Reading Time: 5 Minutes 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. 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 […] 