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.
Topic Participants
Nisha Angel J
Sellers
paul
César Pedrolini
Heike
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 teamWhat'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 dataWe 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 constructingZoho 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
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.Kaizen #140 - Integrating Blog feed scraping service into Zoho CRM Dashboard
Howdy Tech Wizards! Welcome to a fresh week of kaizen. This week, we will look at how to create a dashboard widget that displays the most recent blog post of your preferred products/services, updated daily at a specific time. We will leverage the potentialSchedule meeting monthly on a particular day
Suppose I wanted to schedule HR meeting every month on the first Tuesday with each employee separately for 20 minutes each. How could I automate these type of meetings? And if Sunday occurs on the first Tuesday I would like to shift that meeting on nextIn ZohoCRM Dashboards - Editing Shown Columns on Drilldown of Components
Hello! I'm working with some Dashboards inside of ZohoCRM. When creating a component (In this case, specifically a KPI Ranking Component), I'd like to customize which fields show when trying to drilldown. For example, when I click on one of the salesMultibrand Help Center - Share knowledge base catgories between multiple departments
Hello, I would like to know if it is possible to share categories between multiple departments when the multi brand feature is enabled. So that then one portal exists per department, but certain categories are visible in multiple portals. After all, weAdded Domain but SSL is not being set properly
We added a Domain for our landing page and it pushed an SSL cert to it. The Cert is generated by LetsEncrypt, but it doesn't match our subdomain (i.e., it's just pointing to zohosites.com). How do we get the cert properly setup there?Zoho CRM Widget not displaying 2 related lists (JS)
Okay so I basically have 2 relatedLists that I want to get and render: ZOHO.CRM.API.getRelatedRecords({ Entity: data.Entity, RecordID: data.EntityId, RelatedList: "Notes", page: 1, per_page: 200, }) ZOHO.CRM.API.getRelatedRecords({ Entity: data.Entity,Sharing Knowledge Base articles across multiple departments
It would be useful to share some Knowledge Base articles across multiple departments where they are applicable, rather than having to go into other departments to find the article you're looking for. For example. Our reception uses the 'Admin' desk whereas our IT guys use the 'Support' desk, however both divisions would find KB articles about our company intranet useful. Reception does not have access to the support desk, so cannot see articles created in the Support KB. Perhaps you could installIteration through a list - Coming up against a "Failure to update function" error
Hi there! I've been attempting to get a deluge script working and am running into an error that I have been unable to resolve. The error I am getting is Failed to update function Error at line :18. Improper Statement. Error might be due to missing ';'KPI widget with percentage
I'm trying to create a KPM widget that displays current performance as a percentage - something like the picture below. I've tried following the instructions at https://www.zoho.com/analytics/help/dashboard/kpi-widgets.html#chart but nothing ends up beingCanvas List View Not Saving
Hi, I am trying to edit a list view to look different depending on the tags. Everything worked well and saved well with multiple views, but when I have gone back in to make some small changes like moving one of the icons it comes up with the error messageTeam Inbox is not working AGAIN
I like Team Inbox in general. It makes using a collaborative inbox easy - when it works. The problem is that it doesn't work at times - and it seems to not work, a lot. It's not catastrophic failure, it's little things. Unable to send messages UnableQR code image is not exported in PDFs
The new QR code field works fine when I include it in a report template and I choose the print option: https://creatorapp.zoho.com/<username>/<app_link_name>/record-print/<report_link_name>/<record_ID>/ But when I try to save the document to a .pdf fileQR codes in templates
I'm excited about the new QR code generator. I have included a QR code that contains the record ID setting "${ID}" as input data. In the report detail it works perfectly but when printing it in a template the code is not shown.This mobile number has been marked spam. Please contact support.
Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?geographic search filter in map view
Hi, I have a recruiting and timesheet system built in Creator. The client wants to enhance the search for candidates based on their location and filter by job skills - currently they look on the Map View which uses the geo location or post code of theReal Estate CRM
How can I tailor my CRM for real estate? I had seen an image where the CRM included property tabs.Zoho CRM search not working
The search bar is not showing any results in our CRM installation. We have a lot of items and can not search them by using the navigation each time. Can someone please check this asap.Reload page with widget
Hi all, I hope I can find some help here. I developed a small widget for Creator that is integrated into a page as a component. The page contains other content as well. When the widget is sent, the entire page should be reloaded to apply the changes toTip of the week #37 - Manage all your Telegram business conversations directly from your shared inboxes.
Tired of switching between multiple apps to manage your business conversations? With Zoho TeamInbox's multichannel inboxes, connect your Telegram channel to a shared inbox. This way, your teams can easily handle c View, reply, and collaborate on themTags on notes aren't syncing correctly on Android
I've created notes on the desktop version that have several tags assigned, but on both my Android devices those notes only have ONE of those tags instead of all of them, despite the actual content of the note being correctly synced, and I'm also startingReports - custom layout - duplicate report
Do you also have this problem and what is the possible solution? I duplicate a report that has a "custom layout". Unfortunately the custom layout is not duplicated. To be improved for a future release by Zoho. I export the custom layout and import it..."Copy Field Values from one Module to another" how to use?
Hi everyone! I'm sorry if this question was already asked, I didn't find it! So let me explain: In my Tickets module, we have the custome field "customer type" where we indicate if it's a lead, user, etc... In the Contact module I used the "type" field with exactely the same entries. I would like when in the tickets module an operator choose an option that it automatically update it in the contact module. I found the "Copy Field Values from one Module to another" custom function which seems perfectHow to map a global picklist from one module to another
Hi there, i currently have a new field that is called sales office which we use for permission settings between our different offices located in different countries. It is a global set picklist with three different options: MY, SG and VN. I want to bePageless mode needed to modernise Writer
When we switched from GSuite to Zoho, one of the easiest apps I found to give up, was Docs. In many ways, Writer has always been more powerful than Docs, especially in terms of workflows/fillable forms/etc. However, I went back into Docs because I noticeChanging the Logo Size on Zoho Sites
My company logo incorporates both an image and text, and I would like it to be much more prominent on the page than is currently allowed by the small logo box in the template. Is there any way to hide the page name and then make the logo box much bigger since my company name and logo are connected / are all in one file? Thank you.Is it possible to Select Item Serial Numbers from a Sales Order?
Our accepted estimates are converted to Sales orders for our warehouse staff to pick. How can my warehouse staff select the serial numbers for an item when editing a Sales Order? Logically when staff pull an item and have the serial in front of them they update the Sales Order and select the serial. I understand a serial can be added when creating an invoice but how can accounts team know the serial if the warehouse staff can't select it! A basic flaw!MORE BUGS: Client Script, Deluge and Widget JS SDK don't work as expected when trying to retrieve a record that has been "rejected" as part of an approval process.
Client Script $Page.record is null when accessing a record that has been "rejected" as part of an approval process. Deluge zoho.crm.getRecordById(moduleName, recordId) returns {"status":"failure"} when recordId is a valid, but rejected record. OK... IZoho CRM Widget not displaying 2 related lists (JS)
Okay so I basically have 2 relatedLists that I want to get and render: ZOHO.CRM.API.getRelatedRecords({ Entity: data.Entity, RecordID: data.EntityId, RelatedList: "Notes", page: 1, per_page: 200, }) ZOHO.CRM.API.getRelatedRecords({ Entity: data.Entity,Recurring Events Not Appearing in "My Events" and therefore not syncing with Google Apps
We use the Google Sync functionality for our events, and it appears to have been working fine except: I've created a set of recurring events that I noticed were missing from my Google Apps calendar. Upon further research, it appears this is occurringZoho Books and Zoho Projects Task Status Update
How can we create an automation using custom functions for the following scenario. When our zoho books invoice status changes to paid. I want a task in Zoho projects to change to completed.Different content per social media account..
Is there a way to add different content per social media account on one post?Assigning Tasks and Requests to Groups... how do I?
Guys, I've spent many hours exploring Zoho Support and we are generally satisfied with the system. I'm trying to understand how a system that has so much to offer can be missing GROUP assignment and queue functionality. I am hoping that there is a wayParsing of SQL query failed. Please check the SQL syntax.
I am trying to have Zoho Analytics recognize that if the a Deal is in Stage "Need Docs" it should also be counted as a Deal in the Stage "New Lead" /*New Lead*/ SELECT "ID" 'New Lead' AS "Stage" From "Deals" Where "Stage" = 'Need Docs' Union All ErrorWhere is the setting to enable/disable 2FA?
The following links show where enable/disable 2FA is supposed to appear, but neither appear for me: https://help.zoho.com/portal/en/kb/zohosites/faq/account/articles/how-do-i-enable-or-disable-two-factor-authentication-for-my-account shows Security >How to Assign Record Ownership in a Custom Form via API?
Hello everyone, I’ve created a custom form in Zoho People and I’m using the API to manage its records. I would like to know how I can assign ownership of these records to specific users via the API. Is there a specific parameter or field in the API requestCustomer Statement Template not matching when sending
Hi everyone! So when I send statements to our customers via Zoho Books, the message that appears by default does not match what I have written on the template Under settings -> email notifications -> sales -> customer statement We have a single defaultWorking with keywords
Hello everyone, first time here so I will try to be brief. I am working on my company's data set. I have a table with all the images we have on line. For each image we hava a cell tha contains all keywords related to that image. I would like to exploreUnlocking New Horizons: A Year in Review
As we bid farewell to 2024, let's celebrate and revisit the key highlights of the year. From adding a new edition to cross-platform enhancements, here’s a roundup of all the feature updates designed to simplify accounting, optimize financial management,Peppol Malaysia API
Hi Zoho Books, my country Malaysia will going to implement "Peppol" (E-Invoicing), starting 1 Jul 2025 for all businesses. The government intends to provide API for accounting app. The workflow involves creating an invoice from accounting app, triggersNext Page