Category: Data Analysis
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 …
Moneyball 2.0 Soccer edition – StarTalk Radio
Notes taken from StarTalk Radio’s podcast about how data and analytics is affecting the soccer industry worldwide. Dan Altman – North Yard Analytics http://www.northyardanalytics.com/ Leading in soccer analytics field: Dan …
Creating an ‘Article Meta Data’ Database – Phase 2: Saving Data Locally
Previously we looked at getting some interesting pieces of information from an article. This included data such as: Article Title Article Publish date Text of the article Keywords in the …