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
Business

Getting started with Google Apps Scripts

6th August 20236th August 2023 M Smith3 Comments

Google Apps Script is a great way to extend the functionality and potentially automate processes while working in Google Workspace. Google Apps Script can be thought of as the Google …

Read More ›
Data Analysis

Omnibug – Part 1

6th August 20236th August 2023 M Smith2 Comments

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 …

Read More ›
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 ›

Posts pagination

1 … 5 6 7 8 9 10 11 … 14

Recent Posts

  • Physical Health Tracker – April 2025
  • Generate date range in SQLite
  • Physical Health Tracker – March 2025
  • The missing README – recommended reading
  • Simple made Easy

Categories

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

Archives

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