PinnedJason TragakisinGeek CultureUnderstanding IP Addresses for Data Analysis — A practical example using BigQueryLearn the basics of IP addresses and how to analyze the geographic distribution of your users through a practical example.Jan 7, 20232Jan 7, 20232
Jason TragakisinJustDataPleaseUpgrade Airbyte from Docker Compose to abctl on UbuntuThis guide provides a step-by-step process to upgrade your Airbyte setup from Docker Compose to abctl. Additionally, you'll learn how to…4d ago4d ago
Jason TragakisinJustDataPleaseAnalyzing Chrome Browsing HistoryEver wondered just how much time you spend online — or what you actually do with all that time?Sep 2Sep 2
Jason TragakisinJustDataPleaseBuilding an Advanced Date Calendar in BigQuery: A Step-by-Step GuideWhen working with dates in BigQuery, having a date calendar table can be incredibly helpful. This article will walk you through the steps…Aug 7Aug 7
Jason TragakisinJustDataPleaseJustSQL GPT: Making BigQuery Easier for EveryoneEver wanted to perform customer segmentation analysis by simply asking a question in plain English, without compromising your data’s…Jan 312Jan 312
Jason TragakisinGeek CultureRFM Customer Segmentation Analysis In Action!Learn the principles of RFM analysis and explore a real-world application in Looker Studio.Jan 22Jan 22
Jason TragakisinJustDataPleaseBuilding an Advanced Date Calendar in PostgreSQL: A Step-by-Step GuideWhen working with dates and times in PostgreSQL, having a date calendar table can be incredibly useful. In this article, I will guide you…Jun 12, 20231Jun 12, 20231
Jason TragakisinGeek CultureExplore your Medium.com articles with Knowledge Graphs and NLPLearn how to use Medium API, Knowledge Graphs, basic NLP techniques and ChatGPT to explore your articles and analyze various Medium.com…Apr 17, 20231Apr 17, 20231
Jason TragakisinGeek Culture10 Advanced public BigQuery functions to elevate your game in NLP PreprocessingLearn how to effectively perform text preprocessing using public BigQuery UDFs.Feb 6, 2023Feb 6, 2023
Jason TragakisinGeek CultureMicroservices as Functions in BigQuery — Offline IP Address Lookup using SQL (Part 2)Learn how to retrieve geolocation information for an IP address using SQL.Dec 19, 2022Dec 19, 2022