Data Modeling

The Activity Schema

Flexible - You can use your data in any way you want to answer any type of question.

Consistent - By having consistent ways of relating data, you no longer have to hack at combining data with lots of sql.

Fast - Temporal joins are optimized for query speed by taking advantage of the time-series nature of Activity Schema.

Combine data from anywhere in your Activity Schema

Temporal joins are super powerful and allow you to use all your activities as you want. Any activity can be added to any other activity using customer and time.

Simple SQL Definitions

Activities are often created from a single data source, which makes them super easy to define.

Building Blocks

Once each activity is validated and pushed to production, it can be used anywhere in Narrator.

Joined via Customer & Time

All activities have customer and time as features thus making it really easy to combine data.