1 / 6

Intelli-DQ Overview

Intelli-DQ Overview. SAS Data Quality Server. Overview. Analyze the quality of your data Minimize defective data Reduce redundancies Transform and standardize data Merge and recombine data. Intelli-STANDARDIZE.

waylon
Download Presentation

Intelli-DQ Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Intelli-DQ Overview

  2. SAS Data Quality Server Overview • Analyze the quality of your data • Minimize defective data • Reduce redundancies • Transform and standardize data • Merge and recombine data.

  3. Intelli-STANDARDIZE • Analyze and transform data by creating and applying schemes to normalize input data CASS INPUT ID ADDRESS CITY STATE ZIP TU0010000000001 |440 W 34TH ST APT 4A |NEW YORK NY 10001 TU0010000000002 |855 AVENUE OF THE AMERICAS |NEW YORK NY 10001 TU0010000000003 |1261 BROADWAY RM 815 # 8FL |NEW YORK NY 10001 TU0010000000004 |421 7TH AVE STE 611 |NEW YORK NY 10001 TU0010000000005 |419 W 34TH ST |NEW YORK NY 10001 CASS OUTPUT ID ADDRESS CITY STATE ZIP_ZIP4 REC CENSUS_KEY CRRT DPBC CASS_VERIFY 1 |440 W 34TH ST APT 4A |NEW YORK |NY| 10001-2327|H|360610103002|C030 |419 |Y 2 |855 AVENUE OF THE AMERICAS |NEW YORK |NY| 10001-4105|S|360610101001|C058 |558 |Y 3 |1261 BROADWAY RM 815 # 8FL |NEW YORK |NY| 10001-3532|H|360610076001|C023 |159 |Y 4 |421 7TH AVE STE 611 |NEW YORK |NY| 10001-2002|H|360610101001|C040 |617 |Y 5 |419 W 34TH ST |NEW YORK |NY| 10001-1596|S|360610111002|C030 |197 |Y

  4. Intelli-STANDARDIZE • Standardize Customer and Business Data CUSTOMER DATA Name S_Name S_Prefix S_First S_Middle S_Last S_SUFFIX Dr John K Doe SR Dr John K Doe, Sr Dr John K Doe Sr Dr. john k doe sr Dr John K Doe, Sr Dr John K Doe Sr Mrs jill taylor Mrs Jill Taylor Mrs Jill Taylor Mrs. joanne Smith Mrs Joanne Smith Mrs Joanne Smith Mr Peter Harvey Jr Mr Peter Harvey, Jr Mr Peter Harvey Jr BUSINESS DATA City State Company STD_CITY STD_State STD_Company Detroit MI Ford Motor Company Detroit MI Ford Motor Company Detroit MICHIGAN Ford Motor company Detroit MI Ford Motor Company Burlingame CA Virgin America Inc. Burlingame CA Virgin America Inc Burlingame CA Virgin America Incorporated Burlingame CA Virgin America Inc burlingame California Virgin America Inc. Burlingame CA Virgin America Inc

  5. Intelli-MATCH • Create match codes for analysis, matching, and data transformation Match-Code [Name and Address with Fuzzy Level 95] Obs customer address MATCH_CD CLUSTERGRP 1 Bob Beckett 392 S. Main St. PO Box 2270 M3~$$$$$$$$M@M$$$$$$!K-H$$BP$$$HHI04 1 2 Robert Beckett 392 S. Main St. PO Box 2270 M3~$$$$$$$$M@M$$$$$$!K-H$$BP$$$HHI04 1 3 Robert E. Beckett 392 S. Main St. PO Box 2270 M3~$$$$$$$$M@M$_|$$$!K-H$$BP$$$HHI04 . 4 Paul Becker 392 N. Main St. PO Box 7720 M3Y$$$$$$$$NW$$$$$$$!K-H$$BP$$$IIH0P . 5 Paul Becker 392 North Main St. PO Box 772 M3Y$$$$$$$$NW$$$$$$$!K-H$$BP$$$IIH$P . Match-Code [Name and Address with Fuzzy Level 65] Obs customer address MATCH_CD CLUSTERGRP 1 Bob Beckett 392 S. Main St. PO Box 2270 M3~$$$$$$$$M@M$$$$$$!K-H$BP$HH$$$$$$ 1 2 Robert Beckett 392 S. Main St. PO Box 2270 M3~$$$$$$$$M@M$$$$$$!K-H$BP$HH$$$$$$ 1 3 Robert E. Beckett 392 S. Main St. PO Box 2270 M3~$$$$$$$$M@M$$$$$$!K-H$BP$HH$$$$$$ 1 4 Paul Becker 392 N. Main St. PO Box 7720 M3Y$$$$$$$$NW$$$$$$$!K-H$BP$II$$$$$$ 2 5 Paul Becker 392 North Main St. PO Box 772 M3Y$$$$$$$$NW$$$$$$$!K-H$BP$II$$$$$$ 2

  6. SAS Data Quality Server Locales • DEDEU, German language, for use with data from Germany • ENAUS, English for Australia • ENGBR, English for Great Britain • ENUSA, English for the United States • ENZSA, English for South Africa • FRFRA, French for France • ITITA, Italian for Italy • NLNLD, Dutch for The Netherlands.

More Related