Wrangling Data with Data Preparer

A serious tool to help data migrations and integrations ☺Written from people with serious DB background will analyze separate files and determine a schema and mappings to help data import. Development team adds a lot of new features. You will love the relational algebra schemata. ☹Its usage is not obvious you need to read or watch a video to understand what tool does and does not.

Go for it! ☺It’s easy to use and saves the user hours of work. The support team responds quickly and is willing to help you understand all the features of the Data Preparer. ☹It would be great if the Data Preparer could be used as a software as a service. But I understood from the support services that they are currently working on this.

An excellent solution for data pre-processing This was a very positive experience. A user can quickly learn how to use the software and prepare datasets from multiple sources in very short time. ☺The simplicity with which an inexperienced user can create a new dataset by combining attributes from multiple datasets. The ability to filter the mapped values thus combining joins with filters. Also the ability to set wrangling criteria. All these options allow a more precise data preparation from data management experts. The statistics and analytics that are available for the resulting data are very useful. The ability to combine data from multiple sources in the backend. ☹I would prefer having a few more visualisations of the resulting dataset. A workflow-like visualization of the data wrangling process would be useful.

Delivers what it promises I was able to get insights into large data files in a matter of minutes without using any code (did go through the youtube tutorial). Could be really handy for quick high level insights. ☺Easy to use, really simple and intuitive UI, Data Flow view, no-code, and its ability to handle large data files. ☹- Lacks the flexibility of Numpy/Pandas/Seaborn/Matplotlib stack. – Might not be useful to a moderate to proficient coder – Needs some more data visualization options – An interface to code and execute user defined functions might be useful.

Long-awaited product for data wrangling I’m a data scientist at the University of Manchester and I can see the potential that a tool like Data Preparer can have in saving time when preparing the data to be analysed. A process that can take a long time is now almost completely automated and, even so, with sufficient flexibility for the user to accomodate varied requirements for the wrangling process or for the end product. By making the wrangling process more efficient I can now dedicate more time to the data analysis and publication of my work. ☺The workflow of the software is intuitive and saves a lot of manual work in every step of the process. Simple configuration to adequate the wrangling process to the user needs whilst including the option to review the end product in detail for more experienced data users. ☹Although most of the complexity is hidden from the end user, some functionality (like the user context and control panel tabs) may look intimidating for those users with less experience in these topics.

Data Preparer in the social media world ☺The most important feature was the ability to combine multiple datasets and project the results into a single table. I could use large Twitter datasets combined with other datasets and review the results. I could include/ exclude certain fields and manage the data without the need to write any code. In this way I was able to add/ remove several datasets and create my main corpus dataset with minimal effort. ☹Perhaps you could add some extra reporting functionalities. For example, to describe a dataset instead of naming it the user could also have an option to “preview” its data. There could be a one page summary data export that could be exportable in pdf/csv format.

1 click quick insights on your data A few glitches here and there but overall a positive experience. ☺with 1 click you can upload your data and visualize the distribution of values across all fields with automatic identification of data dependencies (e.g., keys). It’s way easier than using Tableau or code your visualizations in a Jupyter notebook with, e.g., Seaborne. ☹Still no support for graph data and I would like to see cleaning rules being suggested.

A software for making better use of your data With Data Preparer, my data analysis is easier and faster, so I get my insights more easily. By saving time and effort, I can focus on even more complex data analysis tasks and keep finding ways to implement them in my Data Preparer workflows. ☺I had the opportunity to get early access to the Data Preparer software and was thrilled to get my hands on it. I have been traditionally using data coming from various sources (e.g. automated exports from databases) and in various formats, mostly spreadsheets. My issue has always been the fact that I had to use the same data for serving different purposes and users, and this requires a lot of manual work for transforming the data into the expected output each time. With Data Preparer I was able to easily define my expected outcomes and use the data to achieve that – without having to code (I do not code at all!) or to perform complex transformations and defining numerous rules. Thus, I save time and effort and by using the Data Preparer I can provide even more to the users I serve with the data. ☹So far I have not faced any issues. As with any other software, it takes some time to get used to it and explore its functionalities – so that you can make the most out of it. Data Preparer is easy to use and have not faced issues so far. If I had to suggest something, it would be the support of even more data types (in the future).

Nice first version of product, requires more features. ☺Ease of use. Works really well for merging datasets. ☹Couldn’t find a way to import data from multiple URLs (i.e. RESTful URLs with IDs). More types of datasources should be added.

Handling Data easily and smartly ☺Quite easy to use without the need to invest much in learning the software or how to treat data. The overall learning curve is rather shallow and everything is understandable. Transformation of data is quite useful and helpful for organisations that want to merge diverse data-sheets with the same content. ☹The product is quite good. One nice addition would be more AI in the future to automate tasks in mainstream data domains.