Category: Data Analysis
Data analysts as Cartographers
In my downtime I often play in my mind with different ways of explaining various parts and aspects of working with data. One recurring idea is the metaphor that compares …
Digital Analytics Masterclass
For those interested in the field of Digital Analytics I have put together this project based curriculum to take someone from “digital analytics curious” to having the technical skill set …
Running SQL Queries on a schedule in BigQuery | Part 2b: Cloud Functions
In this part of the series we will walkthrough how to set up a query to run at a regular interval using Python and Cloud Functions. This is useful particularly …
Physical Health Tracker – 2024 review
Taking a look back at how my exercise and workout routines went over the year. If you are interested in how I record all of these stats then check out …
MarquinSmithDotCom – A year in review 2024
What Changed This year I made some changes to the infrastructure and analytics used on marquinsmith.com . Digital Ocean, who I use to host this WordPress website have increased there …
A personal health tracking tool
For a little while now I have been using a personal health tracking tool to monitor my progress in various areas such as strength exercises, weight management and mental hygiene …
Load a broken csv file into duckdb
Some CSV files have issues with them. Below is a code snippet to save the information in a csv file into a duckdb database, ignoring all the ‘broken’ rows.
Export BigQuery table to Google Cloud Storage
A code example for how to write BigQuery SQL to export a table to Google Cloud Storage in csv and parquet file formats. Parquet CSV