Metadata
- Author: Timo Dechau
- Full Title:: Eventify Everything - Data Modeling for Event Data
- Category:: 🗞️Articles
- Document Tags:: Data Modeling,
- URL:: https://substack.timodechau.com/p/eventify-everything-data-modeling?utm_campaign=post&utm_medium=web
- Finished date:: 2024-02-10
Highlights
You need behavioral data to analyze data for improving user flows and progress, (View Highlight)
But how do I model these? Put them in 40 different fact tables with 40 dimensional tables. No, that does not scale. (View Highlight)
By ensuring that naming conventions are used, bad data is filtered out, and too granular events are merged or held back, you can design the later data user experience before the data goes into analytics tools like Mixpanel or Amplitude. (View Highlight)
I like to use the ActivitySchema model for this since (View Highlight)
My major use case is to analyze the event data in event analytics tools like Mixpanel or Amplitude or in nerdy tools like Motif Analytics. (View Highlight)