MarquinSmith

Analytical – Honest – Passionate

  • Home
  • Services
  • Mini Projects
    • Data Analytics Helper Tools
    • Bitcoin Price Dashboard
    • Journey to data engineering
    • Tarantino Film Dashboard
    • Woolworths stock price tracker
    • How to reason and argue
  • Reference
    • The BookShelf
    • SQL Cheat Sheet
    • Dockerfile Cheat Sheet
  • Health, fitness and wellbeing
    • Crossfit Workouts
    • Gymnastics
    • Strength and fitness masterclass
    • Nutrition Course
    • Workout Stats
    • Physical Activity Stats
    • 6 week pre season soccer fitness plan
  • About

Author: M Smith

Business

Architecture Decision Record Template

19th March 202519th March 2025 M SmithLeave a comment

Inspired by https://cognitect.com/blog/2011/11/15/documenting-architecture-decisions

Read More ›
Automation

Running Python scripts using UV

6th March 20256th March 2025 M SmithLeave a comment

In case you haven’t heard, UV is a relatively new python package and project manager. UV allows for you to define package dependencies and the Python version to run the …

Read More ›
Personal Development

Physical Health Tracker – February 2025

4th March 20254th March 2025 M SmithLeave a comment
Read More ›
Data Analysis

Digital Analytics Masterclass

3rd March 20253rd March 2025 M SmithLeave a comment

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 …

Read More ›
Automation

Running SQL Queries on a schedule in BigQuery | Part 2b: Cloud Functions

4th February 20254th February 2025 M SmithLeave a comment

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 …

Read More ›
Personal Development

Physical Health Tracker – January 2025

4th February 20254th February 2025 M SmithLeave a comment
Read More ›
Automation

A Dockerfile to create a docker image to run a python file

10th January 202510th January 2025 M SmithLeave a comment

Use this Dockerfile as a template to be able to create docker images that will execute a python script once the container is run. This can be very useful if …

Read More ›
Data Analysis

Physical Health Tracker – 2024 review

9th January 20259th January 2025 M SmithLeave a comment

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 …

Read More ›
Data Analysis

MarquinSmithDotCom – A year in review 2024

6th January 20256th January 2025 M SmithLeave a comment

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 …

Read More ›
Personal Development

Marquin Smith interview on “The Data Engineering Channel”

6th January 20256th January 2025 M SmithLeave a comment

I recently spoke to Chris Gambil on my transition from data analyst to data engineer. Check out the interview here:

Read More ›

Posts pagination

1 2 3 4 5 6 … 15

Recent Posts

  • How to revoke read access to a single table in BigQuery using SQL
  • How to grant read access to a single table in BigQuery using SQL
  • Copy a BigQuery model into another dataset using bq command line tool
  • A python command line tool to create dates in a range
  • Trigger an Airflow DAG in Google Cloud Composer using gcloud command line tool

Categories

  • Automation
  • Business
  • cybersecurity
  • Data Analysis
  • Finance
  • Personal Development
  • Python
  • Uncategorised
  • Web Analytics

Archives

Copyright © 2025 MarquinSmith.
Theme Easthill by ThemeMunk. Powered by WordPress.