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 ...

Learning SQL

Hubspot Lead Analytics in SQL, Beyond CRM Reporting

By Lori Brok   |   December 10, 2019

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 ...

Learning SQL

Comparing Metrics Over Time in SQL

By Lori Brok   |   November 13, 2019

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. ...

Learning SQL

Exploring Tables And Columns In Redshift: A PG_TABLE_DEF Tutorial

By Lori Brok   |   November 6, 2019

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, ...

Learning SQL

Postgres CASE Statement Basics by Example

By Lori Brok   |   October 22, 2019

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 ...

Learning SQL

A Beginner’s Guide to Formatting Dates in SQL

By Lori Brok   |   October 15, 2019