Today, we are launching a new addition to the Zoho Suite – Zoho Database & Reports – An Online Database & Reporting Application. [UPDATE Nov 2018: This is now known as Zoho Analytics]
Zoho Analytics comes with a simple spreadsheet-like user interface. You can create online databases and analyze your data using different views and charting tools. You can start by creating a database from an existing XLS/CSV/TSV files or by creating a blank database. Once you have the data in the database, you can create different views and do visual analysis on the data in your database.
Zoho Analytics lets you create multiple types of views – Tabular View, Chart View, Pivot View, Summary View etc from the ‘New’ button.
One of the core functionalities of Zoho Analytics is Data Visualization. The ‘Chart View’ option enables you to visualize your data in simple charts. This complex functionality is simplified with a very simple Drag-n-Drop interface. You have to play with it to really know the power of this feature.
This drag-n-drop interface is also extended to creating ‘Pivot Tables’ in Zoho Analytics.
One of the unique features of Zoho Analytics is the ability to run SQL Queries of ANY dialect on the data. It understands SQL Queries/dialects from any of the supported databases which include Oracle, SQL Server, DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL. So you can run the SQL queries you already know on Zoho Analytics data to create custom tables or reports.
Of course, once you have all the tables, views, charts etc created, you can share them with appropriate permissions or make them public (check out existing public databases). You can also embed these views and charts on your website or blogs. Here is a sample chart from one of our public databases that has info on the population.
You can start playing with the application with your existing Zoho ID. But wait, before you hop on, we recommend viewing the video below for a quick intro on the capabilities of the application.
Now that the application is out, this will open up new possibilities for integration across other Zoho apps. Stay tuned on that front. Meanwhile, do play with this new BI and Analytics app and let us know your feedback.