Zoho Analytics is an on-premise reporting and business intelligence application that helps you to easily analyze your business data and create insightful reports & dashboards for informed decision-making. It also enables you to easily create and share powerful reports in minutes with no IT help. 

Zoho Analytics offers the following important capabilities:

• Complete On-Premise Reporting & Business Intelligence application.

• Easy to adopt 'Spreadsheet-like' interface for data addition and report creation.

• Powerful drag & drop based reporting features for quick report creation.

• Visual Analysis capability for in-depth analysis and to slice & dice your data.

• Supports Charts, Pivot Tables, Summary, Tabular reports and Dashboards.

• Supports data import from variety of file formats including Excel, CSV, TSV and HTML. Also supports periodic scheduling of import.

• Supports relating data with each other through look-up columns (as you have in a relational database) to enable joining of data sets for reporting.

• SQL (Structured Query Language) driven querying for powerful report creation. Write SQL queries in any of the familiar database dialects, including SQL Server, DB2, MySQL, PostgreSQL.

• Powerful formula engine to derive any business computation to be used in reporting.

• Real-time collaboration by sharing data and reports in read or read-write modes with your colleagues. You could also notify reports via email.

• Export and Print reports in variety of formats.

• Web APIs(HTTP based) to tightly integrate and interact with your business applications.

Zoho Analytics supports a wide variety of report creation options, which includes:

• Charts: Allows you to create any type of chart/graph. Chart types include Line, Multi-Line, Smooth line, Area, Bar, Stacked bar, Stacked Area, Combination, Pie, Funnel, Web, Scatter etc., in both 2D and 3D. Also supports Tabular Data view of the graph.

• Pivot Tables: Allows you to create a powerful view with data summarized in a grid both in horizontal and vertical columns (also known as Matrix Views). 

• Tabular Views: Allows you to create simple table views with column grouping and sub-totals (aggregation). 

• Summary View: Allows you to create a view with summarized values and grouping. 

• Dashboards: Allows you to create dashboards consisting of multiple reports (along with formatted text & images) in a single page format. Dashboards provide you a quick, at-a-glance view of your key business information for easy analysis and visualization.

Yes, Zoho Analytics does support dashboard creation. Zoho Analytics provides an easy to use drag and drop interface for creating custom dashboards in minutes. Using the dashboard you can display a collection of reports in a single page, providing a quick at-a-glance view of your Key Business Information for easy analysis & visualization.

Zoho Analytics supports the following browsers:

• Google Chrome: Version 40 and above
• Firefox: Version 40 and above

5. How do I start and stop the Zoho Analytics application?

For Windows installations, you can start and stop your Zoho Analytics application by opening your Windows Services and navigating to the Zoho Analytics service. Right click the service name and select Start or Stop, to start and stop the application accordingly. You can also start the application from the command prompt by executing the run.bat file found under the Zoho\Analytics\bin folder.

Note: To start or stop Zoho Analytics, please ensure you are logged in to the server on which your Zoho Analytics application is installed. 

For Linix installations, navigate to the directory where Zoho Analytics is installed in your computer or server. Launch a terminal from the Zoho/Analytics/bin folder, and use the following commands to start and stop the application:

• Start the application by executing these commands (from the command prompt/terminal): sh app_ctl.sh run or sh run.sh

• Stop the application by executing these commands (from the command prompt/terminal): sh app_ctl.sh StopServer or sh StopServer.sh

6. What are the languages supported by Zoho Analytics User Interface?

7. How do I change the language of my Zoho Analytics User Interface?

The Zoho Analytics User interface language selection can be done in the My Accounts section present in the top right corner of the application. You may have to refresh the application, for the language change to take effect in the user interface.

9. Does Zoho Analytics support Re-branding?

Yes, Zoho Analytics supports re-branding. Zoho Analytics provides two types of re-branding. They are Logo re-branding and complete re-branding (white labeling).

Logo Re-branding:

Logo Re-branding enables you to customize the Zoho Analytics product logo that is displayed within the Zoho Analytics service. This support is available only in the Premium and Enterprise plans of Zoho Analytics. Using this feature you can replace the Zoho Analytics product logo displayed in the service and also change the powered by logo displayed as footer of the reports when you export them (as PDF or images) or embed them in other web pages.

Follow the steps given below to change the logo:

• Navigate to the Login to Zoho Analytics.
• Click on Subscription link at the top of the page. It will take you to the subscription details page.
• Now, click on Logo Rebranding tab.
• Upload your custom product logo which you want to display in the application instead of Zoho Analytics product logo.
• Provide the URL to be linked from your logo in the Logo URL field.
• Choose one of the following options for Powered by "Logo" field.
  • None - Choose this option to remove powered by logo.
  • Display Zoho Analytics Logo (default Value) - Choose this option to display the Zoho Analytics Logo itself.
  • Display Your Own Logo – Choose this option to display your organization's logo.
• Click Save. Your custom logo will be displayed in the Zoho Analytics application and the Powered by Logo will be set as specified.

Licensing and Pricing

You can change your account setting by following the steps given below:

• Access the Zoho Analytics On-Premise application.
• Click the drop-down menu displayed with your username at the top right corner.
• Click My Account, this will open Zoho Accounts Profile page 
• Customize your account settings as required.

Refer to the My Account Setting document to know more on this.

You can change your password by following the steps given below:

• Access the Zoho Analytics On-Premise application.
• Click the drop-down menu displayed with your username at the top right corner.
• Click My Account, this will open Profile page. 
• Navigate to Change Password tab.
• Enter the current password for confirmation.
• Enter the new password twice and then click Save.
• Your password will be changed.

Yes, you can change your primary email address and set one of your secondary email address as primary.

To change primary email id:

• Access the Zoho Analytics On-Premise application.
• Click the drop-down menu displayed with your username at the top right corner.
• Click My Account, this will open Profile page. 
• You can change the e-mail address by clicking the info icon. My Email Address page will open. 
• Click Edit icon. Enter the Email ID and current password. 
• Click Update. The e-mail address will be modified. 

You can import tabular data from the following file formats:

• Excel Spreadsheets (.xls)
• CSV (Comma Separated Values)
• TSV (Tab Separated Values)
• Any tabular data in text file format
• HTML files MS Access (.mdb)
• files Web URLs which generates data in CSV or Excel format
• Zipped files in any of the above file formats (except .mdb files)

You can also copy-paste data from all the above file formats as well as from spreadsheets (Microsoft Office Excel, Open Office Calc and StarOffice) files to import the data into Zoho Analytics. For more details, refer to Import Data section.

Currently, Zoho Analytics allows you to import files (CSV, TSV, XLS, HTML) with maximum 1000,000 rows or a file size limit of 100 MB at a time when you use the Zoho Analytics user interface. It will restrict it based on whichever condition is met first. If you wish to upload more than 500,000 rows or a file more than 100 MB at a time, you can use the Upload Agent, as it would be more efficient to handle such loads.

For free and trial versions, Zoho Analytics allows you to have only up to a maximum of 500,000 rows in a table.

If you find these limits are constraining to your application needs, mail us your requirements to onprem-support@zohoanalytics.com, we will definitely help you.

You can upload data from various local databases like Oracle, SQL Server, MySQL, DB2, PostgreSQL, MS Access, etc. to Zoho Analytics. Click here to learn more. 

Yes, you can enter data directly into Zoho Analytics table as you enter data in an Excel sheet. To know how to add data in a table, refer to the Add Rows and Columns section. You can also create a table by directly entering data. For details, refer to Enter Data Right Away section.

Yes, Zoho Analytics supports relational modeling of your workspace. The following are the capabilities currently available:

• You can create tables which have lookup columns between them. This helps you to create parent-child relationships and enable to automatically join data tables for creating reports.

• With lookup columns you can define familiar models like Star Schema & Snow-flake Schema which are optimized for reporting and analysis.

• Zoho Analytics supports cascade-on-delete i.e., when you delete a row in the parent table, it will automatically delete the corresponding rows in the child table(s). This setting is optional.

• You can easily join tables to create reports in any of the following models:

  • Auto-Join

  • Join using SQL Query

Yes, you can join data tables and easily create reports in Zoho Analytics. There are two way to join tables. They are by Auto join and by Query tables.

• You can auto join tables using lookup columns and then create reports over these tables. Click here to learn more.

• Using Query tables you can join data from multiple tables in a database using JOIN construct in SQL SELECT query. You can save the results from the query into a new table for creating reports over the same. Click here to learn more.

Yes, Zoho Analytics supports full-fledged SQL based querying of your database. It understands SQL SELECT Queries written in any of the well-known database dialects including Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL. You can use SQLs in Zoho Analytics by creating a query table and executing SQL SELECT queries. You can then generate reports over the generated query table.

Zoho Analytics supports SQL written in a wide variety of popular database dialects. It currently supports Oracle, SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix, and ANSI SQL database dialects.

Yes, you can easily share your data tables, reports, and dashboards created in Zoho Analytics with other admin users. Use the Share option within Zoho Analytics to share your tables, reports, dashboards or entire workspace to other users. You just need to provide the email address (Users should have a Zoho Analytics account registered with this email address. If they do not have an account at the time of sharing they need to create one using the email id to which it is shared) and set the necessary permission (Read or Read-Write etc.) for the views being shared.

To learn more, refer to Sharing and collaboration section.

2. Can I embed/publish the tables, reports & dashboards created in Zoho Analytics into my Website, Web Application, and Blogs?

3. Can I allow others to edit the data in my workspace?

 4. Can I allow others to create reports in my workspace?

5. Can I allow others to upload data in my workspace?

6. Can I generate a standalone URL (permalink) for the reports created in Zoho Analytics?

7. Can I export my reports created in Zoho Analytics? If yes, what are the supported formats?

 8. Can I email the reports as an attachment? If yes, can I schedule the emails to be sent automatically at specified time intervals?