Expanded Data Preparation and Modeling Capabilities in Zoho Analytics

Expanded Data Preparation and Modeling Capabilities in Zoho Analytics

Since launch, the integration of Zoho DataPrep within Zoho Analytics, has significantly enhanced the ETL (Extract-Transform-Load) capabilities. This integration allows users to connect, clean, transform, and enrich their data effortlessly—all from within Zoho Analytics.
Building on this, the release of Zoho Analytics 6.0 in September 2024 introduced even more advanced data modeling and preparation capabilities by fully integrating the latest enhancements of Zoho DataPrep within Zoho Analytics.

Key Features of Zoho DataPrep

Visual Pipeline Builder

Zoho DataPrep’s enhanced Visual Pipeline Builder streamlines data pipeline creation, enabling users to build, test, and execute workflows in minutes. Key improvements include:
  • Automated & Scheduled Workflows – Ensure continuous data readiness.
  • Optimized Processing & Transformation – Enhance performance and efficiency.
  • Advanced Data Operations – Merge, filter, and aggregate data seamlessly.
With an intuitive drag-and-drop interface, users can effortlessly design and manage complex data workflows.

Data Quality at a Glance

Easily assess your data quality using Zoho DataPrep in Zoho Analytics
  • Color-coded bars instantly show valid (green), invalid (red), and missing (gray) data.
  • Interactive charts to identify problematic areas quickly.

Smart Features for Efficient Cleaning

  • Smart sampling with four options (Initial, Random, Erroneous, or Column-based) to work efficiently even with massive datasets.
  • Intelligent suggestions that automatically recommend the best fixes for common data problems.
  • Comprehensive transformation library including deduplication, format standardization, empty cell handling, and pattern matching.

Process Management Made Simple

The workflow tracking features to stay organized:
  • Ruleset management panel to view, edit, or disable any transformation.
  • Clear visualization (Data Flow) of the entire data cleansing journey from import to export.

Why This is Helpful for Users

  • Time-Saving: Automate repetitive data preparation tasks and focus more on analysis.
  • Improved Accuracy: Clean and transform data with precision, ensuring high-quality outputs.
  • Scalability: Handle larger datasets with ease, thanks to the increased processed row limits.
  • Better Insights: Advanced data modeling capabilities allow for more comprehensive and actionable insights.

Data Processing Capacity

Integrated Zoho DataPrep feature usage will be measured based on the total number of rows processed per month. Each plan within Zoho Analytics offers inbuilt processing capacity.
The processing limits within Zoho Analytics have been set higher, compared to the Standard plan of Zoho DataPrep, enabling users to efficiently manage large datasets with greater flexibility.
Plan based processing limits:
  • Premium Users – Process up to 5 Million Rows per month.
  • Enterprise Users – Process up to 10 Million Rows per month.
These new integrated DataPrep capabilities make Zoho Analytics a more powerful and scalable platform, empowering users with advanced tools for seamless data management and analysis. Whether you're preparing data or building pipelines, Zoho Analytics provides the flexibility and performance needed to drive better decision-making.


      • Sticky Posts

      • What's New in Zoho Analytics - November 2025

        We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's

      • What's New in Zoho Analytics - October 2025

        Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme

      • What’s New in Zoho Analytics – September 2025

        Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

      • Announcing Agentic AI - Ask Zia!

        We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

      • Invitation-Based User Access in Zoho Analytics

        Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security

        • Recent Topics

        • Zoho Blog from Zoho Sites

          I keep receiving this error after trying to edit blog posts that were previously saved for posting at a later date: Additionally, I try to make new posts and they show this message, "Failed to save".

        • Help Center Home Tab Search Bar Description

          How do I change what it says above the search bar?

        • First Respons time questions regarding ticket SLA's, Ticket Re-Assignment, and Ticket Closure.

          I am chasing down a few outliers on tickets that my team is reporting to me seen in some of our Zoho Analytics Dashboards with regards to Zoho Desk with regards to First Response Time. Our support organization is setup with different SLA's based on three

        • Toggle Option for SQL Query Auto-Formatting

          We all write SQL queries in a style that makes them clear and easy to understand. However, I’ve noticed that Zoho Analytics sometimes reformats queries in a way that reduces readability - especially when editing existing queries written in a specific

        • payment configuration process

          payment configuration process

        • Lookups from Standard Modules to Custom Modules

          I have created an "External Contacts" Custom Module for adding Contacts who aren't directly associated with a Customer or Vendor but who are related to Orders by being a Site Contact, Job Contact, Warehouse Contact, etc for third party. How can I go about

        • Run automation on quiz completion

          Hello, We're exploring Zoho Learn as a possible solution to creating some training courses to external users on our system. We'd like to run a workflow/ integration to Zoho CRM when a course is completed. Is this possible?

        • Dynamic user applications for CPQ?

          Hi, I've been enjoying getting to know CPQ, the Product Configurator and Price Rules components have been very useful, albeit with some issues. I have noticed that I don't have the power to decide which level of sales staff has permissions when it comes

        • Need details on search criteria for zoho.crm.searchRecords

          Hi, If I understood correctly the integrated functions (getRecords, searchRecords, etc..) I can use inside Functions in Zoho CRM are actually using the Zoho CRM V2 API. I am looking for all the field types and criteria I can use with searchRecords. The

        • Do my notebooks get transferred to a new phone?

          Hello I was wondering about a new phone and I'd like to know whether your notes are automatically transferred to the new device? Regards Will.

        • Client Script Error - Cannot read properties of undefined (reading 'CRM')

          Hi Guys I have a custom form, and I have a client Script set for onLoad of the new form. Below is the script I have defined and the error: Cannot read properties of undefined (reading 'CRM') See Screen Shot Attachement for Details. Here is the Script:

        • Notebook sync

          Hi,After Restart Mobil-Phone since i pressen „Synchronisation“ in my Notebook-App (iPhone) the App is hanging all the time and I have no possibility to Break up. Also Not After Restart my mobile-Phone. After the Restart ( inkl. Connection to WiFi or mobile

        • Employee survey data when the survey creator's account is deleted

          I can’t find in the documentation on this topic, so asking here. When the employee who has created an Employee Engagement survey leaves the organisation and their Zoho account is deleted, will the survey results still be accessible to other persons if

        • DANE IS NOT implemented

          According to the answer of @Sagar S , "DANE has been implemented". on this topic Allow me to disagree, DANE is not implemented at least not to the EU area. The Zoho domain is not under DNSSEC protection and the related TLSA DNS records

        • Enhance Your CRM Experience with Zoho Webinars in Sandbox Environments

          Greetings all, Zoho Webinars will now be available for testing and deployment in Zoho CRM's sandbox environment. Sandboxes offer a safe way to replicate production environments and enable risk-free testing, training, and refining processes before making

        • Increase the elegant comparator to more than 5 users

          Hi Team Requesting to increase the elegant comparators number of custom users to more than 5, this is such a crucial tool in dashboarding but 5 users is simply not enough.

        • No emails coming in

          Hi, I am not receiving any emails, I have tried to send myself an email from another acct and I am not receiving anything, possibly for the last few days. Bit desperate as we are a nursery and not getting important emails from our parents.

        • Problem with Schedule Email parameters in "Send Reply to an Email" API

          Hello, This is my Json script: { "fromAddress": "test@gmail.com", "toAddress": "{{8.fromAddress}}", "subject": "{{8.subject}}", "content": "{{4.result}}", "action": "reply", "isSchedule": true, "scheduleType": 6, "timeZone": "Europe/Lisbon", "scheduleTime":

        • What's New? - May 2025 | Zoho Backstage

          Hi everyone, A May-zing month for you! As summer rolls in and event season picks up the pace, we’ve been working on a set of updates in Zoho Backstage to help make your day-to-day life a little easier. This month’s improvements are all about tackling

        • Integrate Zia AI into Zobot with Support for Hebrew and Bot Context

          Dear Zoho SalesIQ Team, Greetings. We would like to submit a feature request that would significantly enhance the functionality and intelligence of Zobot: native integration of Zia AI into Zobot scripts and blocks—with full support for Hebrew language

        • Mail Merge: Need Transparent Background for Signatures

          I'm using ZohoCRM and Zoho sign to send documents to customers to sign. We use zohoCRM's "Mail merge" option to create the templates. The problem is that those "Signature" fields have a solid white background so it looks like a stamp on the page instead

        • Zoho Flows

          Basically I can't build a connection that works between Excel on OneDrive and Zoho. I wanted to have 1 flow checking on a row added to an excel file and then intiate an import of that row. I'm doing that manually now and thought that this could be automated.

        • Zoho time tracking with automated screenshots

          Time tracking option with automated screen shots would be an exeptuonally good feature, any plans to develop something like that?

        • Sharing my portal URL with clients outside the project

          Hi I need help making my project public for anyone to check on my task. I'm a freelance artist and I use trello to keep track on my client's projects however I wanted to do an upgrade. Went on here and so far I'm loving it. However, I'm having an issue sharing my url to those to see progress. They said they needed an account to access my project. How do I fix this? Without them needing an account.

        • Zoho Campaigns Forms not Responsive on Website

          I have a mobile responsive Zoho Sites website and when I add a Zoho Campaigns form, it is not responsive. I have used the website code and ensured that the 'responsive' checkbox is selected. But, the form is not responsive to mobile. I have attached a

        • Oldest mail on top?

          I am old, and probably missing something simple, but how do I flip my zoho mail so oldest mail is on top?  Thanks in advance, and a HUGE thank you to the entire ZOHO team.  You just keep getting better!

        • Desk API to add or change commenterId to a comment

          Please let me know how to add comments on tickets for different agents using the API. When adding a comment it will take commenterId but then ignores that and used the API agentId. Did not see in API docs which values are readonly. I pleased to see commentedTime worked for past times. Regards, Glenn

        • How send a ticket attachment using the Sendreply API in Zoho Desk

          API document references : you make use of the Upload file API and gather the attachment ID. This ID is be passed with the Send email Reply API to deliver responses with the attachment intact. Code template is as below: // ORGID ORGID = "XXXXXXX"; // Masked

        • First Insight - Find your Fields

          The Wheels of Ticketing - Desk Stories Find your Fields What are fields? Fields are crucial in ticketing modules that capture information about Tickets, Customers, Organizations, Products, and more. Depending on the kind of data being stored, users can

        • Automation#30: Auto-Update Time Entry to the Nearest 5 Minutes

          Hello Everyone, Time tracking is a feature in Zoho Desk to help businesses stay organized and efficient. For Zylker Techfix, this feature has helped to track the duration of gadget services to generate accurate bills. However, Zylker Techfix faced a unique

        • Email adding to existing ticket

          hello Is there some syntax i can add e.g. to the subject line / body of my email that when it reaches the Zoho portal will add the request to an existing ticket. e.g {123} Currently if i have an open ticket and a customer emails me direct, i then forward

        • How to define different shift timings for each weekday in Zoho People?

          Hi everyone, We’re using Zoho People for attendance tracking and need to configure a standard 39-hour workweek that is structured like this: Monday to Thursday: 8 hours per day Friday: 7 hours Currently, our service provider has set up the workweek as

        • add two date range

          Hi, How can I add two date range selections to compare two different column values in a single pivot view? I have attached a snap for your reference.

        • Announcing new features in Trident for Windows (v.1.26.5.0)

          Hello Community, Trident for Windows is here with exciting new features to elevate your email communication and enhance productivity. Let’s dive into what’s new! Open .eml files in Trident. You can now open .eml files directly using Trident. This makes

        • Adjust The max character in Specification Field

          Is there another way to adjust the maximum character limit for the Specifications field in Zoho Commerce? I need to accept responses with fewer than 200 characters.

        • Customize the Sign In And Sign Up in Zoho Commerce

          Is there another way to customize the Sign In and Sign Up in website Zoho Commerce like this i want to customize to edit it like change the "Sign In" word into "Login Zoho Commerce" it is possible or other way to do that?

        • Territories : Deluge and APIs

          I am trying to work out how to filter a deluge query by territory eg "SELECT Total_Amount, Stage, Closing_Date, Created_Time, Deal_Name FROM Deals WHERE Stage in (" + varBaseCriteria + ") AND Territory = 'Territory1'" The problem being that Territory

        • Tidying up messes file system on Site

          I'm been given access to a new site that's been managed by several different people over the years, each with different ways of managing images and files. If I move an image from one folder to another, it shows a missing image icon on the site's page.

        • Move Archive Button in Zoho Mail to Main Toolbar?

          Is there a way to add the Archive Button to this tool bar so I don't have to click the three dots every time?

        • Introducing Bigin 360: Our new pricing edition with increased feature limits and pre-installed toppings

          Dear Biginners Club, Today, we're pleased to launch a brand-new pricing edition called Bigin 360, our highest pricing edition that will sit on top of Express and Premier editions. It's been over four years since our launch, and we're receiving some great

        • Next Page