4 Useful BigQuery SQL Functions You May Not Know
And how to use them- 23861Murphy ≡ DeepGuide
SQL users: Halve the length of (some of) your queries with this one trick
In this article, I’m going to introduce you to the SQL QUALIFY clause: a trick that will help you write shorter and more readable SQL queries. If you work in Data Science/Analytics or Machine Learning, this is a must-have SQL tool for four reasons:- 20555Murphy ≡ DeepGuide
Simplify Data Cleaning With BigQuery SQL User-Defined Functions
Introduction and use cases- 22015Murphy ≡ DeepGuide
How to Fix Missing Dates for Time Series Analysis
Learn how to use TVFs in BigQuery to effortlessly generate date ranges for your time series analysis.- 23988Murphy ≡ DeepGuide
A Guide to Using Window Functions
Create running totals, moving averages, and rankings with ease in BigQuery.- 20329Murphy ≡ DeepGuide
How to Avoid Five Common Mistakes in Google BigQuery / SQL
While working with BigQuery for years, I observed 5 issues that are commonly made, even by experienced Data Scientists- 20950Murphy ≡ DeepGuide
Use the Partitions, Luke! A Simple and Proven Way to Optimise Your SQL Queries
If you've ever written an SQL query that takes ages to run, this is the article for you- 24889Murphy ≡ DeepGuide
Add One Line of SQL to Optimise Your BigQuery Tables
Clustering: A simple way to group similar rows and prevent unnecessary data processing- 26630Murphy ≡ DeepGuide
Fantastic Beasts of BigQuery and When to Use Them
Unveiling the Traits of BigQuery Studio, DataFrames, Generative AI/AI Functions, and DuetAI- 21806Murphy ≡ DeepGuide
Understand Data Warehouse: Query Performance
Deciphering SQL Query Performance: A Practical Analysis in Data Warehousing and Database Management Systems- 23495Murphy ≡ DeepGuide
How to Low-Pass Filter in Google BigQuery
When working with time-series data, it can be important to apply filtering to remove noise. This story shows how to implement a low-pass...- 21081Murphy ≡ DeepGuide
BigQuery Methods For Re-Creating Pandas' Top EDA Functions
In this guide, we'll explore how to re-create key Pandas functions used for EDA such as describe and corr in BigQuery- 29871Murphy ≡ DeepGuide
How to Run Bootstrap Analysis in BigQuery
Make the most out of the little data you have, by grabbing your data by the bootstraps.- 29034Murphy ≡ DeepGuide
A Definitive Guide to Using BigQuery Efficiently
Make the most out of your BigQuery usage, burn data rather than money to create real value with some practical techniques.- 20751Murphy ≡ DeepGuide
How to Create an RFM Model in BigQuery
Learn what an RFM model is, how to create one, and how to segment on the results- 30014Murphy ≡ DeepGuide
Ways of Improving Your RFM Model in BigQuery
Advanced Strategies for Better Customer Insights- 20736Murphy ≡ DeepGuide
Data Scientists Work in the Cloud. Here's How to Practice This as a Student (Part 1: SQL)
Forget local Jupyter Notebooks and bubble-wrapped coding courses - here's where to practice with real-world cloud platforms. Part 1: SQL- 22964Murphy ≡ DeepGuide
We look at an implementation of the HyperLogLog cardinality estimati
Using clustering algorithms such as K-means is one of the most popul
Level up Your Data Game by Mastering These 4 Skills
Learn how to create an object-oriented approach to compare and evalu
When I was a beginner using Kubernetes, my main concern was getting
Tutorial and theory on how to carry out forecasts with moving averag