Data Analytics Blog

1-advanced-bigquery-functions-to-change-your-game-in-nlp-preprocessing
10 Advanced public BigQuery functions to elevate your game in NLP Preprocessing

Learn how to effectively perform text preprocessing using public BigQuery UDFs.

2023-12-20 10 min read
medium-sky
Explore your Medium.com articles with Knowledge Graphs and NLP

Learn how to use Medium API, Knowledge Graphs, basic NLP techniques and ChatGPT to explore your articles and analyze various Medium.com Personas.

2023-12-20 13 min read
extend-bigquery-nlp-armory-with-stemmers-implement-english-spanish-and-greek-stemmers-using-js-udfs
Extend BigQuery NLP armory with Stemmers

Implement English, Spanish and Greek Stemmers using JavaScript UDFs.

Jason Tragakis 2023-12-20 11 min read
microservices-as-functions-in-bigquery-offline-ip-address-lookup-using-sql
Microservices as Functions in BigQuery — Offline IP Address Lookup using SQL (Part 2)

Learn how to retrieve geolocation information for an IP address using SQL.

2023-12-20 9 min read
understanding-ip-addresses-for-data-analysis-using-bigquery
Understanding IP addresses for Data Analysis – A practical example using BigQuery

Learn the basics of IP addresses and how to analyze the geographic distribution of your users through a practical example.

Jason Tragakis 2023-12-20 19 min read
how-to-create-custom-vpn-windows-ubuntu-18-04-20-04
DIY VPN: How to Set Up a Free VPN (IPV4 & IPV6) on Ubuntu 18.04 or 20.04 and Windows with OpenVPN

We will use OpenVPN to create a free VPN (IPV4 & IPV4) on Ubuntu Server 18.04 or 20.04 and we will access it from a Windows computer.

2023-12-20 1 min read