Introducing the activity schema: data modeling with a single table

on Oct 21, 2024
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.
Published on: Oct 29, 2021
Rewrite the future of data work, only at Coalesce
Coalesce is where data teams come together. Join us October 13-16, 2025 and be a part of the change in how we do data.
Set your organization up for success. Read the business case guide to accelerate time to value with dbt.
VS Code Extension
The free dbt VS Code extension is the best way to develop locally in dbt.