PinnedPublished inGeek 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
Published inGeek CultureAm I Addicted? Visualizing My Internet Browsing HabitsIn 3 months, I averaged 0.8 hours per day, totaling 73 hours or about 3 full days on Instagram.6h ago6h ago
Time-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
Upgrade 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
Analyzing Chrome Browsing HistoryEver wondered just how much time you spend online — or what you actually do with all that time?Sep 2Sep 2
Published inJustDataPleaseBuilding 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
Published inJustDataPleaseJustSQL 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
Published inGeek CultureRFM Customer Segmentation Analysis In Action!Learn the principles of RFM analysis and explore a real-world application in Looker Studio.Jan 22Jan 22
Published inJustDataPleaseBuilding 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
Published inGeek 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