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

Category: Data Analysis

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

A Basic Data Studio dashboard with Matomo Analytics data

18th April 202018th April 2020 M SmithLeave a comment

This post walks through how to create a Data Studio dashboard like the one below using Matomo analytics data. The components used to put this together include: A Matomo installation …

Read More ›
Data Analysis

Interacting with Big Query using pandas

15th March 202015th March 2020 M Smith1 Comment

Big Query For those who are into data, Big Query is a great choice if you would like a database but database management is not your thing. Big Query acts …

Read More ›
Data Analysis

Getting started with SQL

2nd January 20202nd January 2020 M SmithLeave a comment

SQL is a programming language that is used to interact with databases. While each database flavour will have its own implementation of SQL there are foundations in the language that …

Read More ›
Data Analysis

Moneyball 2.0 Soccer edition – StarTalk Radio

5th May 20195th May 2019 M SmithLeave a comment

Notes taken from StarTalk Radio’s podcast about how data and analytics is affecting the soccer industry worldwide. Dan Altman – North Yard Analytics http://www.northyardanalytics.com/ Leading in soccer analytics field: Dan …

Read More ›

Posts pagination

1 2 3 4 5 6

Recent Posts

  • Calculate a reasonable daily usage quota for BigQuery
  • Archive (tar + gzip) a folder using bash
  • Set a daily query usage quota in BigQuery
  • Learn Hard Concepts by Colin Galen
  • Self improvement inspired by the founders – Art of Manliness

Categories

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

Archives

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