SQL Tips
How to unnest / extract nested JSON data in BigQuery
Working with nested JSON data in BigQuery analytics database might be confusing for people new to BigQuery. Yet if done well, nested …
Business Intelligence
How We Combine Data Sources at Holistics
Good data teams combine data from different sources in order to do their jobs well. Here's what we've learnt while putting this into practice at Holistics.
Business Intelligence
Why Google Analytics sucks and what you can do about it
Google Analytics is an incredible tool to have in your toolbox. But it only offers aggregated data, which limits your ability to track visitor behavior. In this post, we discuss a simple, affordable alternative to GA that we've implemented at Holistics.
Using Holistics
How Holistics Fits Into A Data Organisation
The new version of Holistics is designed from the ground up to increase the productivity of your data team. Here's how that works.