De-Nesting Google Analytics Data in BigQuery towardsdatascience.com Post date March 26, 2024 No Comments on De-Nesting Google Analytics Data in BigQuery External Tags bigquery, ga4, nested-data-structures, SQL, unnest
A Definitive Guide to Using BigQuery Efficiently towardsdatascience.com Post date March 5, 2024 No Comments on A Definitive Guide to Using BigQuery Efficiently External Tags bigquery, data-engineering, deep-dives, google-cloud-platform, SQL
How to Create an RFM Model in BigQuery towardsdatascience.com Post date March 5, 2024 No Comments on How to Create an RFM Model in BigQuery External Tags bigquery, customer-value, marketing, rfm, segmentation
How to Low-Pass Filter in Google BigQuery medium.com Post date January 21, 2024 No Comments on How to Low-Pass Filter in Google BigQuery External Tags bigquery, data-science, feature-engineering, machine-learning, time-series-analysis
Understand Data Warehouse: Query Performance medium.com Post date January 8, 2024 No Comments on Understand Data Warehouse: Query Performance External Tags bigquery, data-science, data-ware-housing, SQL
Fantastic Beasts of BigQuery and When to Use Them towardsdatascience.com Post date December 31, 2023 No Comments on Fantastic Beasts of BigQuery and When to Use Them External Tags bigquery, bigquery-studio, data-analysis, duet-ai, generative-ai-use-cases
Be Careful When Using “NOT IN” in SQL medium.com Post date December 15, 2023 No Comments on Be Careful When Using “NOT IN” in SQL External Tags bigquery, data-analysis, data-science, programming, SQL
Add One Line of SQL to Optimise Your BigQuery Tables medium.com Post date December 8, 2023 No Comments on Add One Line of SQL to Optimise Your BigQuery Tables External Tags bigquery, data-analysis, data-engineering, data-science, SQL
Use the Partitions, Luke! A Simple and Proven Way to Optimise Your SQL Queries medium.com Post date December 7, 2023 No Comments on Use the Partitions, Luke! A Simple and Proven Way to Optimise Your SQL Queries External Tags bigquery, data-analysis, data-science, SQL, tips-and-tricks
How SQL execution orders varies across databases towardsdatascience.com Post date December 7, 2023 No Comments on How SQL execution orders varies across databases External Tags bigquery, mssql, mysql, SQL, sql-server
SkillenaiSkillenai