Launch of Self-service Data Preparation Service – Zoho DataPrep

We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and pipeline service.

Zoho DataPrep

Introducing Zoho DataPrep:

Zoho DataPrep helps organizations prepare high-quality data by automatically identifying errors, discovering data patterns, cleaning, transforming, and enriching data, all without the need for any coding. It also helps in setting up data pipelines to sync prepared data to Zoho Analytics, or to any data warehouses.

Data Preparation with Zoho DataPrep

Using Zoho DataPrep you can connect, cleanse, transform, enrich, schedule, and export your data with ease. You can also catalog and manage how the prepared data is consumed with fine-grained controls.

50+ data sources

Import data into Zoho DataPrep from 50+ data sources, such as files, feeds, FTP servers, cloud storage, databases, and data warehouses, making it easier to bring your data together.

Zoho_DataPrep_Import_Sources

Cleanse and improve data quality

Automatically profile data to view data distribution, statistics, outliers, and data quality.  Cleanse and improve data quality by removing duplicates, fixing invalid data and missing values.

Zoho_DataPrep_CleanseTransform and enrich data

Use AI-powered intelligent suggestions to apply over 250 transforms and prepare your data. Take advantage of machine learning models to enrich data with sentiment analysis, language detection, keyword extraction, and more.

Zoho_DataPrep_Transform

Data lineage

Track every transform applied to your data using ruleset. Modify, disable, or remove any transforms at any point in time, and reuse rulesets to apply the same set of transforms in other datasets, and automate data preparation.

Zoho DataPrep Data Lineage

Data catalog

Catalog and manage datasets by categories, custom tags, data quality, data readiness, and more. Perform a system-wide metadata search powered by Zia to improve discoverability.

Zoho DataPrep - Data Catalog

Setup end-to-end data pipelines

Organizations continue to gather data every day and cleansing data is never a one-time task. Set up pipelines by automating the import, preparing data using rulesets, and export to destinations. The status of the schedules can also be monitored, and you can also get notified if there are any changes to the data quality.

Zoho DataPrep - Data Pipelines

What’s new in Zoho DataPrep? 

We had a successful open beta run and we want to thank all beta users whose valuable feedback helped us improve the product over the last few months. We have also enhanced the product with lots of features during the beta to make data preparation even easier and more robust. Here are some highlights.

20 new data sources

Apart from the data sources such as files, feeds, local databases, cloud databases and cloud storage services we already support, we have now added more data sources like Amazon S3 and local databases such as Pervasive SQL, DB2, Exasol, SQLite, and many more. Learn more

Zoho DataPrep - New Data Sources

Pivot transform  

The pivot operation distributes the data for easy consumption. It spreads out the data in long, winding tables by converting categories in rows into columns. Learn more

System-wide search powered by Zia  

Zia, Zoho’s AI assistant for business is now integrated with Zoho DataPrep and it helps you to perform a system-wide search of all your data. Learn more

Advanced  Filters  

Cleanse data using complex data filters based on wildcards, patterns, data quality, regex and more. Learn more

Window functions  

Window functions enable you to perform summations and calculations based on a rolling window of data, relative to the current row. Unlike normal aggregate functions, the window functions keep the original rows intact and add the result as a new column. Learn more

We’ve been hearing great things from our early adopters

“From the time we got access to Zoho DataPrep we have put our IT team to the task of integrating our call center data into Zoho DataPrep, so that when we push it to Zoho Analytics, we should be able to offer metrics and data at the customer level. Being able to do this will change the way we do business, and allow us to be competitive in a space not possible before — without crippling fees for dynamic coding. Our eyes are firmly on the future now, thanks to Zoho DataPrep.”

Marc Fishman
Director of Sales and Marketing, Call Center Sales Pro

“We spend a lot of time writing and maintaining custom scripts to import data, fix errors and transform the data. Using Zoho DataPrep, we easily found the errors in the data and fixed them all from within the tool. We are now looking to eliminate manual scripts and use Zoho DataPrep to automate data preparation.”

Claudio Cabeza
Business Development Director, Grupo Premo

 

We welcome you to try Zoho DataPrep with a free 15-day no-commitment trial and reduce up to 80% of the time spent in preparing your data.

 

Sign Up to Zoho DataPrep

Leave a Reply

Your email address will not be published. Required fields are marked *

By submitting this form, you agree to the processing of personal data according to our Privacy Policy.

Related Posts