Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Time for action – matching projects


Matching projects applies the matching policy in the Knowledge Base to an existing dataset and provides output that can be exported in different formats. In this example, we will create a matching project to apply the matching policy of the previous example to a dataset and we will see the options for exporting data. Perform the following steps:

  1. Create a new data quality project and name it Sample Matching Project for PacktPub_Movies. Use the PacktPub_Movies_KB Knowledge Base for this. Select activity as Matching and click on Next.

  2. In the Map step, select source as Excel, file as MoviesSampleData.xlsx, and map Director and Title from the input columns to the Knowledge Base domains.

  3. In the Matching step, click on Start to apply matching policy on the dataset. You will see a view of matched and unmatched data rows; click on Next.

  4. In the Export tab, set destination type as Excel, export the results of matching and survivorship to different Excel files, and export...