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 – knowledge discovery


In this example, we will use an existing Excel file with data rows to enhance the Address KB Knowledge Base from the previous example. We will load new values for the Country, State, and City domains. This example will help you to understand process of knowledge discovery. Perform the following steps:

  1. Open Data Quality Client and then connect to the server.

  2. Under Recent Knowledge Base, click on Address KB. A pop-up menu will open; select Knowledge Discovery.

  3. The first step of knowledge discovery is mapping source data. Choose Excel File as Data Source. Choose the AdventureWorksSampleData.xls file as the source. Check the box Use first row as header.

  4. In the mapping section, map the input columns to the Knowledge Base domain as shown in the following screenshot:

  5. In the Discover step of knowledge discovery, click on the Start button to start discovery. You can also see profiling results in the Profiler section of this window. After completing this step, click...