Getting started with Google BigQuery
BigQuery is literally the next “Big” thing (with a capital B) in analytics. We explain what it is, how some of our clients are already using it, how much it costs and where you can start.
Lace Rogers-
Insights
Google Cloud
Google Cloud Platform services, infrastructure, and data tools (100 posts)
Browse the archive
Explore a topic across our insights
100 results · Page 6 of 6
How to flatten tables with user-defined functions in BigQuery
Flattening tables in Google BigQuery can be painful when doing multiple fields with UNNEST. User-defined functions (UDFs) make life easier and this one will do it for you automatically.
Lace Rogers-
The Measure Pod: a podcast from Measurelab
We’re so obsessed with analytics that we started a podcast! Here’s how we turned our passion into The Measure Pod.
Daniel Perry-Reed-
How to share access to a single BigQuery dataset with GCP IAM
Sometimes less is more; especially when it comes to security access. This simple walkthrough will show you how to use GCP IAM to surface just the parts of your data warehouse to just the right people.
Liam Grant-
Data warehouse: Repair broken tables in BigQuery
At Measurelab, we love a bit of data warehousing using BigQuery; in fact, we are obsessed with finding the best approach to managing data warehouses in the most optimal way possible. So in this series, we want to share with you our knowledge and expertise to show what a fantastic and dynamic tool BigQuery is. As you may know, BigQuery has some super powerful features, which allow us to build, manipulate and even run machine learning algorithms within the interface. However, we’re all human, an
Lace Rogers-
Data warehousing: What is BigQuery and how do I get started?
At Measurelab we live and breathe the Google Cloud Platform, so our specialists are experts in Bigquery. We have decided in this series to share our knowledge and take you through some great techniques to maintain your BigQuery data warehouse. So firstly-what is BigQuery? BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. ...and that means? Simply put, BigQuery is a fantastic cloud-based data warehouse in which you can store huge
Lace Rogers-
Google Analytics data import: automate data import with Python & Cloud functions
Why automate data import into Google Analytics A few months back I was granted access to a Google Cloud Source Repository (private Git repositories hosted on Google Cloud part of Google’s Cloud developer tools) that contained Python code and configuration details for automating the extraction of data from a BigQuery table and uploading to Google Analytics as a custom dimension via the Management API on a desired schedule. Choosing the right approach for blog word counts Being primarily a Jav
Victor Sarker-
How to use BigQuery without GA360: insights from Measurefest 2019
Speaking at Measurefest For the first time in a few years, I took to the stage at Measurefest to talk about how to get your data from Google Analytics into BigQuery, and what you can do with it when you get there. Affordable BigQuery solutions Obviously, Analytics 360 can do this, but it costs $$$ per year. I outlined some more affordable methods, including third-party connector solutions, and provided a detailed example of how we would use our own Pipelines solution and what we could achiev
Adam Englebright-
Goodbye DoubleClick, hello Google Marketing Platform!
Last week, Google announced they were unifying their analytics and advertising platforms under a single new name: Google Marketing Platform. The Google Analytics 360 Suite and DoubleClick brands are being replaced with this single name. What does this mean for DoubleClick? If anything this is a change that has needed to happen for years. DoubleClick always sat rather clumsily alongside other tools from Google and this shift heralds the beginning of a more unified approach. Search Ads 360 wil
Mark Rochefort-
Data Studio new countries availability
<span style="font-weight: 400;">The time has come for more of you to enjoy the benefits of Data Studio reports! Today, Google has announced long-awaited expansion of its product availability to more than 180 countries. </span> More and more people will now be able to enjoy the benefits of this powerful tool - you can now create, share and edit reports, and impress your boss and clients with your skilful dashboard creation skills. But that's not all! With that great news come other useful f
Magdalena Pajak-