Nov 13, 2019 · 20m · mad

How to Answer Data Questions Without Being Miserable // Ahmed Elsamadisi, Narrator (Data Driven NYC)

Ahmed Elsamadisi · 15m spoken Matt Turck · 38s spoken
0:00 / 0:00
▶ Watch on YouTube →

gold bands on the timeline = statements, start to end. Hover to read, click to jump. CC turns on captions

In this presentation at Data Driven NYC, Ahmed Elsamadisi, Founder and CEO of Narrator.ai, addresses the frustration surrounding modern data workflows and presents a simplified architecture centered around a single Activity Stream model (Customer, Activity, Time) that streamlines queries, eliminates stack complexity, and restores business impact.

How this conversation actually went

Every chapter scored 0–10 on four independent dynamics. Hover any point for the reasoning behind the score. Matt holds 4% of the talking time here. How this is scored →

Matt as informed peer 1.0 Guest teaching 0.6 Guest disagreement 2.4 Matt pushing back 0.8
05100:0010:0020:000:13–4:08 · Matt as informed peer 0/10 The Difficulty of Answering Business Data Questions In this solo presentation segment, the host does not participate. Ahmed aggressively attacks conventional data stack tools, calling BI tools the 'biggest myth' and mocking Looker debugging.4:08–6:09 · Matt as informed peer 0/10 The Failure of Dashboard-Centric Data Architectures Solo presentation continues without host participation. Ahmed dismisses traditional multi-table dashboard architectures and acknowledges that people call 'bullshit' on his single time-series table concept.6:09–10:15 · Matt as informed peer 0/10 Introducing the Activity Stream and Single Time-Series Model A purely technical walkthrough of activity streams and SQL queries in a presentation format with zero host interaction.10:15–12:34 · Matt as informed peer 0/10 Reusability, Standardization, and Rediscovering Data Joy Ahmed concludes his presentation monologue explaining how standardization restores joy to data analysis. Host remains silent during the pitch.12:34–20:58 · Matt as informed peer 5/10 Audience Q&A: BI Tools, Data Warehousing, and Narratives Matt enters to moderate Q&A, teasing Ahmed about BI tools and demonstrating domain knowledge by prompting a discussion on the evolution from ETL to ELT.0:13–4:08 · Guest teaching 0/10 The Difficulty of Answering Business Data Questions In this solo presentation segment, the host does not participate. Ahmed aggressively attacks conventional data stack tools, calling BI tools the 'biggest myth' and mocking Looker debugging.4:08–6:09 · Guest teaching 0/10 The Failure of Dashboard-Centric Data Architectures Solo presentation continues without host participation. Ahmed dismisses traditional multi-table dashboard architectures and acknowledges that people call 'bullshit' on his single time-series table concept.6:09–10:15 · Guest teaching 0/10 Introducing the Activity Stream and Single Time-Series Model A purely technical walkthrough of activity streams and SQL queries in a presentation format with zero host interaction.10:15–12:34 · Guest teaching 0/10 Reusability, Standardization, and Rediscovering Data Joy Ahmed concludes his presentation monologue explaining how standardization restores joy to data analysis. Host remains silent during the pitch.12:34–20:58 · Guest teaching 3/10 Audience Q&A: BI Tools, Data Warehousing, and Narratives Matt enters to moderate Q&A, teasing Ahmed about BI tools and demonstrating domain knowledge by prompting a discussion on the evolution from ETL to ELT.0:13–4:08 · Guest disagreement 4/10 The Difficulty of Answering Business Data Questions In this solo presentation segment, the host does not participate. Ahmed aggressively attacks conventional data stack tools, calling BI tools the 'biggest myth' and mocking Looker debugging.4:08–6:09 · Guest disagreement 3/10 The Failure of Dashboard-Centric Data Architectures Solo presentation continues without host participation. Ahmed dismisses traditional multi-table dashboard architectures and acknowledges that people call 'bullshit' on his single time-series table concept.6:09–10:15 · Guest disagreement 1/10 Introducing the Activity Stream and Single Time-Series Model A purely technical walkthrough of activity streams and SQL queries in a presentation format with zero host interaction.10:15–12:34 · Guest disagreement 1/10 Reusability, Standardization, and Rediscovering Data Joy Ahmed concludes his presentation monologue explaining how standardization restores joy to data analysis. Host remains silent during the pitch.12:34–20:58 · Guest disagreement 3/10 Audience Q&A: BI Tools, Data Warehousing, and Narratives Matt enters to moderate Q&A, teasing Ahmed about BI tools and demonstrating domain knowledge by prompting a discussion on the evolution from ETL to ELT.0:13–4:08 · Matt pushing back 0/10 The Difficulty of Answering Business Data Questions In this solo presentation segment, the host does not participate. Ahmed aggressively attacks conventional data stack tools, calling BI tools the 'biggest myth' and mocking Looker debugging.4:08–6:09 · Matt pushing back 0/10 The Failure of Dashboard-Centric Data Architectures Solo presentation continues without host participation. Ahmed dismisses traditional multi-table dashboard architectures and acknowledges that people call 'bullshit' on his single time-series table concept.6:09–10:15 · Matt pushing back 0/10 Introducing the Activity Stream and Single Time-Series Model A purely technical walkthrough of activity streams and SQL queries in a presentation format with zero host interaction.10:15–12:34 · Matt pushing back 0/10 Reusability, Standardization, and Rediscovering Data Joy Ahmed concludes his presentation monologue explaining how standardization restores joy to data analysis. Host remains silent during the pitch.12:34–20:58 · Matt pushing back 4/10 Audience Q&A: BI Tools, Data Warehousing, and Narratives Matt enters to moderate Q&A, teasing Ahmed about BI tools and demonstrating domain knowledge by prompting a discussion on the evolution from ETL to ELT.

speaking balance: gold is Matt, purple is the guest (3 minute bins)

0:00 · Matt 0% · guest 100%0:00 · Matt 0% · guest 100%3:00 · Matt 0% · guest 100%3:00 · Matt 0% · guest 100%6:00 · Matt 0% · guest 100%6:00 · Matt 0% · guest 100%9:00 · Matt 0% · guest 100%9:00 · Matt 0% · guest 100%12:00 · Matt 14.5% · guest 85.5%12:00 · Matt 14.5% · guest 85.5%15:00 · Matt 11.4% · guest 88.6%15:00 · Matt 11.4% · guest 88.6%18:00 · Matt 2.7% · guest 97.3%18:00 · Matt 2.7% · guest 97.3%
Sharpest disagreement ▶ 3:30 Looker and BI Tool Rant

Ahmed forcefully rejects the utility of BI tools, calling them the biggest myth in data and claiming Looker intentionally makes debugging impossible.

Hardest push from Matt ▶ 13:24 Playful Sarcastic Challenge on BI Tools

Matt playfully challenges Ahmed's intense anti-BI rant with deadpan sarcasm, asking him to clarify whether he actually likes BI tools or not.

Biggest teaching moment ▶ 14:43 Reframing Transformation in the Modern Data Stack

Ahmed educates the audience and host on how activity streams redefine transformation from a heavy, predictive ETL phase into a lightweight, on-demand query assembly model.

Matt holds his own ▶ 14:22 Framing the Evolution of ETL

Matt displays clear technical fluency in data engineering by asking Ahmed to contextualize his approach within the historical shift from ETL to ELT.

the scores for every segment, with the reasoning behind each
ChapterTopicMatt as informed peerGuest teachingGuest disagreementMatt pushing backWhy
The Difficulty of Answering Business Data Questions 0040 In this solo presentation segment, the host does not participate. Ahmed aggressively attacks conventional data stack tools, calling BI tools the 'biggest myth' and mocking Looker debugging.
The Failure of Dashboard-Centric Data Architectures 0030 Solo presentation continues without host participation. Ahmed dismisses traditional multi-table dashboard architectures and acknowledges that people call 'bullshit' on his single time-series table concept.
Introducing the Activity Stream and Single Time-Series Model 0010 A purely technical walkthrough of activity streams and SQL queries in a presentation format with zero host interaction.
Reusability, Standardization, and Rediscovering Data Joy 0010 Ahmed concludes his presentation monologue explaining how standardization restores joy to data analysis. Host remains silent during the pitch.
Audience Q&A: BI Tools, Data Warehousing, and Narratives 5334 Matt enters to moderate Q&A, teasing Ahmed about BI tools and demonstrating domain knowledge by prompting a discussion on the evolution from ETL to ELT.

Statements from this episode (17)

Insight
Elsamadisi: Answering data questions provides a company's biggest competitive advantage
“The thing about data questions is that no matter how painful they are, it is a company's competitive advantage, and that's what makes the biggest impact on whether a company can succeed and outdo its competition.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 0:31
Insight
Elsamadisi: Cross-system data queries take weeks due to unlinked identifiers
“There's no foreign key that ties these two systems together. There's no way to deal with different user identifiers. You would have to just go to your engineering team, And ask them to copy that data in all these different places, and then you deal with other …”
Ahmed Elsamadisi Nov 13, 2019 ▶ 1:23
Insight
Elsamadisi: Data tools tend to add more complexity than they solve
“Tools tend to add a lot more complexity than they actually end up solving.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 2:16
Insight
Elsamadisi: Buying Looker requires hiring five to six BI engineers
“All it ends up doing is you end up having to hire a team of five or six BI engineers to write LookML and maintain these systems for you.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 3:43
Disclosure
Elsamadisi: WeWork's 45-person data team spent over $1M with little impact
“We actually spent over a million dollars, a lot of time and resources. We had a 45 person data team, and then very little impact.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 4:12
Insight
Elsamadisi: Traditional data software builds dashboards, not answers
“Well, it turns out that all these tools and all these systems are designed to help you build dashboards, not really answer questions.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 4:40
Disclosure
Elsamadisi: WeWork maintained 3,000 dashboards without resolving its data issues
“We had 3000 dashboards, and it was not helping.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 5:13
Assertion Not checkable as stated
Elsamadisi: WeWork's data team managed 3,000 tables and 700 transformations
“We had 3000 tables, 700 transformation tables”
Ahmed Elsamadisi Nov 13, 2019 ▶ 5:30
Insight
Elsamadisi: Any business data structure simplifies to customer, activity, and time
“Your business can be broken into three simple things. Customer doing some activity in time.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 5:39
Insight
Elsamadisi: Companies can replace hundreds of database tables with one time-series table
“So, instead of hundreds of fact and dimension tables, you can just have one time series table centered around a customer.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 6:15
What-if
Elsamadisi: A working single time-series table eliminates need for 20-30 data engineers
“If a single time series table worked, you wouldn't have 20 or 30 data engineers building tables to answer questions.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 6:47
Insight
Elsamadisi: Time and customer identity replace foreign keys when relating multi-system data
“Instead of depending on foreign keys to relate the data, you can actually just use time and customer.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 8:44
Insight
Elsamadisi: Activity stream queries reuse consistent structures to bridge disparate systems
“The really fascinating thing here is that the query is so consistent. I can literally reuse the same query and combine layers of questions, all using the same structure, all being answered by the same table, bridging these systems invisibly.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 9:58
Assertion Not checkable as stated
Elsamadisi supported 16 companies across five industries using one time-series table
“This allowed me, as a single person, to support 16 different companies using five different industries, all using the same time series table.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 10:15
Assertion Not checkable as stated
Elsamadisi: Single-table activity streams guarantee all dashboard numbers will always match
“There's only one table. Everything will always match.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 11:25
Assertion Not checkable as stated
Elsamadisi: Narrator reduced 40-hour Looker queries to just 10 minutes
“We've taken queries that were taking, like, literally 40 hours in Looker, and we've dropped them down to, like, 10 minutes. Queries that cross billions of rows end up happening in, like, seven to eight seconds on a warehouse.”
Ahmed Elsamadisi Nov 13, 2019 ▶ 17:47
Assertion Contradicted
Elsamadisi: Redshift, Snowflake, and BigQuery perform identically on long tables
“The speed improvement on Redshift and versus Snowflake versus BigQuery becomes interchangeable. Because what they handle is for those edge cases, we have like a bunch of, like Snowflake is really good at a bunch of small tables everywhere trying to load a memo…”
Ahmed Elsamadisi Nov 13, 2019 ▶ 18:26
Made with StarZero

Turn any episode into a week of clips.

This entire site, over 400 conversations transcribed, diarized, checked and made playable, runs on the StarZero media pipeline. Drop in your own episode and the podcast clipper finds the moments worth sharing, cuts them, captions them, and reframes them for every feed.