Ahmed Elsamadisi

Hey there! I’m one of the co-founders and CEO of Narrator. Before I was the first hire on WeWork’s data team, built their data engineering infra and grew the team from zero to 40 people.

📍 New York, NY

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.

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

Data Analysis

Using customer behavior to drive better product decisions

Understanding which customer behaviors lead to conversion is the fastest way to know which product changes to make. As a data person, I frequently get asked for help from product teams. Over the years, I spent quite a bit of time explaining the difference between good and bad questions. Typically

SQL

SQL Hack: How to join tables when the key is buried in a blob of text

The Situation Text blobs are a pain, but they are commonly used with data from email platforms, Salesforce, or dynamic UTMs. In these cases, the JOIN key is probably hidden in a blob of text. For example, say you want to join your users table using the user_id from

SQL

SQL Hack: How to get first value based on time without a JOIN or a Window Function?

This is my favorite trick in SQL! If you are like me and have been working with data for a while, you have googled “how to get the first value without a join or window function” multiple times in your life. We often hate having to write complex queries to

Top 10 Signs You Have a Data Modeling Problem

1. Your warehouse is really slow Situation > “I just hit Run Query. I am going to get a cup of coffee and hopefully it’s done when I get back.” — Data Analyst Problem * Every time a transformation runs in your warehouse, it drops and recreates every table, thus processing