Spreadsheet-like Interface
New users will feel comfortable working with Zoho Analytics as the interface closely resembles a spreadsheet. You can use the "spreadsheet-like" interface for easy data collection (add/edit), analysis and reporting.
Data Integration and Blending
Zoho Analytics helps you to combine data across different datasets enabling you to do cross data analytics. Zoho Analytics supports a model called "look up" which is used to merge two different datasets using a common column. This process is known as Joining of tables. Learn More
Formula Engine
Zoho Analytics has simple to use, click & apply pre-built analytical functions. It has excel-like easy to use formula engine, with an extensive library of mathematical & statistical functions to extract the required business metrics from your data.
Click on Add->Custom Formula in the table view, to create your own formula column based on your need. Know more about custom formulas
Click on Add -> Aggregate Formula in the table view, to create your own formula column based on your need. Know more about Aggregate Formulas
Query Table
In Zoho Analytics, you can query the data using SQL (Structured Query Language), to create powerful and flexible reports. You could construct SQL SELECT queries in any of the known database SQL dialects like Oracle, SQL Server, IBM DB2, MySQL, PostgreSQL, Informix and ANSI.
Click on New -> New Query Tablefor creating your SQL query.
Model Diagrams
Model diagrams give a panoramic view of your reporting database. They give a visual representation of the tables and their relationships.
Go to the Explorer tab and click on Model Diagram, to view the model diagram of your database.
Printer Friendly Reports
All the reports can be exported into a printer-friendly PDF files. You can customize the headers and footers in the PDF. You can also generate page numbers and table of contents.
Zoho Analytics also supports exporting your reports & dashboards into CSV, XLS, PDF, image and HTML file formats. Learn More
Mobile BI
Access and interact with the reports & dashboards that you create in Zoho Analytics service, on-the-move, from your iOS and Android-powered mobile devices.
