What's new in Zoho Analytics?

Settings page revamped

We've revamped the user interface of the Settings page. We've also categorised the settings and included new sections like help and support, troubleshoot and miscellaneous to improve the user experience. Click here to learn more.

Introducing new language support

Zoho Analytics user interface is now available in Romanian language in addition to the other languages.

Support for new mail server types

Zoho Analytics now supports OAuth authentication in SMTP and Microsoft's Exchange Web Services (EWS) as mail servers to trigger email notifications when an action is performed. Click here to learn more.

Redesigned getting started screens

Zoho Analytics' getting started screens have been redesigned to enhance the user experience. Click here to learn more.

Database upgrade

Zoho Analytics' backend PostgreSQL database which is used to store data is upgraded to version 11.14.

Advanced columnar engine

Experience 2x faster read operations in Zoho Analytics with the new and improved columnar engine.

Boosted performance

Zoho Analytics can now support larger workloads with the introduction of horizontally scalable architecture.

Enhancements to Google Ads integration

The Google Ads integration now requires a developer token to authenticate with Google Ads APIs for data collection. Click here to learn more.

Support to import GZIP files

You can now import data from GZIP files stored in your local drives, web URLs, or any FTP servers.

Enhancements to data backup

Zoho Analytics enables you to choose the retention period for your data backups. Click here to learn more.

Support to enable/disable emails triggered on user addition

You can now choose to enable or disable the welcome email being triggered while adding SSO or Active Directory users to Zoho Analytics. Click here to learn more.

Updated Xero authentication process

The key-based authentication mechanism for Xero has been replaced with OAuth mode. Click here to learn more.

Retain source workspace's column data type

While importing data from other Zoho Analytics workspaces, the columns' data type will also be retained as in the source workspace.

Updated Jira Software Cloud authentication process

The authentication mechanism for Jira Software Cloud has been changed from being key based to OAuth mode. Click here to learn more.

Revamped Zoho Analytics login page

Zoho Analytics' login page has been revamped to feature product-related announcements. Click here to learn more.

Remove a table's data source

You can now remove an individual table's data source, to stop the table from updating new data from the source. Click here to learn more.

Sync meta data changes instantly

You can instantly reflect the source database's meta data changes to individual tables in Zoho Analytics easily. This is only applicable for data imported using live connections. Click here to learn more.

Support for AND/OR logical operators in data alerts

You can leverage AND and OR logical operators while creating data alerts. Click here to learn more.

Enhanced custom sort interface

The custom sort option in reports has been revamped to enhance user experience.

Modifications to the Annual Maintenance and Support license format

Zoho Analytics is moving to an xml-based Annual Maintenance and Support (AMS) license format that allows for notifications before AMS expiration. Click here to learn more.

Apply multiple user filters simultaneously

You can now choose to apply multiple user filters simultaneously in a dashboard. Click here to learn more.

Choose the required data center

You can now choose the data center associated to your Zoho account while setting up the integration with Zoho Creator, Zoho DataPrep and Zoho CRM. Click the corresponding links to learn more.

Revamped getting started screens

Zoho Analytics' getting started screens have been revamped to enhance the user experience. Click here to learn more.

Enhanced forecasting engine

You can choose to generate forecasts for the columns used in a chart's Color shelf. Click here to learn more.

Support for lookup columns in live connections

You can now create lookup columns while importing data using live connections. Click here to learn more.

Introducing enhancements in reports

The following enhancements have been made to reports in Zoho Analytics:

1. A chart's Edit Design mode displays contextual menu options over columns used in the chart builder (on mouse hover). Click here to learn more.

2. You can now display images in the place of text in a chart's axis. Click here to learn more.

3. The creating a tabular view screen has been revamped for easier navigation.

Launching advanced analytics for additional modules in ServiceNow

Zoho Analytics now offers out-of-the-box analytics for ServiceNow's release management, change management and configuration management modules. Click here to learn more.

Enhancements to Ask Zia

The following enhancements have been made to Ask Zia.

1. Introducing Zia Insights - you can now access actionable insights on your visualizations instantly. Click here to learn more.

2. Our AI assistant, Ask Zia, now supports inputs in Spanish.

Customize forecasting models

You can now customize the mathematical models involved in forecasting your data. Click here to learn more.

Enhancements to charts

The following enhancements have been made to charts:

1. When a chart has multiple axes, you can now choose to merge specific axes. Click here to learn more.

2. You can now apply various effects on your chart to modify its overall appearance. Click here to learn more.

Expand and collapse user filters

You can now expand and collapse the user filters in your dashboards. Click here to learn more.

Enhanced user interface

There are also several minor enhancements in the Zoho Analytics user interface, designed to enhance your experience.

Import data in batches (Pagination)

You can now import large amounts of data in batches from web URLs. Click here to learn more.

Introducing enhancements to Ask Zia

The following enhancements have been made to Ask Zia:

1. Ask Zia now supports predictive analytics and generates reports with forecasted values. Click here to learn more.

2. Introducing conversation mode: Ask Zia allows you to post follow up questions to help you dig deeper into your data.

3. Ask Zia is now exclusively available in conversation mode within dashboards, to answer any dashboard-specific questions.

4. Ask Zia will list existing reports as answers to your questions where applicable.

5. You can now map terms in your questions to corresponding columns in the data table while entering your questions. Click here to learn more.

Introducing enhancements to dashboards

The following enhancements have been made to dashboards:

1. You can now add multiple tabs to your dashboards. Click here to learn more.

2. The merge user filters functionality in dashboards has been enhanced to support all data types. Click here to learn more.

Introducing enhancements to sort functionality in charts

You can now sort your multi-axis charts with both X and Y-axes values. Additionally, the Sort option in your chart's toolbar has been revamped for easier navigation. Click here to learn more.

Introducing enhancements to the Export feature

1. You can now export multiple views from the Explorer easily.

2. Zoho Analytics also allows you to export all the views under a particular folder.

Automate scheduled application backups

You can now automate scheduled backups of the Zoho Analytics application easily. Click here to learn more.

Import data from more local databases

You can now import data into Zoho Analytics from the following local databases:

• SQLite
• Progress OpenEdge
• Hive
• Firebird
• YugabyteDB
• Microsoft Access
• SAP HANA

Click here to learn more.

Import data from cloud databases into existing tables

You can now import data from cloud databases into existing tables in Zoho Analytics. Click here to learn more.

Introducing enhancements to Ask Zia

The following enhancements have been made to Ask Zia:

• The AI assistant can now understand questions that are grammatically unstructured or incomplete.
• Ask Zia now features typo tolerance, to understand words that are spelled incorrectly.
• Ask Zia can now interpret the mathematical function that is best suited for your question.
• The AI assistant's knowledge of dates is now enhanced - the term "weekend" and the abbreviated versions of months can now be used.

Click here to learn more.

Support for date-based lookup column

Zoho Analytics now allows you to configure a date column as a lookup column between two tables. Click here to learn more.

Introducing enhancements to charts

The following enhancements have been made to charts:

1. A new chart type has been introduced: Histogram. Click here to learn more.

2. You can now apply patterns to your charts, and choose from a range of pre-built ones or create your own. Click here to learn more.

3. You can now create a 100% stacked bar chart, and charts with horizontal stacked bars that can have multiple Y axes.

4. Zoho Analytics allows you to switch your chart's axis dynamically, to view the chart per your requirements. Click here to learn more.

5. You can now choose to disable the Dynamic Drill Down option in charts. Click here to learn more.

Introducing enhancements to pivot views

The following enhancements have been made to pivot views:

1. You can now hide specific columns in pivot views easily. Click here to learn more.

2. You can now expand and collapse the rows, columns and cells in your pivot views. Click here to learn more.

Introducing enhancements to sharing and publishing options

The following enhancements have been made to the sharing and publishing functionality:

1. You can now request access to views that haven't been shared with you. Click here to learn more.

2. Zoho Analytics now allows you to set expiration dates for views that are published without login credentials. Click here to learn more.

3. While publishing a table, you can now choose to publish only selective columns from that table. Click here to learn more.

4. The Export and Email dialog boxes have been revamped for easier navigation.

Introducing enhancements to Explorer view

The following enhancements have been made to the Explorer View:

1. You can convert a parent folder to a sub-folder, and vice versa. Click here to learn more.

2. You can now mark sub-folders as default folders in your workspace. Click here to learn more.

Bookmark views easily

You can now bookmark important views when accessing them, using the icon found beside the view's name.

Introducing enhancements to user filters

The following enhancements have been made to user filters:

• The existing List only relevant values option can now be used to configure cascading user filters, wherein the subsequent user filter's values are dependent on the preceding user filter's value.
• Conversely, the Show All option can be selected to list every value in the subsequent user filter, regardless of the preceding user filter's value.

Click here to learn more.

Create data snapshots with forecasted values

Easily create Data Snapshots of charts containing forecasted values. Click here to more about data snapshots.

Auto-generate reports over a table's related data

Auto-generate reports over data from both the selected table and its connected tables easily, using the Similar to Another Table feature.

Pivot or unpivot your data tables easily

The below keywords are now supported while creating query tables:

• Pivot: Converts rows into columns by turning the unique values in the input column to multiple output columns.
• Unpivot: Converts columns into rows by changing multiple columns to values in a single row.

Customize alignment of KPI widgets

You can now customize a KPI widget's alignment in a dashboard easily.

Introducing enhancements to charts

The following enhancements have been made to charts:

1. Choose to display legends with or without their corresponding values, and customize their format. Click here to learn more.

2. You can now plot charts with percentile function applied over the numeric data. Click here to learn more.

Introducing enhancements to Explorer view

The following enhancements have been made to the Explorer View:

1. Select and move multiple views across folders in a workspace.

2. Move sub-folders from one parent folder to another, and make parent folders as sub-folders within another folder.

3. You can now bookmark important views from the Reports and Dashboards section in the side panel.

4. Creating new views is now easier, with options to create tables, reports, and dashboards from the respective sections in the side panel.

Introducing enhancements to collaboration features

The following enhancements have been made to the collaboration features:

1. The various collaboration options are now grouped under the common Share button.

2. You can now email filtered views to multiple users and groups. Click here to learn more about emailing views.

3. The Embed and Publish URL screen has been revamped to facilitate easy access.

More authentication types supported for import from web feeds

Zoho Analytics now supports the following authentication types while importing data from web feeds.

• AWS Signature
• Digest Authentication
• Hawk Authentication

Click here to learn more.

View dependency details

You can now view the dependency details of a report or a table in Zoho Analytics easily. Click here to learn more.

A compact pivot layout

Zoho Analytics now allows you to customize the pivot layout, to attain a more compact outlook. Click here to learn more.

Improved Manage Groups UI

Managing groups in Zoho Analytics is now easier with the enhanced UI. Click here to learn more.

Introducing enhancements to the sort functionality in charts

1. By default, new pie charts will be sorted in the descending order based on the distribution of values.

2. A chart with its top or bottom 'N' values filtered will also be sorted in the ascending or the descending order accordingly.

3. If a custom sort is configured as the default for a column in a table, new reports created over that column will also be sorted in the same manner.

Import data from more local databases

You can now import data into Zoho Analytics from the following local databases:

• DB2
• Exasol
• Greenplum
• Vertica
• Actian Vector
• Denodo
• Pervasive SQL
• Any Database supporting JDBC Connection

Click here to learn more.

Customize Pivot Summary Position

Zoho Analytics now allows you to customize the positioning of the column and row summaries in Pivot Tables. Click here to learn more.

Enhancement in Report Formula

Zoho Analytics' report-specific formula builder is enhanced to support logical (AND, OR) and comparison operators. Click here to learn more about Report Formulas.

Apply Parent Table's Filter Criteria

You can now apply the parent table's filter criteria while sharing dashboards with users. Click here to learn more.

Unsubscribe from shared workspaces

Zoho Analytics users can now easily unsubscribe from workspaces that are shared to them. Click here to learn more.

Enhanced emailing options

You can now include up to 25 users in each email schedule. The Pick Users / Groups option also lets you pick groups from a list, instead of having to type all the email addresses individually. Click here to learn more.

Introducing enhancements to the Explorer view

1. Use the Shift + Select option (hold down the shift key during view selection) to choose several views at a time.

2. Clicking the speech bubble icons in the Explorer View will take you to the comments section of each view.

Import data from more cloud databases

You can now import data into Zoho Analytics from the following cloud databases:

• Amazon Aurora PostgreSQL
• Amazon Athena
• Microsoft Azure
  • MySQL
  • PostgreSQL
  • Maria DB
  • SQL Databasee
  • SQL Data Warehouse
• Google BigQuery
• Google Cloud
  • SQL
  • PostgreSQL
• Snowflake
• Rackspace Cloud
  • MySQL
  • Maria DB
• Oracle Cloud
• IBM Cloud
• Panoply

Click here to learn more.

Specify accuracy levels while forecasting

Zoho Analytics' forecasting engine has now been enhanced, allowing you to define accuracy levels in your forecast reports. Click here to learn more.

Enhancements in Geo Map charts

The following enhancements are now offered in Geo map charts:

1. New themes have been introduced for map charts- Satellite theme and custom theme. Using the Satellite theme you can now plot a Geo map chart over a satellite view of the area, while the Custom theme allows you to design a customized theme to fit your requirements.

You can invert the colors in your map chart using the Invert Color toggle button. This is not applicable for Geo maps using a Satellite theme. A continuous color range legend can also be applied on map charts. Click here to learn more.

2. You can now create map charts in Zoho Analytics using Airport IATA codes.

3. Country-specific map charts can also be created, where you can display chosen countries and hide the rest. Click here to learn more.

Revamped data import screen

ZThe import from Files and Feeds option has now been split into separate tiles in Zoho Analytics, to simplify the import process.

Enhanced dashboard editor

Zoho Analytics has introduced new functionalities to the dashboard editor to facilitate easy customization. The following enhancements are available:

• Re-organize multiple components together in a dashboard.
• Re-size multiple components at the same time.
• Apply uniform dimensions to several components.
• Apply proportionate width to selected components.
• Fill empty spaces in the dashboard layout by re-sizing components.
• Export specific reports in the dashboard.
• Maximize embedded reports easily.

Improved Chart Color Palette section

The Chart Color Palette section has now been enhanced to facilitate easy access. Click here to learn more.

Enhancements in drill down options

You can now ignore the value in the Color tile and drill down on the entire data present in the chart. Click here to learn more.

Organize views from your side panel

You can now change the dashboard and report listing style (folder view, type view or related view) using Zoho Analytics' side panel.

Rename columns easily

Zoho Analytics now allows you to rename the columns in a table by simply double-clicking the column header.

Support to choose multiple lookup columns

You can now select multiple lookup columns to join two tables. This lets you combine related tables using more than one condition. Click here to learn more.

Generating AuthTokens

The AuthToken required for using the Zoho Analytics APIs is now just a click away.

In-memory columnar engine for faster analytics

In-memory columnar engine has been integrated into Zoho Analytics for high performance at scale. Now experience analytics at speed with faster rendering of reports and dashboards.

Note: The in-memory columnar engine is available only for the Linux platform of Zoho Analytics.

Actian Vector (community and commercial commercial versions available) columnar engine is now supported as a plug-able option for high performance at scale. Users can use this as an alternative to the inbuilt columnar engine.

Note: Actian vector columnar engine is supported in both Linux and Windows platform.

Get in touch with onprem-support@zohoanalytics.com for more details.

Revamped home page

The Zoho Analytics home page has been completely revamped for easy navigation.

1. Dashboards can now be accessed with a single click using the preview cards.

2. The main navigational elements are made bigger and bolder now, with the analytics elements organized into three categories (dashboards, reports & data) for easy accessibility.

3. Zoho Analytics now allows theme customization, enabling you to change the look and feel of the entire application with a single click.

Customized dashboard interactions

You can now enable or disable the following interactions in your dashboard:

• Drill Down in charts
• View Underlying Data in reports
• Sort Menu in grid views
• Show/Hide Columns in tabular views
• Contextual options menu on hover

Coloured KPI Widgets

Using the new widget color options you can select specific colors for each widget in your dashboard. Click here to learn more.

Share selective columns from tables

While sharing tables, you can now exclude columns with personal data to ensure data security and GDPR compliance. Click here to learn more.

Advanced summarizing functions for pivot tables

Zoho Analytics now supports the following advanced summarizing functions in a pivot table.

• % of Row in Group - Displays the data in each cell as a percentage of the total value, of each row within a group.
• % of Column in Group - Displays the data in each cell as a percentage of the total value, of each column within a group.
• Lookup Value - Displays the data in each cell by fetching value from any of Previous/Next/First/Last cell, based on the Base Field selected.

Click here to learn more.

Configure lookup relationships

Zoho Analytics now allows you to customize your reports by revising the default lookup relationship between tables used in creating a report. Click here to learn more.