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!
Screenshot with Comments:
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