Data Modelling and Preparation
Zoho Reports provides powerful options to model and prepare your data. This enables you to structure, transform & clean your data set for effective and easy analysis & reporting.
As you know, data in Zoho Reports is stored in entities called Tables. One of the best aspects of Zoho Reports is its ability to import data from multiple sources. Zoho Reports allows you to easily structure and model your data by identifying data (column) types automatically, setting appropriate formatting, linking tables by creating logical relationships and do much more.
Once you model your data, the immediate next thing that you will look out for is preparation. Zoho Reports provides various data preparation options such as creating formulas to derive your business metrics, cleanup inappropriate or wrong data, merge data sets and many more.
In this section, we are going to learn about the various Data Modelling and Preparation options offered by Zoho Reports.