Category: Data Analysis
UNNESTing in BigQuery – a guided introduction
The UNNEST function in BigQuery is used to transform arrays or repeated fields within a table into individual rows. This is particularly useful when dealing with data stored in nested …
Getting started with Streamlit
Video Tutorials 30 days of Streamlit Build a different Streamlit app each day for 30 days https://blog.streamlit.io/30-days-of-streamlit/ Streamlit documentation Offical Streamlit documentation. Very user friendly and accessible reference materials. https://docs.streamlit.io/library/get-started …
How to host a Streamlit app on Google Cloud Run
A short guide for deploying a Streamlit app to Cloud Run on Google Cloud platform. Google Cloud Run is a managed platform for hosting and running docker containers. So once …
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 …