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.15 min read·Jan 7, 2023--2--2
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…3 min read·Jan 31, 2024--2--2
Jason TragakisinGeek CultureRFM Customer Segmentation Analysis In Action!Learn the principles of RFM analysis and explore a real-world application in Looker Studio.8 min read·Jan 22, 2024----
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…3 min read·Jun 12, 2023--1--1
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…11 min read·Apr 17, 2023--1--1
Jason TragakisinGeek Culture10 Advanced public BigQuery functions to elevate your game in NLP PreprocessingLearn how to effectively perform text preprocessing using public BigQuery UDFs.8 min read·Feb 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.8 min read·Dec 19, 2022----
Jason TragakisinGeek CultureMicroservices as Functions in BigQuery — Language Translation using SQL (Part 1)Learn how to use Translation APIs in your SQL queries.7 min read·Dec 14, 2022--1--1
Jason TragakisExtend BigQuery NLP armory with StemmersImplement English, Spanish and Greek stemmers using Javascript UDFs.9 min read·Dec 8, 2022----
Jason TragakisExpand your professional network using Google Search and PythonGather all Senior Data Engineer profiles in Greece5 min read·Nov 25, 2022----