Data Modeling
Narrator provides the best of Activity Schema and Star Schema.
Start with Activities
Everything is built upon activities. These activities are building blocks written in simple SQL to answer questions
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 using Customer and Time
All activities have customer and time as features thus making it really easy to combine data.
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.
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.
Add dimensions to your activities from anywhere in your warehouse
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.
Build on top of your work
All your work can be joined into an activity schema to drive more value.
Seamless joining
Dimensions are joined when you use a column.
Integrity
We don't simply point at your dimensions, we treat them like activities, which means we test them periodically for duplications, nulls, and more.