Self-Service Data Preparation with Data Preparer
Data Preparer explores how data sources relate to each other and a target table, and populates the target from the sources. In Data Preparer, you describe what you need, not how it should be produced. As a result, there is no more scripting or hand crafting of workflows. Here, Data Preparer is illustrated integrating data from London open government data sets.
You can see Data Preparer in action in the videos in our YouTube channel, or read on for the steps involved in wrangling data.
Step 1: Define the target
Describe a table and its attributes that are to be populated with data from several different sources. In this example, we are interested in social factors influencing attainment data about schools.
Step 2: Identify the sources
Identify source files or database tables that together can contribute to the population of the target. In this example, several (not always relevant) data sets are available.
Step 3: Define the data context
Identify example data or reference data sets that align with target attributes. In this example, we have access to information on the areas of interest.
Step 4: State preferences
Specify the data quality properties that you would most like to have satisfied by the target. In this example, the goal is to maximise the completeness of the result table and specific attributes.
Step 5. Wrangle and View Result
Press wrangle, and the target is populated with an end product from the sources.
Step 6. Examine and Refine
Examine the result and how it was produced. If not as required, change preferences, give feedback or steer the wrangling process.
How different was that?
- The target has been populated without any code being written.
- Data has been combined from several sources.
- Data Preparer can search thousands of ways of combining sources.
- Configuration of data preparation is independent of the number of sources.
- The provenance of values in the end product is captured automatically.