Romain GrangerinTowards Data ScienceIdentifying New and Returning Customers in BigQuery using SQLTo better understand your customer's interests and behaviors, as well as to improve your marketing strategyJan 4, 20231Jan 4, 20231
Romain GrangerinTowards Data ScienceDifferences between Numbering Functions in BigQuery using SQLLearn how to use rank, dense rank, row number, cumulative distribution, percentiles rank, quartiles, percentiles, and moreSep 3, 2022Sep 3, 2022
Romain GrangerinTowards Data ScienceHow to calculate a percentage of total in BigQuery using SQLCompare the contribution of a row to the overall sum of all rowsAug 16, 20222Aug 16, 20222
Romain GrangerinTowards Data ScienceHow to use variables in BigQuery using SQL — Part 1A step towards flexibility and reusability using parameters and variablesJul 20, 2022Jul 20, 2022
Romain GrangerinTowards Data ScienceHow to Split and Sample a Dataset in BigQuery Using SQLEasily segment your data into training, validation, and test setsJun 28, 20221Jun 28, 20221
Romain GrangerinTowards Data ScienceMedian, Mode, and Average Order Value in BigQuery using SQLLearn about your customers’ ordering habits and choose the best strategy for increasing the value of your ordersJun 23, 20222Jun 23, 20222
Romain GrangerinTowards Data ScienceMeasuring string similarity in BigQuery using SQLUse Levenshtein distance to discover similar or duplicated values, clean your data, and moreJun 13, 2022Jun 13, 2022
Romain GrangerinTowards Data ScienceHow to Use Partitions and Clusters in BigQuery Using SQLOptimize your costs and speed up your queriesJun 1, 20223Jun 1, 20223
Romain GrangerinTowards Data ScienceTop 12 advice on BigQuery and SQL for beginnersStart your data warehouse project with BigQuery the right wayMay 25, 2022May 25, 2022
Romain GrangerinTowards Data ScienceHow to Compute a Moving Average in BigQuery Using SQLSmooth out variations, spot trends, and visualize them in Data StudioFeb 10, 20223Feb 10, 20223