Elsamadisi: Any business data structure simplifies to customer, activity, and time
Ahmed Elsamadisi · How to Answer Data Questions Without Being Miserable // Ahmed Elsamadisi, Narrator (Data Driven NYC) · Nov 13, 2019 · at 5:39
Ahmed Elsamadisi, Founder and CEO of Narrator.ai, presents a simplified approach to data modeling that replaces thousands of database tables with an activity stream model.
0:00 / 0:06exact quote · 6.8s
▶ Watch the full episode on YouTube → 720p mp4 · rendered on demand · StarZero watermark
“Your business can be broken into three simple things. Customer doing some activity in time.”
quote is from the automated transcript, cleaned for reading: filler sounds and stutters are removed, nothing is rephrased. names can be misheard (the analysis reads context, assessments check outside sources). how →
More from Ahmed Elsamadisi
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.”
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.”
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.”
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…”