A Zoho Analytics database could contain a collection of tables. Two tables could be related to each other using lookup columns, thus enabling you to model a relational Workspace (Refer Relating tables using Lookup columns). You can create any type of reports over these tables which contain the actual data.
Type of a column defines the nature of values a column can contain and the operations that can be done over the same. e.g., an Age column could be "Positive Number" type.This column can contain only positive numbers and you could apply arithmetic operations over the same. Click to read more about the data types supported by Zoho Analytics.
A database would typically contain one or more tables containing logically related datasets. e.g., a Sales database could contain Products, Sales, Purchase etc., tables. Users are recommended to have logically related datasets stored within the same database, with each distinct dataset stored as a separate table. As mentioned earlier we can also define relationship between two tables using Lookup columns.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.
Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.
Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.
Make the most of Zoho CRM with these useful tips.