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
Data Ops Crash Course
Data Ops, AKA Dev Ops for data. Essential content for learning about improving the velocity of development and effective maintenance of data products (products produced by data teams). Christopher Bergh …