Data Preparer in Practice

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 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.
Close Menu