Tutorial:Data quality project using Address Check - Revision history

Admin at 19:19, 20 January 2014

2014-01-20T19:19:25Z

← Older revision		Revision as of 19:19, 20 January 2014
Line 150:		Line 150:

	[[Category:Tutorial]]		[[Category:Tutorial]]
	[[Category:Data Quality ~~Service~~]]		[[Category:Data Quality Services]]
	[[Category:Address Check]]		[[Category:Address Check]]

Admin at 22:19, 13 August 2012

2012-08-13T22:19:09Z

← Older revision		Revision as of 22:19, 13 August 2012
Line 150:		Line 150:

	[[Category:Tutorial]]		[[Category:Tutorial]]
	~~[[Category:Tutorials:Data Quality Service]]~~
	[[Category:Data Quality Service]]		[[Category:Data Quality Service]]
	[[Category:Address Check]]		[[Category:Address Check]]

Admin at 17:18, 16 July 2012

2012-07-16T17:18:00Z

← Older revision		Revision as of 17:18, 16 July 2012
Line 150:		Line 150:

	[[Category:Tutorial]]		[[Category:Tutorial]]
	[[Category:~~Tutorial~~:Data Quality Service]]		[[Category:Tutorials:Data Quality Service]]
	[[Category:Data Quality Service]]		[[Category:Data Quality Service]]
	[[Category:Address Check]]		[[Category:Address Check]]

Admin at 17:11, 16 July 2012

2012-07-16T17:11:20Z

← Older revision		Revision as of 17:11, 16 July 2012
Line 150:		Line 150:

	[[Category:Tutorial]]		[[Category:Tutorial]]
			[[Category:Tutorial:Data Quality Service]]
	[[Category:Data Quality Service]]		[[Category:Data Quality Service]]
	[[Category:Address Check]]		[[Category:Address Check]]

Admin: /* Export */

2012-07-13T22:05:09Z

Export

← Older revision		Revision as of 22:05, 13 July 2012
Line 151:		Line 151:
	[[Category:Tutorial]]		[[Category:Tutorial]]
	[[Category:Data Quality Service]]		[[Category:Data Quality Service]]
			[[Category:Address Check]]

Admin at 22:04, 13 July 2012

2012-07-13T22:04:03Z

← Older revision		Revision as of 22:04, 13 July 2012
Line 149:		Line 149:
	</ol>		</ol>

	~~[[Category:Help]]~~		[[Category:Tutorial]]
	:[[Category:Tutorial]]
	[[Category:Data Quality Service]]		[[Category:Data Quality Service]]

Admin at 22:02, 13 July 2012

2012-07-13T22:02:38Z

← Older revision		Revision as of 22:02, 13 July 2012
Line 81:		Line 81:
	</ol>		</ol>

	===~~Step 1:~~ Map===
			===Map===
	You must map your data source to the knowledge base.		You must map your data source to the knowledge base.

Line 99:		Line 100:
	</ol>		</ol>

	===~~Step 2:~~ Cleanse===
			===Cleanse===

	[[File:TUT_DQS_AddressCheck_01-09.jpg\|600px]]		[[File:TUT_DQS_AddressCheck_01-09.jpg\|600px]]
Line 109:		Line 111:
	</ol>		</ol>

	~~===Step 3: Manage and View results===~~

	~~[[File:TUT_DQS_AddressCheck_01-10.jpg\|600px]]~~		===Manage and View results===

	In this step you need to manage your data cleansing.		In this step you need to manage your data cleansing.
Line 117:		Line 118:

	The validity of records highly depends on what values you chose under '''Domain Management > Reference Data > Provider Settings'''.		The validity of records highly depends on what values you chose under '''Domain Management > Reference Data > Provider Settings'''.

			[[File:TUT_DQS_AddressCheck_01-10.jpg\|600px]]

			====Suggested====
			This tab contains the records that are invalid but have suggestions for correction.
			====New====
			This tab contains records that are not in the knowledge base and cannot be verified.
			====Invalid====
			This tab contains records that could not be verified and are invalid.
			====Corrected====
			This tab contains records that had invalid data and were corrected. When you approve records in the Suggested tab they are moved to this tab.
			====Correct====
			This tab contains records that have been verified as correct.


			Once you have chosen how to proceed with the data cleansing, click '''Next'''.

			===Export===
			In this step you export your cleansed data into one of three Destination Types: SQL Server, CSV File, Excel File.

			*If you are using 64-bit Excel, you cannot export the cleansed data to an Excel file.


			<ol>
			<li>Enter a '''Name''' (or names, depending on your destination type) for your cleansed data.</li>
			<li>Click '''Export'''.</li>
			*Once the file download is complete, the progress bar will display 100% complete.
			<li>Click '''Close'''.</li>
			<li>Click '''Finish''' to complete your data cleansing operation.</li>
			</ol>

	[[Category:Help]]		[[Category:Help]]
	:[[Category:Tutorial]]		:[[Category:Tutorial]]
	[[Category:Data Quality Service]]		[[Category:Data Quality Service]]

Admin at 21:57, 13 July 2012

2012-07-13T21:57:14Z

@@ Line 85: / Line 85: @@
 [[File:TUT_DQS_AddressCheck_01-08.jpg|600px]]
 [[Category:Help]]
 :[[Category:Tutorial]]
 [[Category:Data Quality Service]]

Admin at 21:45, 13 July 2012

2012-07-13T21:45:51Z

@@ Line 65: / Line 65: @@
 <li>Click '''OK'''.</li>
 </ol>
 [[Category:Help]]
 :[[Category:Tutorial]]
 [[Category:Data Quality Service]]

Admin: /* Min Confidence */

2012-07-13T21:40:32Z

Min Confidence

← Older revision		Revision as of 21:40, 13 July 2012
Line 57:		Line 57:
	This decimal value sets the minimum confidence required for a record to be considered valid. All other records will be set as invalid and not correctable		This decimal value sets the minimum confidence required for a record to be considered valid. All other records will be set as invalid and not correctable

	[[File:TUT_DQS_AddressCheck_01-10.jpg\|600px]]		[[File:TUT_DQS_AddressCheck_01-06.jpg\|600px]]

	<ol>		<ol>