Welcome to Portal
Zoho Analytics is a self-service BI and data analytics software that lets you analyze your data, create stunning data visualizations, and discover hidden insights in minutes.
This guide will help you to learn the concepts specific to Zoho Analytics.
The below image captures how the different entities are organized and how the various concepts in Zoho Analytics are connected to each other. On further reading, this document will give you a clarity on the same.
All information in Zoho Analytics are organized into logical entities called Workspace. A Workspace is a logical grouping of data sets (stored in entities called Tables and all the reports & dashboards created over this data. The Workspace also contains structural information on how the entities are related to each other. It also offers methods to create metrics on the data for further analysis.
You can have one or more
Workspace
in your account which can be owned by you or shared to you by other users.
Click here to learn more about workspace and how to manage them.
Tables contain the actual data that needs to be analyzed. A Workspace contains a collection of tables. A table is similar to a spreadsheet and consists of columns and actual data rows.
Each column has a name and a type (data type) associated with it. A
Workspace typically contains one or more tables with logically related data. For example, a Sales Workspace might contain Products, Sales, and Purchases.
If you wish to define a logical relationship between two different data, you can easily do so by creating a lookup (Refer to Click here to learn more about workspace and how to manage them. for more information). Once this is done you can create any type of report, using the columns from the tables.
Click here to learn more about working with tables.
Formulas are calculations that help you derive key business metrics that can be used in reporting and analysis. Zoho Analytics provides a powerful formula engine to create any type of calculations required to assist in creating the required reports.
Zoho Analytics supports different types of formulas:
Click here to learn about Formulas in Zoho Analytics.
Zoho Analytics offers a wide variety of reporting options such as Charts, Pivot Tables, Summary Views, and Tabular Views. This enables you to easily analyze your data and derive great insights. Creating reports is made easy using the intuitive drag and drop interface of Zoho Analytics.
A report can be created by joining one or more tables.
The following types of reports are supported in Zoho Analytics:
A Dashboard is an effective way of organizing reports into a single page for a quick insight into the Key Metrics at a glance. Zoho Analytics provides a simple and intuitive drag and drop interface for creating dashboards in minutes.
You can easily create a visually rich and interactive dashboard by adding reports, widgets, user filters, and rich-formatted text in single or double column layout.
You can have any number of reports in a dashboard.
Zoho Analytics also offers a widget-based model for creating single number charts (headline charts) within dashboards. These are called KPI Widgets. This is feature highlights any key metric in a dashboard for easy comprehension. The key metric can also be accompanied with associated comparison indicators to highlight the trend.