Latest Stories In: Panoply Blog: Data Management, Warehousing & Data Analysis | Learning SQL

Mastering PostgreSQL — Streamline Your Data with the CASE Statement Data management is an integral part of successful business operations. If you rely on a relational ...
Mastering PostgreSQL, SELECT CASE Statement
Optimizing your SQL code is an important part of maintaining the performance and efficiency of your data pipeline. There are essentially no hard limits on the logical ...
Learning SQL
SQL Optimization Benefits and Techniques
This article will cover how to work with time series/datetime data in Redshift.
Learning SQL
Manipulating Time Series Data with SQL in Redshift
Data is the lifeline of any modern organization. At any point, every day, you work on molding data points into information to derive profits. Therefore, having the right ...
ETL and SQL: The Dynamic Data Duo & Examples
Maybe you're a business analyst who's sick of not being able to level up your Power BI reports. Or maybe your New Year's resolution is that this is the year you'll ...
Data Analysis
How To Nail Your New Year's Resolution To Actually Learn SQL This Time
WordPress and Google Analytics are two BI tools (Business Intelligence) that go together like peas and carrots (if you're into that sort of thing). WordPress powers over ...
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
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
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.