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

    • 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

    • Zoho Analytics: 2021 Look Back

      As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021

    • [Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022

      Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution.  Hear more from Claudio Cabeza, Director at PREMO

    • Recent Topics

    • Dúvidas do Zoho Creator

      Pessoal, Estou colocando um tópico para dúvidas do Zoho Creator. Um abraço, Leandro

    • Tropicalize Books

      Books is an incredibly powerful tool that works well in many countries. But I feel that it is a product that is not yet "tropicalized" for Brazil as we speak (this would be like adapting the local reality). We have many strong competitors who do more

    • Automatic Sitemap Generation

      Guys are all right? Doesn't make sense for me to have to generate a map site and upload it... because it's not automatically generated just as it is done in WIX? where the customer doesn’t have to worry about this.

    • SEO improvements with ZIA

      Are you okay? I would like to bring an idea that would be amazing to improve the product that is the possibility of being able to improve the SEO of the pages (this of each page or each article on the blog) through ZIA so that it could create page Summary

    • Automatically updating field(s) of lookup module

      I have a lookup field, which also pulls through the Status field from the linked record. When the lookup is first done, the Status is pulled through - this works perfectly. If that Status is later updated, the lookup field does not update as well. As

    • Initiating a SalesIQ Zobot from a custom button on Zoho Sites

      I have created a Zobot set to initiate on a custom action called "Fast_Answers". On Zoho Sites, I created a code snippet button and set it to on-click run the event called "Fast_Answers". I installed the SalesIQ integration code into the Zoho Sites Page

    • Zoho Desk -> Zoho Analytics : Where is the field for "Layout" ?

      I have many different layouts on my helpdesks and I want to be able to identify the stats for each one, however I can not file the field in the raw data from the Zoho Desk datasource. I thought it might be under "Tickets" but there is nothing. There is

    • Set resolution mandatory field

      Hi,  i have 2 questions:) : - i want to set the resolution field mandatory before close the ticket. Because for now, i can close the ticket without writing how i solve it - how can i setup zoho desk to receive ticket by email(e.g. clients sent email to support@mydomain.com) and it create a ticket in zoho desk

    • Impuesto automatico en cotizaciones

      Buen dia Mi pregunta es como se puede poner alguna operacion para que las cotizaciones me salgan automaticamente con impuestos ya que uno al cargarla al final tienen que añadir el porcentaje de impuesto Saludos

    • Zoho Assist "Agree and Download" Button "Greyed Out" ("Light Blued" Out)

      Anyone else having issue where support clients are unable to click "Agree and Download" to access the client so that we can provide remote support? This is for "on demand" support via accessing the support page and entering the support key and name. This

    • Project Billing with the Staff Hours Method in Zoho Projects

      The Staff Hours Billing Method in Zoho Projects allows you to bill your clients based on the actual time spent by each team member on a project, at the rate set for each user. This is useful for projects where different skill sets are needed and service

    • Creator Subform to CRM Subform

      Hello all, Has anyone successfully written data from a Creator Subform into CRM subform? I have been able to get the rows to populate but none of the data will come through. I'll add my code and the result in CRM. Creator Subform is 'Delivery_Receiving_Hours'.

    • custom fields not populating from deluge script into invoice

      Hello, I've created some Deluge script that is meant to take a few inputted invoice custom fields and calculate a few others. I can see when I execute the function that my inputted custom fields are being passed, yet im still ending up with all "null"

    • tax summation function - getting error

      Hello, I'm trying to create a function that adds all of individual tax rates from a few jurisdictions. I'm getting an error on line 9 - Value is empty and 'get' function cannot be applied. I've checked that I have data in each of the required fields,

    • Backstage / Zoho Books integration

      Hello. We have Zoho One and have slowly started using Backstage. Loving it. Problem is, we have ZERO accounting control over what is sold through this product. When will we be able to connect it to our existing Zoho Books tenant? Thank you very much!

    • Getting list of calendar events over api for zoho mail calendar

      Hi, I am using just Zoho mail without using Zoho CRM. I wanted to get all events booked in my zoho mail calendar through an api at regular intervals. I could find such API support for Zoho CRM calendar but not for zoho mail calendar. Can you kindly let

    • Allocate emails to user in a shared mailbox

      Hi, This might be obvious, but I cannot find the answer. I have 3 shared mailboxes so any team member can see the emails. Is there a way of allocating a specific email to a user so that it is their responsibility to deal with it? Thanks in advance.

    • Introducing Zoho Campaigns' own gateway for SMS campaigns

      We are excited to announce the launch of our SMS Gateway to send SMS through Zoho Campaigns. We have also made a few other changes in our current SMS Campaign model to improve your over all user experience. These updates are planned with an aim to expand

    • Update a lookup field in CRM from Creator using deluge

      I have a Creator form that creates a new account. When it creates the new account in the Accounts Module, I need it to also populate the Parent Account, which is a lookup field coming from the Module Parent Accounts, field Parent Account Name. I have

    • SMS Keyword Tracking in Zoho CRM From Zoho Campaigns

      Is there a way to track SMS leads in campaigns by associating them with specific keywords or codes? Additionally, can these leads be pushed to the CRM while retaining the keyword for tracking and reporting purposes?

    • Projects Multiselect API

      Having troubles setting a mutli select field via API. updateMap = map(); updateMap.put("UDF_MULTI1","picklist_id1,picklist_id2"); updateProjectRes = invokeurl [ url :"https://projects.zoho.com/restapi/portal/XXXX/projects/" + projectID + "/" type :POST

    • Bill quantity received / PO quantity

      PO's are raised & often the quantity received is greater than the PO quantity, so when we receive the bill & adjust the quantity on the bill we get.... Quantity recorded cannot be more than quantity ordered. This necessitates the adjustment of the PO

    • ZOHO BOOKS - RECEIVING MORE ITEMS THAN ORDERED

      Hello, When trying to enter a vendor's bill that contains items with bigger quantity than ordered in the PO (it happens quite often) - The system would not let us save the bill and show this error: "Quantity recorded cannot be more than quantity ordered." 

    • Adding Bluesky channel

      Hello, Is Bluesky (AT protocol) soon added on Social ? Bluesky is being developped and is now open to anyone (no more invitation) Thank you

    • Using Queries with dynamic parameters in Kiosk Studio

      Hi, I'm pretty new when it comes to developing within Zoho (I'm really a .NET developer), as it was just added to my responsibilities. For a new feature in the CRM, I'm trying to develop a Kiosk function to show a list of records (retrieved by the new

    • Unused items should not count into the available number of custom fields

      Hey, I realized that unused Items reduce the number of available custom fields. I can't see a case where that makes sense. Especially in our case where we have two different layouts in Deals with a lot of different fields, this causes problems.

    • Introducing Bot Filtering for Accurate Email Campaign Analytics

      Dear Marketers, We're excited to announce a new feature designed to enhance the accuracy of your email campaign analytics: bot filtering. This feature helps you filter out bot-generated opens and clicks, ensuring your campaign reports reflect genuine

    • Tip 37: Time Log Restriction in Zoho Projects

      Timesheet in Zoho Projects helps you big time in entering log hours for the tasks and issues and approving them. Now, with the new Time Log Restriction option, you can set daily and weekly log hour limits. You can restrict users from entering extra log hours than the permissible limit. The limits are restricted to 24 hours per day and 168 hours per week by default based on business hours. To customize, navigate to Task & Timesheet settings under Portal Configuration in Zoho Projects setup and enable

    • Chart showing schedule

      I want to be able to create a chart for everyday to check and which of which driver is available on the timeframe. Here's my table Name City Day Start Time End Time Driver1 Medicine Hat Monday 11:45 AM 4:45 PM Driver 2 Medicine Hat Tuesday 11:00 AM 7:00

    • Multiple Vendor SKUs

      One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for

    • In Zoho Projects, is there a way to create a folders template under documents that can be used once a project is created?

      We have a specific folder structure that we would like to use that is standard across every project. Instead of having to create this structure every time a project is created, is there a way to create a template for the folders that can be added?

    • Zoho Payroll in France

      When will Zoho Payroll be available in France ?

    • Blueprint - 'On hold' state with an automatic transition?

      I think I'm missing something here so I'm hoping if I explain what I'm trying to achieve someone might be able to give me a way around it. We sometimes get request far in advance but we don't want to action them unless it is 7 days from when they are

    • HOW TO VIEW INDIVIDUAL COST OF NEWLY PURCHASED GOODS AFTER ALLOCATING LANDED COSTS

      Hello, I have been able to allocate landed costs to the purchase cost of the new products. however, what i need to see now is the actual cost price (original cost plus landed cost), of only my newly purchased products to enable me set a selling price

    • Client Script: $Client.refresh({ triggerOnLoad: true }); not triggering onLoad Client Scripts

      Hey friends! I'm trying to store a temporary var, refresh the page for the user, then check that temporary var and do some actions. Theoretically using the title's code: $Client.refresh({ triggerOnLoad: true }); should refresh the page and trigger on

    • Calculate months and years between 2 dates on subform

      I am looking for a function syntax for an employment candidate to calculate the number of years and months (decimal format. eg 1.2 years) they are employed. I have their start date entered, but if the end date is blank, that tells me they are still employed

    • Combine related grouping values into categories in CRM analytical components

      Hello everyone, Analyzing large datasets can be challenging when dealing with numerous individual data points. It's often difficult to extract meaningful insights when information is scattered and ungrouped. To address this, we're adding options to create

    • How Kiosk Studio can simplify sales for bank employees | Kiosk Studio Session #4

      Hello everyone, Banks can boost revenue by cross-selling to their current customers. For example, they can sell credit cards, personal loans, and more to existing account holders. To do this, bank employees move all around the CRM, open and close records,

    • Tip #19 - Create checkbox tracker in your spreadsheet

      Hello Sheet users! We are here with yet another tip to help you get the most out of Zoho Sheet. Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically? Here's a sample

    • Integrate Oracle with ZOHO CRM

                           Please let me know if its possible to Integrate Oracle with ZOHO CRM. If yes then help me in doing it. 

    • Next Page