Zoho Analytics 6.0 Beta

Zoho Analytics 6.0 Beta

We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team has meticulously developed these functionalities with a focus on current and future business needs, incorporating valuable user & market feedback.


New capabilities in Zoho Analytics 6.0 Beta includes more data connectors, new visualizations, new interactions, advanced analytical models , the ability to build custom ML models, and 60+ features.  
Note: 6.0 Beta is now available in all paid plans to try out. Features available in specific plans are annotated inline.

1. Data Connectors & Data Management

New Connectors

We are expanding our already available 500+ data connectors with 25+ new connectors for big data platforms and business applications  that includes Yellowbricks, ClickHouse, Dremio, Zoho Connect, Zoho Marketing Automation,  Zoho Backstage, Amazon Seller Central, Airtable and many more.



Also, managing data has now become easier with the following features -- Audit history, Sync history, and Import roll back.

Audit History

Audit logs are crucial for maintaining security and troubleshooting issues. They provide a comprehensive record of user and system Actions, including details of the time when the action occurred and information about the administrator who performed the action.


Sync History

Sync history provides a detailed record of data synchronization activities, making it easy for the administrators to track the status of each data sync. The sync operations are color-coded for immediate recognition. Successful data syncs are indicated in green, and failed data syncs are marked in red with the reasons for failure along with the necessary action to be taken.

Import Rollback 

Automated imports can sometimes have errors and inconsistencies in data, and this can affect the data quality and the results. The import rollback capability reverts the current data import version to its previous version without affecting the existing data flow and analysis, ensuring data integrity.


Unified Metrics

Workspace will have data imported from varied sources, and each data source or table will have different metrics (aggregates) computed for analysis. A unified metrics consolidates all the metrics used across the workspace, helps in standardization, promotes usage, and avoids duplication.



Data Bucketing

Categorize or group data points easily with the Bucket Columns options in Zoho Analytics. (Until now, users had to write formulas to achieve this; now, it is available as an inbuilt option.) Bucketing reduces the number of distinct values (cardinality). It facilitates the transformation of numerical data into different categorical bins and makes data analysis easier.




2. Visual Analytics

Zoho Analytics supports 7+ new chart types (on top of 50+ existing ones) with extensive customization options to enhance the presentation and interpretation of the data.

  • Sankey charts are best suited for visualizing the flow of any process, as they clearly capture the movement of data from one point to another. It helps understand the movement of events through interconnected lines.
  • Racing charts are animated views that are best suited for visualizing the changes in the data over a period of time where the relative ranking of categories is important. They highlight and help comprehend the fluctuations and progression in the data. These types of charts grab the user's attention instantly, providing an immersive experience and helping craft a compelling story about the data.
  • Spark lines are compact charts that show the trends and variations in the data without taking up much space. They are widely used alongside pivot tables and help grasp trends and allow quick comparison of metrics across different fields. Zoho Analytics supports three variations that includes line chart, area chart, and bar chart.
  • Geo Map Layering, add multiple data layers to the geo map to visualize various dimensions of information. This feature includes interactive options for enhanced data exploration.
  • Sunburst charts represent hierarchical data through a series of rings, or concentric circles. Each ring corresponds to a level in the hierarchy. The central or innermost circle represents the root node, or the top-level category. Moving outwards, each subsequent ring represents a subcategory, where the outermost ring is the leaf node. The size of each arc in the ring is proportional to the value of the data. 
  • Conversion bar charts show the connected stages of a process and the gradual decrease in data as it moves through different stages of the process. Each stage is represented by a bar, with a step or stair case pattern indicating the shift in values (along with conversion percentage) at each stage.
  • Tree Map is a visualization composed of differently-sized rectangles that represent your data values. This is beneficial when you want to depict the part to whole relationship among various categories.


Zia  Suggestions

Now, with the new Zia Suggestions, you can effortlessly receive insightful chart recommendations while you are in the creation process. Zia suggests a variety of charts suggestions tailored to your data, allowing you to preview and apply them seamlessly with just a click. 


Global User Filter in Dashboards

You can now have a common user filter across all tabs in the dashboard. Global user filter gets applied across all reports in all tabs of the dashboard. 

3. Advanced Data Analytics 

Zoho Analytics now supports two more advanced data analytics methods: Anomaly Detection and Cluster Analysis.

Anomaly Detection 

Anomaly detection helps you to flag outliers in your data or metrics easily. You can now create charts which highlight anomalous points visually for your attention and action. Zoho Analytics deploys robust ML algorithms and various statistical models for detecting outliers.



Cluster Analysis 

Cluster analysis groups similar data points together based on certain factors or conditions. Each cluster contains data points that are more similar to each other than to those in other clusters, reducing the complexity of the data. Zoho Analytics deploys K-means, K-modes and K-prototypes algorithms for clustering the data points.


Alerts Based on Threshold and Anomalies

Set data alerts based on thresholds and anomalies to ensure timely identification of vital change in the key business metrics and potential issues.


Ask Zia Bot in Microsoft Teams

Combine the generative AI capabilities of Zoho Analytics' Ask Zia with Microsoft Teams. Get answers to your data queries, access key business insights quickly, predict future trends, and build reports right from within Microsoft Teams with Ask Zia bot. 

4. Build your ML Models with AutoML & Code Studio 

Auto ML 

Automated machine learning provides a code-free (low-code/no-code) experience to train, verify, and build custom machine learning models with high efficiency. The simple and user-friendly design makes it possible for people with varied data-level expertise to create ML models easily for their custom needs.



Code Studio 

Python Code Studio enables you to build/import custom logic and ML models for your specific data preparation, transformation, enrichment, and analytical modeling needs.



5. Data Storytelling

BI Fabric

Create unified BI portals for your organization's business needs. Collate reports from other BI applications like Tableau and Power BI. Having a unified portal improves collaboration, promotes centralized accessibility, and makes it easy for C-level executives to make robust business decisions.


Visual Zia Insights

Zia Insights now provides visual narratives! Visuals help process information far more efficiently than lengthy text descriptions. These visuals facilitate multi-dimensional interpretations like comparison, contribution, distribution, trends and proportions.


Zia Insights -Multilingual Support

Zia Insights is now available in French and Spanish. Users can choose their preferred language when accessing Zia Insights for a specific report.

Export as PPT

Export multiple views as a Microsoft PowerPoint presentation. Enhance security by protecting the file with a password.


6. More enhancements

Rank within Filters

Identify and analyze top and bottom performers across various dimensions. The rank-based ability helps find the top or bottom performers within and across individual groups without having to write complex formulas.


Date and String data types in Aggregate Formula

Zoho Analytics now supports the date and plain text as return data types in aggregate functions. This improvement proves immensely beneficial in scenarios such as cohort analysis, project milestone tracking, and various other use cases.


White Label CSS Customization

Elevate the visual appeal of your white labeled product and align it with your brand through the CSS customization feature. This latest addition to Zoho Analytics enables you to customize text, colors, and more on pages, tabs, selections, hover options, enhancing the overall look and feel.


Right to left User Interface

Zoho Analytics now supports a right to left user interface. This option is best suited for languages like Arabic and Hebrew that are read from right to left.

Security

At Zoho Analytics, ensuring data privacy and security remains our topmost priority. We have implemented additional measures to strengthen security through the following enhancements.

Zoho Directory

Zoho Analytics' integration with Zoho Directory allows administrators to handle identity and user access management with ease. You can now easily setup Single Sign-on, setup Active Directory sync, manage user access, etc.,with Zoho Directory.


Workspace Level IP Restriction

Configure workspace-level IP restrictions for enhanced security and to prevent unauthorized access. Previously, IP restrictions were available only at the account level.


Zoho Analytics Mobile App

The Zoho Analytics Mobile app has been upgraded as a native app, optimized for your specific device. This enhancement provides faster loading times, high-quality visuals, and advanced security features specific to your device's operating system to protect your data.


Email Schedule APIs

A new set of APIs are now available for managing your email schedules. These APIs enable you to create, update, trigger and delete email schedules easily.

Features in Private Beta

ChatGPT in Ask Zia

Ask Zia now integrates with ChatGPT assisting you to write complex queries and formulas for effective data analysis.

Diagnostic Analysis

Zia insights now supports diagnostic analysis helping you understand the root causes for a certain outcome.

Custom Connector

Zoho Analytics now enables you create your own integration with third party applications.

Try Zoho Analytics 6.0 Beta!

Do try out the new features and share your valuable feedback with us at support@zohoanalytics.com. Your suggestions are crucial to helping us improve and serve you better.



      • Sticky Posts

      • What's New in Zoho Analytics - March 2025

        Hello Users, We're back with the latest set of enhancements and improvements aimed at improving your analytics experience. Common Query Table Expression (CTE) support in Query Tables We’ve added support for Common Table Expressions (CTE) in Query Tables,

      • Zoho Analytics in 2024: A look back

        Happy new year to everyone in the Zoho Analytics community! As we welcome 2025, here's a look back of important happenings in 2024.

      • Announcing Zoho Analytics 6.0 Beta!

        We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team

      • What's New in Zoho Analytics - August 2024

        Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data

      • We are coming to your city! Zoho Analytics Community Meetup

        Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing

        • Recent Topics

        • Zoho Desk Ticket Windows are smaller

          Hi Zoho, All of a sudden your ticket windows have become smaller, any idea on what's happening? FYI that my browser window size for Desk is 100% But on my general dashboard view, it's fine.

        • Budget roll up

          If we load budget details to main expenses and would like a view of budget vs actuals based on the roll up of sub expense, does anybody know how we can get it. For e.g. our budget is loaded to main expense heads like Travel, Entertainment, etc. Travel

        • is it possible to get job wise (invoice) profit?

          HI Team  Greetings i need a Help.. recently i migrated zoho books to  my clients. previously we use quickbooks . Then when ever we need we can get the reports job wise or invoice wise profit margin ( invoice-COGS-Expenses)in QB.is there anyway to get 

        • Not able to see "RETAINER INVOICE" in my tab or in General Setting

          As you can see in the attached screen, i am not able to see retainer invoice option in my main/home screen or even get option to check or uncheck in general setting can anyone please help, if they have encountered such issue

        • Access demo forms other than developers in Zoho Creator 6

          Can zoho creator 6 users other than developers test forms in the development/stage? just want to see the form view. The current condition of the form is being released, and want to make changes. But the user wants to see the changes first before publishing

        • Change Background in PDF Template

          Background PDF Hi, I want to ask a question. I want to create a background template with my own image. Above is an example that I made, why does the result not fit the A4 format? Like cut off. I used an A4 Portrait image, is there a size error? can you

        • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

          Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

        • Possible to bold or indent text in the description field?

          As part of one item, I often have a detailed description that would be much easier to read if there was the ability to have a bulleted list or bold text and the like. Is this possible? My last invoicing software allowed markup in the field so, for example, an asterisk meant a bullet. I haven't been able to find any documentation related to this.  Any information would be appreciated. Thank you.

        • How would you handle Warranty replacement parts or items in zoho inventory

          Hi everyone, I'm working on setting up zoho inventory for our distribution business.  We handle the service for our customers and will replace items that malfunction under a warranty basis.  Does anyone else do this and how do you set it up in inventory?  Do you have to create a sales order and if you want to the original item back, do you use a RMA?  If so, how is it done so there isn't a credit memo associated with it? Thanks, Tim

        • Apple Messages for Business in Omnichannel communications?

          Hello, Apple launched "Apple Messages for Business" but Zoho CRM or Zoho Desk don't appear in the list of possible integrators. Zoho already promotes https://www.zoho.com/crm/omnichannel.html Omni Channel integration, but Apple Messages does not yet appear.

        • Download email snippets

          Is there a way we can mass download agent-created email snippets?

        • Zoho Desk & Tasks

          Hi, I'd like to be able to create a set of tasks each time a customer request comes in, as I understand it, currently each would need to be create manually. Project is too much of an overhead for what we want to use. Effectively in various use cases we

        • CREATING A PACKAGE SHIPMENT DIRECTLY FROM INVOICE

          Hi, In zoho books i can create a package, shipment and delivery only if i am putting a sales order. If I am invoicing a customer without a sales order, then how can i track the shipment details, package and delivery details for that invoice. Please help.

        • Why Format section gets disabled when we create Merge Template over PDF

          I need some assistance I have a Client who is going to give certificates to users who passes his exam. So, I am using mail merge but in ZOHO writer after I upload the PDF and create merge Template over PDF the format Section gets disabled. My problem

        • How to Freeze Tasks

          Is there a way to freeze a task in the Gantt chart so it cannot move even when predecessors are moved?

        • Journey : "Added to segment" trigger doesn't work automatically

          Hello, I’m experiencing an issue with our Marketing Automation 2.0 integration with Zoho CRM. We have multiple segments defined in Marketing Automation, each with criteria based on field values synced from Zoho CRM. If a field value changes in Zoho CRM,

        • Function #1: Convert an accepted Estimate to Sales Order automatically in Zoho Books

          As you’re aware, Zoho Books provides a default option to have the estimates automatically converted to invoices once your customer accepts them. Many of you wanted a similar option for sales orders, so here’s a workflow that converts accepted estimates

        • Zoho People U.S. Compensation Setup

          We're new to Zoho and Zoho People Plus. So far, we like what we see as an HRIS system to suit our small USA-based (under 20-person) non-profit. However, we can't figure out how to configure the Compensation Service to reflect our workplace. We'd simply

        • Meeting integration with Otter.ai

          Would love for an integration with an AI transcription service like Otter.ai to be integrated with Zoho Meeting. Thanks

        • Workflow Logs

          How can I view Workflow Logs? I have setup custom criteria for custom functions and emails for task workflows Sometimes it doesn't get executed, now It's really hard for me to check where the issue occurred is it due to the criteria? My Function Logic?

        • What are the consequences of renaming a picklist value?

          What are the consequences of renaming a picklist value?

        • Integrating Zoho Creator with Google Drive

          I am interested in using Google Drive as a convenient repository to push files from file upload fields in my creator app. I am wondering if people have come up with best practices for this or even how viable it is. https://developers.google.com/drive/api/guides/manage-uploads#simple

        • Dynamic Date Filtering for KPI Widgets – Need Help with Query Table

          Hello, I'm seeking help with setting up dynamic date filtering for my KPI widgets in Zoho Analytics. Below is an overview of my setup and the issues I'm facing: Why: I need my KPI widgets to update dynamically based on a date range selected via a dashboard

        • Sales Returns - Repairand Return

          Hi Inventory Team, I'm working with a client on an Inventory implementation project and they have shared this use case with me. Some items may be returned by the customer, then returned to the vendor for repairs, received from the vendor and shipped back

        • Hosted Payment Pages - how to update the address in zoho billing

          I"m playing around with the muti-page hosted payment pages which have places for customers to enter their addresses when paying. Why does this not update their address in Zoho Billing after payment? What can I do to make this happen?

        • Deluge Script to Reopen Ticket if Tasks are not Completed

          I have the following script, my goal is to have it automatically reopen the ticket when the ticket is closed if there are Activities assigned to the ticket that are not "Completed". This script seems to reopen the ticket if there are any tasks at all,

        • UK payroll entries

          Hey guys, Nett payroll payments are imported direct into the bank, using an external payroll system (will be glad for Zoho to have a UK payroll app) At present I have monthly recurring bills for HMRC which are auto entered & paid when due. This seems

        • Subform Lookup field showError doesn't clear in Client Script

          I have a lookup fields Deal, Account and Lead in Subform, I am checking if its null or not If its null It shows an error, but when I select some value for the Lookup Field it doesn't clear the error , for other fields such as single line or pickup etc.

        • Option to Manually Add and Verify DMARC Record

          Dear Zoho Mail Team, When configuring a new domain in Zoho Mail, we currently have the option to automatically configure the MX, SPF, and DKIM records. For each of these, we can either allow Zoho to create the records or manually add them to our DNS and

        • Working with Products that are non-tangible

          How does one create a 'service' in products? Is there a way to disable inventory functions for things like Sofware as a service? The services module doesn't look to be much help either. Not sure how to do this in CRM

        • Weekly Tips: Categorize Your Emails with Tags

          We send and receive hundreds of emails each week—ranging from work-related updates, personal messages, important documents, and even spam. With so many emails flooding your inbox, it can quickly become chaotic. Some emails are urgent, some are for reference,

        • Create vendor via API

          The Zoho Books web ui has an option to add a new vendor. Though I can't find an API to create a vendor. Is there an API available for creating a new vendor? Regards, Vinod

        • Function to check frequency of customer ordering patterns

          Hi, I'm no coder, so I thought I could make use of Chat GPT to generate some Deluge script to create a function that would check order frequency of our customers so that I could send an email if they go beyond their usual order pattern. Chat GPT and Claude

        • Customization of "List Price" naming convention

          Surely this has been brought up before, but does Zoho plan to allow the customization of the List Price field? For example, the ability to rename to: Sell Price Sale Price Market Price Ticket Price etc etc

        • Dashboard Analytics - Time to fill a job

          Hello! I'm creating a dashboard and want a chart that displays the recruitment SLA (time to fill) of job openings. I created a report that retrieves the SLA for each job opening. However, when generating the chart, the information does not appear as I

        • Zoho Desk - Archiving Contacts

          Hi, We have a lot of customers in Zoho Desk with associated contacts. When a contact leaves we want to be able to still have their tickets in our history as this is important. But we don't want to have all these contacts that no longer work for the company.

        • Zoho Desk integration with Power BI

          Hi, I want to be able to create a Power BI report which has live updates of ticket data from zoho desk, is this possile at all? Thanks Jack

        • Unified WhatsApp Number Management in Zoho Desk and SalesIQ

          Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers

        • Zoho books not accepting valid state code via api

          Hello, I am using make.com to create a contact and then invoice for a Shopify orders. However, while creating contact I'm getting "please provide a valid state code" error even though I'm providing correct state code. For example I'm providing MH as state

        • Create View to See Tickets Closed within the last 3 days

          I'm trying to create a view in Zoho Desk that shows me "recently closed ticket," which I will define as tickets closed in the last 3 days. I want this view to update so that whenever I click to view it is recalculates and shows me tickets closed within 3 days from that moment. When I try to Create a view and use the criteria of "Ticket Closed Time" I have to specify a discrete time frame (on or before a specific date). It doesn't allow me to define time/date dynamically like I can do with date fields

        • Next Page