PinnedTom EllyattinTowards Data ScienceHow to Run Bootstrap Analysis in BigQueryMake the most out of the little data you have, by grabbing your data by the bootstraps.Feb 181Feb 181
PinnedTom EllyattinTowards Data ScienceHow to Create an RFM Model in BigQueryLearn what an RFM model is, how to create one, and how to segment on the resultsMar 5Mar 5
PinnedTom EllyattinTowards Data ScienceWays of Improving Your RFM Model in BigQueryAdvanced Strategies for Better Customer InsightsMar 26Mar 26
PinnedTom EllyattinTowards Data ScienceBigQuery Methods For Re-Creating Pandas’ Top EDA FunctionsIn this guide, we’ll explore how to re-create key Pandas functions used for EDA such as describe and corr in BigQueryFeb 51Feb 51
PinnedTom EllyattMy 2024 BigQuery Efficiency Handbook To Save Time and MoneyCompiling Top Tips and Best Practices: Demonstrating Their Effectiveness with DataJan 82Jan 82
Tom EllyattWhat is Farm_Fingerprint in BigQuery, and Why Do I Love It?Joins are one of the most resource-intensive operations in BigQuery, especially when dealing with large datasets. Over the past few months…Jul 313Jul 313
Tom EllyattA Complete Guide To Arrays in BigQuery (2024)Maximizing Efficiency with BigQuery Arrays: A Comprehensive Guide to Data Management and Query OptimizationFeb 121Feb 121
Tom EllyattA Guide to Search Indexes in BigQueryIf you’re dealing with huge amounts of data or developing search-intensive applications, understanding and implementing this technique can…Feb 3Feb 3
Tom EllyattHow (and why) To Add Clustering To Your Tables In Bigquery (2024)Welcome to part 2 of my in-depth series on maximizing efficiency in Google BigQuery.Jan 22Jan 22
Tom EllyattWhy Partitioning Tables is Essential in BigQuery (2024)Welcome to part 1 of my in-depth series on maximizing efficiency in Google BigQuery.Jan 15Jan 15