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

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

Posts pagination

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