Zoho DataPrep is now integrated with Creator using Zoho Creator connector. The forms in Zoho Creator are used to collect and store data, serving as the main point of interaction between the created application and users. Zoho DataPrep allows you to seamlessly bring in the data in your Creator forms using the Zoho Creator connector and help you achieve data preparation requirements.
Zoho DataPrep is a data pipeline and cleansing tool to bring your data from various data sources, clean and prepare the data before pushing it to your preferred destination. DataPrep offers a comprehensive solution to model, cleanse, prepare, enrich and organize large volumes of data from multiple data sources to serve data analytics and data warehousing, ML, and more with exceptional data quality.
Data preparation
Data often imported from various sources contain a lot of issues such as duplicate data, incorrect data, old or redundant data, missing data, etc. You can use DataPrep to perform data cleanup, blend and join the data in Forms, remove duplicate records, cluster and merge data, find and replace data, and more.
-
Create a pipeline and connect to your data from 50+ data sources using Zoho DataPrep and import data.
-
Clean, prepare, model, transform, and enrich data using 250+ transforms, based on your needs.
-
Export processed data to Zoho Creator using Zoho Creator connector.
After adding a destination, you may want to try executing your pipeline using a manual run at first. Once you make sure manual run works, you can then set up schedule to automate the pipeline. Learn about the different types of runs here.
Let's look into a few use cases to see how Zoho DataPrep can help you clean your Creator data.
1) Zoho Creator → Zoho DataPrep (data cleaning) → Zoho Creator
Usecase : An XYZ Manufacturing firm encounters numerous data quality issues within its complex supply chain network which is maintained in a Zoho Creator application. These issues include duplicate data, missing data, inconsistent data formats, etc. This makes the company struggle to attain real-time visibility into inventory levels, demand forecasts, and logistics performance, hampering its ability to make well-informed decisions.
Requirements: Import data from Zoho Creator, clean data, and export it back to Zoho Creator
How Zoho DataPrep can help you clean data?Zoho DataPrep can help you clean and transform data using 250+ transforms, based on your needs. After cleaning data, you can seamlessly export the cleansed data to Zoho Creator using the Connector available in DataPrep. You can use the cleansed data to get reliable business insights and use it for data-driven decision-making.
➤ Clean the phone numbers in the dataset by removing the delimiters and standardizing using Transform by example.
➤ Export the cleaned data to Zoho Creator using the connector available in DataPrep. Now that you have added a destination, you may want to try executing your pipeline using a manual run at first. Once you make sure manual run works, you can then set up schedule to automate the pipeline. Learn about the different types of runs here.
2) Zoho Creator → Zoho DataPrep (data preparation) → Zoho Creator
Usecase: An online retail platform selling various tech products uses Zoho Creator for its order management system to handle customer orders efficiently in a form and in another form they have the customer feedback. The enterprise faces a decrease in customer satisfaction scores and an increase in customer complaints regarding order fulfillment. They lack insights into customer satisfaction data related to their orders due to poor data quality. Analyzing customer feedback using properly organized and good quality data has become an immediate need to fulfill their services to the unsatisfied users.
Requirements: Import the two forms data from Zoho Creator, join the data, clean and export it back to Zoho Creator
How Zoho DataPrep can help you clean data?
Zoho DataPrep helps you import the feedback form and orders form from Zoho Creator and join both the data. The combined dataset is sent to the Zoho Creator to create reports in Zoho Creator.
➤ Create a pipeline and import orders and feedback form in Zoho Creator using the Zoho Creator connector.
➤ Join both the datasets using a common id column.
➤ Zoho DataPrep can help find if the ordered date was a weekday or during the weekends to assess when the enterprise gets maximum orders. Use Formula Generator in DataPrep.
➤ Export the combined dataset to Zoho Creator using the connector available in DataPrep to perform analytics and derive accurate business insights for each order. Now that you have added a destination, you may want to try executing your pipeline using a manual run at first. Once you make sure manual run works, you can then set up schedule to automate the pipeline. Learn about the different types of runs here.
3) FTP → Zoho DataPrep (data cleaning and enrichment)→ Zoho Creator
Usecase: A company plans to hire human resources in two different regions. In each region they have the candidate details and feedback based on their first round. The company wants to analyse the interview feedback and filter out the shortlisted candidates from the vast list and trigger a workflow. The company wishes to consolidate, clean, transform and enrich data before pushing it into Zoho Creator, as they don't prefer applying post- migration data transformations and avoid the hassles of writing and executing the coding scripts.
Requirements: Import data from FTP server and cloud storage, transform, enrich, prepare the data, and export data to Zoho Creator using Zoho Creator connector.
How Zoho DataPrep can help you clean data?
Zoho DataPrep helps you import the data from FTP and cloud storage. Append the datasets, clean the data, and derive interview feedback using AI features like Sentiment analysis. You can use the enriched data to create reports in Zoho Creator.
➤ Apply append transform to consolidate the two datasets into one.
➤ Export the selected candidates data to Zoho Creator using the Zoho Creator connector. Now that you have added a destination, you may want to try executing your pipeline using a manual run at first. Once you make sure manual run works, you can then set up schedule to automate the pipeline. Learn about the different types of runs here.