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
    • Nutrition Course
    • Strength and fitness masterclass
    • Workout Stats
    • Physical Activity Stats
    • Crossfit Workouts
    • 6 week pre season soccer fitness plan
  • About

Author: M Smith

Data Analysis

(Approximate) Median in BigQuery

1st July 20236th August 2023 M SmithLeave a comment

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 …

Read More ›
Personal Development

Physical Health Tracker – June 2023

1st July 20231st July 2023 M SmithLeave a comment

A summary of workouts done in June 2023

Read More ›
Personal Development

Physical Health Tracker – December 2022

20th January 202318th January 2023 M SmithLeave a comment
Read More ›
Uncategorised

Load json data into SQLite using sqlite-utils

19th January 202318th January 2023 M SmithLeave a comment
Read More ›
Uncategorised

BigQuery table column names

18th January 202318th January 2023 M SmithLeave a comment
Read More ›
Business

Google Apps Script to create a Google Doc for every meeting

21st January 202121st January 2021 M SmithLeave a comment

After listening to Matt Mullenweg (co-founder of WordPress) on the Knowledge Project podcast over the Christmas break I was inspired to try something he mentioned. Matt said that at his …

Read More ›
Business

Top 10 podcasts of 2020 – according to podcastnotes

5th January 20215th January 2021 M SmithLeave a comment

A collection of outstanding podcast episodes released over 2020 from podcastnotes.org. 10 James Nestor: The lost art of breath 9 Bitcoin has entered phase 5 https://www.whatbitcoindid.com/podcast/bitcoin-has-entered-phase-5 When Plan released his …

Read More ›
Data Analysis

Introduction to Google Colab

12th December 202012th December 2020 M SmithLeave a comment

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 …

Read More ›
Personal Development

October 2020 position

31st October 202031st October 2020 M SmithLeave a comment

Sneaking this position in before the end of the month. Although if I had done this at the start of the month I would already be up ~30%. Position: Bitcoin …

Read More ›
Personal Development

Wanna Bet

1st October 20201st October 2020 M SmithLeave a comment

Inspired by the books “Thinking in Bets” by Annie Duke , and “Skin in the game” by Nassim Nicholas Taleb each month I will place a $50 bet (or a …

Read More ›

Posts pagination

1 … 5 6 7 8 9 10 11 … 13

Recent Posts

  • Physical Health Tracker – March 2025
  • The missing README – recommended reading
  • Simple made Easy
  • Data analysts as Cartographers
  • Architecture Decision Record Template

Categories

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

Archives

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