Romain Granger – Medium

Romain Granger

Published in
Towards Data Science

Identifying New and Returning Customers in BigQuery using SQL

To better understand your customer's interests and behaviors, as well as to improve your marketing strategy

Jan 4, 2023

Identifying New and Returning Customers in BigQuery using SQL

Jan 4, 2023

Published in
Towards Data Science

Differences between Numbering Functions in BigQuery using SQL

Learn how to use rank, dense rank, row number, cumulative distribution, percentiles rank, quartiles, percentiles, and more

Sep 3, 2022

Differences between Numbering Functions in BigQuery using SQL

Sep 3, 2022

Published in
Towards Data Science

How to calculate a percentage of total in BigQuery using SQL

Compare the contribution of a row to the overall sum of all rows

Aug 16, 2022

How to calculate a percentage of total in BigQuery using SQL

Aug 16, 2022

Published in
Towards Data Science

How to use variables in BigQuery using SQL — Part 1

A step towards flexibility and reusability using parameters and variables

Jul 20, 2022

How to use variables in BigQuery using SQL — Part 1

Jul 20, 2022

Published in
Towards Data Science

How to Split and Sample a Dataset in BigQuery Using SQL

Easily segment your data into training, validation, and test sets

Jun 28, 2022

How to Split and Sample a Dataset in BigQuery Using SQL

Jun 28, 2022

Published in
Towards Data Science

Median, Mode, and Average Order Value in BigQuery using SQL

Learn about your customers’ ordering habits and choose the best strategy for increasing the value of your orders

Jun 23, 2022

Median, Mode, and Average Order Value in BigQuery using SQL

Jun 23, 2022

Published in
Towards Data Science

Measuring string similarity in BigQuery using SQL

Use Levenshtein distance to discover similar or duplicated values, clean your data, and more

Jun 13, 2022

Measuring string similarity in BigQuery using SQL

Jun 13, 2022

Published in
Towards Data Science

How to Use Partitions and Clusters in BigQuery Using SQL

Optimize your costs and speed up your queries

Jun 1, 2022

How to Use Partitions and Clusters in BigQuery Using SQL

Jun 1, 2022

Published in
Towards Data Science

Top 12 advice on BigQuery and SQL for beginners

Start your data warehouse project with BigQuery the right way

May 25, 2022

Top 12 advice on BigQuery and SQL for beginners

May 25, 2022

Published in
Towards Data Science

How to Compute a Moving Average in BigQuery Using SQL

Smooth out variations, spot trends, and visualize them in Data Studio

Feb 10, 2022

How to Compute a Moving Average in BigQuery Using SQL

Feb 10, 2022

Romain Granger

Romain Granger

📊 Data Scientist | SQL, BigQuery, Python | Follow me to learn about SQL and data-related topics. Thank you so much for your support!

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams