MarquinSmith

Analytical – Honest – Passionate

  • Home
  • About
  • Mini Projects
    • Adobe call formatter
    • Bitcoin Price Dashboard
    • Tarantino Film Dashboard
    • How to reason and argue
  • Cheat Sheets
    • SQL Cheat Sheet
    • Dockerfile Cheat Sheet
  • Health, fitness and wellbeing
    • Nutrition Course
    • Strength and fitness masterclass

Category: Data Analysis

Data Analysis

How to locate and count duplicates in SQL

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

Getting started with Streamlit

1st September 20231st September 2023 M SmithLeave a comment

Video Tutorials 30 days of Streamlit Build a different Streamlit app each day for 30 days https://blog.streamlit.io/30-days-of-streamlit/ Streamlit documentation Offical Streamlit documentation. Very user friendly and accessible reference materials. https://docs.streamlit.io/library/get-started

Read More ›
Data Analysis

How to host a Streamlit app on Google Cloud Run

26th August 202316th September 2023 M SmithLeave a comment

A short guide for deploying a Streamlit app to Cloud Run on Google Cloud platform. Google Cloud Run is a managed platform for hosting and running docker containers. So once …

Read More ›
Data Analysis

Introduction to Google Sheets

19th August 202318th August 2023 M SmithLeave a comment
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

Loop through lines in a file BASH

13th August 202316th September 2023 M SmithLeave a comment
Read More ›
Data Analysis

Omnibug – Part 2 :: Analysing Adobe Analytics hits

13th August 20239th September 2023 M SmithLeave a comment

In part 1 of this Omnibug series we looked at filtering web analytics hits that are detected by Omnibug and exporting this data into a csv (or tsv) format for …

Read More ›
Data Analysis

Omnibug – Part 1

6th August 20236th August 2023 M Smith1 Comment

In the life of a digital data analyst there comes a time(or many a time) when varification of exactly what is being tracked by Google Analytics or Adobe Analytics. This …

Read More ›
Data Analysis

(Approximate) Median in BigQuery

1st July 20236th August 2023 M SmithLeave a comment

Saving the code snippet here in the hopes you don’t also spend multiple hours trying to figure this one out. Luckily my use case didn’t require an exact median so …

Read More ›
Data Analysis

Introduction to Google Colab

12th December 202012th December 2020 M SmithLeave a comment

Colab is a free Jupyter notebook environment that runs entirely in the cloud. Most importantly, it does not require a setup and the notebooks that you create can be simultaneously …

Read More ›

Posts navigation

1 2 3

Recent Posts

  • How to locate and count duplicates in SQL
  • Getting started with Streamlit
  • Physical Health Tracker – August 2023
  • How to host a Streamlit app on Google Cloud Run
  • Physical Health Tracker – July 2023

Categories

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

Archives

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