Blog Introducing the activity schema: data modeling with a single table

Introducing the activity schema: data modeling with a single table

Oct 29, 2021

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.

Last modified on: Oct 21, 2024

Early Bird pricing is live for Coalesce 2025

Save $1,100 when you register early for the ultimate data event of the year. Coalesce 2025 brings together thousands of data practitioners to connect, learn, and grow—don’t miss your chance to join them.

Save $1,100 — Register Now

Set your organization up for success. Read the business case guide to accelerate time to value with dbt Cloud.

Read now

Great data professionals never work alone

Every industry leader understands one thing: you need the right network to grow. The dbt Community connects you with 100,000+ data professionals—people who share your challenges, insights, and ambitions.

If you’re looking for trusted advice, expert discussions, and real career growth, this is the place for you.

Join the dbt Community Learn more

Solve your toughest challenges

Join today and get real-world advice from experienced pros.

Expand your network

Foster connections with meetups, local groups, and like-minded peers.

Advance your career

The dbt community is full of learning opportunities and shared job postings.