We are excited to announce the launch of ×îв©²ÊÍøÕ¾ DataPrep - An advanced self-service data preparation and pipeline service.
Introducing ×îв©²ÊÍøÕ¾ DataPrep:
×îв©²ÊÍøÕ¾ 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 ×îв©²ÊÍøÕ¾ Analytics, or to any data warehouses.
Data Preparation with ×îв©²ÊÍøÕ¾ DataPrep
Using ×îв©²ÊÍøÕ¾ 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 ×îв©²ÊÍøÕ¾ 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.
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.
Transform 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.
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.
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.
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.
What's new in ×îв©²ÊÍøÕ¾ 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.
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.
System-wide search powered by ZiaÌýÌý
Zia, ×îв©²ÊÍøÕ¾'s AI assistant for business is now integrated with ×îв©²ÊÍøÕ¾ DataPrep and it helps you to perform a system-wide search of all your data.
Advanced ÌýFilters Ìý
Cleanse data using complex data filters based on wildcards, patterns, data quality, regex and 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.Ìý
We've been hearing great things from our early adopters
"From the time we got access to ×îв©²ÊÍøÕ¾ DataPrep we have put our IT team to the task of integrating our call center data into ×îв©²ÊÍøÕ¾ DataPrep, so that when we push it to ×îв©²ÊÍøÕ¾ 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 ×îв©²ÊÍøÕ¾ 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 ×îв©²ÊÍøÕ¾ 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 ×îв©²ÊÍøÕ¾ DataPrep to automate data preparation."
Claudio Cabeza
Business Development Director, Grupo Premo
We welcome you to try ×îв©²ÊÍøÕ¾ DataPrep with a free 15-day no-commitment trial and reduce up to 80% of the time spent in preparing your data.
Comments