Cedric Dussud - Narrator Data Blog

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