Narrator provides the best of Activity Schema and Star Schema.
Everything is built upon activities. These activities are building blocks written in simple SQL to answer questions
Activities are often created from a single data source, which makes them super easy to define.
Once each activity is validated and pushed to production, it can be used anywhere in Narrator.
All activities have customer and time as features thus making it really easy to combine data.
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.
You can use your data in any way you want to answer any type of question.
By having consistent ways of relating data, you no longer have to hack at combining data with lots of sql.
Temporal joins are optimized for query speed by taking advantage of the time-series nature of Activity Schema.
If the data is in your warehouse–either as raw data or already modeled–you can use it in Narrator. Add any table in your warehouse as a dimension to be used with an activity, customer, or in an aggregation.
All your work can be joined into an activity schema to drive more value.
Dimensions are joined when you use a column.
We don't simply point at your dimensions, we treat them like activities, which means we test them periodically for duplications, nulls, and more.