All Blogs
WINDOW FUNCTIONS : The Analyst’s Secret Weapon
WHY ANALYSTS NEED WINDOW FUNCTIONS? Before we deep dive into what a window function is, the syntax and how to write it, let us understand why we even need a window function. When you work for a company, as an analyst, you’re constantly asked things like: “How does this row compare to others?” “What has changed since last week?” “What’s the running total?” “Who’s top-N within each group?” “What’s this user’s previous / next event?” A classic SQL ( GROUP BY ) can’t answer thos
LLM - Large Language Models
Large Language Models (LLMs) are a type of machine learning model designed to understand and generate human language using deep neural networks. At their core, language models work by learning patterns in text and calculating the probability of the next word based on the words that come before it. For example, given the input sentence “The sky is …” , the model predicts the most likely next word—such as “blue” —based on what it has learned from vast amounts of text data. By r





