Using customer behavior to drive better product decisions Understanding which customer behaviors lead to conversion is the fastest way to know which product changes to make. As a data person, I frequently get asked for help from product
SQL SQL Hack: How to join tables when the key is buried in a blob of text The SituationText blobs are a pain, but they are commonly used with data from email platforms, Salesforce, or dynamic UTMs. In these cases, the JOIN key is probably hidden in
SQL SQL Hack: How to get first value based on time without a JOIN or a Window Function? This is my favorite trick in SQL! If you are like me and have been working with data for a while, you have googled “how to get the first value
Top 10 Signs You Have a Data Modeling Problem 1. Your warehouse is really slowSituation “I just hit Run Query. I am going to get a cup of coffee and hopefully it’s done when I get back.” — Data
