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

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

Introduction to Google Sheets

19th August 202318th August 2023 M SmithLeave a comment
Read More ›
Data Analysis

Automatically load CSVs received on email into Google Sheet

18th August 202318th August 2023 M SmithLeave a comment

When working hands on with data, the data can be in many different forms and in many different locations. The most common format is arguably csv format, and the most …

Read More ›
Data Analysis

Loop through lines in a file BASH

13th August 202316th September 2023 M SmithLeave a comment
Read More ›
Data Analysis

Omnibug – Part 2 :: Analysing Adobe Analytics hits

13th August 20239th September 2023 M SmithLeave a comment

In part 1 of this Omnibug series we looked at filtering web analytics hits that are detected by Omnibug and exporting this data into a csv (or tsv) format for …

Read More ›

Posts pagination

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