Introducing the activity schema data modeling with a single table

Ahmed will present a new data modeling approach called the activity schema. It can answer any data question using a single time series table (only 11 columns and no JSON). Instead of facts and dimensions, data is modeled as a customer doing an activity over time. This approach works for any business data used for BI.

Ahmed's talk will cover: - the activity schema's structure - how it works in practice - how it can be built and queried - how it makes analytics engineering and data analysis vastly more efficient - how it makes your warehouse cheaper and way faster - how it really can answer any possible data question.

00:00 Introduction
03:38 Reality is not so simple
08:11 Separate models and querying
09:10 Activity schema - a single table for all your data
17:50 What we learnt
20:45 Q&A