Data Preparer in Practice
Data Preparer explores how the 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 open government data sets.
Step 1: Define the target
Describe a table and its attributes that are to be populated by data preparation.
Step 2: Identify the sources
Identify source files or database tables that together can contribute to the population of the target.
Step 3: Define the data context
Identify example data or reference data sets that align with target attributes.
Step 4: State preferences
Specify the data quality properties that you would most like to have satisfied by the target.
Step 5. Wrangle
Press wrangle, and Data Preparer will populate the target with an end product from the sources.
Step 6. View Result and Refine
View the result. If not as required, change preferences or give feedback.
How different was that?
- The target has been populated without a single line of data preparation code being written.
- 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.