De-Nesting Google Analytics Data in BigQuery

-

The right solution to flat tables

Photo of Singapore by Mike Enerio on Unsplash

BigQuery is an analytics engine optimized to crunch pre-joined (or: nested) data. Sub-relations make sense in analytical scenarios because we don’t wish to take care of joins over larger datasets — just imagine every day year-over-year comparisons over the past 3 years, aggregating Terabytes of knowledge — but with joins adding one other layer of…

ASK ANA

What are your thoughts on this topic?
Let us know in the comments below.

0 0 votes
Article Rating
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments

Share this article

Recent posts

0
Would love your thoughts, please comment.x
()
x