An essential part of building customer-facing analytics is to expose the right data to the right users, using vocabulary that they understand. This is where data modeling comes in.

Data modeling maps your databases’ tables and columns onto vocabulary that your team and your users will understand. E.g. at Trevor.io we have a table in our database called datasource_views and another one called series, both of which mean very little to our users. Once joined together and tidied up a little, however, we can comfortably refer to the end result as saved queries which is a concept that all our users are familiar with. This is data modeling.

Getting started

Dimensions and Measures

Joins

Cube data playground

Security context

Using jinja in data models

Next up

Building components

Further reading

Using Cube with DBT