PinnedMartin WeitzmanninTowards Data ScienceDe-Nesting Google Analytics Data in BigQueryThe proper way to flat tablesMar 261Mar 261
PinnedMartin WeitzmanninTowards Data ScienceBigQuery: SQL on Nested DataBigQuery can be very powerful because nested data means working on pre-joined tables. But analysts struggle to use its full potential …Jul 24, 20194Jul 24, 20194
PinnedMartin WeitzmanninTowards Data ScienceBigQuery SQL Optimization 1: Filter as Early as PossibleLet’s talk about low performing SQL and how to use and optimize filters with WHERE, HAVING, and QUALIFY in flat and nested data …Sep 7, 2022Sep 7, 2022
PinnedMartin WeitzmanninTowards Data ScienceBigQuery SQL Optimization 2: WITH Temp Tables to Fast ResultsWhen to use Temporary Tables instead of WITHOct 14, 20224Oct 14, 20224
PinnedMartin WeitzmanninTowards Data ScienceBigQuery Optimization Strategies 3: Table FlatteningAbout Exploding Tables and Imploding ArraysFeb 1, 20231Feb 1, 20231
Martin WeitzmannBigQuery: SQL auf Daten-NesternAnalysen in Google BigQuery können sehr viel schneller sein als in anderen Systemen. Das liegt an den Arrays, die dort bevorzugt verwendet…Feb 4, 2023Feb 4, 2023
Martin WeitzmanninTowards Data ScienceExplain SQL Joins the Right WayThis article takes the perspective of someone who needs to introduce people to the concept of Joins in databases, e.g. LEFT JOIN. This can…Aug 17, 20222Aug 17, 20222
Martin WeitzmanninTowards Data ScienceBigQuery: Creating Nested Data with SQLWorking with SQL on nested data in BigQuery can be very performant. But what if your data comes in flat tables like CSV’s?Jun 22, 20203Jun 22, 20203
Martin WeitzmanninTowards Data ScienceGoogle Analytics in BigQuery 1: Getting StartedHere, I will show you on open data how to get started with Google Analytics tables in BigQuery. I’ll cover what the structure looks like…Apr 28, 20201Apr 28, 20201