Category: Data Analysis
Automatically load CSVs received on email into Google Sheet
When working hands on with data, the data can be in many different forms and in many different locations. The most common format is arguably csv format, and the most …
Omnibug – Part 2 :: Analysing Adobe Analytics hits
In part 1 of this Omnibug series we looked at filtering web analytics hits that are detected by Omnibug and exporting this data into a csv (or tsv) format for …
Omnibug – Part 1
In the life of a digital data analyst there comes a time(or many a time) when varification of exactly what is being tracked by Google Analytics or Adobe Analytics. This …
(Approximate) Median in BigQuery
Saving the code snippet here in the hopes you don’t also spend multiple hours trying to figure this one out. Luckily my use case didn’t require an exact median so …
Introduction to Google Colab
Colab is a free Jupyter notebook environment that runs entirely in the cloud. Most importantly, it does not require a setup and the notebooks that you create can be simultaneously …
A Basic Data Studio dashboard with Matomo Analytics data
This post walks through how to create a Data Studio dashboard like the one below using Matomo analytics data. The components used to put this together include: A Matomo installation …
Interacting with Big Query using pandas
Big Query For those who are into data, Big Query is a great choice if you would like a database but database management is not your thing. Big Query acts …
Getting started with SQL
SQL is a programming language that is used to interact with databases. While each database flavour will have its own implementation of SQL there are foundations in the language that …