Add Relationships
A grasp of these concepts will help you understand this documentation better:
In Create and explore a Dataset, we have used a single model to answer a simple question. What if we want to know, say, the total revenue of movies released by companies in the year 2017?
The name of production companies are not in the movies_metadata model, but the movies_production_companies model. We will need to add a relationship to link these two together. The video below demonstrates the steps to add a new relationship to your dataset, assuming that the movies_production_companies model has is already in your dataset:
Congratulations 🥳! You are off to a good start. However,this is just a glimpse of what Holistics can do. In the next section we will explore more functionalities that enable you to answer complex analytics questions.
💡 If you want to practice this section more, try setting up other models' relationships based on this diagram: https://dbdiagram.io/embed/6077d1d3b6aeb3052d90320c