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

Tag: Javascript

Data Analysis

From email to data warehouse – Google Edition

4th July 20246th July 2024 M SmithLeave a comment

Use the Google technology stack to automatically load csv files received over email into BigQuery. In the data world, sending data over email is something that has been around for …

Read More ›
Business

Send a pdf attachment on email to Google Chat space

30th October 202330th October 2023 M SmithLeave a comment

Situation An pdf export is configured from some external system into your Gmail inbox. You take this pdf export, and forward it on to a Google Chat Space for wider …

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

Tracking first visits to a website

4th June 2018 M SmithLeave a comment

In the world of marketing and advertising there is always the need to understand what kind of effect the activity is having. After all you only do marketing because you …

Read More ›

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.