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

Finance

FTX and SBF

12th November 202312th November 2023 M SmithLeave a comment

A collection of media resources about the FTX collapse and subsequent Scam Bankrun Fraud trial. TL;DR What Bitcoin Did Coffeezilla Crypto critics corner The ‘Against the rules with Michael Lewis’ …

Read More ›
Business

Send a pdf attachment on email to Google Chat space

30th October 202330th October 2023 M SmithLeave a comment

Situation An pdf export is configured from some external system into your Gmail inbox. You take this pdf export, and forward it on to a Google Chat Space for wider …

Read More ›
Uncategorised

Export Google Sheets to pdf and send over Google chat

22nd October 202322nd October 2023 M SmithLeave a comment

Situation A beautiful report has been created in Google Sheets. The spreadsheet is exported to a pdf format and circulated with the relevant people via a Google Chat space. Complication …

Read More ›
Personal Development

Physical Health Tracker – September 2023

6th October 20235th October 2023 M SmithLeave a comment
Read More ›
Data Analysis

UNNESTing in BigQuery – a guided introduction

5th October 20235th October 2023 M SmithLeave a comment

The UNNEST function in BigQuery is used to transform arrays or repeated fields within a table into individual rows. This is particularly useful when dealing with data stored in nested …

Read More ›
Data Analysis

How to locate and count duplicates in SQL

9th September 20239th September 2023 M SmithLeave a comment
Read More ›
Data Analysis

Getting started with Streamlit

1st September 20234th July 2024 M Smith1 Comment

Video Tutorials 30 days of Streamlit Build a different Streamlit app each day for 30 days https://blog.streamlit.io/30-days-of-streamlit/ Streamlit documentation Offical Streamlit documentation. Very user friendly and accessible reference materials. https://docs.streamlit.io/library/get-started …

Read More ›
Personal Development

Physical Health Tracker – August 2023

1st September 20231st September 2023 M SmithLeave a comment
Read More ›
Data Analysis

How to host a Streamlit app on Google Cloud Run

26th August 202316th September 2023 M SmithLeave a comment

A short guide for deploying a Streamlit app to Cloud Run on Google Cloud platform. Google Cloud Run is a managed platform for hosting and running docker containers. So once …

Read More ›
Personal Development

Physical Health Tracker – July 2023

25th August 202325th August 2023 M SmithLeave a comment
Read More ›

Posts pagination

1 … 5 6 7 8 9 10 11 … 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.