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: Automated Reporting

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

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

Automating Google Analytics reports in Google Sheets

24th June 201724th June 2017 M SmithLeave a comment

This guide will walkthrough how to create automatically updating Google Analytics reports. This is for those who need to report on Google Analytics data regularly, and need to get access …

Read More ›

Recent Posts

  • 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
  • Load data into a BigQuery table from Google Cloud Storage using SQL

Categories

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

Archives

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