Does Zoho Analytics support Relational modeling?

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)