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 TragakisTime-saving Google Shortcuts You Should KnowInstead of going through menus to create a new document, sheet, or presentation, you can type these URLs into your browser to open new…Oct 3Oct 3
Jason TragakisUpgrade 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…Sep 11Sep 11
Jason TragakisAnalyzing 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