MarquinSmith

Analytical – Honest – Passionate

  • Home
  • About
  • Mini Projects
    • Adobe call formatter
    • Bitcoin Price Dashboard
    • Tarantino Film Dashboard
    • How to reason and argue
  • Cheat Sheets
    • SQL Cheat Sheet
    • Dockerfile Cheat Sheet
  • Health, fitness and wellbeing
    • Nutrition Course
    • Strength and fitness masterclass

Author: M Smith

Data Analysis

Omnibug – Part 1

6th August 20236th August 2023 M Smith1 Comment

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 navigation

1 2 3 4 5 … 8

Recent Posts

  • How to locate and count duplicates in SQL
  • Getting started with Streamlit
  • Physical Health Tracker – August 2023
  • How to host a Streamlit app on Google Cloud Run
  • Physical Health Tracker – July 2023

Categories

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

Archives

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