A data quality service applies business logic to data contained in Microsoft Excel worksheets. Excel users and data quality developers work together to define the business logic for data quality services.
The following steps describe the process of creating and using data quality services:
An Excel user identifies data quality requirements including information about input data, the types of data quality operations required, and the expected output.
The Excel user provides the data quality requirements to a developer.
The developer creates the data quality service and provides the Excel user with a URL or file path for the web service.
The Excel user adds the URL or file path to Data Quality for Microsoft Excel to store a link to the service.
The Excel user selects Microsoft Excel data to use as input for the data quality service and sets the service output options.