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

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

UNNESTing in BigQuery – a guided introduction

5th October 20235th October 2023 M SmithLeave a comment

The UNNEST function in BigQuery is used to transform arrays or repeated fields within a table into individual rows. This is particularly useful when dealing with data stored in nested …

Read More ›
Data Analysis

How to locate and count duplicates in SQL

9th September 20239th September 2023 M SmithLeave a comment
Read More ›

Posts pagination

1 2 3

Recent Posts

  • 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
  • Python script to send an email with Sendgrid API

Categories

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

Archives

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