Announcements Announcing the Analyze Button Overview of the Analyze Button, the first self service data analysis tool. It creates a full analysis, with recommendations, in one click.
Data Analysis What (actually) is self service analytics? Why data-informed decisions are more important than broad access to data for self service analytics
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 How to generate a sequence of integers for most data warehouses, including Postgres, Redshift, BigQuery, Snowflake, and Azure SQL
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
