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

Automation

A command line tool to get csv summaries using Sweetviz

22nd June 2025 M SmithLeave a comment

Working with data involves handling a lot of data files, most commonly CSV files. It can be very helpful to do some exploratory data analysis on the CSV file to …

Read More ›
Data Analysis

Sample data from a BigQuery table

21st June 202521st June 2025 M SmithLeave a comment

In BigQuery when running a query, the costs associated with doing so include a “scan” of the data that may be processed as part of executing the query. For example, …

Read More ›
Data Analysis

Create a Random Forest ML model in Bigquery and use it to make predictions

20th June 2025 M SmithLeave a comment

A code sample to create a random forest machine learning model in BigQuery and make predictions all using SQL.

Read More ›
Data Analysis

Load data into a BigQuery table from Google Cloud Storage using SQL

19th June 202519th June 2025 M SmithLeave a comment

A short code example which loads a csv file from Google Cloud Storage into a table using SQL.

Read More ›
Automation

List users who have access to a dataset in BigQuery

18th June 202518th June 2025 M SmithLeave a comment

Use the bq command line tool to list the users who have access to a particular dataset in BigQuery

Read More ›
Automation

Set expiration table on existing Bigquery tables

11th June 202511th June 2025 M SmithLeave a comment
Read More ›
Personal Development

Physical Health Tracker – May 2025

6th June 20253rd October 2025 M SmithLeave a comment
Read More ›
Uncategorised

Physical Health Tracker – April 2025

27th May 2025 M SmithLeave a comment
Read More ›
Data Analysis

Generate date range in SQLite

18th May 202515th May 2025 M SmithLeave a comment
Read More ›
Personal Development

Physical Health Tracker – March 2025

14th April 202527th May 2025 M SmithLeave a comment
Read More ›

Posts pagination

1 2 3 4 5 6 … 16

Recent Posts

  • Physical Health Tracker – September 2025
  • Physical Health Tracker – August 2025
  • A command line tool to compare 2 different csv files
  • Pre commit hooks in git YouTube resources
  • Calculate a reasonable daily usage quota for BigQuery

Categories

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

Archives

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