Analytic functions in Google BigQuery – Part 1: Basics

Analytic functions in Google BigQuery - Part 1: BasicsReading 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

Data Warehouse in BigQuery  —  Tracking Changes In DimensionsReading Time: 4 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. 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 […]