Announcements Marketing x Analytics Podcast Ahmed was featured on the Marketing x Analytics podcast. Hear the full thing and see some excerpts about how to properly use data for marketing.
Announcements Activity Schema at coalesce 2021 Ahmed presented the activity schema at dbt's coalesce 2021 conference, and explained why it's a better alternative to a star schema.
Trending Helpful Postgres Queries As with any performance advice, the only way to really improve things is to try things out and measure. Find long-running queries SELECT pid, now() - pg_stat_activity.query_start AS duration, usename, query, state, wait_event_type, wait_event FROM pg_stat_activity WHERE state = 'active' and (now(
Announcements Data Engineering Podcast Ahmed joined the Data Engineering podcast to talk about Narrator and the activity schema
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