Romain Granger – Medium

Romain Granger
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

8 min readJan 4, 2023

--

1

Identifying New and Returning Customers in BigQuery using SQL

--

1

Romain Granger
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

7 min readSep 3, 2022

--

Differences between Numbering Functions in BigQuery using SQL

--

Romain Granger
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

5 min readAug 16, 2022

--

2

How to calculate a percentage of total in BigQuery using SQL

--

2

Romain Granger
in
Towards Data Science

How to use variables in BigQuery using SQL — Part 1

A step towards flexibility and reusability using parameters and variables

4 min readJul 20, 2022

--

How to use variables in BigQuery using SQL — Part 1

--

Romain Granger
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

6 min readJun 28, 2022

--

1

How to Split and Sample a Dataset in BigQuery Using SQL

--

1

Romain Granger
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

8 min readJun 23, 2022

--

2

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

--

2

Romain Granger
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

5 min readJun 13, 2022

--

Measuring string similarity in BigQuery using SQL

--

Romain Granger
in
Towards Data Science

How to Use Partitions and Clusters in BigQuery Using SQL

Optimize your costs and speed up your queries

7 min readJun 1, 2022

--

3

How to Use Partitions and Clusters in BigQuery Using SQL

--

3

Romain Granger
in
Towards Data Science

Top 12 advice on BigQuery and SQL for beginners

Start your data warehouse project with BigQuery the right way

9 min readMay 25, 2022

--

Top 12 advice on BigQuery and SQL for beginners

--

Romain Granger
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

6 min readFeb 10, 2022

--

3

How to Compute a Moving Average in BigQuery Using SQL

--

3

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
Blog
Privacy
Terms
Text to speech
Teams