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: 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 […]