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 ...
Postgres
Mastering PostgreSQL, SELECT CASE Statement
By Greg M. on November 29, 2023
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
By Tan Kim Tran on January 20, 2023
This article will cover how to work with time series/datetime data in Redshift.
Learning SQL
Manipulating Time Series Data with SQL in Redshift
By Manoj Mokashi on January 25, 2022
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/ELT
ETL and SQL: The Dynamic Data Duo & Examples
By Taurai Mutimutema on January 20, 2022
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
By Anders Schneiderman on January 21, 2021
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 ...
MySQL
How To Combine And Analyze WordPress And Google Analytics Data Together
By Trevor Fox on January 9, 2020
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
By Lori Brok on December 12, 2019
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 on 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 on 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 on 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 on 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 on October 15, 2019