Does Zoho Analytics support Relational modeling?
Yes, Zoho Analytics supports relational modeling of your database. There are some limitations currently, which would be addressed incrementally to provide a powerful relational modeling capability in Zoho Analytics. The following are the important capabilities that are currently available:
- You can create tables which have lookup columns between them. This helps you to create parent-child relationships
- Zoho Analytics supports cascade-on-delete i.e. when you delete a row in the parent table, it will automatically delete the corresponding rows in the child table(s)
- You can join tables using SQL Query table feature (Video on Creating Query Tables)
- Zoho Analytics provides Auto-Join feature which automatically joins tables connected using lookup column, while creating reports.(Video on Auto-Join Tables & Creating Reports)