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

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

Posts pagination

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