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 …
Analytical – Honest – Passionate
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …