Watch my new video to get a first introduction to activity schema

Dear Data-Traveller, please note that this is a LinkedIn-Remix.

I posted this content already on LinkedIn in September 2022, but I want to make sure it doesn’t get lost in the social network abyss.

For your accessibility-experience and also for our own content backup, we repost the original text here.

Have a look, leave a like if you like it, and join the conversation in the comments if this sparks a thought!

Link to Post

Screenshot with Comments:

Screenshot of Timo Dechau's LinkedIn post with text about event tracking with the activity schema

Plain Text:

Making Events first-class citizens with Activity Schema

When you and your product and growth team want to create new funnels & cohorts every day, they are super helpful to drive your product. But doing this on top of a star schema or others takes too much time?

When your data model is built by 100+ queries running at night and eating up your cloud credits (the ones you would love to save in this downturn time)?

Maybe it’s a good time to look into alternatives to model data.

I know that all data model approaches have their place in the universe because they solve at least one use case well (let’s hope so).

I had a use case where I could not find any suitable solution when looking at the known model approaches: Model product behavior on top of event data.

That’s why I was intrigued when I came across the activity schema. It treats events as first-class citizens in immutable log-like tables and comes with the leanest modeling I have ever approached (one table for a business entity).

I am working on my second project based on that (the classic e-commerce reporting, which is usually modeled with the star back in the day).

And again, I am pretty amazed about the speed I can apply to get the first version out. And yes, we all know that sometimes initial speed comes at a price later. To find it (if it exists), I will continue using the activity schema intensively.

Watch my video to get a first introduction to activity schema: https://youtu.be/ercbV7Ry63Y

Video: