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

Posts pagination

1 … 6 7 8 9 10 11 12 … 14

Recent Posts

  • SQLite – Getting started masterclass
  • Loading data into SQLite
  • A command line tool to get csv summaries using Sweetviz
  • Sample data from a BigQuery table
  • Create a Random Forest ML model in Bigquery and use it to make predictions

Categories

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

Archives

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