Zoho Analytics is a powerful data modelling and reporting tool that allows users to create or import databases consisting of multiple tables with relationships defined between them, just like a relational database. In a relational database, related columns from multiple tables are joined using a foreign key. In Zoho Analytics, this is done using the Lookup column feature, which uses cardinality functions to join columns from different tables. To ensure data integrity is maintained when data rows are deleted from related tables, Zoho Analytics supports the Cascade-on-Delete feature.
When creating reports, Zoho Analytics provides users with an Auto-Join feature that automatically joins connected tables using the lookup column. Additionally, Zoho Analytics offers a lightweight, standalone utility called Zoho Databridge to provide a seamless import experience. Once two tables are linked using lookup columns, Zoho Analytics allows users to create reports combining columns from these tables without any additional effort. On top of the lookup table created by joining the necessary tables, Zoho Analytics allows users to create any type of reports for analysis and visualisation.