SQL window functions are incredibly powerful and allow us to see the rows in a table with a new column showing a running total, rank or moving average.
Aggregate functions bring your data to life.
They allow you to take a standard table and use a function or two to build metrics and answer questions about the data.
Welcome to another awesome list. This time, Big Data and all the tools Data Scientists and Data Engineers use to build platforms and models.
On first glance, Entity Relationship Diagrams may look like a spaghetti mess. This post hopes to demystify how they fit together with Sonic the Hedgehog
This is the story of the Seattle music scene of the 90s, Throwback Thursday, and some beautiful data visualisations.
Your database doesn’t just contain your data. It also contains data about your data.