Latest Stories In: Panoply Blog - Data Management, Data Infrastructure, And Data Analysis. | Learning SQL

WordPress and Google Analytics go together like peas and carrots (if you're into that sort of thing). WordPress powers over 35% of websites today and Google Analytics is ...
Panoply

How To Combine And Analyze WordPress And Google Analytics Data Together

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: ...
Learning SQL

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

Hubspot Lead Analytics In SQL, Beyond CRM Reporting

In this post, we’ll walk through three ways to subtract dates (or timestamps) in Redshift:
Learning SQL

Tutorial: How To Subtract Dates In Redshift

 
Learning SQL

Comparing Metrics Over Time In SQL

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

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

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

Work smarter, better, and faster with monthly tips and how-tos.