Skip to main content

Insights

Measured Opinions

The latest news, provocative views and some handy how-tos from the world of data, analytics, cloud and AI.

Browse the archive

234 results · Page 8 of 13

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-

Customer segmentation: how to get to know your customers better

In marketing, it’s vital to know your customers and how they interact with your brand. You need to know what they buy, when they buy, how often, how much... But why? Because if you know their habits and behaviours, you can tailor your marketing tactics and even personalise your customers’ journey. In doing so, you can maintain and even raise engagement between your customers and your brand. So how do we do this? Before thinking about any targeting strategies, you need to get to know your cus

Oli Paterson-

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-

How recognising images works - when you're an algorithm

There are many different types of image recognition. The main aim of such practises is to correctly match a new picture to an existing group of pictures. In some instances it is not dissimilar to how a clustering algorithm works, in that common features are identified and grouped together (Moosmann et al., 2008). Although several methods of image recognition exist, this blog post will give an overview of the method of facial image recognition that has been patented by Tsai (2004). This inventio

Katy Beckett-

30 sleeps ’til Christmas: our reflections on 2020

Reflecting on a challenging year What a year. I don't think I'm alone in wishing this particular year away and wanting to start Christmas ASAFP! 2020 has certainly thrown up a few challenges that we could never have predicted this time last year. The global pandemic has affected our lives collectively and individually on so many levels. Adapting to remote work For us at Measurelab we have all been working remotely now for just over 8 months. We were thrown into a situation that on one hand w

Mark Rochefort-

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-