COVID-19 (novel coronavirus) data visualisation

Following my recent posts on data visualisation and Google Data Studio, I thought I’d share another demo of the potential to visualise data beyond marketing analytics.

Once again, using the fantastic data.world open source platform, I’ve created a project for the COVID-19 crisis, which imports data from an external source. I can then link to this in Google Data Studio, along with a simple SQL query to extract the data I’m interested in.

linkedin

New charity case study: Scottish Book Trust

Charities are undergoing digital and data transformations with increasing pace.

My new case study, courtesy of Scottish Book Trust, explores some of the data analytics work we did following the launch of their new website. We worked with Google Analytics, Google Tag Manager, Firebase, BigQuery, and Google Data Studio to structure and improve their insight.

Our work together encapsulates web and mobile app analytics, as well as looking at the wider measurement and optimisation strategy for Scottish Book Trust as an organisation.

Find the analytics case study here!

linkedin

Visualising open source data with Google Data Studio & data.world

Google Data Studio is becoming the go-to reporting tool for data analysts in many sectors. In this article I take a look beyond the typical marketing data connectors like Google Analytics and delve into open source data from a wealth of freely-available sources, courtesy of data.world.

No need for complex engineering or data pipelines – with just a little bit of SQL and using Data Studio’s native connector, a whole new world of data can be delivered right to your dashboards!

linkedin

Data visualisation with Google Data Studio

Data visualisation is all the rage. Some day in the near future, we will be done with spending endless amounts of time producing static reports in Excel, PowerPoint, and Word, instead working with eye-candy dynamic reports such as those provided by Google Data Studio, Microsoft Power BI, Tableau, and many others. These platforms allow diverse data sources to be linked in near real-time to a single report or dashboard, from where users can interact with the data.

linkedin

A simple guide to ecommerce tracking in Google Analytics

Demand for ecommerce reports in Google Analytics seems to be on the rise. Having recently consulted on a full Google Analytics Enhanced Ecommerce implementation, I thought I would share some straightforward, limited-jargon insights into how to best set up Google Analytics ecommerce tracking.

linkedin