Panagiotis Tzamtzis - Digital analytics consultant & Web developer

Building Intelligent Search with BigQuery Machine Learning: A Step-by-Step Guide (Part 1 – K-Means clustering)

Learn how to build an intelligent search system by combining BigQuery ML's K-means clustering with Large Language Models. This comprehensive guide walks through the complete process—from setting up external connections to generating embeddings and creating meaningful cluster labels. While the solution offers good scalability and configurability, we'll explore both its technical implementation and practical limitations. Ideal for data engineers and analysts looking to implement automated search query categorization in BigQuery, with a focus on achievable, production-ready results.

Do AI detectors work?

AI detectors are worthless, according to Christopher Penn, co-founder and Chief Data Scientist at TrustInsights.ai. He tried several AI detectors (like ) using the US Declaration of Independence (written 246 years before ChatGPT launched) an most of them identified it as a AI generated text. Below are a few tips from the Neuron newsletter if you want to sound more human in your writing (whether you’re using AI or not)?  The goal is not to trick AI detectors—it’s to communicate effectively and authentically and make your writing more enjoyable for the reader. Sign up to receive updates about new posts!

2024 Q4 Most Exciting LLM-powered Projects

Following up on the list of 2023’s, Q1 2024’s, Q2 2024’s, Q3 2024’s most exciting projects, here is the list of the most useful, innovative and exciting LLM-powered projects I found in 2024 Q4. Crawl4AI: Open-source LLM Friendly Web Crawler & Scrapper 🕷️ Crawl4AI (11K stars) is a powerful, open-source Python asynchronous web crawling and data extraction library designed for large language models (LLMs) and AI applications. It offers blazing-fast performance, outperforming many paid services, while providing LLM-friendly output formats like JSON, cleaned HTML, and markdown. Key features include: Crawl4AI excels in complex scenarios like session management and dynamic content...

Meet the Greek Tech Gods: sGTM Pantheon Brings Divine Power to Your Data Game

Ever dreamed of having godlike powers over your data? Meet sGTM Pantheon, Google's latest open-source project that's about to revolutionize your server-side Google Tag Manager experience. With ten powerful tools named after Greek deities, sGTM Pantheon offers divine solutions for real-time data access, advanced analytics, and seamless API integration. From Deipneus cooking up first-party cookies to Phoebe's predictive prowess, this toolkit is set to take your data management to Olympian heights. Ready to unleash the power of the tech gods on your data? Dive into our full article to discover how sGTM Pantheon can transform your digital marketing strategies and elevate your data game to legendary status.

Midjourney’s progress throughout the years

Looking at these pictures, it’s pretty wild to see how far Midjourney has come in just a couple years. The early stuff from 2022 looks kinda wonky and artificial. But by the time you get to those 2023 and 2024 versions, it’s like night and day. The faces start looking way more natural, and you can really see the little details in the hair and skin that make it feel real. That last shot from July 2024 is honestly pretty mind-blowing – I had to do a double-take to make sure it wasn’t just a regular photo. It’s crazy to...

Mastering Massive Files: Tips, Tricks, and Tools for Data Engineers

In the ever-expanding world of big data, huge files have become commonplace in data engineering projects. These behemoths can bring even powerful systems to their knees, turning simple tasks like viewing or editing into Herculean challenges. But fear not! Whether you're grappling with gigantic log files, colossal datasets, or mammoth database dumps, this article is your roadmap to efficiently managing and processing huge files. We'll explore a toolkit of ingenious solutions, from specialized file viewers that won't freeze your PC, to command-line wizardry for peeking into files without overloading your memory. You'll discover the art of batch processing, allowing you to tackle massive files in manageable chunks. We'll also delve into compression techniques and streaming processes that'll transform the way you handle big data. By the end of this guide, you'll be equipped with the knowledge to view, edit, and process files that don't fit in your PC's memory with confidence and ease. Get ready to tame those data giants and take your data engineering skills to the next level!

Unleashing Creativity and Productivity: The Best Free AI Tools You Need to Know in 2024

Unlock the power of AI without breaking the bank. From intelligent chatbots and creative writing assistants to cutting-edge image generators and coding companions, this curated list of free AI tools offers something for everyone. Whether you're a professional looking to streamline your workflow or an enthusiast eager to explore AI's potential, discover how these accessible solutions can transform your projects and spark your imagination. Dive into our comprehensive guide and start leveraging the best free AI tools available today.