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: sql

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

Running SQL Queries on a schedule in BigQuery | Part 1: Scheduled Queries

28th June 202428th June 2024 M SmithLeave a comment

A short walkthrough guide of setting up a scheduled query in BigQuery. The Google documentation for scheduled queries is here. Step 1: Create a query in the bigQuery interface that …

Read More ›
Data Analysis

Query Google Sheets from BigQuery

31st March 202431st March 2024 M SmithLeave a comment

Important and valuable data is often kept in Google Sheets. Learn how to make use of this data from within BigQuery in this post. Google sheets is a very useful …

Read More ›
Data Analysis

Last modified BigQuery table datetime

24th February 202414th August 2024 M SmithLeave a comment
Read More ›
Data Analysis

SQL Query for exits on Adobe Analytics click stream data

29th January 202429th January 2024 M SmithLeave a comment
Read More ›
Web Analytics

SQL Query for entries on Adobe Analytics click stream data

25th January 202425th January 2024 M SmithLeave a comment
Read More ›
Web Analytics

SQL Query for orders on Adobe Analytics click stream data

24th January 202425th January 2024 M SmithLeave a comment
Read More ›
Web Analytics

SQL Query for unique visitors on Adobe Analytics click stream data

24th January 202424th January 2024 M SmithLeave a comment
Read More ›
Web Analytics

SQL Query for visits on Adobe Analytics click stream data

24th January 202424th January 2024 M SmithLeave a comment
Read More ›
Web Analytics

SQL Query for page views on Adobe Analytics click stream data

24th January 202424th January 2024 M SmithLeave a comment
Read More ›

Posts pagination

1 2 3

Recent Posts

  • Load data into a BigQuery table from Google Cloud Storage using SQL
  • List users who have access to a dataset in BigQuery
  • Set expiration table on existing Bigquery tables
  • Physical Health Tracker – May 2025
  • Physical Health Tracker – April 2025

Categories

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

Archives

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