Tables in your database often have relationships between each other, and being able to represent these relationships in your data model allows your Embeddable dashboards to answer more complex questions using data from multiple tables.

Imagine a simple database schema like so:

It has 3 tables:

• products
• orders
• customers

And they have relationships between them:

• A customer can have many orders
• Each product can appear in many orders
• An order is by one customer for a single product (i.e. in this simple schema, if they want to order multiple products they need to place multiple orders)

From this simple schema you can imagine wanting to answer questions like:

• “How many orders did customer X purchase last year?”
• “Which product was most popular in France ****(i.e. country) this week?”
• “Which customer spent the most money (i.e. total price_usd) with us?”