<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Martin Weitzmann on Medium]]></title>
        <description><![CDATA[Stories by Martin Weitzmann on Medium]]></description>
        <link>https://medium.com/@martin.weitzmann?source=rss-25d277ee60df------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*k2EEGL79HN3MiTzQABN1QA.jpeg</url>
            <title>Stories by Martin Weitzmann on Medium</title>
            <link>https://medium.com/@martin.weitzmann?source=rss-25d277ee60df------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 06:46:36 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@martin.weitzmann/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Why your Inner Joins produce unexpected duplicates]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science-collective/why-your-inner-joins-produce-unexpected-duplicates-8dfe05d0036d?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/2600/0*LDlwT8Zb8v1brsCx" width="5472"></a></p><p class="medium-feed-snippet">No duplicates should be unexpected. If this headline spoke to you, we need to urgently correct your mental model of joins&#x200A;&#x2014;&#x200A;let&#x2019;s go!</p><p class="medium-feed-link"><a href="https://medium.com/data-science-collective/why-your-inner-joins-produce-unexpected-duplicates-8dfe05d0036d?source=rss-25d277ee60df------2">Continue reading on Data Science Collective »</a></p></div>]]></description>
            <link>https://medium.com/data-science-collective/why-your-inner-joins-produce-unexpected-duplicates-8dfe05d0036d?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/8dfe05d0036d</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[bigquery]]></category>
            <category><![CDATA[sql-joins]]></category>
            <category><![CDATA[data-analytics]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Mon, 08 Sep 2025 13:19:11 GMT</pubDate>
            <atom:updated>2025-09-09T12:38:34.274Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-nc-sa/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[De-Nesting Google Analytics Data in BigQuery]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/de-nesting-google-analytics-data-in-bigquery-f01a76cd8126?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/2600/0*RA-hf3BO94MHgQDM" width="3000"></a></p><p class="medium-feed-snippet">The proper way to flat tables</p><p class="medium-feed-link"><a href="https://medium.com/data-science/de-nesting-google-analytics-data-in-bigquery-f01a76cd8126?source=rss-25d277ee60df------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/de-nesting-google-analytics-data-in-bigquery-f01a76cd8126?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/f01a76cd8126</guid>
            <category><![CDATA[ga4]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[nested-data-structures]]></category>
            <category><![CDATA[bigquery]]></category>
            <category><![CDATA[unnest]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Tue, 26 Mar 2024 06:53:15 GMT</pubDate>
            <atom:updated>2024-03-26T06:53:15.290Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-nc-sa/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[BigQuery: SQL auf Daten-Nestern]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@martin.weitzmann/bigquery-sql-auf-daten-nestern-f8554ce7f550?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/2600/0*dZExA1d9A6LeonP9" width="4928"></a></p><p class="medium-feed-snippet">Analysen in Google BigQuery k&#xF6;nnen sehr viel schneller sein als in anderen Systemen. Das liegt an den Arrays, die dort bevorzugt verwendet&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@martin.weitzmann/bigquery-sql-auf-daten-nestern-f8554ce7f550?source=rss-25d277ee60df------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@martin.weitzmann/bigquery-sql-auf-daten-nestern-f8554ce7f550?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/f8554ce7f550</guid>
            <category><![CDATA[ga4]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[bigquery]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[deutsch]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Sat, 04 Feb 2023 16:04:48 GMT</pubDate>
            <atom:updated>2023-02-04T16:04:48.439Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-sa/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[BigQuery Optimization Strategies 3: Table Flattening]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/bigquery-optimization-strategies-3-table-flattening-373d34c08cea?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/2600/0*xyUU5JpGUzCs0MZP" width="4032"></a></p><p class="medium-feed-snippet">About Exploding Tables and Imploding Arrays</p><p class="medium-feed-link"><a href="https://medium.com/data-science/bigquery-optimization-strategies-3-table-flattening-373d34c08cea?source=rss-25d277ee60df------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/bigquery-optimization-strategies-3-table-flattening-373d34c08cea?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/373d34c08cea</guid>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[optimization]]></category>
            <category><![CDATA[bigquery]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Wed, 01 Feb 2023 13:04:48 GMT</pubDate>
            <atom:updated>2023-02-01T13:04:48.487Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-nc-sa/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[BigQuery SQL Optimization 2: WITH Temp Tables to Fast Results]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/bigquery-sql-optimization-2-with-temp-tables-to-fast-results-41869b15fcff?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/2595/1*G_5KkJqpDSgURpizN3OZhw.jpeg" width="2595"></a></p><p class="medium-feed-snippet">When to use Temporary Tables instead of WITH</p><p class="medium-feed-link"><a href="https://medium.com/data-science/bigquery-sql-optimization-2-with-temp-tables-to-fast-results-41869b15fcff?source=rss-25d277ee60df------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/bigquery-sql-optimization-2-with-temp-tables-to-fast-results-41869b15fcff?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/41869b15fcff</guid>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[bigquery]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[optimization]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Fri, 14 Oct 2022 06:33:48 GMT</pubDate>
            <atom:updated>2022-10-14T06:33:48.997Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-nc-sa/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[BigQuery SQL Optimization 1: Filter as Early as Possible]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/bigquery-sql-optimization-1-filter-as-early-as-possible-60dfd65593ff?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/874/1*0YJaiBfNNaWDRNPGlacccA.png" width="874"></a></p><p class="medium-feed-snippet">Let&#x2019;s talk about low performing SQL and how to use and optimize filters with WHERE, HAVING, and QUALIFY in flat and nested data&#xA0;&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/data-science/bigquery-sql-optimization-1-filter-as-early-as-possible-60dfd65593ff?source=rss-25d277ee60df------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/bigquery-sql-optimization-1-filter-as-early-as-possible-60dfd65593ff?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/60dfd65593ff</guid>
            <category><![CDATA[filtering]]></category>
            <category><![CDATA[bigquery]]></category>
            <category><![CDATA[optimization]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Wed, 07 Sep 2022 15:02:40 GMT</pubDate>
            <atom:updated>2022-09-07T15:02:40.205Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-sa/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[Explain SQL Joins the Right Way]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/explain-sql-joins-the-right-way-f6ea784b568b?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/2600/1*Unm6qo_lCw5mtGG4yzeHvA.jpeg" width="4406"></a></p><p class="medium-feed-snippet">This article takes the perspective of someone who needs to introduce people to the concept of Joins in databases, e.g. LEFT JOIN. This can&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/data-science/explain-sql-joins-the-right-way-f6ea784b568b?source=rss-25d277ee60df------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/explain-sql-joins-the-right-way-f6ea784b568b?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/f6ea784b568b</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[education]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[mental-models]]></category>
            <category><![CDATA[sql-joins]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Wed, 17 Aug 2022 13:23:58 GMT</pubDate>
            <atom:updated>2022-08-17T23:47:52.259Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-sa/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[BigQuery: Creating Nested Data with SQL]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/bigquery-creating-nested-data-with-sql-727b761f1755?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/2600/1*_IJ5GA2TNcw_GOyC4AfObA.jpeg" width="4608"></a></p><p class="medium-feed-snippet">Working with SQL on nested data in BigQuery can be very performant. But what if your data comes in flat tables like CSV&#x2019;s?</p><p class="medium-feed-link"><a href="https://medium.com/data-science/bigquery-creating-nested-data-with-sql-727b761f1755?source=rss-25d277ee60df------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/bigquery-creating-nested-data-with-sql-727b761f1755?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/727b761f1755</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[big-data-analytics]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[nested-data]]></category>
            <category><![CDATA[bigquery]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Mon, 22 Jun 2020 18:44:56 GMT</pubDate>
            <atom:updated>2020-06-22T18:44:56.586Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-nc/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[Google Analytics in BigQuery 1: Getting Started]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/google-analytics-in-bigquery-1-getting-started-ef0991484787?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/630/1*reF3O9OxBN3KKCpN_7Rkwg.png" width="630"></a></p><p class="medium-feed-snippet">Here, I will show you on open data how to get started with Google Analytics tables in BigQuery. I&#x2019;ll cover what the structure looks like&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/data-science/google-analytics-in-bigquery-1-getting-started-ef0991484787?source=rss-25d277ee60df------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/google-analytics-in-bigquery-1-getting-started-ef0991484787?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/ef0991484787</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[standard-sql]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[big-data-analytics]]></category>
            <category><![CDATA[bigquery]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Tue, 28 Apr 2020 13:47:28 GMT</pubDate>
            <atom:updated>2022-09-01T00:04:18.831Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-nc/4.0/</cc:license>
        </item>
        <item>
            <title><![CDATA[BigQuery: SQL on Nested Data]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/data-science/https-medium-com-martin-weitzmann-bigquery-sql-on-nested-data-cf9589c105f4?source=rss-25d277ee60df------2"><img src="https://cdn-images-1.medium.com/max/1464/1*rA1Clq8hynyzBVMYS7S98A.png" width="1464"></a></p><p class="medium-feed-snippet">BigQuery can be very powerful because nested data means working on pre-joined tables. But analysts struggle to use its full potential&#xA0;&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/data-science/https-medium-com-martin-weitzmann-bigquery-sql-on-nested-data-cf9589c105f4?source=rss-25d277ee60df------2">Continue reading on TDS Archive »</a></p></div>]]></description>
            <link>https://medium.com/data-science/https-medium-com-martin-weitzmann-bigquery-sql-on-nested-data-cf9589c105f4?source=rss-25d277ee60df------2</link>
            <guid isPermaLink="false">https://medium.com/p/cf9589c105f4</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[big-data-analytics]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[bigquery]]></category>
            <dc:creator><![CDATA[Martin Weitzmann]]></dc:creator>
            <pubDate>Wed, 24 Jul 2019 12:26:58 GMT</pubDate>
            <atom:updated>2023-02-23T16:09:29.718Z</atom:updated>
            <cc:license>https://creativecommons.org/licenses/by-nc-sa/4.0/</cc:license>
        </item>
    </channel>
</rss>