DATEDIFF is a super useful function that returns the difference between date parts (or dateparts) of two date or time expressions. For this post we will use data from: Hubspot Lead Analytics in SQL, Beyond CRM Reporting and will use…
Continue reading Creating Elapsed Time Histograms in SQL Using DATEDIFF
This blog post is the first of a two-part series. The first part will focus on Hubspot lead analytics and will equip you with the tools you need to go beyond standard Customer Relationship Management (CRM) reporting. Part 2 will…
Continue reading Hubspot Lead Analytics in SQL, Beyond CRM Reporting
Comparing metrics over time is a great way to benchmark progress and to identify issues as they come up. In order to compare metrics over time, the dates in your table(s) should be stored as dates or timestamps. To learn…
Congratulations! You’ve connected to your data warehouse (or database). You are on your way towards analytics awesomeness. But first, you need to get your bearings. Lucky for you, there are some pretty stellar data exploration features to get you started…
Continue reading Exploring Tables And Columns In Redshift: A PG_TABLE_DEF Tutorial
In this blog post, I will introduce you to the basics of using CASE statements/expressions. This post will also cover comparison operators (greater than, less than, equal to) and BETWEEN. My goal is to present the material in a way…
When I started my SQL journey not too long ago, I diligently completed interactive tutorials and to be honest, thought I had a grasp on this thing. Fast forward a couple of months, I tried to write my own queries…
Continue reading A Beginner’s Guide to Formatting Dates in SQL
