SQL PostgreSQL's missing DateDiff function DATEDIFF is an extremely useful function for analytical queries. Given two timestamps it'll tell you how many days, weeks, months, hours, etc they are apart. Here we show an implementation of this function for Postgres.
Data Engineering Shareable data analyses using templates We've been using shared data analyses in production for three years. Here's how you can create reusable templates for common metrics and analyses.
SQL Using PostgreSQL as a Data Warehouse With some tweaking Postgres can be a great data warehouse. Here's how to configure it.
Announcements Making Data Simple Podcast Ahmed joined the Making Data Simple podcast to talk about autonomous cars, WeWork, Narrator, and how to properly ask data questions.
Data Stories: Fun Insights 5 Startups Found in their Data 5 startups share a story of how they arrived at an interesting insight using their data.
SQL Synthetic Data: Generating realistic user timestamps in SQL How to generate timestamps in SQL that match realistic user behavior data.
Announcements Intelligent Analyses with Ahmed Elsamadisi - Software Engineering Daily Ahmed joined the Software Engineering Daily podcast to talk about Narrator, how to properly do analysis, and our unique approach to modeling data.
Data Analysis The best way to calculate Customer Lifetime Value for Ecommerce Understanding what Customer Lifetime Value is, why it's a useful metric, and how to compute it.
SQL How to generate a series of numbers in SQL for Redshift, Azure, and Snowflake Generating a sequence of integers in Redshift, Azure, and Snowflake
Data Engineering Why you should be using your data warehouse to sync your SaaS tools The most robust and simple way to sync between production systems is to use your warehouse as the single source of truth
